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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s