Orders import via CSV File

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

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 > Import orders from CSV file.

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, ahlens, aliexpress, allegro, alltricks, amazon, animalis, anthropologie, asos, atlasformen, auchan, bandq, beerwulf, bestsecret, bhv, bigcommerce, bild, blackredwhite, blokker, boots, brandalley, bricobravo, bricodepot, bricomarche, bricoprive, bulevip, but, carrefour, carrefour_es, carrefour_fr, casadellibro, castorama, cdiscount, commercelayer, conforama, creavea, cultura, darty, debenhams, decathlon, douglas, ebay, ecwid, elcorteingles, elkjop, ellos, empik, eprice, etsy, fanatics, feelunique, fnac, fonq, freepeople, fressnapf, gifi, greenweez, greenweez_fr, groupon, handm, home24, ibs, incomedia, lafayette, laredoute, leroyMerlin, leroymerlin_it, magento, magento2, maisonDuMonde, maisondumonde_es, maisondumonde_it, manomano, manomano_de, manomano_es, manomano_fr, manomano_gb, manomano_it, matalan, mathon, maty, maykers, mediaMarkt, mediamarkt_at, mediamarkt_de, mediamarkt_es, mediamarkt_it, mediamarkt_nl, miravia, miravia_es, modivo, modivo_pl, mountainwh, natureetdeco, newcart, nocibe, obelink, pandacola, pccomponentes, perfumesclub, phonehouse, pixmania, placedestend, planetahuerto, pourdebon, prestashop, printemps, privalia, privalia_es, privalia_it, privsportshop, public, quirumed, redcarepharmacy, rueducommerce, sarenza, shopapotheke, shopify, shopware6, showroomprive, slood, 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, stadium, storeden, superdrug, tiendanimal, tradeinn, truffaut, twil, ubaldi, urbanoutfitters, venca, venteunique, vivino, vtex, watchfinder, winesitting, woocommerce, wook, worten, worten_es, worten_pt, yoox, _epriced, _mage2d, _maged, _prestad, _shipmentsepriced, _shipmentsmage2d, _shipmentsmaged, _shipmentsprestad

Not