-
-
Notifications
You must be signed in to change notification settings - Fork 406
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Warehousing Storage & Weight Calculation Feature Request #1852
Comments
@tech4kstudios As a first pass, we could implement these as product attributes and extend some of the reporting to include the attributes as well as product attributes that are custom formulas. This would be fine for the first two bullets as well as some reports. However, we wouldn't be able to include volume / weight in the workflows just yet. The longer term solution would be to add these properties to ProductPackage and allow you to select a specific product package as the default for storage (or at least a default unit of measure: EA, BTL/100, BX/10). We also might want lot numbers to be associated with a ProductPackage so that you could have different volumes / weights if you have multiple suppliers that each send a package with different volume / weight. We'd also want the product package to be associated with a bin location. The only issue there is that I'm not sure how we'd deal with an implementation where different products are co-mingled in a single bin location (see Amazon Prime as an example https://youtu.be/5TL80_8ACPc?t=20). I guess there the bin location wouldn't be associated with a product package but rather with its own volume / weight restrictions and all the items would just need to fit within that space. Let me know what you think and whether you'd be cool with a short-term solution that uses product attributes. Here's what I'm thinking:
|
@jmiranda A short term solution like this would be perfect to get started. Would allow my business to make the switch from entirely Excel based to something an order of magnitude better. Then based on the observable workflow, we can make modifications and additions to future passes. Had a look at the Amazon Prime video linked. Seems like they are dealing with smaller quantities of a large range of products. In our warehouse a significant proportion will involve handling pallets and other bulk goods and will be shipped out in bulk quantities. Although there will be fulfilment, only one or two items will be picked per order, and as we likely won't have anywhere near the same range of items found in warehouses such as Amazon, items with the same barcode/SKU will be placed together. In terms of volume calculation, we can definitely implement automation of this in future passes. It is not a critical requirement to get started. The rest of the outline looks great! |
@tech4kstudios I made some progress on this last week. I'll share a video some time this week. |
@jmiranda Thank you heaps, look forward to the video and can't wait to start using it. My business has been expanding a fair bit and using excel is taking a big toll at the moment. |
Attached a sample XLSX file. This actually needs to be an XLS file when importing into OpenBoxes, but Github does not like XLS for some reason. |
@tech4kstudios Finally had time for a rambling video to show some progress on this one |
Here's a custom query we could run to get the total weight and volume for each product. Slight modifications would be required to aggregate at the bin location or inventory item level. Temperature was added to show a basic example of what we could do with time series data.
|
#1852 Allow users to import product attributes
… to the attribute and product attribute tables
… to the attribute and product attribute tables
@tech4kstudios Did you ever get my Slack messages back in December regarding this feature? If not I'll upload the video and comments here so we can continue the discussion. I had a branch that was more or less ready to be merged ... was just waiting on your feedback. |
Here's the video demonstrating the new customizable export feature https://www.youtube.com/watch?v=o8Xqf5OAfOM We're about to get 0.8.15 out the door so I wanted to give you a chance to review to see if this might be a good candidate for the release. Otherwise, we can work on it at some point in the future. |
Workflow
Excel Document Currently Used for this Workflow: https://cloud.t4ks.com/s/Kry76pepRTkcGKY
Purpose
The purpose of such a system is to allow warehousing businesses to quickly see the space consumption of the items, thus allowing for use cases like invoicing where storage is calculated based on monthly storage usage charged per cubic metre, see required space when creating shipments, ie. does the shipment weight or volume exceed the allowed limits, is it required to be split into separate shipments, does the shipment method need to be changed due to volume and weight, etc...
Future Use Cases
Furthermore, future feature additions such as automated weight limit notifications can allow for use cases such as:
To-Do
Remaining to-do points to be added by dev with more knowledge of implementation and requirements than me ;)
The text was updated successfully, but these errors were encountered: