What is best practice to bulk importing large amounts of products?
I need to import 3000 products from offline business. I have CSV of products with only SKU, Name and price. The products are for a tech store that has all types of products ranging from pc to bike. This means I need to add attribute sets and specifications for every product separately.
What I can do is scrape products from manufacturers or competitors. I tried using Scrapy for this, but I would have to write a separate script for every product type. Also, I have trouble with downloading images. I can scrape image links but how will I sort them so that they are imported in the right folders.
There are two approaches I can think of:
Add products manually (it would take approx. 3 months)
Make manually attribute sets. Than create scripts for every product type. Import products. Download and add images manually. (it would maybe take a month, but still, I have near 200 categories on this website)