Variant Attribute/Option Update Doesn't Reflect in BigCommerce

  • 10 July 2023
  • 4 replies

Userlevel 2

Hello everyone! 

We are converting our inventory into a template-matrix item using this customization:

I am just facing some concern when there are some corrections made in the stock/matrix items in Acumatica that should reflect in BigCommerce.

Consider an example of a template with attribute Size (Small, Medium, Large) and Color (Red, Green, Blue). Not all permutations are available. And the item was synced in BigCommerce

Now, the business decided to change the color attribute name from Red to Rose, Blue to Navy Blue and Green to Lime Green. It was changed in Acumatica, but the variant details was not reflected in BigCommerce.

Maybe one way is to delete the item in BC and resync the item. But that is not desirable especially if we made lots of changes in BC side of product details, and a transaction has already been made.

Can you pls help how to fix the issue? Thank you


Best answer by jib87 10 August 2023, 09:56

View original

4 replies

Userlevel 7
Badge +2

@jib87 Changing the Attribute Name or its Values once used is prohibited in Acumatica once used. How did you change the name? Also, I think Connector exports the updates from the Attributes to the BC Variant options and name. 

If it is not updating then please create a case with Acumatica support. We need to check the data. 

Userlevel 2

@KarthikGajendran Sorry, I forgot to mention that we are using Import Scenario in Importing attribute and options as well as assigning them to matrix items. So the updating of variant options/name of the matrix item is not by updating the attributes value (though description can be updated), but instead by creating a new set of options and replacing the old attribute value in that matrix/stock item. Thus, in our sample, from colors Red, Green, Blue, we have now Red, Green, Blue, Rose, Navy Blue and Lime Green color options. But Red, Green and Blue should not be in used anymore.

Userlevel 7

Hi @jib87 were you able to find a solution? Thank you!

Userlevel 2

Hi @Chris Hackett ..

We fix the provided scenario by manually modifying BigCommerce product to make sure that number of options and their values matches what is in Acumatica, and if necessary, to match also the number of variants and their SKU (since in our case, not every permutation of options are existing products)


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