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?
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... :)
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)
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?
I'm not sure what happened to the forum text above (you can mostly read the original content by copying and pasting the entire page into Notepad and then do a Replace on ass='searchlite'> using the "Replace with" line BLANK - it will remove all the garbage content), but I was just re-visiting this one again. If you need to directly modify the database (MySQL or through phpMyAdmin), you can use the command below - it worked great for me, I created a spreadsheet and ran a whole batch of Product Codes I needed to change in one easy pass - each command on its own row:
UPDATE store_products SET product_code = "BLUE-17" WHERE product_id = 398;
(You will need to change BLUE-17 to be what you need the new Product Code to be that matches up with the corresponding Product ID # - in this example, it was 398)
Explanation: The command above will set the Product Code of Product ID #398 to become BLUE-17 instead of what it was before.
UPDATE store_products SET product_code = "" WHERE product_id = ;
(remove the <> comment characters too)
I'm sure there are many ways of getting it done, but this worked great for me and was reasonably quick to do...
Change three at the same time example:
UPDATE store_products SET product_code = "RED-5" WHERE product_id = 77;
UPDATE store_products SET product_code = "T-65B" WHERE product_id = 167;
UPDATE store_products SET product_code = "Wedge" WHERE product_id = 2;
Again, there's an addon available that is a 1-button approach to the problem as stated in #7 above. It uses the same exported file as you'd use for importing your products. However, if a 'Product id' field is present, it will change the product_code related to that product_id. It acts as pre-filter. I.e. it's run in advance of your running the standard import but uses the same data file. It does nothing other than change the product_code if needed.
Again, there's an addon available that is a 1-button approach to the problem as stated in #7 above. It uses the same exported file as you'd use for importing your products. However, if a 'Product id' field is present, it will change the product_code related to that product_id. It acts as pre-filter. I.e. it's run in advance of your running the standard import but uses the same data file. It does nothing other than change the product_code if needed.
I'm not sure what happened to the forum text above (you can mostly read the original content by copying and pasting the entire page into Notepad and then do a Replace on ass='searchlite'> using the "Replace with" line BLANK - it will remove all the garbage content), but I was just re-visiting this one again. If you need to directly modify the database (MySQL or through phpMyAdmin), you can use the command below - it worked great for me, I created a spreadsheet and ran a whole batch of Product Codes I needed to change in one easy pass - each command on its own row:
UPDATE store_products SET product_code = "BLUE-17" WHERE product_id = 398;
(You will need to change BLUE-17 to be what you need the new Product Code to be that matches up with the corresponding Product ID # - in this example, it was 398)
Explanation: The command above will set the Product Code of Product ID #398 to become BLUE-17 instead of what it was before.
UPDATE store_products SET product_code = "" WHERE product_id = ;
(remove the <> comment characters too)
I'm sure there are many ways of getting it done, but this worked great for me and was reasonably quick to do...
Change three at the same time example:
UPDATE store_products SET product_code = "RED-5" WHERE product_id = 77;
UPDATE store_products SET product_code = "T-65B" WHERE product_id = 167;
UPDATE store_products SET product_code = "Wedge" WHERE product_id = 2;
I hope this helps, good luck!
Hello, I have a question on your query. If we have about 2270 products, we put the ID seperated by comma? Or if theese products are products of a whole category, can this work and how?Thgank you very much.
I would like to, do the data update on products, with the ID Code and not the Product Code. Often, the Product Code field needs to be updated and currently, it is impossible to