support

how to move the content in form "SKU" to "Model" in each products all at once

Started by denagpam, November 08, 2014, 11:06:21 PM

Previous topic - Next topic

denagpam

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 ?

llegrand

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.





epimadman

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?

Forum Rules Code of conduct
AbanteCart.com 2010 -