Tradecloud One offers users the possibility to export orders from the portal in an .CSV (comma-separated values) file. This page will explain how the export function works.
Orders can be exported from the Orders page using the “EXPORT” button at the top right in the blue banner. A user can determine which orders are exported based on the regular order filters.
For example, if you want to export all Issued orders, then select the “Issued” process filter. If you want to export only one specific order, then search for that order using the Search box.
A maximum of 100 orders (including order lines) or 100 order lines are exported, depending on if you use the “ORDERS” or “LINES” overview on the Orders page.
Because Tradecloud One uses over 200 data fields, the possibility is offered to customize the export file. This can be done in the dialog that is opened just after the export button is pressed. The available data fields for export are categorized into 7 groups, within each group a user can drag and drop certain fields to another position, and of course, certain fields can be (de)selected.
Based on a user’s role (buyer or supplier) a default set of data fields is preselected. However, a user’s customization is saved in the local storage from the browser when any changes are made in the selection. So a user doesn’t have to select the desired fields every time an export is made.
|GENERAL ORDER DATA||Includes the aggregated order statuses and dates when an order received a specific status for the first time.|
|BUYER ORDER||Includes the order header information originated by the buyer’s ERP. For example, the destination and incoterms.|
|SUPPLIER ORDER||Includes the order header information originated by the supplier’s ERP (Can only be filled when a supplier also has an integration with Tradecloud One)|
|GENERAL LINE DATA||Includes the order line statuses, dates when an order line received a specific status for the first time & aggregated item detail data.|
|BUYER LINE||Includes the order line information originated by the buyer’s ERP. For example, the price, quantity & delivery date.|
|SUPPLIER LINE||Includes the order line information originated by the suppliers. For example, the sales order number of an order line.|
|CONFIRMED LINE||Includes the order line information where the buyer and supplier agreed upon. (Only filled when the order line has been in the process status Confirmed)|
The .CSV file can be opened with Excel. If your PC is set up in a language that uses a “,” as list separator (like English), then Excel will interpret the .CSV file automatically. If your PC is set up in a language that uses another list separator then a “,” (like Dutch), you have to follow the steps below to make a human-readable table out of your .CSV file.
- Open your CSV file in Excel
- Go to the Data tab and select ‘Text to Columns’
- Choose the ‘Delimited’ option and click Next
- Select the “Comma” as the delimiter, check if the data is correctly displayed in the Preview pane below
- Click on Finish