Shopify B2B Companies Import File Checker

Shopify has no built-in CSV import for B2B companies; its help points to the Matrixify app. Matrixify rejects rows for small mistakes: a missing Name, a duplicate company, a bad country code, a customer that does not exist yet. Check your Companies file here first. Checked against Matrixify's published Companies format on 2026-11-07.

Check your file (free)

What the checker tests

• Name column present and not blank on every row; each location row has Location: Name.
• Command values: NEW, MERGE, UPDATE, REPLACE, DELETE, IGNORE. Location: Command: NEW, MERGE, UPDATE, REPLACE, DELETE. Customer: Command: MERGE, DELETE.
• Company names must be unique: the same name in separate row groups is flagged. Repeated External IDs and a customer listed under two companies are flagged.
• Country Code (two-letter ISO 3166), Province Code (two letters), Address 1 and Country Code when an address is given.
• Email format for Customer: Email and Main Contact: Customer Email.
• Payment terms (Due on fulfillment, Net 7/15/30/45/60/90), Tax Setting (Collect, Do not collect), Tax Exemptions only apply with Collect, Customer: Location Role (Ordering only, Location admin, or empty), TRUE/FALSE columns.
• Export-only columns (Created At, Order Count and so on) and unknown column names are flagged.
• Customers must already exist in your store: a company with an unknown customer fails to import. The checker lists the customer emails you need to import first with Matrixify's Customers sheet. It cannot check your store.

Sources: Matrixify Companies documentation; Shopify Help: B2B companies. Matrixify may change its format; this page is not a guarantee that an import will succeed.

Skip the cleanup: we return a Matrixify-ready file

Not open yet. This is a price test: the button below goes to a page that says so. No payment and no email is collected.

Planned (not open yet): you would send us your messy spreadsheet, and we would return a Matrixify-ready Companies file within 2 business days. You would run the import yourself, so we would never access your store. Files would be deleted after delivery. Placeholder prices:

Request this service

FAQ