Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Product Code - Can They Be Updated With A Product Import? Rate Topic   - - - - -

 

Posted 04 December 2018 - 10:09 PM #1

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
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19976 posts

Posted 05 December 2018 - 05:27 AM #2

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • crazyshark20
  • Junior Member
  • Members
  • Join Date: 19-Aug 09
  • 310 posts

Posted 05 December 2018 - 10:37 AM #3

   -



 

Posted 05 December 2018 - 04:41 PM #4

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
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11442 posts

Posted 05 December 2018 - 07:44 PM #5

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.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 

Posted 07 December 2018 - 01:02 AM #6

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
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11442 posts

Posted 07 December 2018 - 06:36 PM #7

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.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.