Export Sold items
Export details about recent trades and transactions from My Trade Me. For old, bulk or tax information, you may need to request an account summary.
Download details about your recent sales from My Trade Me as a .csv file. For sales older than 45 days, you may need to request an account summary.
How to export your Sold items
You can export your sold items as a .csv file, which opens in Excel, Google Sheets and most accounting tools.
To export your Sold items on the Trade Me website:
- Head to trademe.co.nz in your browser. You can't download your sales from the Trade Me app.
- Go to My Trade Me.
- Select Sold from the left hand menu.
- Select Export CSV.
- Use the dropdown to select the time period of sales you want to export.
- To find a specific sale, type in the search box. You can search by listing number, the buyer's member name or email, or words in the listing title.
- If you want sales you've deleted from your Sold page, tick Include items I have deleted.
- Select Export.
When it's ready, a .csv file will download to your computer's downloads folder.
Choosing which sales are in your file
Your file has every sale that matches what you choose, going back 45 days. Each row is one sale.
You can choose:
- A time period, such as the last 7 days or the last 45 days.
- A sale status, such as Goods shipped or Feedback to place.
- Whether to include sales you've deleted from your Sold page.
To find particular sales use the search bar. You can search by:
- A listing number.
- The buyer's full member name or full email address.
- A word or words in the listing title.
Your file includes every sale in the period you choose. If no sales match your criteria, the file will only have column names.
If you need to look at sales older than 45 days, request an account summary.
What's in your file
Each column in your sold items file shows a different detail about your sales. Select a heading below to see what each column means and how it looks
Sale details
This table lists the columns in your sold items file that describe each sale, such as the listing number, sale price and when it sold
| Column | What it means | Example |
|---|---|---|
| listing_id | The listing number. | 2147499304 |
| title | The listing title. If the payment is on hold or being reviewed, the title starts with Payment held - or Payment under review -. | Rimu dining chair |
| category | The category the item was listed in. | /Building-renovation/Kitchen/Kitchen-cabinets |
| sold_date | When the item sold, in NZ time. | 2026-11-12 17:05 |
| sold_type | How it sold: Auction, Buy now or Fixed price offer. | Buy now |
| sale_price | The price for one item. If the buyer bought more than one with Buy Now, multiply this by bn_quantity_sold to get the total. | 12.00 |
| bn_quantity_sold | How many the buyer bought with Buy Now. | 1 |
| purchase_id | Our reference number for this purchase. | 341 or P341 |
| order_id | The order number, if the buyer checked out using their cart. Blank if they didn't. | 1043552 or C1043552 |
| sku | Your own stock code (SKU), if you added one to the listing. | CHR-RIMU-01 |
| note | Your private note on this sale. | Posted Tuesday |
Shipping
This table lists the columns in your sold items file that show the shipping option the buyer chose and what it cost.
| Column | What it means | Example |
|---|---|---|
| shipping_details | The shipping option the buyer chose, without the price. | Wellington |
| selected_shipping | The shipping option the buyer chose, with the price. | $13.18 Wellington |
| selected_shipping_price | The price of the shipping option the buyer chose. -1 means pick-up and -2 means free shipping. | 13.18 |
| Multiple_items_shipping | How shipping is charged if a buyer buys more than one with Buy Now: Charge no extra (shipping charged once) or Per item (charged for each item). | Charge no extra |
Buyer details
This table lists the columns in your sold items file with the buyer’s details, including their delivery address and contact details.
| Column | What it means | Example |
|---|---|---|
| buyer_name | The buyer's member name. | kiwibargains22 |
| buyer_delivery_address | The name and address the buyer wants the item sent to. If they're not getting it delivered, this is blank or says 'Buyer to pick-up or make arrangements directly with the seller'. | Kev Kiwi, 12 Gumboot Lane, Grey Lynn, Auckland 1021 |
| message_from_buyer | Delivery instructions from the buyer. | Please leave at the back door |
| buyer_contact_ph | The buyer's phone number, if they gave one. | 021 5551234 |
| buyer_email | The buyer's email address. | Kev@example.com |
Payment
This table lists the columns in your sold items file that show how the buyer paid and whether you’ve asked for a success fee refund.
| Column | What it means | Example |
|---|---|---|
| is_pay_now_purchase | Whether the buyer paid by card with Pay Now: yes or no. Shows no while the payment is on hold or being reviewed. | no |
| is_afterpay_purchase | Whether the buyer paid with Afterpay: yes or no. | no |
| is_ping_purchase | Whether the buyer paid with Ping: yes or no. Shows no while the payment is on hold. | no |
| refund_status | Where your success fee refund request is up to, if you asked for your success fee back because the sale didn't go ahead: Refund pending, Refund approved, Refund declined or Refund cancelled. Blank if you didn't ask. | Refund pending |
Fees
This table lists the columns in your sold items file that show the fees you paid for each listing and sale.
| Column | What it means | Example |
|---|---|---|
| listing_fees | Listing fees for this listing, including any fee for going over your free listing allowance. | 0.00 |
| promotion_fees | Other fees on the listing, mostly promotions like gallery, bold or a subtitle. | 3.45 |
| success_fees | The success fee for this sale. | 1.08 |
Fees when you sell several items from one Buy Now listing
If you sold several items from one Buy Now listing, its listing and promotion fees show on each sale’s row. Don’t add them up across these rows, or you’ll count the same fees more than once.
GST on overseas sales
This table lists the columns in your sold items file that show GST collected on sales by overseas sellers. If you sell from within New Zealand, tax_subtotal shows 0.00 and tax_jurisdiction and tax_rate_id are blank.
| Column | What it means | Example |
|---|---|---|
| tax_subtotal | The GST we collected from the buyer. When there's GST, sale_price and selected_shipping_price don't include it, but start_price, reserve_price and buynow_price do. | 5.87 |
| tax_jurisdiction | The country the GST was collected for. | NZ |
| tax_rate_id | Our reference for the GST rate used. | 1 |
The listing
This table lists the columns in your sold items file with details of the original listing, such as start date, prices and who could buy.
| Column | What it means | Example |
|---|---|---|
| start_date | When the listing started, in NZ time. | 2026-11-12 17:02 |
| auction_length | How long the listing ran, or 'Scheduled enddate' if you picked the end time. | 7 days |
| start_price | The starting price. | 5.00 |
| reserve_price | The reserve price. If you didn't set one, it's the same as start_price. | 40.00 |
| buynow_price | The Buy Now price. Can be 0.00 for Buy Now only listings. | 12.00 |
| bn_only_quantity_avail | For Buy Now listings: the quantity on the listing. | 1 |
| restrictions | Who could buy, if you limited it. 'Authenticated only' means authenticated members, and 'av only' means members with a verified address. Blank if anyone could buy. | Authenticated only |
| bidder_and_watchers | How many people were watching the listing. | 1 |
Listing extras
This table lists the columns in your sold items file that show which listing extras you used. Each one shows yes or no.
| Column | What it means |
|---|---|
| feature | Whether it was a featured listing. |
| gallery | Whether it had gallery. |
| bold | Whether the title was bold. |
| homepage_feature | Whether it was featured on the homepage. |
| highlighted | Whether it was highlighted. |
| extra_photos | Whether it had more than one photo. |
| scheduled_enddate | Whether you chose the end date and time. |