Bulk stock updater

Contrib type: 
Module
Status: 
Complete and working
Moderation: 
Awaiting moderation

Downloads

Latest version: 
6.x-1.0
Compatibility: 
Ubercart 2.x

Bulk Stock Updater is a Ubercart extension module which lets you easily bulk-edit stock levels for all your products. It displays a page similar to the uc_stock module’s Stock reports page.

Once the module is enabled, ensure you assign the 'bulk update stock' permission to the appropriate user roles. You should see the following new menu: Store administration > Stock

Goto Store administration > Stock > Bulk update and you will see a paged list of your products ordered by SKU. At the bottom is a link to view all the products on one page if you wish. On the one-page view you'll be able to filter the list of products using the input field at the top.

You will notice that the stock value for each product is displayed as an input field. Once you change the value in an input field it will be automatically submitted to the server via AJAX (you will see a progress indicator while this happens). If any errors occur the field value will be reset to what it was originally and an error message will be shown.

You can refer to the CSS file in the module’s folder to find out which styles need to be overridden in order to customize the look and feel.

----

The reason for building this module was that none of the other ones really did what I wanted. There is now a project page on Drupal.org - http://drupal.org/project/uc_bulk_stock_updater


PreviewAttachmentSize
uc_bulk_stock_updater-6.x-1.0.zip7.34 KB
j.mead's picture
Offline
Joined: 07/27/2009
Juice: 385
Re: Bulk stock updater

I just started testing this, and so far I'm very impressed. My test site handles it well, and I haven't come across any conflicts with other functions yet. Hopefully there aren't going to be any issues.
I don't know how hard it would be to implement, but I think that the ability to filter or narrow down the listed SKUs on a large site would a great thing. My test site has only a dozen items, so it's easy to update the quantities. My actual site has over 1000 items at the moment, so while this would work to adjust items for sales from our retail store, scrolling through that many SKUs to get to the needed ones is a bit of work.
I really like how it is so far, and I hope that this goes forward without issue.
Thanks very much for the module, and I'm going to keep testing to see if there's anything that keeps this off my production site.

the sites i'm always breaking.... www.sew-la-fabric.com
http://lostpetsla.com (though i hope i never break this one too bad)

hiddentao's picture
Offline
Joined: 04/29/2010
Juice: 51
Re: Re: Bulk stock updater

Thanks for trying it out. I've added a small filtering field which shows up when you view all the items on a single page.

j.mead's picture
Offline
Joined: 07/27/2009
Juice: 385
Re: Re: Re: Bulk stock updater

So I added the new version, and it's pretty great so far. I only have about 20 items in my test site, so I need to add a bunch more to get a better idea of how it will work on my real site (1500+ items).
I posted a similar reply in the forums, and hopefully the increasing exposure will boost the usage of this for those who could benefit. I don't need to change much on a regular basis, it's really just the stock levels needing to be kept in line with the retail POS system we have, which is a frustrating thing as we eagerly jumped on it before we thought ahead to our future needs...... hence my manual daily updating.

Thanks again!

the sites i'm always breaking.... www.sew-la-fabric.com
http://lostpetsla.com (though i hope i never break this one too bad)

kgod's picture
Offline
Joined: 12/28/2009
Juice: 9
Awesome

This is great and i can't help but wonder how awesome it would be if you could edit price at the same time?

adrianf25's picture
Offline
Joined: 03/14/2010
Juice: 11
How to activate bulk exietncia levels?

the module is great and I avoid doing:

UPDATE `deldiario`.`uc_product_stock` SET `stock` = 1;

But what I fail to do is "enable massively" for those products that have disabled the level of existence. Do you know how could I?

Since I can only change the level of existence of the previously enabled product in: http:// .../node/xxxx/edit/stock

hiddentao's picture
Offline
Joined: 04/29/2010
Juice: 51
Re: Bulk stock updater

This module is now available on Drupal.org -> http://drupal.org/project/uc_bulk_stock_updater