Template Items & Matrix Items

Question

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..

Page 1 / 1

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.

Reply

Leonardo Justiniano · Accepted Answer

Hi @cardfauxAcumatica 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 itemsAnd this new extended attributes would work the way you are attempting to. However, in my experience, you should create a new stock item ISwith the new variant value, assuming the targeted variant is COLOR for example. That new color, to me, represents a different item.

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded