Product Category Mappying

[harsha.gus]

Hi have about 3000 products in my website.

I want to map those products to New Categories.

Can I make a spreadsheet with two columns like
SKU and Category and Import it?

will this work?
is there any other work around?

[webopius]

Hi

I think there are a number of ways you could approach this...

1. Use the standard import spreadsheet (if you are able to populate it)
2. Write a new spreadsheet containing SKU and Category Names (even better: Product ID and Category IDs), then write a custom import module to process it

or (if you are careful and backup the database first)

3. Create a series of SQL statements that insert the new Product to Category Mappings and run these directly against the database

[jsimacek]

For the Excel based importing route, we have our http://www.ecommercecartmods.com/p-5...torefront.aspx and then for Bulk mapping via the Admin suite we have http://www.ecommercecartmods.com/p-1...torefront.aspx

[harsha.gus]

For the Excel based importing route, we have our http://www.ecommercecartmods.com/p-5...torefront.aspx and then for Bulk mapping via the Admin suite we have http://www.ecommercecartmods.com/p-1...torefront.aspx

Can i Get a Demo of these modules, the screen shots were not showing everything.

Thanks

[jsimacek]

Sorry about that, the image was missing...you should be able to see the screenshot now.

Both are quite easy to use, but due to the nature of these add-ons, we cannot provide demos.