Marketplaces > Marketplaces T-Z > Zalando > ZEOS > ZEOS Reports > Sales & Returns Report (ZEOS)
TIP: Find an example for a Sales & Returns report here. |
When using ZEOS you receive regular reports about sold and returned articles.
Your download options:
•Use your FTP access to retrieve the reports (directory "out").
•Download the reports manually via TB.One's output directory ("Data exchange > Directories > Output").
Structure and Content of the CSV File
Naming
Sales & Returns Reports are named according to the following scheme:
Salesreport_mcf_channelsign_yyyymmdd_hhmmss.csv |
Salesreport_ |
Indicates that the file contains a sales/return report |
mcf_ |
Indicates a ZEOS report |
channelsign_ |
Letter code referencing the source channel |
yyyymmdd_hhmmss |
YearMonthDay_HourMinuteSecond |
.csv |
file type |
TIP: |
Configuration of the CSV File
Character Set |
Separator |
Text Qualifier |
|---|---|---|
UTF-8 |
Semicolon (;) |
Quotation mark (") |
Content of the CSV File
The following columns are part of the CSV file and may be evaluated:
FIELD |
DATA TYPE |
DESCRIPTION |
|---|---|---|
MESSAGE_DATE |
DATE(yyyy-mm-dd) |
The date of the event referenced in this message (e.g. the shipping date or the return date) |
DATE_CREATED |
DATE(yyyy-mm-dd) |
Shows when TB.One received the message |
CHANNEL_SIGN |
CHAR(12) |
The channel sign |
CHANNEL_ORDER_ID |
CHAR(50) |
The channel's unique order number |
CHANNEL_ORDER_SHIPMENT_ID |
CHAR(30) |
The channel's shipment ID |
CHANNEL_ORDER_ITEM_ID |
CHAR(50) |
The channel's item number |
CHANNEL_MESSAGE_ID |
CHAR(50) |
Unique ID of the channel message that created this order item. If it cannot be identified, this field is empty |
TB_MESSAGE_ID |
INT(20) |
Unique ID of the message that created this item |
TB_ORDER_ITEM_ID |
INT |
Unique number of an item within an order, assigned by TB.One |
TB_ORDER_ID |
INT |
Unique order number, 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 DELIVERED PAYMENT_STATE_OPEN PAYMENT_STATE_PAID PAYMENT_STATE_SHORTFALL |
QUANTITY |
INT |
Shipped/returned quantity (depending on TYPE) |
P_NR |
CHAR(50) |
Product number of the article's parent product |
A_NR |
CHAR(50) |
Article Number |
A_NR2 |
CHAR(50) |
Article number 2 |
A_PROD_NR |
CHAR(50) |
Manufacturer's article number |
A_EAN |
EAN13 |
EAN |
POS_ANR_CHANNEL |
CHAR(50) |
Channel article number (if available) |
BILLING_TEXT |
CHAR(255) |
Invoice text of the order item as provided by the channel |
ITEM_PRICE |
FLOAT |
Gross article price (retail price) |
TRANSFER_PRICE |
FLOAT |
Net article price per piece (quantity 1) after deduction of the channel's commission (if applicable), if no value is provided, the calculation is done in TB.One |
POS_CONDITION |
CHAR(50) |
Condition of the article (if provided by the channel); For returns: shows whether the article is still sellable, dirty, etc.; mainly used by Amazon FBA |
SERVICES |
CHAR(100) |
Item-related SERVICES. Note: NOT order-related services! Those are listed in the order-related fields |
CARRIER_PARCEL_TYPE |
CHAR(50) |
Information about the shipment |
CARRIER_TYPE |
CHAR(300) |
Carrier/delivery agency or shipping type |
IDCODE |
CHAR(50) |
Tracking code |
EST_SHIP_DATE |
DATE |
Estimated delivery date; only provided in order acknowledgments (otherwise empty) |
MESSAGE_COMMENT |
TEXT |
Item-related comment |
CUSTOMER_COMMENT |
TEXT |
Customer comment; order-level comments are repeated for each item |
ORDER_DATE |
DATE(yyyy-mm-dd) |
The channel's order date; if the channel does not provide a date, the order's creation date from TB.One is used |
INVOICE_NUMBER |
CHAR(25) |
The invoice number; if no invoice number is provided, the field remains empty |
TIP: You can include Intra Community Trade (ICT) information in your Sales & Returns Reports. The respective fields will be enabled for you on request. In some countries it is mandatory to provide this information to comply with tax regulations.
|