For correct transport settings on MALL.CZ are the following steps are required:
- Correct and complete spectrum of Uloženka branches that you update regularly (unless you manually enter shipments directly in the Uloženka system) - use Uloženka documentation for API connection and updating here, For CSV export current branches, please visit the Implementation section in the portal.
- Correct settings package_size for your products on MALL.CZ (for now only smallbox = sum of three sides 170 cm max. length of one side 100 cm; max. 20 kg).
If the shipments are not set up correctly and are above the above dimensions, they may be rejected by the courier or the dispatcher and the customer will not receive the order.
- Correct mapping transport_id to your transports (if you connect directly to your information system) from the Get Transports endpoint here.
- Proper traffic generation:
- For API connect using the Marketplace API documentation for the establishment of transport
- for connection via MALL XML, Heureka XML or MANUAL input use the approach in MALL PORTAL in the section Delivery
- transport_id for mapping They are at CZ 20 and 21, v EN 49 and 119
- Correct behaviour by you of your shipping settings can be tested by adding items to your cart and checking that customers are offered drop-off locations for Personal collection - See:
- After selecting them, the customer gets to choose the most suitable collection point to pick up their order.
IMPORT CSV
THE FORM OF THE IMPORTED FILE
CSV is a simple file format designed for spreadsheet data exchange. CSV file format consists of rows in which individual items are separated by commas. It is advisable, but not necessary, to enclose the values of each column in quotation marks. This allows the item text to contain a semicolon. Imported file must not begin with a blank line or other white characters. It is necessary to save the file in Windows-1250 or UTF-8 character set. (Sample file is Windows-1250 to display correctly in Excel)
SHOWCASE .CSV FILE TO DOWNLOAD
SETTING THE ORDER OF COLUMNS
Two different import options can be used methods for determining the order of the columns. Either they are explicitly in the file headers are explicitly specified, i.e. the first line in the file contains the headers of each column listed in the first column of the table below. The second The other option is to set the order of the columns individually. In this case it is not necessary for the file to contain the column headings. Simply create and save the CSV in the "CSV settings" menu in the store settings. your own column order. According to this order, the data from the file will be loaded. It is also possible to choose to omit the first row of the file. This can be useful if your system generates a CSV file with headers that do not match the headers used in our system. Just select the option to skip the first line, set the the correct column order and the data will be loaded correctly.
CHECK BEFORE STORAGE
It is not necessary for the imported file to contain complete shipment data. It is possible to load only partial data, fill it in the form and save the shipment. On the other hand, if your data in the imported file is complete and correct, it is possible to save the shipment without confirmation.
| Header | Required | Data type | Description |
| transport_service | Yes | STR | Service, The service by which the shipment will be sent. The service alias is entered. The currently allowed values are: "storage", "depositor_parcelshop", "depositor_partner", "skpost_default", "dpd_private", "dpd_ classic", "cpost_dr", "cpost_np", "save_b2c". |
| address_state | For services. Parcel to hand, DPD Classic, DPD Pri- vate, SK Post Contract parcel with insurance, Storage card delivery to the address | ISO 3166-1 | Three digits code of the country to which the shipment is to be delivered. E.g. "CZE", "SVK". If the country is not filled in, the the country in which the selected pick-up branch is located the branch selected for the shipment. |
| register_branch | Optional | STR | Branch, where the shipment will be made. Enter the abbreviation of the branch. E.g. "pha4", "brno2". Branch abbreviations can be found in the section "Implementation". If the mailroom is not filled in, the the default mailroom that you have set in the settings of your store. |
| destination_branch | For services: Uloženka Premium, Uloženka Partner, Uloženka Partner, DPD Pic- kup CZ and SK, ČP parcel to post | STR | Branch, where the shipment will be picked up. The abbreviation of the branch is used. For example: "pha4", "brno2". Branch abbreviations can be found in the section "Implementation". |
| order_number | Yes | STR | Yours order number. For example, the order number ge- nerated by your system. |
| partner_consignment_id | Optional | INT | Number from your individual number series. The series has the format XXXXXYYZZZZZ where XXXXX = Id of your branch in our system (e.g. 00101), YY = rising YY = increasing number series for different shipment resolutions (from 01), ZZZZZ = shipment serial number (from 00001) |
| parcel_count | Yes | INT | Number of number of packages in the shipment. Possible with the services Storage Premium, Storage Partner, DPD Pickup CZ, DPD Private, DPD Classic, Package delivery to address |
| cash_on_delivery | Optional | Number | Above COD. |
| currency | Mandatory if it is cash_on_delivery, stated_price or insu- rance parameter is sent | ISO - 4217 | Currency other parameters sent in ISO-4217 format (e.g. CZK or EUR). |
| password | No | STR | Password, which is to be required for the release of the shipment. This parameter is not need to be filled in, we set the password for the shipments to be issued automatically. |
| variable | Optional | INT | Variable The symbol under which payment will be sent if the shipment is a shipment with COD. |
| customer_name | Yes | STR | Name Recipient. |
| customer_surname | Yes | STR | Last name Recipient. |
| company_name | Optional | STR | Name of the recipient company. |
| customer_phone | Yes | STR | Phone Recipient's phone number. |
| customer_email | For services: Storage Premium, Storage Partner, Storage Partner PNS, DPD Pickup CZ and SK, ČP parcel to post, Package delivery to address | STR | Email Recipient's address. |
| address_street | For services.
Parcel to hand, DPD Classic, DPD Pri- vate, SK Post Office contract ba- lík with insurance, Deposit card delivery to the address | STR | Streets Recipient. For delivery to a private address. |
| address_town | For services.
Parcel to hand, DPD Classic, DPD Pri- vate, SK Post Office contract ba- lík with insurance, Deposit card delivery to the address | STR | City Recipient. For delivery to a private address. |
| address_zip | For services.
Parcel to hand, DPD Classic, DPD Pri- vate, SK Post Office contract ba- lík with insurance, Deposit card delivery to the address | STR | POSTCODE of the recipient. For delivery to a private address. |
| insurance | For services. Mail | Number | Above insurance of the shipment. |
| weight | For services.
parcel to hand, ČP parcel to post, SK Post Office, Depository delivery to | Number | Weight shipment. |
| allow_card_payment | Optional for
Services. Partner (for other switches this option is not available at the moment) | INT | Permission payment by card upon receipt of the shipment at the branch. |
| require_full_age | Optional for
Services. ka Partner (verify) | INT | Verification of legal age of majority before the shipment is released. |
| note | Optional | STR | Note for partner's purposes. |
| allow_preview | Optional for Services. | INT | Permission to inspect the shipment upon receipt of the shipment at the branch. |
| sender_name | Optional for
Services. that Partner | STR | Name The sender's name used in notifications instead of the store's name. |