How do I troubleshoot Error: Option values ids on update should belong to the option when syncing a Template Item to BigCommerce?

  • 7 August 2023
  • 2 replies

Userlevel 5
Badge +1

I’m not sure if this is the right place to ask this.  If not please accept my apologies in advance. 

We have several template items that are giving this error when trying to sync with BigCommerce. 

One example is below:

Error: Option values ids on update should belong to the option, the following is were not found: 6593; Status: 422


  1. How can I find out what the missing Option ID is referring to?
  1. More generally, is there a way to set up the Template items so that Acumatica will update BigCommerce automatically, without manual intervention, either overwriting what's there or creating an alternative listing?

Thanks for any advice,




Best answer by Yuri Karpenko 8 August 2023, 18:32

View original

2 replies

Userlevel 6
Badge +6

@ppowell , this kind of issue will require more in-depth investigation. I would compare template items + matrix items + options selected in Acumatica with the same product + variants + option values in BigCommerce, just to see what’s the difference.

If I’m not mistaken, you cannot change option values for existing matrix items. If you want to redefine your matrix items, you need to delete them in Acumatica, then MANUALLY delete them in BigCommerce, set up new matrix items in Acumatica, and then sync.

I would recommend engaging with your VAR to troubleshoot this issue. They would need to understand both, Acumatica, and BigCommerce.

Userlevel 5
Badge +1

@Yuri Karpenko Thanks for confirming this isn’t a simple fix. We have manages to resolve the issue now for that item after removing the old matrix item on Bigcommerce and resyncing.


Thanks again,



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