Export basic transaction details to CSV file

You can easily export transactions, their amounts, parties and more details to a CSV file (that can be viewed in Excel).

Sharetribe avatar
Written by Sharetribe
Updated over a week ago

Exporting the transaction information from your marketplace to a CSV file is a great way for you to analyze this information. You can download this data, importing it into a third party software like Excel or Google Spreadsheets, and create tables and graphs out of it. 

How to download your marketplace transactions

You can easily export the details of the transactions to a CSV file (that can be viewed in Excel) with the following steps:

  • Log in to your marketplace as an administrator.

  • Open your Admin panel.

  • Open the "Transactions & Reviews / Manage transactions" tab.

  • Click the "Export to CSV" link in the top right, above the table.

  • The download will start automatically.

Note: only administrators can export transaction information.

What does the transaction export file contain?

The CSV file export contains the following information: 

  • transaction_id: the unique transaction identifier

  • listing_id: the unique identifier of the listing that the transaction is related to (can be matched with the Listings CSV export)

  • listing_title: the title of the listing that this transaction is related to

  • status: the current state of the transaction

  • currency: the currency of the transaction and commission(s)

  • sum: the total amount that the buyer paid for this transaction

  • commission_from_provider: the commission charged to the buyer

  • commission_from_buyer: the commission charged to the seller

  • payment_gateway: the payment gateway used for the transaction

  • started_at: the datetime (UTC) when the buyer started the transaction

  • last_activity_at: the datetime (UTC) of the latest message or status change

  • buyer_user_id: the unique id of the buyer

  • provider_user_id: the unique id of the provider/seller

What is the export format?

You'll be able to download a CSV (Comma Separated Value) file. This is a text file where a comma separates all fields. You can open that file with any text or spreadsheet editor (like Notepad or Excel). It is not encrypted or password protected.

Here are more technical details on the file format:

  • Fields are separated by the comma (,) symbol.

  • Fields are enclosed with the quote (") symbol.

  • There is a header row.

  • File encoding is UTF-8.

What can you do with this data?

Lots of things! For example, you can:

  • Track how many transactions happen per week

  • Track your marketplace transactions growth

  • Find out who are the most important providers and buyers

  • Discover what is the most used payment gateway on your marketplace

  • Store it to keep it as a backup,

  • ...and more!

Did you know that you can also export your users' and listing information as a CSV file? Click here to learn more about user export and here to learn more about listing export!

Did this answer your question?