napogee Posted December 2, 2004 Share Posted December 2, 2004 I was wondering, if there is a way or contribution, to change the price of all my products to a different price. my items all have the same flat rate price of 5.99 there are about 340 items, i would like to change them all to 4.95, any idea how I could do it. Thanks in advance! ~ Jessie Link to comment Share on other sites More sharing options...
ozcsys Posted December 2, 2004 Share Posted December 2, 2004 I was wondering, if there is a way or contribution, to change the price of all my products to a different price. my items all have the same flat rate price of 5.99 there are about 340 items, i would like to change them all to 4.95, any idea how I could do it. Thanks in advance! ~ Jessie <{POST_SNAPBACK}> Backup your database first!!!!!! In phpmyadmin try the following sql UPDATE `products` SET `products_price` = '4.95', `products_last_modified` = NULL , `products_date_available` = NULL ; The Knowledge Base is a wonderful thing. Do you have a problem? Have you checked out Common Problems? There are many very useful osC Contributions Are you having trouble with a installed contribution? Have you checked out the support thread found Here BACKUP BACKUP BACKUP!!! You did backup, right?? Link to comment Share on other sites More sharing options...
Guest Posted December 2, 2004 Share Posted December 2, 2004 Jesse, The easypopulate contrib could be used to download all of the products, update the prices, and reupload. Also, there's an EZ price updater contrib. ed Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.