Jump to content

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

Trying To Amend Product Codes Rate Topic   - - - - -

 
  • AMB
  • Member
  • Members
  • Join Date: 07-May 18
  • 47 posts

Posted 13 July 2021 - 05:30 PM #1

Hi,

 

I have been asked by my Management team to make some changes to our product codes on some of our products.

 

Where the part number is 'AFFS-OR-04-1' they want it changed to 'AFFS-OR-04-01'. I have updated the Master File and when loading it in I had a number of error messages stating that a product updated has the exact same combination of feature values as a variation that already exists in the group.

 

I have attached two screenshots. The first being the error messages and the second a cut from the master file.

 

The original master file loaded in fine the first time it was done and also on several other occasions where other updates have been made.

 

Any ideas why changing the product code would create this error message? We are currently on Version 4.12.1

Attached Thumbnails

  • Staging_PN_Updated.jpg
  • Master_File_with new PN.jpg


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 22197 posts

Posted 14 July 2021 - 04:44 AM #2

I am afraid, you cannot update product codes with import feature since product code is used as primary key to identify product


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)

 
  • AMB
  • Member
  • Members
  • Join Date: 07-May 18
  • 47 posts

Posted 14 July 2021 - 12:48 PM #3

Thank you for you response.

 

So could they manually be updated in CS-Cart?



 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 22197 posts

Posted 14 July 2021 - 01:16 PM #4

Yes, manually you can change them


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)

 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12091 posts

Posted 14 July 2021 - 06:54 PM #5

I have a "pre import" filter that will change product codes if the product_id is specified. Feel free to contact me via my signature if you're interested....

 

The way it works is that you use the same import file you normally do except you import via a special menu item.  It only utilizes the product_code and product_id columns.  If a product_code for a product_id is different than what's in the DB, it updates the product_code to be that specified in the import file.

 

You then do you normal import and it uses the new product_code without issue.  Note that it does NOT address any duplication issues you might inject from your data.


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.