Orders CSV import

Looking to import your orders manually into the app? Read this article to learn how to do that using our CSV file importer.

In this article:

  1. How do I import an order CSV file into Bigblue?
  2. How do I create the perfect CSV import file 🚀?
  3. Common errors to avoid 🆘
  4. Can I use a CSV import to edit already existing orders?

1. How do I import an order CSV file into Bigblue?

  • Access the Orders tab
  • Hover over the thunderbolt at the top right corner
  • Select Import orders from CSV

  • Download the template available in the import page

  • Prepare your CSV file as explained in section 2
  • Click within the indicated area to upload your import file or simply drag and drop it in there
  • Once your file is uploaded, go through all the order pages that appear, one by one, to check for missing information or errors


    ⚠️ If there is any missing/flawed information, it will be highlighted in red.

 

2. How do I create the perfect CSV import file 🚀 ?

The details you provide for your orders affect their logistics, this why creating a perfect CSV import file is crucial! The more accurate and detailed the information you provide is, the better your orders will be handled. 

a) First things first

CSV stands for comma-separated values and is a file format (.csv) for spreadsheets. 

  • The simplest way to create a CSV file is to use a Microsoft Excel or Google Sheets spreadsheet.
  • Save your spreadsheet as a ".csv" file and make sure it's encoded in UTF-8.


    💡Read this guide for a step-by-step explanation of how to complete these two steps.

  • If you have a CSV file from another store or source, make sure it matches the CSV file format explained below.


    💡If the format doesn't match, an import error message will guide you through the necessary steps to fix it.

 

b) Guidelines for creating your CSV import file

  • The first row of your spreadsheet should include the headers, as specified in the Headers column below.


    💡See section 2c for an explanation about each header.

  • The following rows of the file must contain the data corresponding to the headers for each order.


    ⚠️ There must be  one row per order!

  • Each order data field needs to be properly formatted as per the specifications in the Order data format and Example columns below.
  • Columns must follow the right order, as indicated in the Column number column below.
  • If you are importing an order with multiple line items, only the LineItem data (columns 12 to 16) is changing. The other data fields must be identical between the different lines.

CSV fields format

