Sync Acumatica SKU to Shopify Variant SKU

Topic summary

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

Hi @niravs

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.

Ben
InSyncer by CyberWorkshop