I have more than 100 products and each product is compatible to more then 2000 categories.
What is the most efficient way of linking each product to about 2000 categories using bulk import.
Following are some option which i think of possibility
1.bulk uploading csv file
Upload one proudct using csv and separate each category by @. But it can exceed limit of 35000 characters in excel and make website hang while bulk uploading csv file
2.Modify 2000 categories page (by adding each product on category page using modifying category edit page ). i may be use bulk upload the csv file for 2000 categories. i have not tried it so i am not sure how effecient is this
Please suggest the easiest way for it.
thanks in advance.
kim
What is the most efficient way of linking each product to about 2000 categories using bulk import.
Following are some option which i think of possibility
1.bulk uploading csv file
Upload one proudct using csv and separate each category by @. But it can exceed limit of 35000 characters in excel and make website hang while bulk uploading csv file
2.Modify 2000 categories page (by adding each product on category page using modifying category edit page ). i may be use bulk upload the csv file for 2000 categories. i have not tried it so i am not sure how effecient is this
Please suggest the easiest way for it.
thanks in advance.
kim
Comment