How do I get Shopify B2B orders and reports to line up with my ERP?

By Ranjit Bhinge, founder of Blur Studio · Updated · 7 min read

Short answer: Shopify B2B is the set of wholesale features built into Shopify: company accounts, customer catalogs, payment terms and net-term checkout. For QuickBooks Online, Intuit's own Shopify connector now brings B2B orders in as invoices linked to a company, with terms and PO numbers. For NetSuite (Oracle's cloud ERP, the system that runs accounting, stock and orders), you pick Oracle's connector or an integration platform such as Celigo. Whatever you use, decide first which system owns customers, prices and stock, or the two will overwrite each other.

Ranjit Bhinge

You sell wholesale on Shopify, your books live somewhere else, and you want orders to flow across and your reports to match without retyping anything.

I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.

Does Shopify B2B connect to QuickBooks?

Yes, if you use QuickBooks Online, Intuit's cloud accounting product. In June 2026 Intuit announced native B2B support in its Shopify Connector. Per Intuit, B2B orders now arrive as invoices that already carry the company details, the PO number (the customer's purchase order reference), the products and the payment terms. A Shopify B2B company maps to a QuickBooks customer, so the invoice belongs to the business, not to whichever buyer clicked checkout.

Payment status also goes both ways. If you mark an invoice paid in QuickBooks, Shopify updates, even when the customer paid by check outside Shopify. Intuit says no setup is needed beyond the existing integration, and that availability varies by plan type.

The help article adds useful detail. B2B companies come into QuickBooks as customers with the type "Shopify B2B company." Shopify fees become expenses. The app imports up to 12 months of history, and the first import can take from 10 minutes to 3 hours. Anything it is not confident about waits in a For Review tab, so if you see a "No invoice found" message, the invoice is probably sitting in review.

Two limits matter. First, the product matching: with product tracking on, the connector matches items by SKU (your product code) and name, and it does not add a product that has no match. You create those by hand. Second, Intuit's pages do not say that price lists or catalogs sync, so plan for prices to stay in Shopify. Intuit's help page lists a QuickBooks Online account as the requirement and does not mention QuickBooks Desktop, so check with Intuit before assuming it works there. My page on QuickBooks alternatives covers that decision.

What does Shopify B2B need before you connect anything?

Shopify's help center says B2B is available on the Basic, Grow, Advanced and Plus plans, and not on Starter or Retail. You set up each buyer as a company in the admin. Each company can have its own pricing, currency, products, payment methods and shipping methods.

The limit that bites ERP users is catalogs. A catalog is a list of products and prices you offer a group of buyers. On Basic, Grow and Advanced you can have up to 3 active catalog assignments across B2B markets. Plus has no limit and is the only plan that lets you assign a catalog straight to a company location. If your ERP holds ten customer price tiers, you will hit three fast. I cover the pricing side in customer-specific pricing.

If your wholesale customers reorder on a schedule or buy pre-order items, check Shopify's B2B feature list for your plan before you commit.

How do you connect Shopify B2B to NetSuite?

NetSuite is Oracle's cloud ERP. Two common routes exist.

  • Oracle's own connector. The NetSuite ERP Connector in the Shopify App Store syncs product, pricing, inventory, sales order and fulfillment data. As of November 2026 the listing shows plans from $199.92 a month, with the B2B plan at $916.58 a month. B2B adds invoice posting, later payment handling, B2B order sync and standalone B2B customer sync. The listing warns that Oracle may bill some charges separately from your Shopify invoice. One reviewer on that listing calls the setup hard to manage, so ask for a partner who has done B2B before.
  • Celigo. Celigo is an integration platform: software whose only job is moving data between business systems. Its Shopify B2B to NetSuite template creates or updates companies, maps Shopify locations to NetSuite sub-customers, syncs contacts, turns Shopify B2B orders into NetSuite sales orders, sends shipping status and tracking back, and syncs refunds. Celigo offers a 30-day free trial. Check Celigo's page for current prices, and ask how it handles customer-specific prices, because the template description does not mention price lists.

Shopify's developer documentation says the Admin API (the programming door into your store) can create companies, contacts and locations, attach catalogs to locations, read B2B orders, create draft orders and import B2B orders from outside systems. So any ERP with an API can be connected, if someone builds the link. It also means a ready-made connector for your particular ERP may not exist. Look at the Shopify App Store listing for your ERP and read what it says about B2B before you pay anything.

This is where a small custom link often beats a monthly connector. If you only need three flows, such as orders into the ERP, stock and prices out of it, and tracking back, a purpose-built sync costs one project instead of a monthly fee that grows. I go through that trade-off on my AI integration services page.

Which data should flow in which direction?

Decide this before you buy a connector. Most sync problems come from two systems that both think they own the same data.

DataUsual ownerDirection
Customer and company recordsERP or accountingERP to Shopify, with new buyers flowing back
Item list and costsERPERP to Shopify
Customer prices and termsERPERP to Shopify
Stock on handERPERP to Shopify
OrdersShopifyShopify to ERP
Shipping status and trackingERP or warehouseERP to Shopify
Invoices and paymentsAccountingBoth ways

Write your own version of this table and agree it with whoever keeps your books. It is also worth a look at business process automation if you want the wider picture of what to automate first.

What B2B reports does Shopify give you?

