[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ic] Re: Changing a SKU


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'

-- 
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


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.