--- title: "Export shipping slips" description: "Export your shipping slips as an Excel file: the ten formats available (standard, Boxtal, SendCloud, Mondial Relay...) and what their columns contain." url: https://www.ciklik.academy/en/expeditions/exporter-les-bons-de-livraison/ lang: en lastUpdated: 2026-10-09 --- # Export shipping slips > Box store > > This page applies to box stores hosted by Ciklik. Using the PrestaShop module? [See the PrestaShop documentation](https://www.ciklik.academy/en/prestashop/). The shipping slips export produces an Excel file (`.xlsx`) to send to your logistics provider or to import into your carrier’s tool. Ciklik does not send anything directly to carriers. ## Run an export 1. Go to **Sales > Shipments > Shipping Slips**. 2. Filter the slips to ship, usually with **Scheduled After** and **Scheduled Before** (see [Shipping slips management](https://www.ciklik.academy/en/expeditions/gestion-des-bons-de-livraison/#filter-shipping-slips)). 3. Check the slips, or select all the slips matching the filter. 4. Run the **Export Shipping Slips** action and choose the **Export format**. 5. Confirm. For one or two slips, the file downloads right away. Beyond that, the export is prepared in the background: the message “Merci de patienter. Votre export est en traitement” (shown in French) appears, then a “Votre fichier est prêt !” notification (file ready) appears in the notification bell, top right, with the download link. A slip has one row per item: an order with a plan and an addon gives two rows with the same slip number. ## The formats | Export format | Use | | --------------------------- | ------------------------------------------------------------ | | Export Shipping Slips | The standard format, the most complete. Selected by default. | | Export (Light) | The standard format without a few technical columns. | | Export Custom Subscriptions | One row per chosen product, to prepare customized boxes. | | Export Boxtal | Import into Boxtal. | | Export SendCloud | Import into SendCloud. | | Export Kinexya | File for the Kinexya logistics provider. | | SupplyWeb Export | Two-sheet file for SupplyWeb. | | Export Mondial Relay Format | Import into the Mondial Relay shipping tool. | | Export Shipping Bo | Import into Shipping Bo. | | Export Packlink | Reserved format, see the warning below. | ## Common columns Most formats include these columns, on top of their own: - `NUM_FACTURE_BL`: the slip number, starting with `ship_`. It is used to match a [tracking number](https://www.ciklik.academy/en/expeditions/liens-de-suivi-de-livraison/). - `FORMULE`: the identifier of the subscription’s plan. - `CUSTOMER_ID` and `SUBSCRIPTION`: the customer and subscription identifiers. - `SITE`: your site’s name. - `CREATED_AT` and `scheduled_at`: the slip’s creation and scheduling dates. - `BOX_NUMBER`: the number of slips already created for this subscription before this one. 0 for the first shipment. - `transporter`: the carrier’s name. - `abos_count`: the customer’s number of subscriptions. - `relay_id` and `relay`: the chosen pickup point, if any. - `orderable_name`, `orderable_id`, `orderable_type`: the item (plan, addon, product, offer) and its type. - `order_id`: the originating order. - `declinaisons`: the customer’s answers to the profile questions, separated by `|`. - `first_box`: flags a [First Box](https://www.ciklik.academy/en/expeditions/transporteurs/#first-box) slip. ## What each format contains ### Export Shipping Slips (standard) Columns: `id`, `NUM_FACTURE_BL`, `FORMULE`, `NOM`, `PRENOM`, `PATRONYME` (first and last name), `ADR1`, `ADR2`, `ADDR_FULL` (both address lines), `CP`, `STATE` (region), `VILLE`, `SOCIETE`, `CODE_PAYS`, `PAYS`, `MAIL`, `TEL_CLIENT`, `CUSTOMER_ID`, `SUBSCRIPTION`, `SITE`, `CREATED_AT`, `BOX_NUMBER`, `transporter`, `abos_count`, `relay_id`, `relay`, `quantity`, `orderable_name`, `orderable_id`, `orderable_type`, `order_id`, `scheduled_at`, `declinaisons`, `first_box`, `last_order`, `customization`, `order_state`, `ref`, `extra_customization`. Columns specific to this format: - `last_order`: the status of the subscription’s latest order. - `order_state`: the status of the slip’s originating order. - `customization`: the products chosen by the subscriber for a [customized box](https://www.ciklik.academy/en/abonnements/creer-une-box-personnalisee/), separated by `|`. - `extra_customization`: the [products added to this slip only](https://www.ciklik.academy/en/expeditions/ajouter-des-produits-supplementaires-sur-un-bon-de-livraison/). - `ref`: the item’s reference. ### Export (Light) Same information as the standard format, without `id`, `PATRONYME`, `ADDR_FULL`, `STATE`, `quantity`, `last_order`, `customization`, `order_state` or `extra_customization`. ### Export Custom Subscriptions One row per product of the customized box, with its reference (`SKU`) and quantity (`QTY`), followed by the customer’s details and the common columns. Products added to this slip only with the **Personnaliser ce BL (admin)** action are highlighted in orange. ### Export Boxtal Columns in the Boxtal import format: `Nom`, `Prenom`, `Societé`, `Adresse`, `Complement`, `Code postale`, `Ville`, `Pays format ISO`, `Etat`, `Telephone`, `Email`, `Code point relais livraison`, the parcel dimensions (`package_1_weight`, `package_1_length`, `package_1_width`, `package_1_height`, `package_1_value`), `external_reference` (the slip number), then the common columns. > First and last name swapped > > In this format, the `Nom` (last name) column contains the customer’s first name and the `Prenom` (first name) column their last name. The parcel weight and dimensions are empty (height 1, value 0): fill them in Boxtal. ### Export SendCloud Columns in the SendCloud import format: `Nom` (first and last name), `Societé`, `Numéro de la voie` (empty), `Adresse`, `Ville`, `Code postale`, `Code pays`, `Email`, then the standard format columns (`NOM`, `PRENOM`, `ADR1`, `ADR2`…). > Note > > The `Societé` (company) column of this format contains the address complement, not the company name. ### Export Kinexya Columns in the provider’s format: `declinaisons`, `ARTICLE` (item name, spaces replaced by hyphens), `QUANTITE`, `DATE CO`, `NOM`, `AD1 (35c)`, `AD2 (35c)`, `AD3 (35c)`, `VILLE (35c)`, `CODE POSTAL`, `PAYS`, `COMMANDE` (the slip number), `TRANSPORT` (the **Carrier code**), `relay`, `Commentaire Externe (50c)`, `TELEPHONE`, `Email`, `Code point relais livraison`, `Commentaire Interne (50c)`, then the common columns. ### SupplyWeb Export A file with two sheets: - **Clients**: `Numéro de commande` (the slip number), `Transporteur` (the **Carrier code**), `ID relais` (without the country prefix), `Raison sociale`, `Nom et Prénom`, `Adresse 1`, `Adresse 2`, `Téléphone portable`, `Ville`, `Code postal`, `Code pays`, `Email`, `Prix HT, sans frais de livraison`. - **Articles**: `Numéro de commande`, `declinaisons`, `ARTICLE`, `Quantité`, `Prix HT total avec réductions`, `SITE`, `BOX_NUMBER`, `abos_count`. Prices are those of the slip’s originating order, excluding tax and shipping. ### Export Mondial Relay Format Columns in the Mondial Relay import format: `Numéro Item`, `Numéro BL`, `Libelle Destinataire`, `Complement Nom`, `Adresse Ligne 1`, `Adresse Ligne 2`, `Ville Destinataire`, `Code Postal Destinataire`, `Code Pays Destinataire`, `Téléphone`, `TéléphoneBis`, `Email`, `Type de livraison MR`, `ID Point retrait Collecte`, `Code Pays Collecte`, `Type de livraison`, `ID Point retrait Livraison`, `Code Pays Livraison`, `Code Mode Livraison`, `Code Langue Destinataire`, `Nb de colis`, `Poids`, then the common columns. Fixed values: pickup point delivery (`R`), mode `24R` (Standard), collection country `FR`, one parcel, weight 0. The carrier’s **Relay Mode** (XL, XXL, Drive) is not copied: correct the `Code Mode Livraison` column if needed, and enter the weight in the Mondial Relay tool. ### Export Shipping Bo Columns in the Shipping Bo import format (`date`, `orderId`, `state`, `lineId`, `origin`, `originRef`, `sku`, `quantity`, `description`, `companyName`, `firstname`, `lastname`, `address1`, `address2`, `postcode`, `city`, `region`, `country`, `phone`, `email`, then the billing and amount columns, left empty). > Values to check before importing > > In this format, the `city` column contains the postcode, and the `tags` column is prefilled with “fragile,explosif”. The other fixed values are `state` set to `to_be_prepared`, `lineId` set to 1 and `origin` set to `abonnement`. Correct these columns before importing the file. ### Export Packlink > Reserved format > > This format was built for one specific shop. The sender columns (name, company, address, phone, email) and the parcel columns (title, value, dimensions, weight) are fixed and do not use your shop’s information. Do not use it: contact Ciklik support if you ship with Packlink. ## Shipping volume by carrier On the shipping slips list, the **Shipping Volume by Carrier** lens counts slips per carrier and per site, with their percentage. It filters by site, not by date, and can also be exported to Excel. ## See also [Shipping slips management](https://www.ciklik.academy/en/expeditions/gestion-des-bons-de-livraison/) [Delivery tracking links](https://www.ciklik.academy/en/expeditions/liens-de-suivi-de-livraison/) [Pickup points](https://www.ciklik.academy/en/expeditions/points-relais/) [Create a custom box](https://www.ciklik.academy/en/abonnements/creer-une-box-personnalisee/)