EZ Exporter Update: B2B Company Fields Now Available in Shopify Order Exports

EZ Exporter can now export Shopify B2B Company fields such as the Company Name, Company ID, Location Name, and Location ID when exporting order data.

To include these fields in your order data export, simply use the following variables in the Custom Fields or Calculated Fields of the Data Settings (we're intentionally not including them in the preset fields as these will only apply to a small number of our users):

  • {{ purchasing_entity.company.name }}
  • {{ purchasing_entity.company.external_id }}
  • {{ purchasing_entity.location.name }}
  • {{ purchasing_entity.location.external_id }}

Below are screenshots showing where these fields map to when viewing the information in the Shopify Admin:

In case you also need to export the Shopify auto-generated company ID and location ID, these are available as well via the following variables:

  • {{ purchasing_entity.company.id }}
  • {{ purchasing_entity.location.id }}

These fields above will use the new GraphQL API's ID structure which will look something like gid://shopify/Company/491600.  If you just want to export the last part of this auto-generated ID, you can use a formula like this in the Calculated Fields:

{{ purchasing_entity.company.id }}.split("/")[-1]

Tags: new features, ez exporter, shopify b2b, shopify companies