Required
(☑︎) 
Headers Explanation Order data format
Example Column number
OrderExternalId Order external (not Bigblue) identification code String F12676FGFG 1
SubmitTime Time of order submission Time format: ISO 8601 or RFC 3339 2007-03-01T13:00:00Z 2
☑︎ OrderLanguage* Order recipient's language code ISO 639-1 language code ES 3
☑︎ OrderCurrency* Currency code for all the order's financial amounts 3-letter ISO 4217 code EUR 4
☑︎ OrderShippingPrice* Gross price charged for the shipping (displayed on the delivery note or invoice) Decimal number with a maximum of 2 digits precision (no comma) 45.12 or 45.1 or 45
Not accepted: 45,1
5
☑︎ OrderShippingTax* Tax value on the shipping price (displayed on the delivery note or invoice) Decimal number with a maximum of 2 digits precision (no comma) 4.51 or 4.5 or 4
Not accepted: 4,51
6
OrderAdditionalTax Additional tax amount to be applied to the total order amount Decimal number with a maximum of 2 digits precision (no comma) 1.51 or 1.5 or 1
Not accepted: 1,51
7
OrderAdditionalDiscount Additional discount to apply to the total order amount Decimal number with a maximum of 2 digits precision (no comma) 1.21 or 1.2 or 1
Not accepted: 1,21
8
ShipmentInsurance(Y/N) Ad valorem insurance Single character Y or N 9
Fulfillment-Warehouse Code of the warehouse the order is fulfilled from Warehouse code (the list of codes can be found in SettingsWarehouse) EU-FRA-001 10
Fulfillment-CarrierServiceCode Code of the carrier service to ship this order Carrier code (the list of codes can be found in the section 2d below) colissimo-international 11
Fulfillment-DateTime Date and time at which the fulfilment will be created, i.e. at which the order (or part of it) will be dispatched to the warehouse - Date at the RFC339 format → To convert a date to the right format, you may use this tool.
- If empty, the order will be held  
2019-03-01T12:30:00+00:00 12
☑︎ LineItem-ProductSKU* Bigblue product SKU SKUs should match Bigblue format BGBL-MODEL1-VAR0 13
☑︎ LineItem-Quantity* Quantity of this product in the order Integer 5 14
☑︎ LineItem-UnitPrice* Product's gross unit price Decimal number with a maximum of 2 digits precision (no comma) 45.12 or 45.1 or 45 Not accepted: 45,1 15
☑︎ LineItem-UnitTax* Product's gross unit tax Decimal number with a maximum of 2 digits precision (no comma) 4.51 or 4.5 or 45 Not accepted: 4,51 16
LineItem-TotalDiscount Discount applied on this line item Decimal number with a maximum of 2 digits precision (no comma) 1.21 or 1.2 or 1
Not accepted: 1,21
17
☑︎ ShippingAddress-FirstName* Order recipient's first name String (maximum 38 characters) John-Erik 18
☑︎ ShippingAddress-LastName* Order recipient's last name String (maximum 38 characters) Paul 19
ShippingAddress-Company Order recipient's company String (maximum 38 characters) Google inc. 20
☑︎ ShippingAddress-Email* Order recipient's email - will be used to communicate the order's info Email address johnerikp@gmail.com 21
ShippingAddress-Phone Order recipient's phone - used by the carrier for the communication with the recipient.
We recommend to always add the country identification code in front of the number (e.g. +33)
String (maximum 38 characters) +33601010101 22
☑︎ ShippingAddress-Line1* First line of address String (maximum 38 characters) 5, avenue du Maréchal 23
ShippingAddress-Line2 Second line of address String (maximum 38 characters) Résidence Soleil 24
ShippingAddress-Line3 Third line of address String (maximum 38 characters) Batiment B 25
ShippingAddress-Line4 Fourth line of address String (maximum 38 characters) Lieu-dit Le Ciel 26
☑︎ ShippingAddress-City* City of destination String (maximum 38 characters) Paris 27
☑︎ ShippingAddress-PostalCode* Postal code of destination String (maximum 12 characters) 75000 28
ShippingAddress-State State or province of destination String (maximum 38 characters) Ile de France 29
☑︎ ShippingAddress-CountryCode* Country code of destination ISO 3166-1 Alpha-2 country code FR 30
BillingAddress-FirstName [If empty, the shipping address will be used] First name of the billing person String (maximum 38 characters) John-Erik 31
BillingAddress-LastName [If empty, the shipping address will be used] Last name of the billing person String (maximum 38 characters) Paul 32
BillingAddress-Company [If empty, the shipping address will be used] Company of the billing person String (maximum 38 characters) Google inc. 33
BillingAddress-Email [If empty, the shipping address will be used] Email of the billing person Email address johnerikp@gmail.com 34
BillingAddress-Line1 [If empty, the shipping address will be used] First line of billing address String (maximum 38 characters) 5, avenue du Maréchal 35
BillingAddress-Line2 [If empty, the shipping address will be used] Second line of billing address String (maximum 38 characters) Résidence Soleil 36
BillingAddress-Line3 [If empty, the shipping address will be used] Third line of billing address String (maximum 38 characters) Batiment B 37
BillingAddress-Line4 [If empty, the shipping address will be used] Fourth line of billing address String (maximum 38 characters) Lieu-dit Le Ciel 38
BillingAddress-City [If empty, the shipping address will be used] Billing address city String (maximum 38 characters) Paris 39
BillingAddress-PostalCode [If empty, the shipping address will be used] Billing address postal code String (maximum 12 characters) 75000 40
BillingAddress-State
[If empty, the shipping address will be used] Billing address state or province String (maximum 38 characters) Ile de France 41
BillingAddress-CountryCode [If empty, the shipping address will be used] Billing address country code ISO 3166-1 Alpha-2 country code FR 42

 

c) Data fields explained

