Shopify B2B Company data sync, along with new Customer and Line-Item fields

Shopify B2B Company data now in Mixtable

Shopify has been rapidly expanding its B2B capabilities, enabling merchants to create company accounts, manage custom wholesale price lists, and define tailored terms for different company locations. Today, we’re excited to announce that Mixtable now fully supports Shopify B2B data.

With this release, you can:

• Import B2B Companies and Company Allocations directly into Mixtable worksheets
• View, organize, and analyze your wholesale structures alongside the rest of your Shopify data
• Export B2B data for reporting or offline work
• Bulk edit B2B companies and allocations – update thousands of records in seconds

This is just the beginning. We’re actively building additional B2B workflows—including company contacts, payment terms, price lists, and more—to roll out over the coming months.

If your business sells wholesale or manages enterprise accounts, this update brings powerful new flexibility to how you work with Shopify B2B inside Mixtable.

New Customer related fields

With this release, we’re expanding customer worksheet functionality by introducing two new related data fields: First Order Date and Last Order Date. These fields automatically retrieve and display the dates of a customer’s earliest and most recent orders. The Last Order Date updates dynamically—if a customer places a new order, the field will automatically refresh to reflect the latest activity. Simply load the fields into your worksheet and Mixtable will fetch the data for you in real time.

Order Fields & Metafields added to Line-Item Worksheets

We’ve expanded support for order line-item worksheets. You can now load order-level fields directly into these worksheets, including both standard order fields and order metafields.

In addition, you can now create conditional line-item worksheets that filter rows based on order-level criteria. This means you can build powerful workflows such as:

• Only show line items from orders with a specific tag
• Filter by fulfillment status or payment status
• Include only orders placed within a certain date range

This update gives you greater control and flexibility when analyzing order data at the line-item level.