[ic] Re: Changing a SKU

[ic at 3edge.com]

Mike Heins writes: 

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

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 <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
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users