Shops contains basic information about your stores. Most tables in the data warehouse have a foreign key reference to the shop_id column in this table, which means you can join this table with other tables to compare metrics across your stores. This table contains one row per store.
|shop_id||numeric||Unique identifier for the store. This column is the primary key for the shops table.|
|name||varchar||Name of your store.|
|domain||varchar||Primary domain specified for your online store. Your primary domain is the one that your customers and search engines see. For example, www.mycompany.com.|
The following example returns the total sales by stores: