Do not duplicate products

id	name	cat	        price	variant
1	tovar1	cat>cat2>cat3	10	varinat1
2	tovar1	cat>cat2>cat3	20	varinat2
3	tovar1	cat>cat2>cat3	30	varinat3
4	tovar2	cat>sub1	110	varinat1
5	tovar2	cat>sub1	120	varinat2
6	tovar1	cat>tmp	        10	varinat1
7	tovar1	cat>tmp	        20	varinat2
8	tovar1	cat>tmp	        30	varinat3

Why is the tmp category empty? How to make tovar1 appear in the tmp category?

• This reply was modified 4 years, 7 months ago by graf1n.

Hi @graf1n

How to make one product in different categories instead of three?

I assume these should be variable products and variations, correct? If so, you’d need to list all of the categories on the first record with a delimiter to separate the hierarchies:

cat>subcat|cat>sub>cat|cat>cat>sub

You’d use that in the import like so: https://d.pr/i/0yrc1a, and you’d connect the variations like this: https://d.pr/i/2tb1yO (see documentation). Note that you wouldn’t need to list categories for the variations below it because you can’t assign categories to variations in WooCommerce by default.

Why is the tmp category empty? How to make tovar1 appear in the tmp category?

As explained above, you must import the categories at the parent level (or first variation if there are no parents).

Also, if all of the “tovar1” product belong together, they should be listed together – tovar2 should not be in between them.

Hi @graf1n

I’m marking this as resolved since we haven’t heard back. Let me know if you still have questions about this. Anyone else, please start a new thread.