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.