So the previous template I shared was from a single producer hub, with the objective to end up with a list of customers and their ordered products.
Here is another example from a hub with around 30 producers, and the reverse need : having a list of products and their dispatch into buyers’ orders. They have around 180 orders per week currently. Here is their process:
- They assign a number to each buyer. This number is written on a physical box at their delivery spot.
- They create the spreadsheet to know for each product how many they need to put in each box. The temp. controlled products have their own packing sheet taped to the fridge.
- Once the producers have delivered their products, they start packing thanks to this spreadsheet.
How the spreadsheet works:
-
They copy paste packing per customer report in “packing2” tab cell A1. This will generate the order number, they only need to update the spreadsheet to have the list of buyers and their number in “buyer number” tab.
-
They select all the lines with TOTAL ITEMS and delete them (it will mess with the order number formula).
-
They do a pivot table to have a view of the list of product and the quantities per order. Thanks to the pivot table, this can be filtered by temp. control as well.
-
- should be enough but it is not printable with so many orders hence the last spreadsheet tab called “DISPATCH”: where column A and B will be printed out. Basically this tells them : put 2 kg of potatoes in box 1, 2 in box 4 and 6 in box 14. Then put 1 salads in box 4, 6 in box 9 and 2 in box 56… etc
EDIT: The column B is generated thanks to a macro you can launch by clicking on the red button.
Link to the spreadsheet: https://drive.google.com/file/d/1AtICmZ9azKtHu77_Fp4wKOSIv5yATXKe/view?usp=sharing
This made me notice we have no reports showing individual orders by products. We have by customers, by suppliers, but nothing by products.
Also packing does no show shipping method (delivery spots).