Import Order Line Items via CSV
Creating a manual order with multiple SKUs? You can import thse references through a CSV.
1) How to import your order line items via CSV
1) How to import your order line items via CSV
In the order creation page
- Click on the Import from CSV button and import your CSV
- You can download the template from the tooltip
Template
| ProductSKU | Quantity | UnitPrice | UnitTax | TotalDiscount |
Requirements
| Column Name | Required | Description | Example |
|---|---|---|---|
| ProductSKU | ☑ | Bigblue Product SKU (String) |
BGBL-MODEL1-VAR0 |
| Quantity | ☑ | Quantity of this product in the order (Integert) | 12 |
| UnitPrice | - *💡 If you let this field empty or put a negative value, it will be automatically filled by the corresponding product value in Bigblue |
Product gross unit price | 45 or 45.2 or 45,2 |
| UnitTax | - | Product gross unit tax | 5 or 5.7 or 5.7 |
| TotalDiscount | - | Discount applied on this line item | 1 or 1.2 or 1,2 |
- Upload your CSV
- Click on OK in the modal
You're all set 🎉
Review the quantities and prices and complete your order!
2) Need help to build a CSV?
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.
3. Common errors to avoid 🆘
Before uploading your CSV into the app, make sure you have checked that:
- All your Bigblue SKUs have the following format "ABCD-XXXXXX-XXXX", with the first 4 characters corresponding to your quadri
- All the required fields aren't empty
If your CSV has errors, an error message will explain what needs to be fixed. 😊
Through this CSV import, we help you same time when you need to import multiple line items in an order. Save precious time with Bigblue ⏱