AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: denagpam on November 08, 2014, 11:06:21 PM

Title: how to move the content in form "SKU" to "Model" in each products all at once
Post by: denagpam on November 08, 2014, 11:06:21 PM

Hi

I have a problem that I have fill the wrong form in which the contents in form "SKU" should be in the form "Model"

so how to move them onto the latter form ?

Title: Re: how to move the content in form "SKU" to "Model" in each products all at once
Post by: llegrand on November 09, 2014, 01:20:59 AM

Make a backup of your database PRIOR to working in it.

In your database,  the two fields are located in the table called Products.   
Export that table to a CSV spreadsheet move your values from SKU column to the Model Column.   
Save as CVS.
Import your table back.

Title: Re: how to move the content in form "SKU" to "Model" in each products all at once
Post by: epimadman on July 14, 2016, 11:07:32 AM

Is there a way to issue an SQL command to copy all from the SKU table to the MODEL table?  For someone with 35000 products, exporting products won't work even with high memory allocations.

Ideally there would be an easier way to do this as the sku is required to order from the distributor and it doesn't show up in print invoice.  Any suggestions?