[ic] Re: Changing a SKU

[suppressed]

Mike Heins writes: 

> Quoting suppressed (suppressed):
> > 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' 

Oh how simple life can be sometimes :) 

> --
> Mike Heins
> Perusion -- Expert Interchange Consulting    http://www.perusion.com/
> phone +1.765.647.1295  tollfree 800-949-1889 <suppressed> 
>
> 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
> _______________________________________________
> interchange-users mailing list
> suppressed
> http://www.icdevgroup.org/mailman/listinfo/interchange-users


_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users