Shopify On-prem Reporting

For pulling the Shopify daily report numbers for The Shop almanac or otherwise, specifically for on-premise figures:

• Log in to Shopify with the credentials in 1p, or with your own personal Shopify credentials: https://threesbrewing.myshopify.com/

• Click on "Orders"

  • Click ALL above the search filter

  • In the search filter enter "On-Premise", making sure to use the hyphen.

• Click "More filters"

  • Click "Date"

  • Click "Today", assuming you are querying the date in question.

    • If not, click "Other" and enter the starting and ending dates you want to query

  • If you are querying for Threes Gowanus or Greenpoint, make sure you have the correct location set in the top right.

• Press 'Export'

• Chit the following settings

  • Chit "x orders matching your search"

  • Export as plain CSV file

  • Click "Export transaction histories

• Shopify will either download the CSV file or email it to the associated email for the account you are logged in as.

  • Either way, retrieve the file and open the file.

  • Sum the total in Column G, which will be the amount total.

    • The quick way to do this is to drag and select the total figures, and the sum will be in the bottom right.

  • This is the sum total of sales at your designated location, including tips.