I’ve put together something of a ‘sort of’ solution for our purposes.
This takes the ‘pack by customer’ report from our hub, as a csv (example) from OFN, user uploads it through the form, selects the OC date from the date picker field, and clicks import.
The script uploads the data, imports it to a mySQL database, then pulls the data, sifts through it all, and spits out a display like this. When the user prints, it turns into something like Generate Labels_CLFC-TEST_1.pdf (78.3 KB), with labels for each producer separated into separate pages, and each page has the variants broke down by customer. So if Bob bought 300g of tomatoes, and Sally bought 500g of tomatoes, there will be a label for each, showing the number of 100g of tomatoes each purchased.
The final page is kind of a packing checklist - just the products/variants and how many in total of each item are needed to fulfill all the orders. So if a producer needs 16 heads of Romaine lettuce to fill all of their orders, it just says Lettuce - Romaine - 16, and there’s a space on the left they can check off when they’ve harvested the 16 heads.
If anyone wants to try it with their own files, it’s the pack by customer report you need (other reports will give unexpected results, since the DB is set up for this report specifically), and the script is here. I’ve removed the CLFC logo from the script.
My ideal situation here is that we get the OFN producer pack by customer report able to display the customer names instead of “HIDDEN” … then they could run the script to have their own labels/packing sheets made, instead of having it at the hub level, as this is.