How do I export the "Employee" field as part of my Shopify order export?

While the "Employee" field which displays the name of the user/staff logged into Shopify POS who processed the order is available in the default Shopify order export, this data is unfortunately not available in the Shopify Order API.

Only the user_id field is available in the Order API, which is an auto-generated ID assigned to the user by Shopify.  EZ Exporter can export this field.

You can find this ID when you go to the Shopify Admin > Settings > Plan and permissions, and then select a user/staff account.  The URL will look something like this and the ID is the last part of the URL:

How to find the user ID of the staff account in the Shopify Admin

So a potential workaround is to make a list of those IDs and the associated staff names and then use our get_attribute_value() function in the Calculated Fields to automatically replace the IDs with the staff names on export like this:

get_attribute_value('{"123456": "John Doe", "789012": "Mary Poppins", "382813": "Elon Musk"}', {{ user_id }})

The first parameter is the mapping of ID -> Staff Name and the second parameter is the value of the user_id field.  Our app will basically do a lookup based on the user_id and return the staff name if there's a match (it will simply export a blank value if there's no match).


App: EZ Exporter

Tags: advanced features, shopify order export