I did a test with what appeared to be a free Docs addon (Smartsheet Merge), but turns out it’s only a 30 day free trial. Too bad, because the first test almost worked flawlessly.
Oh, even better! Found a free addon - autoCrat. Pulled the csv into Google Sheets, ran the addon, and it generated THIS lovely label doc. And the template is a really simple Google Doc with the field names in << >> double brackets. You can also add exceptions on the import, so that it will skip lines conditionally. IE: the csv has lines for total items, but the hub column is blank, so it skipped any rows with blank hub data. I should have also tried a test where it skipped anything with “Membership Fee” since those don’t need labels. (Actually, tried that, won’t work … buuuuuuut just deleting those rows from the spreadsheet does the job just fine!)
So that’s a possible solution, but I’m not confident that a lot of our producers would have the knowledge to do this themselves. We do have some who aren’t what you’d call tech savvy. It would also hinge on producers being able to see customer information from their hub orders in the packing reports.
We’d need to figure out a much more automated way to make that happen, even if the results are quite good. Otherwise it’s an extra job that would fall on our hub co-ordinators that would be very time sensitive, and require a separate merge for each individual supplier. Workable, but not exactly ideal.