Is there a possibility to edit multiple products (nodes) at once? Not e.g. images, but specifically prices? I (my clients) would love to see that feature implemented...
Tue, 08/05/2008 - 17:01
Re: Editing multiple products at once
Lyle did some work on the Editable Fields module which may allow you to setup a View of product nodes w/ the price fields and use that as a sort of bulk node editor... I haven't tried it myself, but if you can't figure it out you might post back to get a hint from Lyle. 
Re: Re: Editing multiple products at once
The module only works for CCK fields, right? Not for prices I understand.
Re: Editing multiple products at once
On the meantime, does someone know how to run a SQL command to edit all the list prices, reducing the price on 3% for example?
DB List Price Change
Use PHPmyAdmin and look for uc_products. There should be 3 price fields.
UPDATE `your_database_name_goes_here`.`uc_products` SET `list_price` = `list_price` * .97 LIMIT 100 ;First download a copy of uc_products as a backup just in case.
To test, change the LIMIT to 1 so only the first row is changed. Once it works change the limit to how may rows (products) are in your products listing.
This can be used to count the number of products in your table.
SELECT COUNT( * )FROM uc_products;To move all prices up 25% use 1.25, etc. To lower by 1/2 use .5 in place of .97 .
It is fast, easy but not forgiving if an error is made.