Skip to main content

How do I export orders to CSV?

Export orders from the Orders page to a .csv or .xlsx file and choose which fields to include.

You can export orders from Tradecloud to a .csv or Excel (.xlsx) file, for example for your own reporting.

For: suppliers and admin buyers. Buyers without admin rights can't export orders.

Steps

  1. Go to the Orders page.

  2. Use the filters or the search box to show the orders you want to export. For example, select the process status Issued to export all unconfirmed orders, or search for one order number to export only that order.

  3. Click Export at the top right.

  4. Choose the fields you want to include (see below).

  5. Choose .csv or .xlsx and start the export.

Choosing fields

Tradecloud has more than 200 data fields, grouped in seven categories. A default set is selected based on whether you are a buyer or supplier. Your own selection is remembered in your browser for the next export.

General order data

Aggregated order statuses and the date an order first reached each status.

Buyer order

Order header data from the buyer's ERP, such as destination and incoterms.

Supplier order

Order header data from the supplier's ERP. Only filled when the supplier has an integration.

General line data

Order line statuses, the date a line first reached each status, and item details.

Buyer line

Line data from the buyer's ERP, such as price, quantity and delivery date.

Supplier line

Line data from the supplier, such as their sales order number.

Confirmed line

The line data both sides agreed on. Only filled once the line has been confirmed.

Troubleshooting

If a .csv file doesn't open correctly in Excel, export as .xlsx instead.

Did this answer your question?