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:

  1. Head to trademe.co.nz in your browser. You can't download your sales from the Trade Me app.
  2. Go to My Trade Me.
  3. Select Sold from the left hand menu. 
  4. Select Export CSV.
  5. Use the dropdown to select the time period of sales you want to export. 
  6. 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.
  7. If you want sales you've deleted from your Sold page, tick Include items I have deleted.
  8. Select Export.
     
     

When it's ready, a .csv file will download to your computer's downloads folder. 

Top Return_to_top.svg

 

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.

Top Return to top

 

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.

 

Top Return to top



Thank you for your feedback!
Something went wrong
Try the action again, or get in touch with us.