Locations table
The locations table contains metrics about your Shopify Point of Sale (POS). You can use this table to generate a list of the Shopify POS locations or you can join the table with the sales table to measure sales performance. This table contains one row per Shopify POS location.
| Column | Data type | Description |
|---|---|---|
| location_id | numeric | The ID of the Shopify POS. This column is the primary key for the locations table. The location_id is null for orders not placed through Shopify POS, such as those placed through the online store. |
| shop_id | numeric | The ID of the store. This column is a foreign key reference to the shop_id column in the shops table. |
| name | varchar | Name of the POS location as provided by the merchant. For example, 150 Elgin Street or Downtown Boutique. |
The following SQL query returns Shopify POS data by staff member: