This one is for all of you who’ve got an online farm store full of order and need to put together a harvest list to fill those orders.
In this tip, we’ll see how to …
- Export your orders from you online store as a CSV. (This one is from Shopify – it would be similar with most other ecommerce platforms.)
- Impot your order CSV into a Google Sheet
- Add a new column with an INDEX MATCH formula to make sure all rows are associated with a pickup location.
- Make a PIVOT table to see how many of each crop to harvest for each pickup.
Now you can print out that list and head out to the field!!!