Order CSV Files
This page describes the file format of the order CSV files. For information on how to import these files into the Kaufland marketplace, see the Managing Orders page.
Overview
One way to manage orders is with order CSV files.
You can import files by uploading the file to a publicly accessible web server and sending a
POST request to the /import-files/order-command REST API endpoint.
Order Command Files
Order Command files are a kind of CSV file without a header line at the top. Instead, the first field of each line contains a command and the subsequent fields vary based on the command. Because of the lack of a header, the subsequent fields must be in the expected order. The correct fields and order for each command is listed below. Kaufland marketplace accepts two different commands in order command files. Every command consists of both required and optional fields.
Here are the available commands:
| Command | Description |
|---|---|
| MARK_UNIT_SENT | Mark an unit as sent. |
| MARK_UNIT_CANCELLED | Mark an unit as cancelled. |
MARK_UNIT_SENT
The MARK_UNIT_SENT command marks an item as shipped. This starts a background process which sends an email to the customer and (provisionally) transfers credit for the sale to the seller's account.
| Field | Required | Description | Example |
|---|---|---|---|
| id_order_unit | Required | The id_order_unit received in the order summary. | 56896348978 |
| carrier_code | Required | The shipping carrier that was used to send the item. The list of available codes is available in the
Carrier Codes section of this page. If you cannot supply a tracking
number for some reason, do not choose the Carrier Code, because then the tracking number
field is mandatory. Instead, give the value Other or Other Hauler for the
carrier. This changes the
tracking_number field from required to optional.For example, if you have shipped the package via DHL, but sent it book rate (Büchersendung), there is no tracking number for the package. So, you would specify Other for the carrier_code
and leave the tracking_number field blank. |
DHL |
| tracking_number | Required unless carrier_code is Other or Other Hauler |
Comma-separated list of tracking numbers of the package. | AB34DE5,6ED43BA |
MARK_UNIT_CANCELLED
The MARK_UNIT_CANCELLED command cancels the delivery of an item. This starts a background process which sends an email to the customer and transfers credit for the sale back to the customer's account.
| Field | Required | Description | Example |
|---|---|---|---|
| id_order_unit | Required | The id_order_unit received in the order summary. | 56896348978 |
| reason | Optional | Reason for cancelling the order. The list of available reasons is available in the Cancellation Reasons section of this page. | NoInventory |
Examples
Here are some examples of lines from command files.
MARK_UNIT_SENT;56896348978;DHL;012345678912
This command marks the unit with id_order_unit 56896348978 as shipped. Shipping carrier is DHL and the tracking number is 012345678912
MARK_UNIT_CANCELLED;56896348978;NoInventory
This command cancels the unit with id_order_unit 56896348978 because the unit is not in inventory.
Carrier Codes
The following values are allowed for the carrier_code field:
OtherOther Hauler4PXAllekurierAmazon Logistics DE (Swiship)Amazon Shipping (IT)Ambro ExpressAsendiaAsendia GermanyAustrian PostBejot LogisticsBRT BartoliniBurspedCargolineCargo InternationalChina PostChronopostChukou1 LogisticsColissimoColis PriveCorreosCubynCzech PostCNE ExpressDachserDeutsche PostDHLDHL EcommerceDHL FreightDHL Hong KongDHL Poland DomesticDPDDPD FranceDPD HungaryDPD NetherlandsDPD PolandDPD RomaniaDPD Czech RepublicDPD SlovakiaDPD AustriaDPD UKDTLDSVECEEmonsEvriFedexFedEx Poland DomesticFlyt ExpressGebrüder Weiss GermanyGebrüder WeissGeisGeis PolandGELGeodisGLSGLS ItalyGLS PolandGuettler LogistikHellmannHermesHermes 2 MHHong Kong PostHua Han LogisticsIDS LogistikIloxxInPostJersey PostKuehne & NagelLa PosteMondial RelayNexiveNova PostOrlen PaczkaOverseas Territory FR EMSPacketa*Poland PostPoste ItalianePost HastePostNLPostNL 3SPressioPPLRaben GroupRedur SpainRhenusRoyal ShipmentsSailpostSchenkerSDASeurSFC ServiceSGT Corriere EspressoSiodemkaSlovakia PostSlovak Parcel ServiceSpring GDSSPT Furniture LogisticSuusSunyouTNTTNT ClickTNT FranceTNT ItalyTrans MFtrans-o-flexTopTransUBI Smart ParcelUPSWanb ExpressWeDo LogisticsWinitWnDirectYanwenYDHYun ExpressZufall
*Please note: Packeta has made changes to its own API. Before you can use Packeta's tracking again, you have to set the tracking to "public".
Alternatively, you can unlock the Kaufland key in Packeta's settings.
The Kaufland key is: e6844cc6bffd48cf
Cancellation Reasons
Here are the allowed values for the reason field for cancellations, along with their meanings:
BuyerCancelled: the buyer cancelled the order.ShippingAddressUndeliverable: could not deliver to the address given by the customer.WrongCatalogData: the description on the Kaufland marketplace did not match the item in your inventory.MerchandiseNotReceived: the customer says that the item did not arrive due to problems during shipping.NoInventory: the item is not currently in your inventory, for example because you are temporarily or permenantly sold out.DelayedInventory: the item is not in your inventory and there is a delay in delivery by the supplierWrongPrice: the price on the Kaufland marketplace was incorrect.UndeliverableRegion: if you do not ship to the customers location.NoReactionBuyer: if there is no response by the customer to complete the orderGeneralAdjustment: if none of the other reasons apply to your situation, use this reason.