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.

Data format

• Bold if required for order import
• Underlined if required for fulfillment creation

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.
• A 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

• Go to Settings > Warehouses
• Warehouse codes are directly displayed

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