Users table
The users table contains information about the staff accounts in the store. It contains one row per staff account. Use this table to generate a list of your staff accounts, or join it with the sales, API clients and locations tables to analyze staff performance at Shopify Point of Sale (POS) locations.
| Column | Data type | Description |
|---|---|---|
| user_id | numeric | The unique identifier for the user of your Shopify POS or your Shopify admin. This column is the primary key for the table. |
| shop_id | numeric | The ID of the store. This column is a foreign key reference to the shop_id column in the shops table. |
| first_name | varchar | First name of the staff member. |
| last_name | varchar | Last name of the staff member. |
| varchar | Email address of the staff member. |
Only Shopify POS orders and draft orders are associated with a staff member. Shopify POS orders are associated with the staff member who is logged into the POS at the time of the sale. Draft orders are associated with the staff member who converts the draft order to an order. Online store sales do not have a staff member associated with their sales.
The following SQL query returns Shopify POS data by staff member: