update multiple prices
Hi,
I am making a shop with multiple product variations resulting in maybe thousands of products. I have looked at VBO to update prices but it seems that I still need to click save on each single price update?
1. What is the recommended method for updating many different prices?
2. Is there a method where I eventually can calculate the productprice based on some product-properties?
Regards
Lars Nielsen / Grafikom
Comments
I have been looking at VBO
I have been looking at VBO (Views Bulk Operations) to assist commerce and now I can edit around 20-30 prices on a page. But I still have to click 'save' on each single value!
Are there any spreadsheet-like procedures to update multiple prices?
Commerce feeds
You could use Commerce feeds: http://drupal.org/project/commerce_feeds if you want to import/update stuff.
Or try out Editable fields for a UI solution: http://drupal.org/project/editablefields
Through SQL
In Ubercart I could apply a query directly to MySQL and update prices by multiplying or adding. Now that everything has become field based, it has become very complex to find the right query. Anybody has tried it in Commerce that could share his experience?
For me worked the solution
For me worked the solution mentioned by pcambra. I have installed the module http://drupal.org/project/editablefields, then gone to admin/commerce/products (of course http://drupal.org/project/commerce_vbo_views is required), edited the view of product list (upper right corner, engine gear icon), clicked the "Commerce Product: Price (Price)", set the formatter to "editable". After this, I was able to edit all prices without editing and saving the product itself.