FSA Tip #30 From Order CSV To Harvest List

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.

You can get the spreadsheet from this tip to follow along at home.

Now you can print out that list and head out to the field!!!

Leave a Reply