Template Items & Matrix Items

  • 23 November 2022
  • 1 reply

I have a problem and I am not sure how to fix it, one store uses the Shopify connector and one store uses the BigCommerce connector.

Each store has thousands and thousands of products with individual SKU numbers, so each stock item in Acumatica creates 1 product in the stores. I am trying to condense these products as much as I can, to give each one a color variant where it is applicable. 

I was trying to do this with TEMPLATE ITEMS and MATRIX ITERMS but I can’t seem to do it with existing stock items and also use existing stock items for their matrix items (variants).

I can not change the SKU numbers, the SKU numbers are used across multiple stores both online and offline.

For example say i have these 3 stock items REG-RB-0013 (red lighter), REG-RB-0014 (blue lighter), REG-RB-0015 (green lighter). Currently all 3 of these are different stock items and 3 different products across the stores.


I need to take the REG-RB-0013 and make it just a lighter with red being the default variant with REG-RB-0014 being a blue variant and REG-RB-0015 being the green variant. 

But I can’t seem to get the Matrix items to use an already existing INVENTORY ID and I can’t make a template item use an already existing INVENTORY ID. So I am not sure what to do because changing the SKU numbers isn’t possible but I also don’t need everything being completely separate products on the Shopify and bigcommerce store fronts.

Has anybody else had this issue before, any suggestions would be greatly appreciated.

Thank You..


Best answer by Leonardo Justiniano 23 November 2022, 21:08

View original

1 reply

Userlevel 6
Badge +4

Hi @cardfaux 


Acumatica uses Variant Attributes assemble the stock item ID using the segment configuration defined on the template:

If you want to add anew Variant value of any attribute will imply the creation of a new stock item ID reflecting that new variant value in the segment.

You can have additional attributes not set as Variant with additional information you want to link to existing items

And this new extended attributes would work the way you are attempting to. However, in my experience, you should create a new stock item IS with the new variant value, assuming the targeted variant is COLOR for example. That new color, to me, represents a different item.


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