Import of related products data

  • Posts: 44
  • Thank you received: 1
12 years 6 months ago #48737

Hi,

I have just been updating our site, in particular with new 'related products'.
We several hundred of these to do so I created an import file and, just for convenience, organised it with a format similar to the simplified one below:

product_code,related
xxTest_Product_Top2,TD_2180058
xxTest_Product_Top2,TD_2214419

Although the above import correctly attaches both related products to the main product, it completely erases pretty much everything else, including:

The product name
The product description
The product category
The product image
etc etc

However,the following format works fine, keeping all the other product information intact:

product_code,related
xxTest_Product_Top2,TD_2180058;TD_2214419

I have used related product imports before but each line has started with a new product code, not a repeat of the same product code. That type of import also works fine.
The problem seems to be where the product code is a repeat of the line that precedes it. It behaves the same whether the import is from CSV or from the text area.

Regards
PhilP

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
12 years 6 months ago #48777

Yes, you should not have several times the same product in your CSV.
Otherwise, it won't work properly, regardless of what you're trying to import.
You never need or should have more than one line of information per product in your CSV.

Please Log in or Create an account to join the conversation.

  • Posts: 44
  • Thank you received: 1
12 years 6 months ago #48879

OK Nicolas - thanks.
Now I know, I can work with it.
It would be useful to have a warning about this in the user documentation the next time you update it.
Regards
PhilP

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
12 years 6 months ago #48898

Yes. We'll add that warning.

Please Log in or Create an account to join the conversation.

Time to create page: 0.059 seconds
Powered by Kunena Forum