Import orders via CSV

To import orders into Bigblue, on top of connecting your sales channels for an automatic order import, you can also manually import orders. Even better, our AI assists you so that your file can be effortlessly transformed into fulfillments.


Import an order CSV file into Bigblue

Requirements and tips for your CSV file

Preventing common mistakes

Frequent questions


Import an order CSV file into Bigblue

  • Go to the Orders tab
  • Click Create order on top right of the page
  • Select Import orders

  • Ensure that your CSV file matches all the requirements
  • Click Select a CSV file to import or drag and drop your file

First, our AI matches your columns with the required information.

  • If all information could be matched, check the results and click Confirm columns
  • If some information couldn't be matched, a red message indicates that you have to manually match your columns with the required information

    • For each required field, click the No match message to fix the matching

    • In the modal, either select a column from your file to extract the data from, or enter a value that will be applied to all lines of the CSV file

    • Once all the matchings are done, click Confirm columns

Then, our AI validates your content.

  • If all your content could be validated, ensure the orders are correct and click Confirm orders
  • If some issues were detected, fix them and click Upload corrected file

    • If some required data is empty, add it in your file and ensure the column is fully filled
    • If some data is too long or too short, review it and adjust it
    • If some data is incorrect, adjust it according to the instructions or the requirements

Requirements and tips for your CSV file

The information provided for your orders has a great impact on their logistics, which is a properly detailed file is strongly recommended for a seamless order import and management.

What is a CSV file?

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

  • You can create a CSV file from Microsoft Excel or Google Sheets.
  • Save your spreadsheet as a ".csv" file and ensure it's encoded in UTF-8.

    💡 This guide provides a step-by-step explanation for these two steps.

  • Your CSV file can also be an export from another store or source.

    💡 In any case, ensure that the data matches your needs — see below.

Requirements

  • The first row should be headers, for example: Order External ID, Product SKU, Quantity...
  • The following rows should be the corresponding order data.
  • Orders with multiple line items should have one row per order line item, and only the line item data should change, all the other fields should be identical in each line.
  • Each order data input to import into Bigblue should be properly formatted as per the table below.

Tips

  • You can download an import file template at the bottom of the Import orders menu (or here).
  • The fulfillment creation is optional, meaning that you can import orders without creating the corresponding fulfillments. In that case, your orders won't be sent to the warehouse until you manually fulfill them from each order page.

To create both the orders and their fulfillments, ensure that the optional fields Fulfillment Warehouse, Shipping Method Code and Fulfillment Date Time are properly filled and formatted as per the table below.

Data format

  • Bold if required for order import
  • Underlined if required for fulfillment creation
Possible header Content Format Example
Order External ID Order ID from your system String F12676FGFG
Submit Time Order submission time ISO 8601 or RFC 3339 2021-08-03T13:00:00Z
Order Language Order recipient's language code ISO 639-1 (2 letters) ES
Order Currency Currency code for all the order's financial amounts ISO 4217 code (3 letters) EUR
Order Shipping Price Gross price charged for the shipping Decimal number, dot-separated, max 2 digits after the dot

45.12 or 45.1 or 45

Invalid: 45,1

Order Shipping Tax Tax value on the shipping price Decimal number, dot-separated, max 2 digits after the dot

4.51 or 4.5 or 4

Invalid: 4,51

Order Additional Tax Additional tax amount to apply to the total order amount Decimal number, dot-separated, max 2 digits after the dot

1.51 or 1.5 or 1

Invalid: 1,51

Order Additional Discount Additional discount to apply to the total order amount Decimal number, dot-separated, max 2 digits after the dot

1.21 or 1.2 or 1

Invalid: 1,21

Shipment Insurance Activate ad valorem insurance or not Single character Y or N
Fulfillment Warehouse Code of the fulfillment warehouse Warehouse code EU-FRA-001
Shipping Method Code Code of the shipping method for the fulfillment Shipping method code colissimo-international
Fulfillment Date Time Date and time for fulfillment transmission to the warehouse

RFC 3339

If empty, fulfillment is put on hold

2021-08-03T13:00:00Z
Product SKU Product or bundle to add to the order Bigblue SKU format or Merchant SKU format BGBL-MODEL1-VAR0
Quantity Quantity of the product in the order Integer 5
Unit Price Product's gross unit price Decimal number, dot-separated, max 2 digits after the dot

45.12 or 45.1 or 45

Invalid: 45,1

Unit Tax Product's gross unit tax Decimal number, dot-separated, max 2 digits after the dot

