14 replies [Last post]
Juanzo@drupal.org's picture
Offline
Uber Donor
Joined: 05/05/2008
Juice: 79

I was wondering if anyone else has a solution to easily edit multiple product prices easily. Since the mass price editor contribution is outdated, I am currently using Editview to accomplish this.

Yet, Firefox loads around 200MB+ in memory each time I display the view generated to edit the prices and some clients are complaining.

Does anyone else have any solution to accomplish this? Any help is appreciatted.

Juanzo@drupal.org's picture
Offline
Uber Donor
Joined: 05/05/2008
Juice: 79
Re: Easily edit multiple prices?

Is this something that you guys never did or need? I wonder if other people have this need.

For my clients, price updating is something really common and having to edit each product, one by one, is a bit frustrating.

torgosPizza's picture
Offline
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.
Joined: 08/14/2007
Juice: 4110
Re: Re: Easily edit multiple prices?

Sounds like something that might be doable in uc_views and Views Bulk Operations... have you looked at them? Is this a D6 site?

--
Help directly fund development: Donate via PayPal!

Juanzo@drupal.org's picture
Offline
Uber Donor
Joined: 05/05/2008
Juice: 79
Re: Re: Re: Easily edit multiple prices?

Thanks for your reply torgosPizza. This is a Drupal 6 site, sorry for not detailing it before.

I've installed VBO and tried playing with it without any luck. I do see all the node fields but not the product price. Maybe it needs a specific action to be written to make it work? If you have any ideas or suggestions, please let me know.

Alaska's picture
Offline
Joined: 10/16/2007
Juice: 1433
Price Change

You can always use phpMyAdmin to modify the prices in the database. Do this on this end to move all prices up or down say 10%, etc.

Juanzo@drupal.org's picture
Offline
Uber Donor
Joined: 05/05/2008
Juice: 79
Alaska wrote: You can always
Alaska wrote:

You can always use phpMyAdmin to modify the prices in the database. Do this on this end to move all prices up or down say 10%, etc.

Thanks for your suggestion Alaska. phpMyAdmin would be nice but this is a solution I need for our clients, how have no clue about databases and if I grant them MySQL access they will probably mess up.

Juanzo@drupal.org's picture
Offline
Uber Donor
Joined: 05/05/2008
Juice: 79
Re: Alaska wrote: You can always

Maybe it's us. Living in Argentina and the currency prices changing very often makes us need something like this. Is there anyone able to give us a hand with this? I'd also love to receive some quotes in case someone can make a good price editor for Ubercart.

Juanzo@drupal.org's picture
Offline
Uber Donor
Joined: 05/05/2008
Juice: 79
Re: Re: Alaska wrote: You can always

Sorry to bring this thread up, but if anyone has any ideas, suggestions, or maybe can send us a quote on how to handle this it will be great.

hedac's picture
Offline
Joined: 12/14/2007
Juice: 143
Re: Re: Re: Alaska wrote: You can always

I'm also frustrated when it comes to update multiple products at once... price or options. I'm trying now to figure out how to do custom PHP scripts with Views Bulk Operations module. Or maybe it is better to configure an "Action" that can be used with it.

torgosPizza's picture
Offline
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.
Joined: 08/14/2007
Juice: 4110
Re: Re: Re: Re: Alaska wrote: You can always

It sounds like a possible solution in uc_views. I'm not sure if that allows multiple product edits, though, but it's a cool idea. Consider setting up a bounty.

--
Help directly fund development: Donate via PayPal!

Willem's picture
Offline
Joined: 02/21/2010
Juice: 24
G'day guys, I too have an

G'day guys,

I too have an interest in this. When I have finished the site I am building at present I will have over 1500 products. Updating prices one at a time is a painful - and expensive - prospect. Currently I have a website with similar products on Zen Cart, (see EveryLabel.com.au ) and they have a copy facility in their 'Attributes Controller', where you can copy all the attributes from one product to an entire category at once. This page is a good example of how it looks to the customer:

http://www.australianstory.net.au/blanklabels/index.php?main_page=produc...

If Zen Cart can do it, surely Ubercart can - if they are the 'One cart to rule them all'?

I'd really appreciate any feedback on any developments in this area since this thread was last active some 12 months ago.

Thanks

Willem

Willem

MartyW's picture
Offline
Joined: 03/12/2010
Juice: 13
Me too!

I hate me too posts... but this is also a need for a client of mine. It would be nice it input something like "10%" and just have all the prices go up or down based on the percentage increase/decrease.

Willem's picture
Offline
Joined: 02/21/2010
Juice: 24
Re: Easily edit multiple prices?

I think I have worked out the way to do this ... but its not working.

It seems to me that the way to do it is to use 'classes'. You can set up attributes and options for 'classes', and when you add products to those classes they all have the assigned attributes and options. Looks good ... BUT ... when you edit the 'Class' in only updates the products listed after the edit. It does not update the products listed before the edit?

Which makes a 'Class' of limited use!

You can check it out here http://wholesalelabels.com.au/catalog/1

Rats! I thought I had the problem nailed. Sad

Willem

Willem

zeezhao's picture
Offline
Joined: 04/23/2008
Juice: 956
Re: Easily edit multiple prices?

As an alternative, have you tried the module uc_stock_update : http://www.ubercart.org/contrib/12428

It requires a csv file to update prices with: SKU, Stock level, Sell Price, List Price

Willem's picture
Offline
Joined: 02/21/2010
Juice: 24
Pricing by Attributes and Options

Drupal 6.14/ Ubercart 2 (I know, there's a Drupal update. I should update ... haven't yet ... its too hard! Sad )

Because the site I am building has large numbers of products with lots of options, About 200 products, each with three attributes, each attribute with 21 options http://wholesalelabels.com.au/catalog/1 ) I wanted a way to update those details without having to manually go thru each one. this is what I've worked out.

Set up the attributes and options in the standard way - Administer> Store administration> Attributes.

Set up a 'Class' - Administer> Store administration> Products> Manage classes. Setup the attributes and options on that class. You can now use that class as a template for setting up any number of products.. You can set up more classes for different types of product, if you want. But classes operate only as templates. They don't operate as an update mechanism for products already created using that class.

To update prices and other attributes without having to manually edit each price, do this:

Go to the product you want to update, then Edit>Attributes and DELETE the attribute you want to update. Then immediately add that Attribute back in. The updated version will now load. A quick check of the Options tab to make sure the options are as you want them. Don't forget to hit the 'Save' button!

This is still pretty clunky, but it sort of works. What would be ideal is to have every product created using a 'Class' be automatically updated when that class is updated. I don't have that skill ... perhaps someone else could take that one on??

Willem

Willem