The definitions below aim to help you understand the meaning of the different order data fields:

  • An order is a commercial transaction of specific products realized on a selling channel.
  • The shipping address is the address the order's content is shipped to, namely the recipient's address.
  • The shipping price is the price displayed on the delivery note and invoice representing the charges to ship the content of an order, without tax.
  • The billing address is the address of the person that paid for the order. By default, the billing address is the same as the shipping address.
  • line item represents the invoice line for an order, namely:
    • a product
    • the product's number of units
    • the product's unit price
    • the product's unit tax for this line
    • the line item discounts
  • The order external ID is the order external identification code. On top of this, Bigblue automatically generates an ID to identify the order in our system.
  • Fulfillment refers to the process of preparing and shipping a customer’s order.
    • You can schedule the whole order for immediate fulfillment if both the fulfillment warehouse and carrier service code are provided for an order.
    • By default, a fulfillment is not held. Orders imported will be pushed to the warehouse 30 minutes after the import.
    • If you're looking for more fine-grained control over the fulfillment, it'll be available once you've created the order.

 

d) Carrier codes

☝️ Please note that carrier codes might differ slightly depending on the warehouse. Carrier codes for the warehouse you are using can be found in the Warehouse settings of the app (Logistics > Warehouse), under Shipping Zones, at the bottom of the page.

Carrier service Area Code Description
Chronopost 13 France chronopost-13 Next-day delivery, before 1.00pm, in France
Colis Privé Tracked France colisprive-tracked 48-72h home delivery in France | no signature
Colissimo Access France, Overseas colissimo-access 48-72h home delivery in France | no signature
Colis Privé Tracked with Signature France colisprive-tracked-signature 48-72h home delivery in France | with signature
Colissimo Expert France, Overseas colissimo-expert 48-72h home delivery in France | with signature
Coliéco France laposte-colieco-ads 3-6 days in France | economic, no signature, tracking not guaranteed
Geodis Messagerie Plus France geodis-messagerie-plus French B2B LTL Service
Mondial Relay France, Europe mondialrelay-relaisl Pickup point delivery service in France, Belgium, Luxembourg, Spain
Geodis Express France geodis-express French B2B Express LTL Service
DPD Classic B2B France dpd-classic-b2b French B2B Multi-Parcel Service
Rapid Métropole Ile de France rapidmetropole-paris B2B same-day delivery to Paris & suburbs
B2C Europe Europe b2ceurope-ads 3-7 days home delivery in Europe
BPost Belgium bpost-ads 48h home delivery to Belgium | no signature
Chronopost Europe Europe chronopost-europe International shipments through DPD network | 2 to 5 days
Colissimo International Europe, Rest of the World colissimo-international International Shipments through postal networks | 3 to 8 days
Delivengo (not tracked) Europe, Rest of the World laposte-delivengo International Shipments for small packages (less than 2kg and less than 90cm of circumference) | No tracking
DHL Express Europe, Rest of the World dhl-express Worldwide express shipment
UPS Standard France, Europe ups-standard 2-day delivery
UPS Express Saver France, Overseas France, Europe, Rest of the World ups-saver Worldwide express shipment, next-day delivery

Carrier codes by area

France

chronopost-13, colissimo-access, colisprive-tracked, dpd-classic-b2b, rapidmetropole-paris, ups-standard, ups-saver

Overseas France

colissimo-access, dhl-express, ups-saver

Europe

bpost-ads, b2ceurope-ads, chronopost-europe, colissimo-international, dhl-eco, dhl-express, laposte-delivengo, ups-standard, ups-saver

Rest of World

colissimo-international, dhl-express, laposte-delivengo, ups-saver

 

3. Common errors to avoid 🆘

Before uploading your CSV into the app, make sure you have checked that:

  • All your decimal separators are "." (dots) and not "," (commas)
  • Make sure there are no discrepancies in the data among different line items of the same order
  • Check that you've entered a fulfillment date for each order
  • Postal code formats should respect national format standards
  • All your Bigblue SKUs have the following format "XXXX-XXXXXX-XXXX", with the first 4 characters corresponding to your quadri

 

4. Can I use a CSV import to edit already existing orders?

  • To avoid bulk mistakes, it is not possible to edit orders by importing a CSV that includes already existing orders.
  • Modifications of already existing orders can be made manually in the Orders tab.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us