Why are the user_id and staff_member_id column Values Null in My Destination?
If the user_id or staff_member_id columns' values are NULL, it's because these columns require the read_users scope on the authenticated Shopify app. If this scope is not granted, these columns are synced with NULL values in the destination.
Which columns require the read_users scope?
The following columns require the read_users scope on the authenticated Shopify app:
| Table | Column |
|---|---|
STAFF_MEMBER | All columns (entire table) |
SALES_AGREEMENT | USER_ID |
ORDER | STAFF_MEMBER_ID |
ORDER_LINE | STAFF_MEMBER_ID |
REFUND | STAFF_MEMBER_ID |
TRANSACTION | STAFF_MEMBER_ID |
TENDER_TRANSACTION | USER_ID |
SHOP | ACCOUNT_OWNER_ID |
How to populate these columns
To populate these columns, request the read_users scope from Shopify and reconnect the connector. For steps on how to enable this scope, see our Request API access documentation.