Skip to content

Instantly share code, notes, and snippets.

@lqb2

lqb2/5feb2014.csv Secret

Forked from bengolder/index.html
Last active August 29, 2015 13:56
Show Gist options
  • Save lqb2/9215865 to your computer and use it in GitHub Desktop.
Save lqb2/9215865 to your computer and use it in GitHub Desktop.
Download ZIP
OK So Now I'm really confused as to why this isn't working...
Raw
5feb2014.csv
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
Date Time Category Item Quantity Price Point Name SKU Modifiers Applied Gross Sales Discounts Net Sales Payment ID Device Name Notes Details
2/5/14 21:14:04 Coffee Espresso 1 Single $1.68 $0.00 $1.68 A47ND940CXZBK Sean https://squareup.com/dashboard/sales/transactions/A47ND940CXZBK
2/5/14 21:14:04 Ice Cream Ice Cream 2 1 Scoop $7.94 $0.00 $7.94 A47ND940CXZBK Sean https://squareup.com/dashboard/sales/transactions/A47ND940CXZBK
2/5/14 21:07:23 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 gfVmsGnVNBs0Tvyj0GB Sean https://squareup.com/dashboard/sales/transactions/gfVmsGnVNBs0Tvyj0GB
2/5/14 21:07:00 Ice Cream Ice Cream 1 Pint $6.31 $0.00 $6.31 SSg7vyD9bn8xqtdT0GB Sean https://squareup.com/dashboard/sales/transactions/SSg7vyD9bn8xqtdT0GB
2/5/14 21:04:40 Ice Cream Ice Cream 2 2 Scoop $10.28 $0.00 $10.28 2FEN3ZPAB82N7 Sean https://squareup.com/dashboard/sales/transactions/2FEN3ZPAB82N7
2/5/14 21:02:00 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 oTHlrXaAWgVrhLe60GB Sean https://squareup.com/dashboard/sales/transactions/oTHlrXaAWgVrhLe60GB
2/5/14 21:01:52 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 AFuB6weMmOO6Mirk0GB Sean https://squareup.com/dashboard/sales/transactions/AFuB6weMmOO6Mirk0GB
2/5/14 20:57:59 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 2O9N0b06WS3UsmWI1GB Sean https://squareup.com/dashboard/sales/transactions/2O9N0b06WS3UsmWI1GB
2/5/14 20:57:41 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 szUOg1nx7NF2WhnW1GB Sean https://squareup.com/dashboard/sales/transactions/szUOg1nx7NF2WhnW1GB
2/5/14 20:57:29 Coffee Mocha 1 M Vanilla Mocha $4.02 $0.00 $4.02 C26ZlA6i0hy13FX30GB Sean https://squareup.com/dashboard/sales/transactions/C26ZlA6i0hy13FX30GB
2/5/14 20:56:43 Drinks Hot Chocolate 1 L Hot Vanilla $3.74 $0.00 $3.74 shtRpdb80HQQKWA30GB Sean https://squareup.com/dashboard/sales/transactions/shtRpdb80HQQKWA30GB
2/5/14 20:56:28 Drinks Hot Chocolate 1 L Hot Chocolate $3.55 $0.00 $3.55 OeFUQqyC3I1oQmRf0GB Sean https://squareup.com/dashboard/sales/transactions/OeFUQqyC3I1oQmRf0GB
2/5/14 20:56:07 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 WM66pTtn0hT3DwG20GB Sean https://squareup.com/dashboard/sales/transactions/WM66pTtn0hT3DwG20GB
2/5/14 20:55:45 Drinks Hot Chocolate 1 M Hot Chocolate $3.08 $0.00 $3.08 8Ty1pmRInvM62Nrj0GB Sean https://squareup.com/dashboard/sales/transactions/8Ty1pmRInvM62Nrj0GB
2/5/14 20:55:18 Drinks Hot Chocolate 1 S Hot Chocolate $2.85 $0.00 $2.85 cRLGd61OOZu5cGN0zGB Sean https://squareup.com/dashboard/sales/transactions/cRLGd61OOZu5cGN0zGB
2/5/14 20:54:48 Tea Chai 1 Small $3.08 $0.00 $3.08 EpzrI9rCwLM8hBr10GB Sean https://squareup.com/dashboard/sales/transactions/EpzrI9rCwLM8hBr10GB
2/5/14 20:44:47 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 EFRFT1BZMZEHR Sean https://squareup.com/dashboard/sales/transactions/EFRFT1BZMZEHR
2/5/14 20:44:15 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 SiElnjvS7PPVetSE1GB Sean https://squareup.com/dashboard/sales/transactions/SiElnjvS7PPVetSE1GB
2/5/14 20:44:15 Tea Tea 1 Hot $1.92 $0.00 $1.92 SiElnjvS7PPVetSE1GB Sean https://squareup.com/dashboard/sales/transactions/SiElnjvS7PPVetSE1GB
2/5/14 20:43:59 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 gBo9V55h4DD7UyZF1GB Sean https://squareup.com/dashboard/sales/transactions/gBo9V55h4DD7UyZF1GB
2/5/14 20:43:59 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 gBo9V55h4DD7UyZF1GB Sean https://squareup.com/dashboard/sales/transactions/gBo9V55h4DD7UyZF1GB
2/5/14 20:39:45 Ice Cream Ice Cream 3 2 Pints $35.04 $0.00 $35.04 6imFgTEVsgMFR6Cn0GB Sean https://squareup.com/dashboard/sales/transactions/6imFgTEVsgMFR6Cn0GB
2/5/14 20:37:26 Drinks Bottled Drinks 1 Vitamin Water $1.87 $0.00 $1.87 yOQGgReEf5XueXUy0GB Sean https://squareup.com/dashboard/sales/transactions/yOQGgReEf5XueXUy0GB
2/5/14 20:37:26 Ice Cream Toppings 1 Regular Price Nuts and Stuff $0.70 $0.00 $0.70 yOQGgReEf5XueXUy0GB Sean https://squareup.com/dashboard/sales/transactions/yOQGgReEf5XueXUy0GB
2/5/14 20:37:26 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 yOQGgReEf5XueXUy0GB Sean https://squareup.com/dashboard/sales/transactions/yOQGgReEf5XueXUy0GB
2/5/14 20:34:36 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 26HJX6VXwbOYFgcI0GB Sean https://squareup.com/dashboard/sales/transactions/26HJX6VXwbOYFgcI0GB
2/5/14 20:34:17 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 2TVPC3AJNAEZ2 Sean https://squareup.com/dashboard/sales/transactions/2TVPC3AJNAEZ2
2/5/14 20:33:50 Coffee Espresso 1 Double $1.92 $0.00 $1.92 76HZ6M22YKZQJ Sean https://squareup.com/dashboard/sales/transactions/76HZ6M22YKZQJ
2/5/14 20:32:16 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 aWuKXSKLCsZ7rqXH0GB Sean https://squareup.com/dashboard/sales/transactions/aWuKXSKLCsZ7rqXH0GB
2/5/14 20:22:15 Ice Cream Ice Cream 1 Pint $6.31 $0.00 $6.31 1F8EY9C446TPQ Sean https://squareup.com/dashboard/sales/transactions/1F8EY9C446TPQ
2/5/14 20:22:15 Ice Cream Ice Cream 1 2 Pints $11.68 $0.00 $11.68 1F8EY9C446TPQ Sean https://squareup.com/dashboard/sales/transactions/1F8EY9C446TPQ
2/5/14 20:19:02 Drinks Hot Chocolate 1 S Hot Chocolate $2.85 $0.00 $2.85 y6ukZLU4TaoaKduR0GB Sean https://squareup.com/dashboard/sales/transactions/y6ukZLU4TaoaKduR0GB
2/5/14 20:17:47 Tea Tea 1 Hot $1.92 $0.00 $1.92 496aFpzu6NsvFh1M0GB Sean https://squareup.com/dashboard/sales/transactions/496aFpzu6NsvFh1M0GB
2/5/14 20:17:47 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 496aFpzu6NsvFh1M0GB Sean https://squareup.com/dashboard/sales/transactions/496aFpzu6NsvFh1M0GB
2/5/14 20:17:11 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 oRi9iedRN9sV2q4c0GB Sean https://squareup.com/dashboard/sales/transactions/oRi9iedRN9sV2q4c0GB
2/5/14 20:17:00 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 gpGYym18ZfRt7VZ2zGB Sean https://squareup.com/dashboard/sales/transactions/gpGYym18ZfRt7VZ2zGB
2/5/14 20:16:32 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 E7221UhVKLRSnwzd1GB Sean https://squareup.com/dashboard/sales/transactions/E7221UhVKLRSnwzd1GB
2/5/14 20:16:13 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 CCgzeyGjuvRNGBGD1GB Sean https://squareup.com/dashboard/sales/transactions/CCgzeyGjuvRNGBGD1GB
2/5/14 20:15:19 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 iaSg9qDgjHgGAWml0GB Sean https://squareup.com/dashboard/sales/transactions/iaSg9qDgjHgGAWml0GB
2/5/14 20:15:19 Ice Cream Ice Cream Drinks 1 Frappe $5.61 $0.00 $5.61 iaSg9qDgjHgGAWml0GB Sean https://squareup.com/dashboard/sales/transactions/iaSg9qDgjHgGAWml0GB
2/5/14 20:08:35 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 a8TNSpAHRIO6tWoT0GB Sean https://squareup.com/dashboard/sales/transactions/a8TNSpAHRIO6tWoT0GB
2/5/14 20:03:37 Coffee Latte 1 L Vanilla Latte $4.72 $0.00 $4.72 kv4m7r0xSjy7f8yj0GB Sean https://squareup.com/dashboard/sales/transactions/kv4m7r0xSjy7f8yj0GB
2/5/14 20:03:16 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 0K6W1TSHT17H8 Sean https://squareup.com/dashboard/sales/transactions/0K6W1TSHT17H8
2/5/14 20:00:49 Coffee Cappuccino 1 Small $2.38 $0.00 $2.38 iaiwbjdYKVgpIyc90GB Sean https://squareup.com/dashboard/sales/transactions/iaiwbjdYKVgpIyc90GB
2/5/14 20:00:49 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 iaiwbjdYKVgpIyc90GB Sean https://squareup.com/dashboard/sales/transactions/iaiwbjdYKVgpIyc90GB
2/5/14 19:58:27 Tea Tea 1 Hot $1.92 $0.00 $1.92 47ZCBAC3WKK2P Sean https://squareup.com/dashboard/sales/transactions/47ZCBAC3WKK2P
2/5/14 19:51:10 Ice Cream Ice Cream 1 2 Pints $11.68 $0.00 $11.68 I3TyJvF8DCmcvxy9zGB Sean https://squareup.com/dashboard/sales/transactions/I3TyJvF8DCmcvxy9zGB
2/5/14 19:51:10 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 I3TyJvF8DCmcvxy9zGB Sean https://squareup.com/dashboard/sales/transactions/I3TyJvF8DCmcvxy9zGB
2/5/14 19:51:10 Ice Cream Ice Cream 1 2 Scoop Fudge $6.31 $0.00 $6.31 I3TyJvF8DCmcvxy9zGB Sean https://squareup.com/dashboard/sales/transactions/I3TyJvF8DCmcvxy9zGB
2/5/14 19:49:24 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 C0F0YP6DSVP9X Sean https://squareup.com/dashboard/sales/transactions/C0F0YP6DSVP9X
2/5/14 19:47:36 Ice Cream Ice Cream 1 Pint $6.31 $0.00 $6.31 6E9YDD9DZTEGS Sean https://squareup.com/dashboard/sales/transactions/6E9YDD9DZTEGS
2/5/14 19:35:20 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 eYC8JzJpgjRB9gt30GB Sean https://squareup.com/dashboard/sales/transactions/eYC8JzJpgjRB9gt30GB
2/5/14 19:32:52 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 KsJSUaVblrnbQkMe0GB Sean https://squareup.com/dashboard/sales/transactions/KsJSUaVblrnbQkMe0GB
2/5/14 19:30:04 None Custom Amount 1 $0.00 $0.00 $0.00 56G3QXDY2S58S Sean https://squareup.com/dashboard/sales/transactions/56G3QXDY2S58S
2/5/14 19:29:20 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 SmWDmbSI0YNXdmFI1GB Sean https://squareup.com/dashboard/sales/transactions/SmWDmbSI0YNXdmFI1GB
2/5/14 19:29:20 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 SmWDmbSI0YNXdmFI1GB Sean https://squareup.com/dashboard/sales/transactions/SmWDmbSI0YNXdmFI1GB
2/5/14 19:22:46 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 0RK8G189SAVBC Sean https://squareup.com/dashboard/sales/transactions/0RK8G189SAVBC
2/5/14 19:22:28 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 1B4K3MHCW5542 Sean https://squareup.com/dashboard/sales/transactions/1B4K3MHCW5542
2/5/14 19:19:52 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 0HqdcJlfr2H4O6q2zGB Sean https://squareup.com/dashboard/sales/transactions/0HqdcJlfr2H4O6q2zGB
2/5/14 19:19:33 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 YpUW60dIYQKMxIHW0GB Sean https://squareup.com/dashboard/sales/transactions/YpUW60dIYQKMxIHW0GB
2/5/14 19:10:28 Ice Cream Toppings 1 Regular Price Nuts and Stuff $0.70 $0.00 $0.70 D7EETM2G8QKV1 Sean https://squareup.com/dashboard/sales/transactions/D7EETM2G8QKV1
2/5/14 19:10:28 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 D7EETM2G8QKV1 Sean https://squareup.com/dashboard/sales/transactions/D7EETM2G8QKV1
2/5/14 18:44:48 Coffee Latte 1 Medium $3.55 $0.00 $3.55 AZZK8DQHGK9AS Sean https://squareup.com/dashboard/sales/transactions/AZZK8DQHGK9AS
2/5/14 18:36:10 Coffee Drip Coffee 1 Micro $0.93 $0.00 $0.93 BV2FHFXT3N5CP Sean https://squareup.com/dashboard/sales/transactions/BV2FHFXT3N5CP
2/5/14 18:35:54 Coffee Espresso 1 Large Americano $2.62 $0.00 $2.62 sVD1oJqTSEaMP2eZ0GB Sean https://squareup.com/dashboard/sales/transactions/sVD1oJqTSEaMP2eZ0GB
2/5/14 18:33:57 Ice Cream Ice Cream 1 Small Sundae $5.61 $0.00 $5.61 CN4HPWXC3CNBE Sean https://squareup.com/dashboard/sales/transactions/CN4HPWXC3CNBE
2/5/14 18:16:56 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 qKMGNtrRQJyg7jbp0GB Sean https://squareup.com/dashboard/sales/transactions/qKMGNtrRQJyg7jbp0GB
2/5/14 18:16:56 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 qKMGNtrRQJyg7jbp0GB Sean https://squareup.com/dashboard/sales/transactions/qKMGNtrRQJyg7jbp0GB
2/5/14 18:06:39 None Custom Amount 1 $0.00 $0.00 $0.00 1KN7T7FKT4M50 Sean https://squareup.com/dashboard/sales/transactions/1KN7T7FKT4M50
2/5/14 18:06:34 Coffee Drip Coffee 2 Small $3.36 $0.00 $3.36 MzyHDtaEvPXYpr7B1GB Sean https://squareup.com/dashboard/sales/transactions/MzyHDtaEvPXYpr7B1GB
2/5/14 18:00:03 None Custom Amount 1 $0.00 $0.00 $0.00 4884DF9RNX2C8 Sean https://squareup.com/dashboard/sales/transactions/4884DF9RNX2C8
2/5/14 17:59:56 None Custom Amount 1 $0.00 $0.00 $0.00 4SCFTWV4CMXTQ George https://squareup.com/dashboard/sales/transactions/4SCFTWV4CMXTQ
2/5/14 17:58:26 None Custom Amount 1 $0.00 $0.00 $0.00 5XHND1WZVYQV8 Sean https://squareup.com/dashboard/sales/transactions/5XHND1WZVYQV8
2/5/14 17:57:48 None Custom Amount 1 $0.00 $0.00 $0.00 CCT05FQPRHPQQ George https://squareup.com/dashboard/sales/transactions/CCT05FQPRHPQQ
2/5/14 17:56:04 None Custom Amount 1 $0.00 $0.00 $0.00 0V926XXZY3RKB George https://squareup.com/dashboard/sales/transactions/0V926XXZY3RKB
2/5/14 17:48:39 Coffee Bag Of Coffee 1 Staff Coffee Bag $10.00 $0.00 $10.00 7Y4K574DW0C6V Sean https://squareup.com/dashboard/sales/transactions/7Y4K574DW0C6V
2/5/14 17:45:20 Drinks Hot Drinks 1 Small Steamer $1.68 $0.00 $1.68 7Z5PX1XTG8N6M Sean https://squareup.com/dashboard/sales/transactions/7Z5PX1XTG8N6M
2/5/14 17:39:11 None Custom Amount 1 $0.00 $0.00 $0.00 CRRM4PR5123HW George https://squareup.com/dashboard/sales/transactions/CRRM4PR5123HW
2/5/14 17:30:06 Ice Cream Ice Cream 1 Pint $6.31 $0.00 $6.31 Iv5T9qnal4vYG53u0GB Sean https://squareup.com/dashboard/sales/transactions/Iv5T9qnal4vYG53u0GB
2/5/14 17:30:06 Tea Tea 1 Hot $1.92 $0.00 $1.92 Iv5T9qnal4vYG53u0GB Sean https://squareup.com/dashboard/sales/transactions/Iv5T9qnal4vYG53u0GB
2/5/14 17:27:27 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 o7l0iOJ0LmZmXVAJ1GB Sean https://squareup.com/dashboard/sales/transactions/o7l0iOJ0LmZmXVAJ1GB
2/5/14 17:27:27 Coffee Drip Coffee 1 Iced Vietnamese $2.62 $0.00 $2.62 o7l0iOJ0LmZmXVAJ1GB Sean https://squareup.com/dashboard/sales/transactions/o7l0iOJ0LmZmXVAJ1GB
2/5/14 17:25:53 Drinks Hot Chocolate 1 S Hot Chocolate $2.85 $0.00 $2.85 FS4EJ6N14NKBD Sean https://squareup.com/dashboard/sales/transactions/FS4EJ6N14NKBD
2/5/14 17:24:36 Ice Cream Ice Cream 2 1 Scoop $7.94 $0.00 $7.94 kb4lEHZQZYScLux6zGB Sean https://squareup.com/dashboard/sales/transactions/kb4lEHZQZYScLux6zGB
2/5/14 17:24:13 Coffee Bag Of Coffee 1 Barismo $14.00 $0.00 $14.00 ewqmDhtnfXlSszrm0GB Sean https://squareup.com/dashboard/sales/transactions/ewqmDhtnfXlSszrm0GB
2/5/14 17:23:38 Coffee Mocha 1 Small $3.32 $0.00 $3.32 5WJ0076JC0849 Sean https://squareup.com/dashboard/sales/transactions/5WJ0076JC0849
2/5/14 17:21:15 Drinks Hot Chocolate 1 S Hot Chocolate $2.85 $0.00 $2.85 ctxAQa6umR1rZpNm0GB Sean https://squareup.com/dashboard/sales/transactions/ctxAQa6umR1rZpNm0GB
2/5/14 17:21:15 Tea Tea 1 Hot $1.92 $0.00 $1.92 ctxAQa6umR1rZpNm0GB Sean https://squareup.com/dashboard/sales/transactions/ctxAQa6umR1rZpNm0GB
2/5/14 17:20:16 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 wr1JWenFS8an4fnB0GB Sean https://squareup.com/dashboard/sales/transactions/wr1JWenFS8an4fnB0GB
2/5/14 17:18:35 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 6YrqqOxn6Qfh6I8W1GB Sean https://squareup.com/dashboard/sales/transactions/6YrqqOxn6Qfh6I8W1GB
2/5/14 17:15:39 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 MFtCied5C116cTZU1GB George https://squareup.com/dashboard/sales/transactions/MFtCied5C116cTZU1GB
2/5/14 17:15:29 Ice Cream Ice Cream 1 2 Pints $11.68 $0.00 $11.68 0dT0UdELocHypPa50GB Sean https://squareup.com/dashboard/sales/transactions/0dT0UdELocHypPa50GB
2/5/14 17:15:29 Coffee Drip Coffee 1 L Vietnamese $2.62 $0.00 $2.62 0dT0UdELocHypPa50GB Sean https://squareup.com/dashboard/sales/transactions/0dT0UdELocHypPa50GB
2/5/14 17:05:57 Coffee Cappuccino 1 Large $2.90 $0.00 $2.90 yknOtvS7U08h9p6y0GB Sean https://squareup.com/dashboard/sales/transactions/yknOtvS7U08h9p6y0GB
2/5/14 17:05:57 Coffee Latte 1 M Vanilla Latte $4.02 $0.00 $4.02 yknOtvS7U08h9p6y0GB Sean https://squareup.com/dashboard/sales/transactions/yknOtvS7U08h9p6y0GB
2/5/14 17:01:31 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 4B0mBPptEo0apuBb1GB Sean https://squareup.com/dashboard/sales/transactions/4B0mBPptEo0apuBb1GB
2/5/14 16:53:40 Coffee Drip Coffee 1 Small au Lait $2.15 $0.00 $2.15 C089256V5QMT9 George https://squareup.com/dashboard/sales/transactions/C089256V5QMT9
2/5/14 16:53:06 Coffee Cappuccino 1 Large $2.90 $0.00 $2.90 0VGRA3HNP6QHT Sean https://squareup.com/dashboard/sales/transactions/0VGRA3HNP6QHT
2/5/14 16:53:06 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 0VGRA3HNP6QHT Sean https://squareup.com/dashboard/sales/transactions/0VGRA3HNP6QHT
2/5/14 16:48:17 Tea Tea 1 Hot $1.92 $0.00 $1.92 EHuLX4GOMT2XkM5H1GB Sean https://squareup.com/dashboard/sales/transactions/EHuLX4GOMT2XkM5H1GB
2/5/14 16:39:35 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 EAYCN60ZJQ8EE Sean https://squareup.com/dashboard/sales/transactions/EAYCN60ZJQ8EE
2/5/14 16:39:35 Coffee Latte 1 Medium $3.55 $0.00 $3.55 EAYCN60ZJQ8EE Sean https://squareup.com/dashboard/sales/transactions/EAYCN60ZJQ8EE
2/5/14 16:38:52 Baked goods Iggy's 1 Plain Croissant $1.87 $0.00 $1.87 w7zsGuAZTEWoaY6D1GB Sean https://squareup.com/dashboard/sales/transactions/w7zsGuAZTEWoaY6D1GB
2/5/14 16:38:52 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 w7zsGuAZTEWoaY6D1GB Sean https://squareup.com/dashboard/sales/transactions/w7zsGuAZTEWoaY6D1GB
2/5/14 16:36:20 Ice Cream Ice Cream 1 Pint $6.31 $0.00 $6.31 CYNYZ1HBBHJRB Sean https://squareup.com/dashboard/sales/transactions/CYNYZ1HBBHJRB
2/5/14 16:34:30 None Custom Amount 1 $0.00 $0.00 $0.00 0MQ0N1ZGFABQV Sean https://squareup.com/dashboard/sales/transactions/0MQ0N1ZGFABQV
2/5/14 16:33:57 Ice Cream Ice Cream 1 2 Pints $11.68 $0.00 $11.68 OcYGQGHOy3ceHZHA1GB Sean https://squareup.com/dashboard/sales/transactions/OcYGQGHOy3ceHZHA1GB
2/5/14 16:32:44 Tea Tea 1 Hot $1.92 $0.00 $1.92 3QH9RC9B72MXK Sean https://squareup.com/dashboard/sales/transactions/3QH9RC9B72MXK
2/5/14 16:32:44 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 3QH9RC9B72MXK Sean https://squareup.com/dashboard/sales/transactions/3QH9RC9B72MXK
2/5/14 16:31:58 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 IjdOOxFZ91PGs6EH1GB Sean https://squareup.com/dashboard/sales/transactions/IjdOOxFZ91PGs6EH1GB
2/5/14 16:31:02 Ice Cream Ice Cream 1 Pint $6.31 $0.00 $6.31 9244X2VSCKCAB Sean https://squareup.com/dashboard/sales/transactions/9244X2VSCKCAB
2/5/14 16:30:44 Ice Cream Ice Cream 2 1 Scoop $7.94 $0.00 $7.94 41G16X0GMDB8B Sean https://squareup.com/dashboard/sales/transactions/41G16X0GMDB8B
2/5/14 16:28:11 Ice Cream Ice Cream Drinks 1 Frappe $5.61 $0.00 $5.61 EBNkdJwqQvf9s08x0GB Sean https://squareup.com/dashboard/sales/transactions/EBNkdJwqQvf9s08x0GB
2/5/14 16:28:11 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 EBNkdJwqQvf9s08x0GB Sean https://squareup.com/dashboard/sales/transactions/EBNkdJwqQvf9s08x0GB
2/5/14 16:27:05 Ice Cream Ice Cream 1 Affogato $4.67 $0.00 $4.67 AKQRBM69GSMQK George https://squareup.com/dashboard/sales/transactions/AKQRBM69GSMQK
2/5/14 16:26:45 Ice Cream Ice Cream 1 Affogato $4.67 $0.00 $4.67 50W519G1M4XYH Sean https://squareup.com/dashboard/sales/transactions/50W519G1M4XYH
2/5/14 16:25:02 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 CE7WT9ffS6zhoXL00GB Sean https://squareup.com/dashboard/sales/transactions/CE7WT9ffS6zhoXL00GB
2/5/14 16:19:42 Coffee Latte 1 Medium $3.55 $0.00 $3.55 7P9JVYFFXBZJT Sean https://squareup.com/dashboard/sales/transactions/7P9JVYFFXBZJT
2/5/14 16:19:42 Coffee Espresso 1 Small Americano $1.92 $0.00 $1.92 7P9JVYFFXBZJT Sean https://squareup.com/dashboard/sales/transactions/7P9JVYFFXBZJT
2/5/14 16:12:52 None Custom Amount 1 $0.00 $0.00 $0.00 1Y040WVS49V0M George https://squareup.com/dashboard/sales/transactions/1Y040WVS49V0M
2/5/14 16:12:50 None Custom Amount 1 $0.00 $0.00 $0.00 B91XGVSQ82C3F Sean https://squareup.com/dashboard/sales/transactions/B91XGVSQ82C3F
2/5/14 16:10:11 Coffee Drip Coffee 1 Small Iced $2.34 $0.00 $2.34 FS4VN3EH949SF Sean https://squareup.com/dashboard/sales/transactions/FS4VN3EH949SF
2/5/14 16:08:06 None Custom Amount 1 $0.00 $0.00 $0.00 EF6Y3BRNQ7R78 Sean https://squareup.com/dashboard/sales/transactions/EF6Y3BRNQ7R78
2/5/14 16:07:31 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 EYXXDTH3E0YTK Sean https://squareup.com/dashboard/sales/transactions/EYXXDTH3E0YTK
2/5/14 15:44:44 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 gzpdpMfiIFgSlEmz0GB Sean https://squareup.com/dashboard/sales/transactions/gzpdpMfiIFgSlEmz0GB
2/5/14 15:43:23 Tea Tea 1 Hot $1.92 $0.00 $1.92 7H9DGJ1KRKFMP Sean https://squareup.com/dashboard/sales/transactions/7H9DGJ1KRKFMP
2/5/14 15:37:52 Coffee Drip Coffee 1 Small $1.68 $0.00 $1.68 cDc8k7lHAUDAA6Uc1GB Sean https://squareup.com/dashboard/sales/transactions/cDc8k7lHAUDAA6Uc1GB
2/5/14 15:37:52 Baked goods Brown Butter 1 Scone $1.87 $0.00 $1.87 cDc8k7lHAUDAA6Uc1GB Sean https://squareup.com/dashboard/sales/transactions/cDc8k7lHAUDAA6Uc1GB
2/5/14 15:23:06 Ice Cream Ice Cream 1 Small Sundae $5.61 $0.00 $5.61 FN58AAZVPS3ZH Sean https://squareup.com/dashboard/sales/transactions/FN58AAZVPS3ZH
2/5/14 15:21:02 Drinks Hot Chocolate 1 M Hot Vanilla $3.32 $0.00 $3.32 GiRq5s70x0KhsdY3zGB Sean https://squareup.com/dashboard/sales/transactions/GiRq5s70x0KhsdY3zGB
2/5/14 15:21:02 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 GiRq5s70x0KhsdY3zGB Sean https://squareup.com/dashboard/sales/transactions/GiRq5s70x0KhsdY3zGB
2/5/14 15:19:46 Ice Cream Ice Cream Drinks 1 Frappe $5.61 $0.00 $5.61 URJIXCZHJ8cWLZJ6zGB Sean https://squareup.com/dashboard/sales/transactions/URJIXCZHJ8cWLZJ6zGB
2/5/14 14:51:54 Coffee Drip Coffee 1 Small 2 extra shots $3.08 ($1.54) $1.54 0J0W4TRSFDMCC Sean https://squareup.com/dashboard/sales/transactions/0J0W4TRSFDMCC
2/5/14 14:21:55 Coffee Cappuccino 1 Large $2.90 $0.00 $2.90 DW3EBDXJJWZ2F Sean https://squareup.com/dashboard/sales/transactions/DW3EBDXJJWZ2F
2/5/14 14:21:55 Coffee Cappuccino 1 Small $2.38 $0.00 $2.38 DW3EBDXJJWZ2F Sean https://squareup.com/dashboard/sales/transactions/DW3EBDXJJWZ2F
2/5/14 14:16:25 Ice Cream Ice Cream 1 Pint $6.31 $0.00 $6.31 GEUPltUFLCvSMfq20GB Sean https://squareup.com/dashboard/sales/transactions/GEUPltUFLCvSMfq20GB
2/5/14 14:15:18 Coffee Latte 1 Medium $3.55 $0.00 $3.55 w5OmI0O94ivvHttT1GB Sean https://squareup.com/dashboard/sales/transactions/w5OmI0O94ivvHttT1GB
2/5/14 14:14:32 Tea Tea 1 Hot $1.92 $0.00 $1.92 y0f0knc6YsXc5hWe1GB Sean https://squareup.com/dashboard/sales/transactions/y0f0knc6YsXc5hWe1GB
2/5/14 14:07:57 None Custom Amount 1 $0.00 $0.00 $0.00 C3X4H86KBA0J0 Sean https://squareup.com/dashboard/sales/transactions/C3X4H86KBA0J0
2/5/14 14:05:54 Coffee Drip Coffee 1 Small $1.68 $0.00 $1.68 eQmw3QMDYG5YQMSP1GB Sean https://squareup.com/dashboard/sales/transactions/eQmw3QMDYG5YQMSP1GB
2/5/14 14:05:51 None Custom Amount 1 $0.00 $0.00 $0.00 9RRCTADVA77RK George https://squareup.com/dashboard/sales/transactions/9RRCTADVA77RK
2/5/14 14:03:59 Tea Chai 1 M Vanilla Chai $3.79 $0.00 $3.79 uA091zMsoMaut3mc0GB Sean https://squareup.com/dashboard/sales/transactions/uA091zMsoMaut3mc0GB
2/5/14 14:03:24 Ice Cream Ice Cream 3 1 Scoop $11.91 $0.00 $11.91 25R1A87Y9GZPQ Sean https://squareup.com/dashboard/sales/transactions/25R1A87Y9GZPQ
2/5/14 13:55:59 Ice Cream Ice Cream 1 1 Scoop Fudge $5.14 $0.00 $5.14 mapMPLr4iJH5Coaf0GB Sean https://squareup.com/dashboard/sales/transactions/mapMPLr4iJH5Coaf0GB
2/5/14 13:55:59 Ice Cream Ice Cream 1 Micro Sundae $3.74 $0.00 $3.74 mapMPLr4iJH5Coaf0GB Sean https://squareup.com/dashboard/sales/transactions/mapMPLr4iJH5Coaf0GB
2/5/14 13:53:22 None Custom Amount 1 $0.00 $0.00 $0.00 E96VY20Q0Q0MP Sean https://squareup.com/dashboard/sales/transactions/E96VY20Q0Q0MP
2/5/14 13:50:17 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 B4EST273N16Y0 Sean https://squareup.com/dashboard/sales/transactions/B4EST273N16Y0
2/5/14 13:44:59 Coffee Drip Coffee 1 Large $2.15 $0.00 $2.15 AB70GKPBHP5X3 Sean https://squareup.com/dashboard/sales/transactions/AB70GKPBHP5X3
2/5/14 13:39:51 Coffee Latte 1 Medium $3.55 $0.00 $3.55 GOx9OznTvXumNKSL1GB Sean https://squareup.com/dashboard/sales/transactions/GOx9OznTvXumNKSL1GB
2/5/14 13:38:01 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 QrFZkytG8yti6MNJ1GB Sean https://squareup.com/dashboard/sales/transactions/QrFZkytG8yti6MNJ1GB
2/5/14 13:35:11 Coffee Latte 2 Small $6.16 $0.00 $6.16 776KGWVC9YN89 Sean https://squareup.com/dashboard/sales/transactions/776KGWVC9YN89
2/5/14 13:32:53 Coffee Cappuccino 1 Small $2.38 $0.00 $2.38 280b1wo24O7SNR8d1GB Sean https://squareup.com/dashboard/sales/transactions/280b1wo24O7SNR8d1GB
2/5/14 13:28:25 Coffee Drip Coffee 1 Medium $1.96 $0.00 $1.96 2SXFDEGJJ5VWG Sean https://squareup.com/dashboard/sales/transactions/2SXFDEGJJ5VWG
2/5/14 13:27:33 Ice Cream Ice Cream 1 Micro $3.27 $0.00 $3.27 W2LKWtDx0E73bdA80GB Sean https://squareup.com/dashboard/sales/transactions/W2LKWtDx0E73bdA80GB
2/5/14 13:23:14 Baked goods Brown Butter 1 Muffin $1.87 $0.00 $1.87 Q75jwzBGWPltOe0D1GB Sean https://squareup.com/dashboard/sales/transactions/Q75jwzBGWPltOe0D1GB
2/5/14 13:23:14 Coffee Espresso 1 Single $1.68 $0.00 $1.68 Q75jwzBGWPltOe0D1GB Sean https://squareup.com/dashboard/sales/transactions/Q75jwzBGWPltOe0D1GB
2/5/14 13:22:46 Baked goods Brown Butter 1 Scone $1.87 $0.00 $1.87 sXicQVbhsc12R3y2zGB Sean https://squareup.com/dashboard/sales/transactions/sXicQVbhsc12R3y2zGB
2/5/14 13:22:46 Coffee Drip Coffee 1 Small $1.68 $0.00 $1.68 sXicQVbhsc12R3y2zGB Sean https://squareup.com/dashboard/sales/transactions/sXicQVbhsc12R3y2zGB
2/5/14 13:14:11 None Custom Amount 1 $0.00 $0.00 $0.00 CT4RPXGK20CDG George https://squareup.com/dashboard/sales/transactions/CT4RPXGK20CDG
2/5/14 13:14:03 None Custom Amount 1 $0.00 $0.00 $0.00 7D4XXWBG4EWKV Sean https://squareup.com/dashboard/sales/transactions/7D4XXWBG4EWKV
2/5/14 13:06:04 Tea Tea 1 Hot $1.92 $0.00 $1.92 1ZDT22JZ582A4 Sean https://squareup.com/dashboard/sales/transactions/1ZDT22JZ582A4
2/5/14 12:59:56 None Custom Amount 1 $0.00 $0.00 $0.00 0VWW71TRJPE03 George https://squareup.com/dashboard/sales/transactions/0VWW71TRJPE03
2/5/14 12:59:47 Coffee Drip Coffee 1 Medium $1.96 $0.00 $1.96 DN2Z9FR9Z8ZPQ Sean https://squareup.com/dashboard/sales/transactions/DN2Z9FR9Z8ZPQ
2/5/14 12:59:23 None Custom Amount 1 $0.00 $0.00 $0.00 2BY883WXE8VDR George https://squareup.com/dashboard/sales/transactions/2BY883WXE8VDR
2/5/14 12:59:03 Coffee Drip Coffee 1 Small $1.68 $0.00 $1.68 wDz2C1UZf0PySyVC1GB Sean https://squareup.com/dashboard/sales/transactions/wDz2C1UZf0PySyVC1GB
2/5/14 12:57:58 Coffee Drip Coffee 2 Medium $3.92 $0.00 $3.92 EG9EC7G6Q8TC3 Sean https://squareup.com/dashboard/sales/transactions/EG9EC7G6Q8TC3
2/5/14 12:56:51 Coffee Drip Coffee 1 Large $2.15 $0.00 $2.15 ayiB3PFb7taF0ub00GB Sean https://squareup.com/dashboard/sales/transactions/ayiB3PFb7taF0ub00GB
2/5/14 12:55:59 Coffee Drip Coffee 1 Micro $0.93 $0.00 $0.93 DC6THZ1KWRM92 Sean https://squareup.com/dashboard/sales/transactions/DC6THZ1KWRM92
2/5/14 12:55:15 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 0QMCYWZ6P6B9N Sean https://squareup.com/dashboard/sales/transactions/0QMCYWZ6P6B9N
2/5/14 12:54:16 None Custom Amount 1 $0.00 $0.00 $0.00 7ZN09KGC86CXE Sean https://squareup.com/dashboard/sales/transactions/7ZN09KGC86CXE
2/5/14 12:50:49 Coffee Drip Coffee 1 Large $2.15 $0.00 $2.15 Y1iszQd1IApzOGiN0GB Sean https://squareup.com/dashboard/sales/transactions/Y1iszQd1IApzOGiN0GB
2/5/14 12:50:07 None Custom Amount 1 $0.00 $0.00 $0.00 CBDJRZS5MGK5V George https://squareup.com/dashboard/sales/transactions/CBDJRZS5MGK5V
2/5/14 12:50:02 Coffee Drip Coffee 1 L Vietnamese $2.62 $0.00 $2.62 A3SCV0VBVMKFX Sean https://squareup.com/dashboard/sales/transactions/A3SCV0VBVMKFX
2/5/14 12:38:53 Ice Cream Ice Cream 1 2 Scoop $5.14 $0.00 $5.14 Km20DfRuY6CWaokE1GB Sean https://squareup.com/dashboard/sales/transactions/Km20DfRuY6CWaokE1GB
2/5/14 12:38:53 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 Km20DfRuY6CWaokE1GB Sean https://squareup.com/dashboard/sales/transactions/Km20DfRuY6CWaokE1GB
2/5/14 12:31:58 None Custom Amount 1 $0.00 $0.00 $0.00 F9MD7PM3MZWB3 Sean https://squareup.com/dashboard/sales/transactions/F9MD7PM3MZWB3
2/5/14 12:29:39 None Custom Amount 1 $0.00 $0.00 $0.00 71ED7F3MQEMJ8 Sean https://squareup.com/dashboard/sales/transactions/71ED7F3MQEMJ8
2/5/14 12:29:31 Ice Cream Ice Cream 1 Affogato $4.67 $0.00 $4.67 68S8D9A89X0SS Sean https://squareup.com/dashboard/sales/transactions/68S8D9A89X0SS
2/5/14 12:24:04 Coffee Bag Of Coffee 1 Barismo $14.00 $0.00 $14.00 W4q5wuzpb1hvAnRj0GB Sean https://squareup.com/dashboard/sales/transactions/W4q5wuzpb1hvAnRj0GB
2/5/14 12:24:04 Coffee Latte 1 Medium $3.55 $0.00 $3.55 W4q5wuzpb1hvAnRj0GB Sean https://squareup.com/dashboard/sales/transactions/W4q5wuzpb1hvAnRj0GB
2/5/14 12:21:45 Baked goods Brown Butter 1 Scone $1.87 $0.00 $1.87 EK5ZZ1B8AEQGA Sean https://squareup.com/dashboard/sales/transactions/EK5ZZ1B8AEQGA
2/5/14 12:21:45 Coffee Drip Coffee 1 Small $1.68 $0.00 $1.68 EK5ZZ1B8AEQGA Sean https://squareup.com/dashboard/sales/transactions/EK5ZZ1B8AEQGA
2/5/14 12:09:55 Coffee Latte 1 Large $4.25 $0.00 $4.25 186Z420QR5N3S Sean https://squareup.com/dashboard/sales/transactions/186Z420QR5N3S
2/5/14 11:52:47 None Custom Amount 1 $0.00 $0.00 $0.00 884Z5JWSHHJEV George https://squareup.com/dashboard/sales/transactions/884Z5JWSHHJEV
2/5/14 11:52:43 Coffee Bag Of Coffee 1 Staff Coffee Bag $10.00 $0.00 $10.00 CBMHEPTF1942B Sean https://squareup.com/dashboard/sales/transactions/CBMHEPTF1942B
2/5/14 11:45:58 None Custom Amount 1 $0.00 $0.00 $0.00 EY3KNFSPHB2YN Sean https://squareup.com/dashboard/sales/transactions/EY3KNFSPHB2YN
2/5/14 11:40:58 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 ApklzKHqf3jnhxmd1GB Sean https://squareup.com/dashboard/sales/transactions/ApklzKHqf3jnhxmd1GB
2/5/14 11:39:12 Baked goods Brown Butter 1 Muffin $1.87 $0.00 $1.87 BG4PMHQB16ECZ Sean https://squareup.com/dashboard/sales/transactions/BG4PMHQB16ECZ
2/5/14 11:39:12 Coffee Drip Coffee 1 Medium au Lait $2.38 $0.00 $2.38 BG4PMHQB16ECZ Sean https://squareup.com/dashboard/sales/transactions/BG4PMHQB16ECZ
2/5/14 11:39:12 Baked goods Iggy's 1 Plain Croissant $1.87 $0.00 $1.87 BG4PMHQB16ECZ Sean https://squareup.com/dashboard/sales/transactions/BG4PMHQB16ECZ
2/5/14 11:39:12 Baked goods Iggy's 1 Filled Croissant $2.34 $0.00 $2.34 BG4PMHQB16ECZ Sean https://squareup.com/dashboard/sales/transactions/BG4PMHQB16ECZ
2/5/14 11:39:12 Coffee Drip Coffee 1 Small au Lait $2.15 $0.00 $2.15 BG4PMHQB16ECZ Sean https://squareup.com/dashboard/sales/transactions/BG4PMHQB16ECZ
2/5/14 11:34:42 Ice Cream Ice Cream 1 1 Scoop $3.97 $0.00 $3.97 22PgqhmJfiiOW1uA1GB Sean https://squareup.com/dashboard/sales/transactions/22PgqhmJfiiOW1uA1GB
2/5/14 11:26:15 Coffee Drip Coffee 1 Medium $1.96 $0.00 $1.96 94PEC86FHVVF2 Sean https://squareup.com/dashboard/sales/transactions/94PEC86FHVVF2
2/5/14 11:19:29 Baked goods Iggy's 1 Plain Croissant $1.87 $0.00 $1.87 euJuTRO5Tal7TeB2zGB Sean https://squareup.com/dashboard/sales/transactions/euJuTRO5Tal7TeB2zGB
2/5/14 11:19:29 Tea Tea 1 Hot $1.92 $0.00 $1.92 euJuTRO5Tal7TeB2zGB Sean https://squareup.com/dashboard/sales/transactions/euJuTRO5Tal7TeB2zGB
2/5/14 10:46:09 Coffee Mocha 1 L Vanilla Mocha $4.95 $0.00 $4.95 A8XY151D4CBF4 Sean https://squareup.com/dashboard/sales/transactions/A8XY151D4CBF4
2/5/14 10:46:09 Coffee Latte 1 Large $4.25 $0.00 $4.25 A8XY151D4CBF4 Sean https://squareup.com/dashboard/sales/transactions/A8XY151D4CBF4
2/5/14 10:46:09 Baked goods Brown Butter 1 Muffin $1.87 $0.00 $1.87 A8XY151D4CBF4 Sean https://squareup.com/dashboard/sales/transactions/A8XY151D4CBF4
2/5/14 10:39:18 Baked goods Brown Butter 1 Scone $1.87 $0.00 $1.87 cbylMoy3KJw0U9B00GB Sean https://squareup.com/dashboard/sales/transactions/cbylMoy3KJw0U9B00GB
2/5/14 10:39:18 Coffee Latte 1 Small $3.08 $0.00 $3.08 cbylMoy3KJw0U9B00GB Sean https://squareup.com/dashboard/sales/transactions/cbylMoy3KJw0U9B00GB
2/5/14 10:35:20 Coffee Drip Coffee 1 Micro $0.93 $0.00 $0.93 DT2XM327KF87R Sean https://squareup.com/dashboard/sales/transactions/DT2XM327KF87R
2/5/14 10:33:23 Coffee Latte 1 Medium $3.55 $0.00 $3.55 FK2XY6J955X9J Sean https://squareup.com/dashboard/sales/transactions/FK2XY6J955X9J
2/5/14 10:33:23 Coffee Espresso 1 Large Americano $2.62 $0.00 $2.62 FK2XY6J955X9J Sean https://squareup.com/dashboard/sales/transactions/FK2XY6J955X9J
2/5/14 10:20:08 Coffee Drip Coffee 1 Small $1.68 $0.00 $1.68 A46QPCT55DZJ1 Sean https://squareup.com/dashboard/sales/transactions/A46QPCT55DZJ1
2/5/14 10:18:59 Coffee Drip Coffee 1 Large $2.15 $0.00 $2.15 F32KB1G6V0YBX Sean https://squareup.com/dashboard/sales/transactions/F32KB1G6V0YBX
2/5/14 10:17:44 Tea Chai 1 Small $3.08 $0.00 $3.08 3FAFW84SJK0JV Sean https://squareup.com/dashboard/sales/transactions/3FAFW84SJK0JV
2/5/14 10:15:45 Baked goods Brown Butter 1 Muffin $1.87 $0.00 $1.87 EJ1Z9104X74B3 Sean https://squareup.com/dashboard/sales/transactions/EJ1Z9104X74B3
2/5/14 10:15:45 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 EJ1Z9104X74B3 Sean https://squareup.com/dashboard/sales/transactions/EJ1Z9104X74B3
2/5/14 10:07:33 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 9DFG834D37QJX Sean https://squareup.com/dashboard/sales/transactions/9DFG834D37QJX
2/5/14 10:02:19 Baked goods Iggy's 1 Filled Croissant $2.34 $0.00 $2.34 yigNCX10s4Wzb6Mb0GB Sean https://squareup.com/dashboard/sales/transactions/yigNCX10s4Wzb6Mb0GB
2/5/14 10:02:19 Coffee Espresso 1 Iced Americano $2.15 $0.00 $2.15 yigNCX10s4Wzb6Mb0GB Sean https://squareup.com/dashboard/sales/transactions/yigNCX10s4Wzb6Mb0GB
2/5/14 10:01:11 Coffee Latte 1 M Vanilla Latte $4.02 $0.00 $4.02 S43tl5pVWBQCyuA60GB Sean https://squareup.com/dashboard/sales/transactions/S43tl5pVWBQCyuA60GB
2/5/14 9:49:40 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 70F4AWSAX1W3X Sean https://squareup.com/dashboard/sales/transactions/70F4AWSAX1W3X
2/5/14 9:48:36 Baked goods Iggy's 2 Filled Croissant $4.68 $0.00 $4.68 oJqXsMATFPPMyUge1GB Sean https://squareup.com/dashboard/sales/transactions/oJqXsMATFPPMyUge1GB
2/5/14 9:46:20 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 3CY2ZSHF1YT5Y George https://squareup.com/dashboard/sales/transactions/3CY2ZSHF1YT5Y
2/5/14 9:45:49 Baked goods Iggy's 2 Filled Croissant $4.68 $0.00 $4.68 YLvdFfEguPpxCbd8zGB Sean https://squareup.com/dashboard/sales/transactions/YLvdFfEguPpxCbd8zGB
2/5/14 9:45:49 Coffee Drip Coffee 1 Medium au Lait $2.38 $0.00 $2.38 YLvdFfEguPpxCbd8zGB Sean https://squareup.com/dashboard/sales/transactions/YLvdFfEguPpxCbd8zGB
2/5/14 9:45:05 Coffee Drip Coffee 1 Medium $1.96 $0.00 $1.96 84ZBFM1T117FK George https://squareup.com/dashboard/sales/transactions/84ZBFM1T117FK
2/5/14 9:44:30 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 ECAGQ559Y6BAR George https://squareup.com/dashboard/sales/transactions/ECAGQ559Y6BAR
2/5/14 9:35:47 Coffee Drip Coffee 1 Large $2.15 $0.00 $2.15 cjMIudFMDjKgkqcx0GB George https://squareup.com/dashboard/sales/transactions/cjMIudFMDjKgkqcx0GB
2/5/14 9:33:18 Coffee Espresso 1 Small Americano $1.92 ($1.92) $0.00 0EZQEXNFC65ZC Sean https://squareup.com/dashboard/sales/transactions/0EZQEXNFC65ZC
2/5/14 9:27:43 Coffee Latte 1 Small $3.08 $0.00 $3.08 WCloagkfSaUoLTjT0GB Sean https://squareup.com/dashboard/sales/transactions/WCloagkfSaUoLTjT0GB
2/5/14 9:20:09 None Custom Amount 1 $0.00 $0.00 $0.00 4MKCRCFS5W9Y0 Sean https://squareup.com/dashboard/sales/transactions/4MKCRCFS5W9Y0
2/5/14 9:18:11 None Custom Amount 1 $0.00 $0.00 $0.00 AJ0DGGNQMR76M Sean https://squareup.com/dashboard/sales/transactions/AJ0DGGNQMR76M
2/5/14 9:16:41 Coffee Drip Coffee 1 Medium $1.96 $0.00 $1.96 YtCC9iWUADRSiGKd1GB Sean https://squareup.com/dashboard/sales/transactions/YtCC9iWUADRSiGKd1GB
2/5/14 9:16:07 Coffee Drip Coffee 1 Medium $1.96 $0.00 $1.96 WKT7nvkD1MJulEDx0GB Sean https://squareup.com/dashboard/sales/transactions/WKT7nvkD1MJulEDx0GB
2/5/14 9:02:08 Baked goods Brown Butter 1 Muffin $1.87 $0.00 $1.87 0GXCQZEMF4D4Q Sean https://squareup.com/dashboard/sales/transactions/0GXCQZEMF4D4Q
2/5/14 9:02:08 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 0GXCQZEMF4D4Q Sean https://squareup.com/dashboard/sales/transactions/0GXCQZEMF4D4Q
2/5/14 9:00:33 Coffee Drip Coffee 1 Medium $1.96 $0.00 $1.96 YVQzzokaTTrMN60l0GB Sean https://squareup.com/dashboard/sales/transactions/YVQzzokaTTrMN60l0GB
2/5/14 8:59:38 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 o7jXiRDohfTRXJ8v0GB Sean https://squareup.com/dashboard/sales/transactions/o7jXiRDohfTRXJ8v0GB
2/5/14 8:59:38 Coffee Drip Coffee 1 Large $2.15 $0.00 $2.15 o7jXiRDohfTRXJ8v0GB Sean https://squareup.com/dashboard/sales/transactions/o7jXiRDohfTRXJ8v0GB
2/5/14 8:58:57 Coffee Drip Coffee 1 Medium au Lait $2.38 $0.00 $2.38 95KN6CQP8T28J Sean https://squareup.com/dashboard/sales/transactions/95KN6CQP8T28J
2/5/14 8:56:53 Coffee Drip Coffee 1 Large $2.15 $0.00 $2.15 krQjrby9OR4J1eAM1GB Sean https://squareup.com/dashboard/sales/transactions/krQjrby9OR4J1eAM1GB
2/5/14 8:49:30 Coffee Latte 1 Medium $3.55 $0.00 $3.55 AZ1VGQFW33822 Sean https://squareup.com/dashboard/sales/transactions/AZ1VGQFW33822
2/5/14 8:49:30 Baked goods Brown Butter 1 Muffin $1.87 $0.00 $1.87 AZ1VGQFW33822 Sean https://squareup.com/dashboard/sales/transactions/AZ1VGQFW33822
2/5/14 8:45:44 Coffee Drip Coffee 1 Large $2.15 $0.00 $2.15 SkNpzDiKMaEkynCo0GB Sean https://squareup.com/dashboard/sales/transactions/SkNpzDiKMaEkynCo0GB
2/5/14 8:44:58 Coffee Drip Coffee 1 Medium $1.96 $0.00 $1.96 SKOyCKM6OKigHWIQ1GB George https://squareup.com/dashboard/sales/transactions/SKOyCKM6OKigHWIQ1GB
2/5/14 8:41:44 Baked goods Brown Butter 1 Muffin $1.87 $0.00 $1.87 4zl6Ls4XaGefQGOM0GB Sean https://squareup.com/dashboard/sales/transactions/4zl6Ls4XaGefQGOM0GB
2/5/14 8:40:38 Coffee Drip Coffee 1 Small $1.68 $0.00 $1.68 32C7755SZRMFD Sean https://squareup.com/dashboard/sales/transactions/32C7755SZRMFD
2/5/14 8:40:38 Baked goods Brown Butter 1 Muffin $1.87 $0.00 $1.87 32C7755SZRMFD Sean https://squareup.com/dashboard/sales/transactions/32C7755SZRMFD
2/5/14 8:38:27 Drinks Hot Chocolate 1 L Hot Chocolate $3.55 $0.00 $3.55 AD4JGH6WS0X73 Sean https://squareup.com/dashboard/sales/transactions/AD4JGH6WS0X73
2/5/14 8:36:16 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 1ECJZP8F6TT8D Sean https://squareup.com/dashboard/sales/transactions/1ECJZP8F6TT8D
2/5/14 8:32:12 Baked goods Iggy's 1 Filled Croissant $2.34 $0.00 $2.34 E23YHN0FA98HZ Sean https://squareup.com/dashboard/sales/transactions/E23YHN0FA98HZ
2/5/14 8:31:50 Coffee Espresso 1 Double $1.92 $0.00 $1.92 80SK4MJ0QGGV8 George https://squareup.com/dashboard/sales/transactions/80SK4MJ0QGGV8
2/5/14 8:31:25 Coffee Drip Coffee 1 Large $2.15 $0.00 $2.15 SwLvAVlm8uhGWhnX1GB Sean https://squareup.com/dashboard/sales/transactions/SwLvAVlm8uhGWhnX1GB
2/5/14 8:26:08 Coffee Drip Coffee 1 Large $2.15 $0.00 $2.15 qU1wXWOjG1T8aXzd1GB Sean https://squareup.com/dashboard/sales/transactions/qU1wXWOjG1T8aXzd1GB
2/5/14 8:21:00 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 8YA9FGBMEK6AP Sean https://squareup.com/dashboard/sales/transactions/8YA9FGBMEK6AP
2/5/14 8:21:00 Baked goods Brown Butter 1 Scone $1.87 $0.00 $1.87 8YA9FGBMEK6AP Sean https://squareup.com/dashboard/sales/transactions/8YA9FGBMEK6AP
2/5/14 8:17:25 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 DWYPB8ZQJRBF3 Sean https://squareup.com/dashboard/sales/transactions/DWYPB8ZQJRBF3
2/5/14 8:13:00 Coffee Drip Coffee 1 Medium $1.96 $0.00 $1.96 cRRnO5Shvateejo1zGB Sean https://squareup.com/dashboard/sales/transactions/cRRnO5Shvateejo1zGB
2/5/14 8:12:41 Coffee Drip Coffee 1 Medium au Lait $2.38 $0.00 $2.38 0EBP1QHQ11FSE Sean https://squareup.com/dashboard/sales/transactions/0EBP1QHQ11FSE
2/5/14 8:12:03 Baked goods Iggy's 1 Filled Croissant $2.34 $0.00 $2.34 CH9X0H798GYDS Sean https://squareup.com/dashboard/sales/transactions/CH9X0H798GYDS
2/5/14 8:12:03 Coffee Drip Coffee 1 Medium $1.96 $0.00 $1.96 CH9X0H798GYDS Sean https://squareup.com/dashboard/sales/transactions/CH9X0H798GYDS
2/5/14 8:10:57 Baked goods Brown Butter 1 Scone $1.87 $0.00 $1.87 8JKH2PER3Z5NH Sean https://squareup.com/dashboard/sales/transactions/8JKH2PER3Z5NH
2/5/14 8:10:32 Tea Tea 1 Hot $1.92 $0.00 $1.92 2173WGPNVJM8A Sean https://squareup.com/dashboard/sales/transactions/2173WGPNVJM8A
2/5/14 8:06:25 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 6YREBBDFCDZK9 Sean https://squareup.com/dashboard/sales/transactions/6YREBBDFCDZK9
2/5/14 8:00:38 Coffee Drip Coffee 1 Reusable Cup $0.93 $0.00 $0.93 23HPENF3HD252 Sean https://squareup.com/dashboard/sales/transactions/23HPENF3HD252
2/5/14 7:35:10 None Custom Amount 1 $0.00 $0.00 $0.00 0MXVHZ6T6XREK Sean https://squareup.com/dashboard/sales/transactions/0MXVHZ6T6XREK
Raw
index.html
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF8">
</head>
<body>
<script src="http://d3js.org/d3.v3.min.js" charset="utf-8"></script>
<script src="http://code.shutterstock.com/rickshaw/vendor/d3.layout.min.js"></script>
<script src="http://code.shutterstock.com/rickshaw/rickshaw.min.js"></script>
<script src="tosci_ben.js" charset="utf-8"></script>
<div id="chart"></div>
<script>
console.log("preparing to graph");
var data = [ { x: 0, y: 40 }, { x: 1, y: 49 }, { x: 2, y: 17 }, { x: 3, y: 42 } ];
var graph = new Rickshaw.Graph( {
element: document.querySelector("#chart"),
width: 580,
height: 250,
series: [ {
color: 'steelblue',
data: preppedCoffeeData //<--- this doesn't work
//data: data //<--- but this does. i don't get it!
} ]
} );
console.log("graphed!");
graph.render();
</script>
</body>
</html>
Raw
tosci_ben.js
function parseRow(d) {
var dateTimeJoiner = d3.time.format("%x %X"); // combines date and time into a Date object
var dateTime = dateTimeJoiner.parse(d.Date + " " + d.Time) // grabs the date and time
var gross_sales_conversion = +d["Gross Sales"].substr(1) //strips the $ sign
var total_sales = gross_sales_conversion * 1.07 //add tax
return {
date: dateTime,
category: d.Category,
item: d.Item,
quantity: +d.Quantity,
pricepoint: d["Price Point Name"],
gross_sales: gross_sales_conversion,
total_sale: +d3.format(".2f")(total_sales), // rounds to 2 decimal places
device_name: d["Device Name"]
};
}
function handleRows( error, rows ) {
// this function is only called once all the rows are loaded
// In this function you can now access the loaded and parsed rows
rows.forEach( handleRow );
//console.log("dataset after loading csv:", dataset)
//console.log("coffeeData after full loading:", coffeeData);
coffeeData.forEach(prepRowForRickshaw);
//reverses the order of entries to increase since they're added to the array from close of the store to open (22 down to 8)
preppedCoffeeData.reverse();
}
function handleRow( row, i, rows ) {
//console.log("item #", i, row.date, "adding to dataset");
var hour = d3.time.hour.floor(row.date);
if (row.category == "Coffee") { // for all items that are coffee...
//console.log("Adding", row.item, "to dataset");
//console.log("This item was sold in the hour of", d3.time.hour.floor(row.date));
// if the hour of sale of this item exists as a key in our sales dictionary
if (!(coffeeData.has(hour))) {
//add the total_sale to that hour
//coffeeData[hour] = row.total_sale; OLD IDEA AS PYTHON DICTIONARY
coffeeData.set(hour, row.total_sale);
//console.log("Adding", row.total_sale, "of", row.item, "to new hour:", d3.time.hour.floor(row.date))
}
//otherwise, add that hour to the dictionary and initialize it with this item's total_sale
else {
//coffeeData[hour] += row.total_sale OLD IDEA AS PYTHON DICTIONARY
//get current sales for this hour
var currentSales = coffeeData.get(hour);
//add this particular sale to the current hour
coffeeData.set(hour, currentSales + row.total_sale);
//console.log("Adding", row.total_sale, "of", row.item, "to existing hour", d3.time.hour.floor(row.date));
}
}
//dataset.push(row);
}
// d3.csv( csv_file_path, parsing_function, callback_function)
d3.csv("5feb2014.csv", parseRow, handleRows);
//var dataset = [];
var coffeeData = d3.map();
//var coffeeMap = d3.map(coffeeData);
//console.log("dataset before loading csv:", dataset)
//make an array
var preppedCoffeeData = [];
//create an object for each key in the map with x and y properties
function prepRowForRickshaw(key,value) { //function pushes sales data to preppedCoffeeData in the proper form for Rickshaw (x: time, y: total_sale)
//Convert the d3.date into a js Date object and then get the hours as an integer
var hourInteger = new Date(key).getHours()
//create an object with the x and y values as the hour (int) and total sales amount, respectively
//var xy = {x: 0, y: 1} <--- even this doesn't work...
var xy = {x: hourInteger, y: value}
//Push the object into our array to be graphed by rickshaw
preppedCoffeeData.push (xy);
}
@bengolder
Copy link

check out this and see if you can figure out how to plug it in:

function prepRowForRickshaw( d ) {
  return {
    x: d.date,
    y: d.total_sale,
  };
}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment