Export shipping slips

Box store

This page applies to box stores hosted by Ciklik. Using the PrestaShop module? See the PrestaShop documentation.

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).

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.
• 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 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, separated by |.
• extra_customization: the products added to this slip only.
• 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

Delivery tracking links

Pickup points

Create a custom box