With the built-in CSV Order Import and Export tool, you can migrate orders from third-party eCommerce platforms to Gridbox Store App. This tutorial will show you how to import or export orders using the CSV file.
Sample CSV File: Download CSV.
Column |
Description |
Required |
|---|---|---|
ID |
Order ID. Must be unique. If the value is empty, the order ID will be assigned automatically. |
Yes |
Date |
The date must be entered in the format: year – month – day (YMD). For example:
|
Yes |
Status |
Order status. |
Optional |
SKU |
Product SKU. |
Optional |
Title |
Product title. If this value is empty, the product will be named Product_ID. |
Yes |
Product Type |
Product, Option, Variation, Extra Options, Digital Product, Subscription. |
Optional |
Option |
Product options. Values must be separated by a slash "/". For example:
|
Optional |
Variation |
Product variations. Values must be separated by a slash "/". For example:
|
Optional |
Extra Options |
Extra product options. Values must be separated by a slash "/". For example:
|
Optional |
Min. Qty |
Minimum quantity of products that can be ordered. The field supports only the numeric format without separators. For example:
|
Optional |
Price |
Product price. The field doesn't include any currency symbols. For example:
|
Optional |
Payment Method |
The name of the payment method. |
Optional |
Shipping Method |
The name of the shipping method. |
Optional |
Branch |
Branch shipping. |
Optional |
Coupon Code |
Coupon code that provides a discount. |
Optional |
User |
Username. |
Optional |
Store email from Contact Info of Store Settings. |
Optional |
|
First Name |
First name of the customer. |
Optional |
Subtotal |
Cart subtotal. The field doesn't include any currency symbols. For example:
|
Optional |
Discount |
Discount amount. The field doesn't include any currency symbols. For example:
|
Optional |
Shipping Price |
Shipping price. The field doesn't include any currency symbols. For example:
|
Optional |
Tax |
The value of the tax rate. The field doesn't include any currency symbols. For example:
|
Optional |
Total |
Cart total. The field doesn't include any currency symbols. For example:
|
Optional |
NOTE! If you enter a value for Option or Extra Option that does not exist, the field will be blank. Therefore, previously create Options and Extra Options that you need in the Gridbox Store App.
1. In the Gridbox dashboard, mouse over the icon Store App ➝ Orders.
2. Click the button Import/Export CSV.
Importing Gridbox CSV File is a method for uploading a previously exported Gridbox CSV file. This method is suitable for bulk creation or editing of existing Gridbox orders.
1. Choose Gridbox CSV File from the dropdown list.
2. Select a CSV file.
3. Click on the checkbox in the fields as needed:
4. Click the button Import.
Importing 3rd Party CSV File is a method for uploading a CSV file from 3rd-party eCommerce extensions and platforms to the Gridbox Store App. To import a 3rd-party CSV file, you need to match the fields of your file with the existing fields in the Gridbox Store App.
1. Choose Match Fields from the dropdown list.
2. Select a CSV file.
3. Click on the checkbox in the fields as needed:
4. Click the button Next.
5. Match fields from the uploaded CSV file and click the button Next.
1. In the Gridbox dashboard, mouse over the icon Store App ➝ Orders.
2. Click the button Import/Export CSV ➝ tab Export.
3. Uncheck the fields that are not used in the CSV file.
4. Click the button Export.
To export some orders, select the orders ➝ click the Import/Export CSV button ➝ repeat steps above.
Select the date range ➝ select all orders ➝ click the Import/Export CSV button ➝ repeat steps above.