Assign product to category by SQL with CSV

[lukaszwoznb0bb]

Hello!

We have over 110'000 products (4400 config products) and we  need to assign all of them to few categories. Yesterday we run a script but will take a lot of time (20h = only 4000 products).

I think the best option will be to do it directly in sql.

We have a csv with:
SKU of config product | root category | subcategory

I found some information the best will be create table in sql based on the csv but what later?

Thanks for help!

[gaurav_harsh1 · Accepted solution]

Hello @lukaszwoznb0bb 

For huge count of products, you can first create URL's of those product name from script and update, then it will take pretty less time, here is a blog with example of code, please check this once and let us know if it helped or not :

https://bsscommerce.com/confluence/how-to-import-a-large-number-of-products-in-magento-2/