ERP reality check
Acumatica and B2B commerce
Acumatica is a cloud ERP used widely by mid-market manufacturers and distributors. It ships native commerce connectors for Shopify and BigCommerce, and the gap between what those connectors advertise and what they sync is where most Acumatica commerce projects get into trouble.
Does the Acumatica Shopify connector sync customer-specific prices?
Not the way most Acumatica users mean it. The native Shopify connector syncs a stock item’s Default Price, and Acumatica’s own community answer to a direct question about syncing the effective sales price from the ARSalesPrice table is “Only Default Price is supported”, which strands anything you set with a Sales Price Worksheet. Per-customer prices can still reach Shopify B2B as catalogues through the connector’s Price List entity, and that is the path most teams end up on.Acumatica matrix items and Shopify variants: the option limits and the sync errors you will hit
Shopify caps a product at three options and Acumatica template items can carry more attributes than that, so a four-attribute product fails outright with “Shopify supports only up to 3 product options”. Acumatica also needs at least two attributes per template item, re-sorts your Shopify variants by Option1 then Option2 then Option3 on every template sync, and on 25R1 rejects a whole template if any attribute anywhere contains duplicate value descriptions.Multi-warehouse availability between Acumatica and a storefront: what one stock number costs you
Acumatica holds availability per warehouse and most storefronts show a buyer one number, which is a promise the business cannot keep. BigCommerce does support inventory locations, four to eight by plan, but its Stencil storefront queries return stock from the default location only unless you request an aggregated model, and Acumatica’s own community answer for per-customer warehouse availability is still a customization keyed on something like ship-to state.How do you stop Acumatica recalculating tax that Shopify already charged at checkout?
Acumatica 2023 R1 added a “Disable Automatic Tax Calculation” checkbox on the Order Types form. Paired with Tax Synchronization on the store record, it lets the tax figure your storefront already charged stand instead of being recalculated. The trade is explicit: with that box ticked Acumatica stops sending those invoices to external tax providers such as Avalara or TaxJar, which is by design to prevent double reporting, and it does not work with inclusive taxes, gross entry mode, or partial invoices.Acumatica sells in cases but syncs the each price: the UOM mismatch that puts a wrong number on the page
Older Acumatica Commerce Connector builds exported the price and the availability held against the base unit rather than the sales unit, so a case-priced item showed the each price online and a case of six showed 36 available instead of six. Acumatica added sales-unit price and product sync in 22R2 and sales-unit availability in 2022 R2, but a user on that release in February 2023 could not find the setting and the request for documentation in that thread went unanswered.Running a French and English storefront when the item description lives in Acumatica
Acumatica can hold user input in more than one language, and its Locales and Languages documentation names the stock item description editor on form IN202500 among the boxes with that support. Whether those translations reach a storefront through the Commerce Connector is unverified, so the practical answer for a bilingual Canadian catalogue is to hold translated content in the front end or a PIM and leave Acumatica authoritative for price, stock and item identity.Why can’t I see the Shopify and Shopify POS Connector option in Acumatica?
The Shopify and Shopify POS Connector is a separately licensed product from the plain Shopify Connector, and the community answer is that it needs the Commerce Edition licence. A user in Acumatica community thread 23200 in 2024 had Distribution Edition with Shopify added, could not see the option in production although it was there in test, and it appeared once the licence was added.Acumatica and BigCommerce B2B Edition: the six customer sync behaviours that surprise people
The Acumatica to BigCommerce B2B customer sync has six documented behaviours on 23R1 that will surprise you. It picks the main contact rather than the primary contact as the company’s first admin, sends the second phone number instead of the first, lets BigCommerce overwrite Acumatica edits to the main contact email and primary contact name, misses changes to any other contact, creates duplicate contacts readily, and ties the Acumatica customer to the BigCommerce company through that first admin, so deleting it severs the link. Acumatica’s 2026 R1 notes list new BigCommerce B2B Edition import work, so re-check these against your release.Can one Acumatica tenant run two Shopify storefronts?
Yes, and merchants do it: Acumatica community thread 31345 describes a direct-to-consumer Shopify store and a wholesale Shopify store running off one Acumatica instance, with stock items restricted per store through entity mapping filters. Matrix items are the exception, because the thread’s accepted answer from July 2025 states the template item import "does not respect attributes set on the Variance stock items", so every matrix child reaches both stores whatever you filter.Acumatica’s Product Configurator on a storefront: what it is and what reaching it costs
Acumatica ships a rules-based Product Configurator in its Manufacturing Management suite that builds a bill of material and routing for a configured item with calculated costs and pricing. Acumatica’s own datasheet says you can "Extend Acumatica’s Product Configurator via web endpoints to leverage rules-based product options and values logic for configured orders from external apps like website storefronts, custom portals, or other applications", so the integration point exists, and there is no shipped buyer-facing configurator, which means the storefront experience is something you build.Does the Acumatica Shopify connector support Shopify’s higher variant limit?
Acumatica says yes since 2025 R1. In Acumatica community thread 27439 the accepted answer, posted 6 March 2025 by Acumatica’s Technical Product Manager for Retail Commerce, states "we have updated the Stock, Non-stock, Template Item entity with GraphQL in 25R1. With that you should have the 2000 variants supportability based on your Shopify plan". Shopify has since gone further: its developer changelog of 15 October 2025 raised the ceiling to 2,048 variants for all merchants, not 2,000 and not plan-gated, and the option count did not move.