[SkywayWebDesign]

We somewhat regularly have manufacturers updating their product SKUs (Product code) for a product line - even if they are essentially the same product, same image, etc., and I was wondering if there is a simple/quick way to batch update the Product code (SKU - I renamed ours so customers know what it is) for a bunch of products in cs-cart? 

It seems like product imports are linked around the "Product code" variable (it would become a new product if the Product code doesn't already match a product in cs-cart) - even though Product ID's are also available and unique to each item. 

We recently had a manufacturer rename over a 1000 SKU's (Product codes), so a quick product import with the new SKU updated (or something similar - maybe even direct database manipulation) would save a TON of time instead of individually going through the affected products in the Admin products area.  I want to keep the existing product links for SEO purposes, even though it would be much faster to add these "new" products and remove the outdated ones with spreadsheets via exports and imports.  Am I missing anything here - Any suggestions?

Thanks!

[eComLabs]

Since product code is used as primary key, it is required to rework import feature according to your needs

 

As alternative, import new SKU for each item, for example, as promo text field. Then in phpMyAdmin move value from promo text to product code column

[crazyshark20]

   -

[SkywayWebDesign]

Since product code is used as primary key, it is required to rework import feature according to your needs

 

As alternative, import new SKU for each item, for example, as promo text field. Then in phpMyAdmin move value from promo text to product code column

Thanks for the info!  I was pretty sure I would have to do it directly in the database, but just wanted to make sure I didn't miss any tricks in the admin area...

[tbirnseth]

We have an addon for exactly this purpose. We don't advertise it but if you contact me, I'll sell it to you for $20.

It works like this:

 

1) Do a normal export that includes product_Id and product_code in the 'Product id' and 'Product code' columns.

2) Change the value of 'Product code' to be whatever you want for each product you want to change.

3) Import via a custom import and it will set the product_code for each product_id to that which is in the CSV.

4) Optionally do a standard import to apply changes to other columns.

 

It's simply a special import that only makes the adjustments to the product_code for the product_ids in the CSV.

[SkywayWebDesign]

We have an addon for exactly this purpose. We don't advertise it but if you contact me, I'll sell it to you for $20.

It works like this:

 

1) Do a normal export that includes product_Id and product_code in the 'Product id' and 'Product code' columns.

2) Change the value of 'Product code' to be whatever you want for each product you want to change.

3) Import via a custom import and it will set the product_code for each product_id to that which is in the CSV.

4) Optionally do a standard import to apply changes to other columns.

 

It's simply a special import that only makes the adjustments to the product_code for the product_ids in the CSV.

Great, thanks!  I may take you up on the offer.  I'm going to try direct database manipulation first and if it starts to take up a little too much time or becomes a pain to do, I'll definitely want it.  I created a similar custom importer (same situation) with the last shopping cart we had, but I don't have enough time these days to do it again and am glad you already made one.

Where can I buy it from and what versions of CS-Cart does it work with?  (we'll probably be updating the cart in the spring once the season slows down some)

[tbirnseth]

You can email me at support at ez-ms.com and I'll give you purchase instructions.

It's very straight forward and is compatible with any V4 version of cs-cart.

[RSUP]

I have tried this method, but it does not work for me in version 4.11. The update function works of the Product Code rather than Id to update. Is there something I am missing?