Marketplaces > Reports > EXPORT OF REPORTS FOR FULFILLMENT CHANNELS
For channels providing fulfilment options to merchants (fulfilment channels), orders and returns as well as stock numbers are passively mirrored. That means, they are retrieved from the channel and displayed in TB.One.
Reports on fulfilment channels can be initiated manually via the menu "Home > Statistics". If you would like to receive these reports regularly in order to evaluate them, contact the Tradebyte support to have the feature activated. You can access these reports in TB.One's "OUT" directory. The reports have to be activated separately for each fulfilment channel. The reports listed below are the most basic version of reports available for fulfilment channels. Some channels, such as ZFS, have individual report files, which are explained in the respective channel's section of the knowledge base.
SALES/RETURNS REPORT
The sales and returns reports which are made available to you in TB.One's "OUT" directory are named according to the following structure:
Salesreport_channelname_yyyymmdd_hhmmss.csv |
|
|---|---|
Salesreport_ |
Identification as a sales & returns report file |
channelname_ |
Name of the source channel |
yyyymmdd_hhmmss |
YearMonthDay_HourMinuteSecond (time of the export) |
.csv |
File extension |
The file contains every order/returns item that was created in TB.One over the course of the previous day. The file is always created, even if no new order/returns data were generated. In that case, the file will only contain the header.
The following columns are included in the CSV file:
FIELD NAME |
DATA TYPE |
DESCRIPTION |
|---|---|---|
MESSAGE_DATE |
DATE(yyyy-mm-dd) |
The channel's date for the message relating to this position (e.g. shipping date, return date) |
DATE_CREATED |
DATE(yyyy-mm-dd) |
Date on which TB.One received the channel's message |
CHANNEL_SIGN |
CHAR(12) |
The channel sign (a unique identifier referencing the channel; usually four characters) |
CHANNEL_ORDER_ID |
CHAR(50) |
The channel's order number (unique) |
CHANNEL_ORDER_SHIPMENT_ID |
CHAR(30) |
The channel's shipment ID |
CHANNEL_ORDER_ITEM_ID |
CHAR(50) |
The channel's order-related item number (references the order item) |
CHANNEL_MESSAGE_ID |
CHAR(50) |
The channel's unique ID for the message that created this row in the table (if available; otherwise empty) |
TB_MESSAGE_ID |
INT(20) |
TB.One's unique ID for the message that created this row in the table |
TB_ORDER_ITEM_ID |
INT |
Unique number of an item within an order, assigned by TB.One |
TB_ORDER_ID |
INT |
Unique number of the order, assigned by TB.One |
TYPE |
CHAR(20) |
Message type (ORDER_ACKNOWLEDGE, SHIP, NO_INVENTORY, CUST_CANCEL, RETURN, DEDUCT_SHIPPING_COSTS, DEDUCT_SERVICE_PRICE, DEDUCT_PAYMENT_COSTS, PAYMENT_STATE_OPEN, PAYMENT_STATE_PAID, PAYMENT_STATE_SHORTFALL); a description of the message types can be found here |
QUANTITY |
INT |
Delivery/returns quantity (dependent on TYPE) |
P_NR |
CHAR(50) |
Product number (number of the product which includes the article) |
A_NR |
CHAR(50) |
|
A_NR2 |
CHAR(50) |
|
A_PROD_NR |
CHAR(50) |
|
A_EAN |
EAN13 |
|
POS_ANR_CHANNEL |
CHAR(50) |
The channel's article number (if available) |
BILLING_TEXT |
CHAR(255) |
The order item's (external) billing text as provided by the channel |
ITEM_PRICE |
FLOAT |
Article price; gross (retail price) |
TRANSFER_PRICE |
FLOAT |
Net article price after the channel's commission has been deducted; if this value is not provided by the channel, TB.One will calculate it; the value refers to one article (quantity 1) |
POS_CONDITION |
CHAR(50) |
The article's condition (if provided by the channel); usually used for returns (can the article still be sold; is it broken, dirty, etc.); mainly used with Amazon FBA |
SERVICES |
CHAR(50) CHAR(100) |
Position-related services (not order-related ones; those are indicated in the order-related fields) |
CARRIER_PARCEL_TYPE |
CHAR(50) |
Information about the shipment |
CARRIER_TYPE |
CHAR(300) |
Carrier and/or shipping type |
IDCODE |
CHAR(50) |
Tracking number |
EST_SHIP_DATE |
DATE(yyyy-mm-dd) |
Estimated delivery date (as indicated in the order acknowledgment; otherwise empty) |
MESSAGE_COMMENT |
TEXT |
A comment/message regarding this order item |
CUSTOMER_COMMENT |
TEXT |
A comment by the customer; if the comment was submitted on order level, it is repeated for each order item |
ORDER_DATE |
DATE(yyyy-mm-dd) |
The channel's order date; if no date is provided, the date on which the order was created in TB.One is used |
STOCK REPORT
ARTICLE_stockreport_hhmmss.csv |
|
|---|---|
ARTICLE_stockreport_ |
Identification as a report file for article stock |
yyyymmss_hhmmss |
YearMonthDay_HourMinuteSecond (time of the export) |
.csv |
File extension |
The file contains the stock numbers for all articles that are active for the respective channel during the time of export.
The following columns are included in the CSV file:
FIELD NAME |
DATA TYPE |
DESCRIPTION |
|---|---|---|
P_NR |
CHAR(50) |
Product number |
A_NR |
CHAR(50) |
Article number |
A_NR2 |
CHAR(50) |
Article number 2 |
A_PROD_NR |
CHAR(50) |
Manufacturer's article number |
A_NR_CHANNEL |
CHAR(50) |
Channel article number |
A_EAN |
EAN13 |
EAN |
A_STOCK[KEY] |
INT |
The article's stock numbers. The key is the name of the channel-specific warehouse |
For further information, see also:
•Order processing - overview of interfaces and settings
•Manual order processing - overview
•Order processing via CSV - overview
•Order processing via XML - overview