TradeBox Export

Overview
This report produces data that is designed to be uploaded to Tradebox. Tradebox can act as a middleman between Linnworks and accountancy software such as Sage. It contains details of all completed orders for the given dates.

Selection Criteria

Linnworks will select the items to be included in the report based on the following criteria

Parameters - There are no configurable parameters for this report.

  • Date Range: An inclusive range based on the date the order was placed on the sales channel
    • Start date: From the start of the day for the specified date
    • End Date: To the end of the day for the specified date

Rules - internal logic applied to extract only those records that fulfil the specified criteria

  • This report includes all processed, non-returned, orders between the specified dates

Reported Values

The following values are returned by the report

Values - Column names and description

  • Order Date: The date and time at which the order was placed on the sales channel
  • Order ID: This is the Linnworks OrderID
  • Item ID: The SKU / Item number assigned on the channel for the Linnworks inventory item that was ordered
  • SKU: The SKU / Item number for the Linnworks inventory item
  • Product Name: The title for the Linnworks inventory item (found on the General tab)
  • Currency: This is the currency used on the order or set in the channel config for that sales channel
  • Product Price: The individual sold price for the item that has been purchased, includes tax
  • Quantity: This is the number of the order item in the order
  • Carriage Amount: The shipping cost, as downloaded from the channel
  • Discount: This is the total discounted amount, in the order currency, for the order.
  • Payment Method: This is the Linnworks payment method that has been applied to the order
  • Shipping Method: This is the Linnworks Postal Service that has been assigned to the order
  • Billing Name: This is the Billing Name associated with the order
  • Billing Company Name: This is the company name, as entered on the order
  • Billing Address 1: Line 1 of the address used for billing purposes
  • Billing Address 2: Line 2 of the address used for billing purposes
  • Billing Address 3: Town of the address used for billing purposes
  • Billing Address 4: Region / State / County of the address used for billing purposes
  • Billing Address 5: Post code of the address used for billing purposes
  • Billing Country: This is the name of the country used for billing purposes
  • Billing Country Code: This is the ISO country code for the billing address
  • Customer Email: Email used for despatching purposes
  • Customer Telephone: This is the customer phone number that is associated with the order
  • Shipping Name: This is the name of the customer, as entered on the order
  • Shipping Company Name: Company name used for despatching purposes
  • Shipping Address 1: Address line 1 used when the order was despatched
  • Shipping Address 2: Address line 2 used when the order was despatched
  • Shipping Address 3: Town of the address used when the order was despatched
  • Shipping Address 4: This is the region, such as county or state, used when the order was despatched
  • Shipping Address 5: This is the shipping postcode or ZIP code entered on the order
  • Shipping Country: Country of the address used when the order was despatched
  • Order Status: This is a required column for tradebox and will display Complete
  • Shipping Country Code: This is the ISO country code for the shipping address
  • Marketplace: This is the concatenation of the Sourse and SubSource, such as: RAKUTEN My Rakuten Channel
  • ReferenceNumber: This is the reference number assigned by the sales channel for the order