Skip to content

myShop Orders

File: myshop_orders_export.csv · Where: Admin Tasks → End-of-Year Reports → year → myShop Orders

myShop orders are deleted when a school year closes — the store starts the new year empty. This export is the permanent record of what was sold.

Three things are saved:

What File Where on the page
The orders myshop_orders_export.csv The myShop Orders card
The products on each order myshop_order_items_export.csv Under Other Files
A receipt per online order myshop_receipts/myshop_order_<number>.html Under Other Files

The orders file

One row per order.

Column What it holds
id The order number
full_name Who the order is for
billed_to, billed_to_email The name and email on the payment
email The email the confirmation went to
shipping_address Where it was going, if the order was shipped
amount_paid The total received
date_ordered When the order was placed
payment_method Cash, check, PayPal, card
notes Notes recorded on the order
confirmation The confirmation number shown to the shopper
phone_number Contact number given at checkout
school, students_name, student_sponsor The checkout fields your store asks for, where you use them
user The signed-in account that placed the order, if any
status New, In-Progress, On-Hold, Fulfilled or Needs Review
tx_details The raw payment-processor response, for online orders

Reading it

user is empty for guest checkouts. Anyone can buy from your store without an account.

Blank tx_details means the order wasn't paid online — cash and check sales taken at the Point of Sale, mostly. Those orders have no saved receipt file either.

Needs Review means the payment went through but a check afterwards didn't. Whatever went wrong is described in notes. Those orders need reconciling against your processor.

Discounts aren't broken out in this file. amount_paid is what was actually taken. Promo code detail sits with the order in myShop while the year is open — capture it from the myShop dashboard exports before you close out if you need it.

The order items file

Under Other Files, myshop_order_items_export.csv lists the individual products bought. It is download-only — there's no preview.

Column What it holds
id The line item's ID
product_id Which product was bought
quantity How many
price The price paid per item
user_id The account that bought it, if the shopper was signed in
item_options The size, colour or other option chosen

Product names aren't in this file

Line items record product_id, and products themselves aren't exported. The saved receipts name every product in plain English, and are the better place to look up what an order actually contained.

The saved receipts

myshop_receipts/ holds one HTML file per online order, named myshop_order_<order number>.html. Each is the receipt the buyer received: products, options, quantities, prices and the total.

Download one from Other Files and open it in any browser. Use Print → Save as PDF to keep a PDF copy — handy when a buyer asks for a receipt for an order from a previous year.

Orders paid in cash or by check at the Point of Sale have no receipt file.