You build B2B reports in Analytics. Go to Reports, choose New exploration, then set the report in the panel or write a ShopifyQL query (Shopify's query language for store data). Five fields work as filters or dimensions on any sales number: Is B2B order, Company ID, Company name, Company location ID and Company location name.

Shopify's own examples are B2B against direct-to-consumer net sales by month, and top B2B companies and locations by net sales. You can save a report and add it to your Analytics dashboard. ShopifyQL returns 1,000 rows by default, and Shopify's report page does not describe an export option, so plan on copying results out if finance wants a spreadsheet. For more detail, see Shopify B2B versus BigCommerce B2B.

Why are your B2B reports not showing what you expect?

Check these causes in order.

  1. The filter is wrong. If Is B2B order is not set to Yes, retail and wholesale are mixed.
  2. The order has no company. The B2B fields are built around companies, so an order placed by a plain customer record, with no company attached, is unlikely to show up under the B2B filter.
  3. Net sales versus invoiced amounts. Shopify reports sales by order date. Your books may count the same sale on the invoice date, and credit memos can land in a different month.
  4. Review queue in QuickBooks. Transactions waiting in For Review do not affect your QuickBooks reports until you confirm them.
  5. Orders paid outside Shopify. A customer who pays by check outside Shopify can show as unpaid there until the invoice is marked paid in QuickBooks, which Intuit says syncs back.

Here is a worked example with made-up figures. In October, Shopify shows $48,200 of B2B net sales. QuickBooks shows $46,900 of invoices. The $1,300 gap is two orders placed on October 30 that were invoiced on November 2. Nothing is wrong. The reports just use different dates. A monthly reconciliation that lists orders by Shopify date next to invoices by QuickBooks date finds this in minutes. For more on what Shopify's reports cannot do, see Shopify reporting limits, and for a dashboard that pulls both sides together, see how to build a KPI dashboard.

How to set it up, step by step

  1. Clean the customer list. One company, one name, one set of terms. Duplicates in the ERP become duplicates in Shopify.
  2. Match the item list. Every Shopify product needs the same SKU as the ERP item. A mismatch is the most common reason an order will not post.
  3. Fill in the ownership table above. Pick one owner for each row.
  4. Connect in a test store or with one customer. Run five real orders: one with a PO number, one on net 30 terms, one with a partial shipment, one refund and one with a customer-specific price.
  5. Compare the results line by line. Order total, tax, shipping and terms must match in both systems.
  6. Turn it on for every customer. Then reconcile weekly for the first month.

Can Shopify B2B connect to a CRM?

A CRM is the tool that holds your sales contacts and deal history. Shopify's B2B help pages do not list a built-in CRM sync. Connectors in the App Store vary, so read each listing for the words "company" and "B2B" before you install, because many sync only retail customers. For company-level history on the account record, a custom link through the Admin API is the reliable route.

How I'd approach this

I would start with the ownership table, not the connector. Many owners buy a connector first, then discover their ERP and Shopify disagree about who sets the price. If your accounting is QuickBooks Online, turn on Intuit's connector, run five test orders, and see how far it gets you before paying for anything. If you run NetSuite, price Oracle's connector against Celigo with a partner and ask both about customer-specific prices. If your ERP is older, or your price rules are the hard part, a small custom sync is often cheaper over three years. And if reports are the real pain, fix the order-has-no-company problem first, because it hides half of your wholesale sales.

Questions people ask

Does Shopify B2B integrate with QuickBooks?

Yes, for QuickBooks Online. Intuit's Shopify Connector brings B2B orders in as invoices linked to the company, with payment terms and PO numbers, and syncs paid status back to Shopify. It does not apply to QuickBooks Desktop or Enterprise. See my page on QuickBooks alternatives if you are weighing a move.

What are Shopify B2B integrations?

They are links between Shopify B2B and other systems such as an ERP, accounting tool or CRM. They come as App Store connectors, integration platforms such as Celigo, or custom code that uses Shopify's Admin API. My AI integration services page covers the custom route.

Is there a Shopify B2B NetSuite integration?

Yes. Oracle's NetSuite ERP Connector has a B2B plan listed at $916.58 a month as of November 2026, and Celigo offers a Shopify B2B to NetSuite template with a 30-day free trial.

Where do I find Shopify B2B reports?

Go to Analytics, then Reports, and create a new exploration. Use the Is B2B order, Company name and Company location name fields to filter and group your sales. A KPI dashboard can combine them with your accounting numbers.

Why are my Shopify B2B reports not showing all my wholesale orders?

Usually the Is B2B order filter is not set to Yes, or the order has no company attached. Check one missing order in your admin to see which it is.

Can I export a Shopify B2B sales report?

Shopify's B2B report page describes saving a report and adding it to your dashboard, and it does not describe an export option. Check the report screen in your admin for the options your plan shows, or copy the results out.

More in this topic: B2B: customer portals and B2B ecommerce (9 guides) →

Sources

Ready for the next step?

A 30 minute call. If you do not need me, I will tell you.

Ranjit Bhinge You talk to me, Ranjit. I reply within a few hours.

Not sure what you need? Tell me what is going on. I will point you the right way, even if it is not me.

Blur Studio · 30 minute call

Book a 30 minute call

You talk to me, Ranjit. If you do not need me, I will tell you.

  • We talk about your business and what is going on.
  • You leave with a clear next step, even if it is not me.
  • I reply to every message within a few hours.
Loading the calendar…