Multiple edit stock

[David_Douma]

Is there an option, that i’m not aware of, that allows to multiple edit stock.
Now: If you have 4 products that you need to adjust the stock level you have to search them one by one… but is there an option the find multiple products in 1 form and then edit the stock → save → done?

Thanks!

[jmiranda]

You have a couple of options, but I don’t know if any of these satisfy your requirements exactly.

Option 1 - Import Inventory

https://openboxes.atlassian.net/wiki/spaces/OBW/pages/1291321345/Inventory+Import

You can use the the Import Inventory feature to create an inventory transaction for a group of inventory items.

1. Go to Import Data
2. Download inventory data file
3. In your favorite spreadsheet editor, remove all rows that aren’t related to the products you want to edit (this is important as you only want to create a transaction for the products you’re editing)
4. Go back to the Import Data page
5. Enter a date for the transaction
6. Choose the edited file from step 1
7. Choose Inventory impot type
8. Click the Upload button
9. Review the data to be imported
10. Click the Finish button

IMPORTANT: This does not create an adjustment transaction (+/-), but rather a stock count. So you must include every row for the product you want to edit. Removing a row is like zero’ing out the quantity.

Option 2 - Adjust Stock feature

Enable Adjust Stock as a supported activity for your location and then use the Manage Inventory feature to adjust stock for specific items.

Option 3 - Adjust Inventory (no longer available but could be added back)

We used to have that available from the Browse Inventory page, but I guess we removed the checkboxes and action menu from the Browse Inventory page (probably for performance reasons). I don’t see why we couldn’t add it back but I wouldn’t hold your breath.

The way it worked as that you’d select multiple products and then click Adjust Inventory button and it would take you to a page like this.

You can still get to the Adjust Stock for a single product by using the action menu in the header of the Stock Card page.

And if you’re willing to do it manually you could grab the product UUIDs and build the URL yourself. You just need a product.id parameter for each product to the URL like below.

https://yourserverurl.xyz/openboxes/inventory/createAdjustment?product.id=product-uuid1&product.id=product-uuid2

Option 4 - Build a new Import Adjustment feature

There was a suggestion to build a new data import for stock adjustments which I think is a great idea, but it’s not currently in our backlog.

Bulk adjust stock through importing a spreadsheet

I think I’m getting the hang of consuming a widget. Is there a way to import a consumption with a spreadsheet? Something similar to how you can import inventory which adds to your inventory stock only this would subtract from your stock, show the widget consumed along with a reason. • Adjust Inventory (Consumption spreadsheet) ○ Select the widget ○ Select adjust stock ○ Reason code "consumed" ○ Comments: "Installed on date"

[David_Douma]

Thanks for the quick respond.

Option 3 seems to be the fastest and easy way, but I understand there where some problems with them.

I tried Option 2 but if I click on some products I get this error:

So not all products are working.

The option to edit a single product from the action menu gives me this error if I do a stock decrease:

Why I ask for this option is simple. We use handwritten lists in our depot. Where users that are not highly IT can write down the items they picked. Afterwards someone will edit the list on the end of the day. Now they have to search and edit each stock manually, and that takes a bit of time.

[jmiranda]

Option 3 seems to be the fastest and easy way, but I understand there where some problems with them.

It might take some time before I have the ability to work on this, but I’ll look into what it would take to restore.

I tried Option 2 but if I click on some products I get this error:

This is a known issue that I fixed in another branch but it’s a long-lived feature branch that hasn’t made its way back to develop yet. I’ll try to get that commit cherry-picked over as soon as I can. In case you want to try to workaround the issue (although I don’t have any good suggestions on how), I think this was due to the fact that there was whitespace in the bin location name or lot number. The request parameter just needed to be URL encoded (i.e. whitespace needs to be removed or converted to %20 or +). In the case of bin locations, replacing all whitespace with hyphens would probably work.

The option to edit a single product from the action menu gives me this error if I do a stock decrease:

Interesting. I think this is an issue with the Adjustment type only being able to accept all positive or all negative quantities (not mixed), but I’ll have to look into that.

Why I ask for this option is simple. We use handwritten lists in our depot. Where users that are not highly IT can write down the items they picked. Afterwards someone will edit the list on the end of the day. Now they have to search and edit each stock manually, and that takes a bit of time.

You could use a debit transaction as well.