[ic] Re: Changing a SKU

Mike Heins mike at perusion.com
Tue Apr 19 11:55:31 EDT 2005

Quoting ic at 3edge.com (ic at 3edge.com):
> Andre Bunting writes: 
> >Good day all,
> >		IS it possible to change the sku of a product already
> >entered into the system ? if so how ? 
> >
> >I have tried in the admin gui.. and it doesn't seem possible..
> If I remember correct you can go to the tables tab and export the products 
> table. You can then change the SKU for a certain product and import the 
> file again, marking 'allow delete' .. Perhaps there is an easier way, but 
> this is one I think does the trick. 

Assuming you use SQL, you can go to the Direct SQL tab and do:

	update products set sku = 'NEWSKU' where sku = 'OLDSKU'

Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

I am convinced that life is 10% what happens to me and 90%
how I react to it. And so it is for you... we are in charge
of our attitudes. -- Charles Swindoll

More information about the interchange-users mailing list