We have a client who is live on BigCommerce and wants to import their existing stock item catalog into Acumatica first to get Stock items set up and the External ID links established, then switch the sync direction to Export with Acumatica as the master going forward. Has anyone done this before? What's the recommended way to manage this? can we map item class using a custom field from BC to Acumatica to match it to the correct item class using import mapping? And once you flip to Export, does the connector pick up the existing External ID links and update the BC products cleanly without creating duplicates?
Solved
Best Approaches to connect to Live Big commerce Store
Best answer by Yuri Karpenko
I would recommend to do this one-by-one at first, and then in small batches before you attempt to do a full sync.
But to answer your question, yes, once the products are imported, you can switch the direction and have Acumatica update BigCommerce.
+7
I would recommend to do this one-by-one at first, and then in small batches before you attempt to do a full sync.
But to answer your question, yes, once the products are imported, you can switch the direction and have Acumatica update BigCommerce.
Translate
Translate
+7
Translate
Is there some documentation for that process? Thanks!
Translate
+7
- https://beacon.acumatica.com/r/Commerce-Edition-Guide/Integration-with-BigCommerce/Importing-Products/Product-Import-General-Information
- https://beacon.acumatica.com/r/Commerce-Edition-Guide/Integration-with-BigCommerce/Importing-Products/Product-Import-Settings-of-Imported-Items
- https://beacon.acumatica.com/r/Commerce-Edition-Guide/Integration-with-BigCommerce/Importing-Products/Product-Import-To-Import-Stock-Items#entry_0
Hope this helps!
Translate
- https://beacon.acumatica.com/r/Commerce-Edition-Guide/Integration-with-BigCommerce/Importing-Products/Product-Import-General-Information
- https://beacon.acumatica.com/r/Commerce-Edition-Guide/Integration-with-BigCommerce/Importing-Products/Product-Import-Settings-of-Imported-Items
- https://beacon.acumatica.com/r/Commerce-Edition-Guide/Integration-with-BigCommerce/Importing-Products/Product-Import-To-Import-Stock-Items#entry_0
Hope this helps!
Thanks Yuri - I'm familiar with the general import process but the challenge I'm running into is around item class assignment at scale. When you have a large catalog with products that need to land in different item classes in Acumatica, running small batches and changing the default item class between each batch works but it's not exactly clean. I also thought about importing everything into one item class and then running an import scenario in Acumatica to reassign — but that feels like extra cleanup work. The more elegant solution I was exploring was mapping a BC custom field directly to the Item Class field in Acumatica via the Import Mapping - so the right item class gets assigned automatically on import based on what's in BC. Has anyone actually got that working? From what I've tested so far, custom fields don't seem to surface cleanly in the External Field dropdown on the mapping screen and I'm not sure if this is a supported path or a dead end.
Translate
+7
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.