4.51 or 4.5 or 45

Invalid: 4,51

Total Discount Discount applied on the line item Decimal number, dot-separated, max 2 digits after the dot

1.21 or 1.2 or 1

Invalid: 1,21

Shipping Address - First Name Recipient's first name String, max 38 characters John-Erik
Shipping Address - Last Name Recipient's last name String, max 38 characters Paul
Shipping Address - Company Recipient's company String, max 38 characters Google inc.
Shipping Address - Email Recipient's email Email address johnerikp@gmail.com
Shipping Address - Phone Recipient's phone number, used by the carrier for the delivery

String, max 38 characters

Tip: start with the country dialing code (e.g. +33)

+33601010101
Shipping Address - Line1 1st line of address String, max 38 characters 5, avenue du Maréchal
Shipping Address - Line2 2nd line of address String, max 38 characters Résidence Soleil
Shipping Address - Line3 3rd line of address String, max 38 characters Batiment B
Shipping Address - Line4 4th line of address String, max 38 characters Lieu-dit Le Ciel
Shipping Address - City City of destination String, max 38 characters Paris
Shipping Address - Postal Code Postal code of destination String, max 12 characters 75000
Shipping Address - State State or province of destination String, max 38 characters Ile de France
Shipping Address - Country Code Country code of destination ISO 3166-1 Alpha-2 FR
Billing Address - First Name Billing person's first name

String, max 38 characters

If empty, shipping data is used

John-Erik
Billing Address - Last Name Billing person's last name

String, max 38 characters

If empty, shipping data is used

Paul
Billing Address - Company Billing person's company

String, max 38 characters

If empty, shipping data is used

Google inc.
Billing Address - Email Billing person's email

Email address

If empty, shipping data is used

johnerikp@gmail.com
Billing Address - Line1 1st line of billing address

String, max 38 characters

If empty, shipping data is used

5, avenue du Maréchal
Billing Address - Line2 2nd line of billing address

String, max 38 characters

If empty, shipping data is used

Résidence Soleil
Billing Address - Line3 3rd line of billing address

String, max 38 characters

If empty, shipping data is used

Batiment B
Billing Address - Line4 4th line of billing address

String, max 38 characters

If empty, shipping data is used

Lieu-dit Le Ciel
Billing Address - City Billing address city

String, max 38 characters

If empty, shipping data is used

Paris
Billing Address - Postal Code Billing address postal code

String, max 38 characters

If empty, shipping data is used

75000
Billing Address - State Billing address state or province

String, max 38 characters

If empty, shipping data is used

Ile de France
Billing Address - Country Code Billing address country code

ISO 3166-1 Alpha-2

If empty, shipping data is used

FR

Some definitions

  • An order is a commercial transaction of specific products realised on a selling channel.
  • The shipping address is the expected recipient's address.
  • The shipping price corresponds to the charges to ship the order line items, without taxes.
  • The billing address is the address of the person who paid for the order.
  • line item includes a product, its quantity, its unit price, its unit tax and the total discount.
  • The order external ID is the identification code outside of Bigblue.
  • The fulfillment refers to the process of preparing and shipping line items, it includes at least a warehouse, a shipping method and a date time for transmission the warehouse.

Find the Warehouse Code or the Shipping Method Code

  • Open the desired warehouse's details
  • Shipping method codes are displayed at the bottom, in the Shipping Zones section

    💡 Shipping method codes can vary from one warehouse to another

Preventing common mistakes

  • Columns with the required data should be fully filled.
  • Decimal separators should be dots and not commas.
  • For one same order, all the data (appart for line item data) should be identical.
  • Ensure that all the necessary information for fulfillment creation is correct.
  • Postal codes should match national format standards.

Frequent questions

☝🏾 Where is it possible to find the warehouse codes and shipping method codes?

Kindly refer to this section.

☝🏿 Can I import my orders and create their fulfillments all at once?

Yes, it is possible to import orders and create fulfillments during the order import. To do so, ensure that the optional fields Fulfillment Warehouse, Shipping Method Code and Fulfillment Date Time are properly filled.

☝🏼 Orders have been imported but the fulfillments have not been created, what can I do?

You can either fulfill them manually one by one from the Orders tab or reach out to our Care Team — kindly provide a file with two columns: the orders to fulfill and the shipping method to be used.

☝🏽 Is it possible to use a CSV import to edit existing Bigblue orders?

To avoid bulk mistakes, it is not possible to edit orders by importing a CSV with already existing orders. Existing orders can be manually edited 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