Skip to main content

Creating Matrix Item from existing Items


Hi,

is it possible to take existing item codes and add attributes.  E.g. An existing Inventory item = W-01.  I want to use the Matrix Items to add combinations of this item.  So …. W-01-BLK-2.8;  W-01-RED-2.8 etc…

Can I do this?   I have tried to add the Inventory item as an attribute but had no luck.  I don’t want to have to manually enter 200 templates with the Inventory ID.

 

Any help appreciated.

Cheers,

Laura

Did this topic help you find an answer to your question?

9 replies

Forum|alt.badge.img+5
  • Captain II
  • 398 replies
  • April 14, 2021

It looks like Matrix item can only applied to new items.  I did not find a way to make existing item to Matrix item. But I think some experts might know a way to do it.
subscribed and wait for the solution.


  • Author
  • Freshman II
  • 9 replies
  • April 14, 2021

thanks Ray.  

I’m knew to this community so just want to know what “subscribed and wait for the solution” mean.  Does this mean you have on sent the issue to someone?


Forum|alt.badge.img+5
  • Captain II
  • 398 replies
  • April 19, 2021

@laurac 
“subscribed and wait for the solution” just means that I’ve followed your post/question, and if someone can give a solution here, I can also be aware of.


  • Author
  • Freshman II
  • 9 replies
  • April 19, 2021

cool. thanks


sethkuhn25
Freshman I
Forum|alt.badge.img
  • Freshman I
  • 17 replies
  • June 5, 2021

Did you try submitting an Acumatica Support Ticket? There is a Matrix Import Scenario package that Acumatica can provide. It allows you to add Template Items to existing Stock & Non-Stock Items. It also allows you to use an import scenario to add many Template & Matrix items in more of a bulk upload process.


Yuri Karpenko
Captain II
Forum|alt.badge.img+6

This will solve your issue, I believe: 

 


  • Freshman I
  • 5 replies
  • October 11, 2023

I downloaded Popular Retail-Commerce Customization Packages and it was helpful thanks.

My question is that I already have the stock items in my ERP and I was to convert them to Matrix Items.

They have the same items class. I made a template item then did the following import scenario.

It said completed successfully but it did nothing.  Im assuming my import is too simple or Im missing something.

 


nathantrauscht
Semi-Pro II
Forum|alt.badge.img

@RoslynRule did you find a solution to convert existing stock items to template items?

When we migrated, our old system did not have this feature. We would like to convert a large number of existing stock items to template items with variants, such as size/brand etc. but we do not want to create duplicates and we do not want to lose item history of the existing stock items.


  • Freshman I
  • 5 replies
  • November 1, 2023

@nathantrauscht I am using MYOB Advanced in Australia and they are telling me it cannot be done.

I believe Acumatica can do a customisation for you to allow it to be done.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings