How to upload orders from CSV on Qapla’

This procedure allows to import orders on Qapla’ from a CSV file.

1. Create a CSV file

Download the example file

2. Fill the file out

With the necessary data, following order and list of the fields below indicated.

3. Enter

Enter the file on the panel of Qapla’, going on the labels home and clicking on: Actions > Import > I

This way you will be able to upload the file and select the channel you want to import it in. In order to proceed, please click on “Start importing”.

List of CSV fields

Create the text file taking into account the following fields (fields with * are mandatory and values must be separated by “;” semicolon):

Field Description Mandatory
Reference* Alphanumeric reference of the order
Order ID* Numerical reference of the order
Carrier The courier code of Qapla’: courier codes list Not
Courier Service Possible type of courier service; for instance it can be the contract code of GLS Italia or the tariff code of BRT: service code list Not
Status* The order status (processing, complete, etc.)
Created* Date of order creation (date format: YYYY-MM-DD)*
Modificated* Date of order update (date format: YYYY-MM-DD)
Name* Consignee’s name
Address* Consignee’s address
Town* Consignee’s city
Province* Consignee’s province
Post Code* Consignee’s post-code
Country* Consignee’s country
Email* Consignee’s email
Telephone Consignee’s telephone Not
Price Shipment amount. Please specify only one separator (the dot) for decimals and do not use separators to indicate thousands. Give a maximum of two decimal digits. Example: 2340.23 Not
Payment* Payment type
Is COD It is true if the payment is Cash On Delivery Not
Notes Any order notes Not
Weight Any order weight Not
Packages Any order packages Not
Length Possible dimensions: length Not
Width Possible dimensions: width Not
Height Possible dimensions: height Not
Origin API, aliexpress, allegro, amazon, bigcommerce, carrefour, carrefour_es, carrefour_fr, cdiscount, commercelayer, decathlon, ebay, ecwid, eprice, etsy, greenweez, greenweez_fr, groupon, ibs, leroyMerlin, leroymerlin_it, magento, magento2, maisonDuMonde, maisondumonde_es, manomano, manomano_de, manomano_es, manomano_fr, manomano_gb, manomano_it, mediaMarkt, mediamarkt_de, modivo, modivo_pl, prestashop, privalia, privalia_es, privalia_it, shopify, shopware6, spartoo, spartoo_be, spartoo_bg, spartoo_cn, spartoo_com, spartoo_comhr, spartoo_couk, spartoo_cz, spartoo_de, spartoo_dk, spartoo_es, spartoo_fi, spartoo_fr, spartoo_gb, spartoo_gr, spartoo_hu, spartoo_it, spartoo_nl, spartoo_pl, spartoo_pt, spartoo_ro, spartoo_se, spartoo_si, spartoo_sk, sprinter, sprinter_es, storeden, vivino, vtex, woocommerce, worten, worten_es, worten_pt, _epriced, _mage2d, _maged, _prestad, _shipmentsepriced, _shipmentsmage2d, _shipmentsmaged, _shipmentsprestad Not