You can import the related products, categories, and tags using the default WooCommerce importer with the help of a CSV file. Specify comma-separated multiple IDs in the corresponding meta columns.
CSV columns
The sample CSV columns for the related categories, products, and tags are as shown below:
| Meta: _crp_related_product_cats | Meta: _crp_related_ids | Meta: _crp_related_product_tags | Meta: _crp_related_product_attr | Meta: _crp_excluded_cats |
|---|---|---|---|---|
| 196 | music | test1, test2 | color:green,size:large,size:small | uncategorized |
Mapping columns
Ensure to map the columns of CSV as shown below:
Comments (5)
Pismai
May 21, 2024
Hi,
in the example above, are the CSV columns and the Mapping colums based ot the same example ?
I see no relation between cat 106, 108 and music or the ID’s 102, 103 and 196 or tags 115, 120 and tags test1, test2 ?
Arjun
May 29, 2024
Hi Pismai,
Thank you for reaching out. It appears there was an error in the data provided. We apologize for the inconvenience. The information has been updated accordingly.
Nuno Sousa
October 2, 2021
Hi,
I am trying to use this functionality but it’s not working for me. I pasted the code snippet above and I imported a CSV file with the related category IDs. Although I can see the categories properly listed on the product via the backend, on the front end it’s still not showing the related products within the chosen category. However when I edit that product and simply hit the “update” button, then it works! This would mean editing every single product after the import just to update each one individually. Any suggestions?
Erich
July 1, 2021
Hi Shesna
How do I export the Tag_ID associated with the various tags?
Thanks
Erich
Mark
July 2, 2021
Hi Erich,
Are you referring to exporting the related product tags added via our Related Product for Woocommerce plugin?