A user is seeking a solution to synchronize Acumatica Stock Items with Shopify SKUs, including both standard SKUs and variant SKUs when applicable. The goal is to enable real-time inventory (on-hand quantities) syncing from Acumatica to Shopify.
Key Details:
Acumatica does not use Template/Matrix Items in their setup
Looking for implementation methods via API or other tools
Need to handle both simple products and products with variants
Status: The question remains unanswered with no responses yet. The user is looking for recommendations from others who have successfully implemented similar integrations.
Summarized with AI on October 26.
AI used: claude-sonnet-4-5-20250929.
We need to sync the Acumatica Stock Item to the Shopify Standard SKU is some cases and if the standard SKU has a Variant then to the Variant SKU so that we can pass Acumatica on hand inventory. Has anyone completed this using an API or other tool easily?
Note: In Acumatica we do not use Template/Matrix Items
Our app InSyncer for Acumatica supports this scenario. We can map an Acumatica Stock Item directly to a Shopify variant SKU and keep on-hand inventory in sync, even when you’re not using template or matrix items in Acumatica.
If you’d like to see how it works, I’m happy to run you through a quick demo of our Acumatica → Shopify integration and show how we handle product and inventory mapping in detail.