Skip to main content
Answer

Acumatica and Shopify integration Issues

  • September 17, 2025
  • 1 reply
  • 137 views
D
Freshman I

Hello,

 

We are running Acumatica 2025 and Shopify Advanced with the  standard Acumatica<>Shopify connector and are experiencing a lot of issues. We have two(2) retail stores, one e-commerce site and an industrial sales division. Our ERP is Acumatica and our online store and POS run on Shopify.

  1. We have been unable to get real-time sync of orders. Everything goes through a schedule - orders, item availability, payments, etc. When we do flash sales/promos, we oversell product.
  2. We have been unable to to implement BOPIS. The Shopify statuses (Ready for Pick Up and Marked as Picked Up) is not transferred to Acumatica. We have automatizations that close the orders in Shopify automatically.
  3. For POS orders, we are ONLY able to do exchanges or returns for original form of payment. Gift Cards or product exchanges are not updated because of a order does not allow modification errors.
  4. If a customer buys in store A but returns or exchanges products in Store B, this second transaction is posted to the Store A not in Store B as it should.
  5. Item Cost is not reflected in Shopify.

 

Are these issues due to limitations of the platforms/connectors or programming/setup issues? Is anyone else having these type of issues?

 

Regards

Best answer by Yuri Karpenko

​@dabarca , these issues are pretty common. Most of them are due to the limitations of the connector + the fact that Acumatica is an ERP with a strong financial component - you cannot make changes to orders, for example, if they are not Open / On Hold or if there is a shipment / PO attached to an order.

Some of these issues can be resolved by moving to a custom connector / integration platform. Some will require rethinking of your business processes. Not everything is customizable, even though Acumatica is pretty flexible, it’s not a blank canvas -- it has internal rules and controls that cannot be subverted.

Probably the most annoying issue is the inventory discrepancies and overselling. If Shopify (POS locations + online store) is the main sales channel, I would actually suggest against real time sync for inventory. Sales in Shopify will adjust inventory, regardless of the channel, and you won’t oversell. The issue happens when sales are flooding into Shopify, but orders are not getting into Acumatica fast enough. Say, you get 10 orders for a widget in Shopify, your inventory in Shopify goes from 100 to 90, and then only the first 3 orders make it into Acumatica. Acumatica ‘thinks’ that it has 97 items available, so it pushes 97 to Shopify, overriding the correct “90” that Shopify has at that point. This is how overselling happens.

DM me if you need help with your specific problems, but as I said, a solution will be a mix of technological changes, process changes, and expectation adjustments.

    1 reply

    Yuri Karpenko
    Captain II
    Forum|alt.badge.img+6
    • Yuri Karpenko
    • Captain II
    • Answer
    • September 17, 2025

    ​@dabarca , these issues are pretty common. Most of them are due to the limitations of the connector + the fact that Acumatica is an ERP with a strong financial component - you cannot make changes to orders, for example, if they are not Open / On Hold or if there is a shipment / PO attached to an order.

    Some of these issues can be resolved by moving to a custom connector / integration platform. Some will require rethinking of your business processes. Not everything is customizable, even though Acumatica is pretty flexible, it’s not a blank canvas -- it has internal rules and controls that cannot be subverted.

    Probably the most annoying issue is the inventory discrepancies and overselling. If Shopify (POS locations + online store) is the main sales channel, I would actually suggest against real time sync for inventory. Sales in Shopify will adjust inventory, regardless of the channel, and you won’t oversell. The issue happens when sales are flooding into Shopify, but orders are not getting into Acumatica fast enough. Say, you get 10 orders for a widget in Shopify, your inventory in Shopify goes from 100 to 90, and then only the first 3 orders make it into Acumatica. Acumatica ‘thinks’ that it has 97 items available, so it pushes 97 to Shopify, overriding the correct “90” that Shopify has at that point. This is how overselling happens.

    DM me if you need help with your specific problems, but as I said, a solution will be a mix of technological changes, process changes, and expectation adjustments.

    Yuri Karpenko | DM me if you need help building e-Commerce for your business or connecting it to Acumatica ERP
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved