I'm trying to import a system module containing flat list dimensions (store, product) containing line items that combines store and product code into a combined numbered list that up until now only have stores in it. When running the import I get below failure messages although import was completed:
* Another row has already been processed with this key
* Cannot import record into numbered list as it has a new name
I believe my list doesn't understand that the same product should be able to be sold in different stores. Also, when having a numbered list I cannot uniquely identify data with my code or combination of properties, but only Name (#ID), which I suppose is the Product name, so that is causing problems.
I tried the same import for a dummy non-Numbered list and it then worked. But how can I make this work with a numbered list? Do I have to maybe add some line item calculation row to my system module that I'm importing?
Re: Trouble importing System module to Numbered List
@fabien.junod But I don't want to put Store as a parent in the Products List as I want to keep that as a flat list. So the system module I have is built on 2 flat lists as dimensions; store and product. This module, SYS Create Store->Product, then has the combined code of both as a line item. Is this possible somehow?
You just need to create a Display Name" property that has the name of the Product (as text) and in the general list section, in the "Display Name Property", you need to select the "Display Name" property you just created.
In the last step, @naushad786 created a hierarchicall list which you don't want.
Instead, you can take the last 2 steps of my proposed solution
3) Add a "Parent Store" property for that list and format it as a Store list
4) When you import into that list, import the store into the "Parent store"
Can I ask, how are you planning to use the numbered list? Why do you need parent information but still need a flat list?