[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