We are trying to look into importing our entire product base (40,000+ products) into a new Magento website.
The problem is that we need to assign categories to our products PRIOR to upload, or a way to ensure they will all be categorized during the upload. Putting the products into categories after they have been uploaded would just be a massively time consuming procedure and I know that I must not be the only one with this problem - hence the post!
I looked at adding all categories to the new site and then writing category ID’s into my upload file so they would automatically be categorized during the upload but this also proved to be a very lengthy procedure and again I know I cannot be the only one with this problem.
There must be an alternative, much easier way of importing each category along with each product?
Any sort of ideas are welcome - e.g extensions etc.
I look forward to hearing from someone with more experience than me soon!