@bigtwig First, I have to admit that finding the answer to this was a lot harder and more frustrating that I think it should have been. Regardless, I found the answer. You are right — there is no “note to seller” field in the usual Transactions, etc, CSV files. And, while you are right that the note is not on the email we get from Square when an order is placed, it IS on the customer’s email. Very odd oversight there, IMO.
The ONLY place you can find this is in a report from your Online Store. To do this, start at your Square dashboard. Then:
- Select Online
- Go to Orders
- Click Export Orders button at the top
- Specify date range, type of report and file type (probably CSV so that you can mess with it in a spreadsheet app).
- Then click Export
You will receive an email shortly with a link to your CSV. Keep in mind that this is a complicated file. It has a header line for the order information, and then one line below that for each item in the order. However, scroll all the way to the right and you’ll see a column labeled “Order Notes.” This will contain notes to seller. I confirmed this by creating a test order on my online ordering website.
Definitely, I would submit a feature request to have this column added to the regular Transactions CSV in the future, as well as to the email we get. Do that here — https://www.sellercommunity.com/t5/Feature-Requests/ct-p/Beta-Feature-Requests
If it helps, I saw that the note I added to my test order was:
- On the printed kitchen check (KDS, too),
- On the POS detail when the order was received
Since I don’t think you are a restaurant, that probably doesn’t help much. However, it is also displayed if you go to Online -> Orders and touch on the order to display order details.
Lastly, I have a spreadsheet that will take the CSV I mentioned above and “compress” it by adding the order details to each item for the order. It works, even if it is clunky. LOL
Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)
Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!
