New to importing Matrix items. I can get the impor...
# csvimports
j
New to importing Matrix items. I can get the import to add by color but not by color AND size. Template comes through as expected and the size is filled in, but the naming isn't doing as we'd expect. So ex. 1100-Red-S But it's just coming through 1100-Red. The size is mapped and the matrix name template looks correct and it's showing all lines imported, but only the two children (two colors) were created.
s
did you try using internal ID for 1100- red-s?
j
No, since these are all new items.
b
share your import file? here is a sample import file that works for us for two matrix options (color and size)
j
In the import tool in NS, how do you map the column Item Options (the values are separated with a pipe)?
s
you can separate it by pipe
b
for us this field seems to map automatically using the csv import assistant as long as you use the name
Item Options
in the csv file's column title
j
I will try it, thanks!
b
we had to use the Matrix Item Assistant to create a dummy item with all possible options just to make sure that the relevant Item Options are created and configured in tandem with the Custom Item Field and the Custom Lists
s
Yeah that's what I was suggesting, you can do two step process, you can create matrix list first and then just reference internal ID
j
Okay, yeah, this is set up to do it all in one step.
Trying to import ~8K items, not including all the child items, so...
s
good luck!!