|
Group: Forum Members
Last Active: Thu 21 May 2015
Posts: 5,
Visits: 54
|
I'm trying to load a very simple Excel file of 1 product that is to be placed under 2 categories. The categories get created but the product only shows in 1 category. Has anyone made this work? I can manually add the product to additional categories afterward but am going to be working with thousands of products eventually.
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
I think we have sample data for this in our sample spreadsheet. The product data is repeated, except the category data in each row is different. The DT should use the product name as the key, so if it sees the same product name on different rows with different category info, it should assume it is the same product, and map to each category.
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
Group: Forum Members
Last Active: Thu 21 May 2015
Posts: 5,
Visits: 54
|
I don't believe there is any one product that goes under more than one category in the demo data....each row that has the same product name has a different version name and different version code so it gets added as a new version of the same product under the same category.
Correct me if I'm doing this wrong....my first row has a category called "Round Widgets" and a product name called "Round Blue Widget" and version code number of "WID123". My second row has a category called "Blue Widgets", a product name of "Round Blue Widget", and a version code number of "WID123". What happens is the two categories are created, on the same level, but the product is only showing under the first category. Any ideas what I'm doing wrong?
Thanks.
|