mass price editor

Contrib type: 
Module
Status: 
Initial upload
Moderation: 
Awaiting moderation

Downloads

Compatibility: 
Ubercart 1.x

This module will let an admin with the appropriate role edit all product prices for one taxonomy category at once using a table form showing title -> price.

It is quite rough - there are no options for configuration as of yet but it will provide all that my site admins need at this point in time.

This module will let an admin edit the prices for all the items associated with one taxonomy term. All the items will be listed in a form in a table. When the form is submitted, the products table will be updated with the shown price for the item.

Obviously this module can be greatly improved. I'm posting as is in case someone finds it useful.

PreviewAttachmentSize
uc_price_manager.tar8 KB
zeezhao's picture
Offline
Joined: 04/23/2008
Juice: 1075
Re: mass price editor

Tried it out. Its a great start.

By the way, there is a bug whereby updated prices are currently being rounded to whole numbers. The module needs a fix in function uc_price_manager_make_form_submit to replace %d with %f i.e.:

db_query("UPDATE {uc_products} SET sell_price = %f WHERE nid = %d", $price, $nid);

Blackguard's picture
Offline
Joined: 10/24/2007
Juice: 47
Re: Re: mass price editor

Thanks - I've updated the file with your change.

andor_pds's picture
Offline
Joined: 12/12/2008
Juice: 13
some improvements

Hi

first of all, thank you for this module.

I made some simple modification
for addition price manipulation...

- You could change all product price at once
there are two options:
1. add an amount to price
2. rise or lower the prices in %

Andor,
www.webdizajn.co.rs

AttachmentSize
uc_price_manager_1.zip 2.44 KB
macsobel's picture
Offline
Joined: 12/23/2008
Juice: 9
Adding Retail Price Too

Whenever we change our prices it is because the manufacturers do and we have to follow suit. So I wanted to add retail prices too.

Do you guys think you could help me finish an addition to the code? I was going to upload it when I finished it but I have no Drupal coding experience.

I started adding in the ability to change retail prices too. I added the fields but haven't figured out how to save my edits. Anyone want to help?

AttachmentSize
uc_price_manager_retail.zip 3.52 KB
Miquel carol's picture
Offline
Joined: 01/15/2009
Juice: 2
SKU identification

Hi all,

Have any possibility to can swich or select, between the title of product and the SKU number¿?

Usually the changes on prices, make more fast if we can use the SKU than the product name.

Thx, for all.

viktormas's picture
Offline
Joined: 12/20/2008
Juice: 8
Re: mass price editor

Great module! Thank you so much. I believe this should be part of Ubercart's core system.

DickSwart's picture
Offline
Joined: 03/16/2009
Juice: 39
Upgrade?

Anyone know if this module will be upgraded to Ubercart 2.x for drupal 6?

Juanzo@drupal.org's picture
Offline
Uber Donor
Joined: 05/05/2008
Juice: 79
Re: mass price editor

Great contribution! Any change that this could be updated to Drupal 6 or moved to drupal.org?

douglas79's picture
Offline
Joined: 07/31/2009
Juice: 39
Re: Re: mass price editor

Yes, also interested in the D6 version!

KingAndy's picture
Offline
Joined: 04/01/2009
Juice: 95
Re: mass price editor

I've just given this module a thorough going-over, cleaning up the code and clarifying the language ... the only major change in functionality is that you can now apply the multiplier/raiser to ALL PRODUCTS simultaneously (this doesn't supply a list of all the products, as potentially that could be pretty big, it just straight out multiplies/adds using SQL). It's not a D6/U2 update but it definitely needed to be done.

I also fixed a bug in the SQL code for fetching products which presented duplicates if there were more than one revision of a product node - it now uses INNER JOIN on VID (that's version ID, not vocabulary).

Oh, BTW, this is based on andor_pds' code in #3, and extends his idea for the multiplier/raiser fields.

Finally - this modification does change the menu hierarchy! The form no longer has its own path, it's presented at the same URL (admin/store/price_manager). You'll have to clear you menu cache (usualy by visiting admin/build/menu) after updating.

That is all

AttachmentSize
uc_price_manager.zip 3.21 KB
Dave_____1's picture
Offline
Joined: 12/17/2008
Juice: 24
Hi KingAndy, I'm looking for

Hi KingAndy,

I'm looking for this type of thing for D6 and UC2, is there anything out there that you know of?

Dave.

skydesigner's picture
Offline
Joined: 10/13/2009
Juice: 4
mass price editor

I'm looking for this type of thing as well for D6 and UC2.
if anyone know please let me know.

many thanks.

Alan.

skydesigner's picture
Offline
Joined: 10/13/2009
Juice: 4
to the master dave,

have you found it yet???

Alan.

Juanzo@drupal.org's picture
Offline
Uber Donor
Joined: 05/05/2008
Juice: 79
Re: to the master dave,

I'm also looking for something to accomplish the same thing this module does.

moby's picture
Offline
Joined: 10/05/2008
Juice: 205
doh

wishing & hoping for a 2.0 port...

johnflower's picture
Offline
Joined: 12/21/2009
Juice: 2
+1

This would be great to have in UC2!

FixiT's picture
Offline
Joined: 03/15/2010
Juice: 12
UC2 mass price

Drupal 6 and Ubercart 2 needed this or same tool for mass price editing... If web store have more than 1000 items - absolutely impossible do price updates everyday.

zeezhao's picture
Offline
Joined: 04/23/2008
Juice: 1075
uc_stock_update for mass price updates

Have a look at the module uc_stock_update as it may help...: http://www.ubercart.org/contrib/12428

FixiT's picture
Offline
Joined: 03/15/2010
Juice: 12
uc_stock_update for mass price updates

Thank you for reply. I have test for this module and see fine results, but i don't have clear solution for export part.. I don't see attributes options price fields in view. Manual creation of full list of 2000+ items is not acceptable solution rather when products has been added everyday...

zeezhao's picture
Offline
Joined: 04/23/2008
Juice: 1075
pls explain export

I do not understand what you mean by export - export from drupal? Please explain. If its from another system, then just use spreadsheet to create csv file.

If you have new products, then you are better off using node_import - see:
http://www.ubercart.org/contrib/5221#comment-46436

edit:
will also need this node_import patch for attributes: http://www.ubercart.org/contrib/11013

FixiT's picture
Offline
Joined: 03/15/2010
Juice: 12
export for price updating

Yes, export from Drupal. I see best possibility to export data from view (uc_view + bonus pack for CSV export) but i don't see list price field from product_options table in views.