Documentation is being updated for the upcoming Gridbox 3 release. Some sections may be incomplete.

How to import orders in Gridbox Joomla eCommerce using CSV file?




With the built-in CSV Order Import tool, you can migrate orders from third-party eCommerce platforms to Joomla eCommerce for Gridbox. This tutorial will show you how to import orders using the CSV file.

  • We strongly recommend creating a store backup before importing a CSV file.

Gridbox CSV file format. Standards and requirements


Sample CSV Files: Download CSV.

  • The column names in the CSV file are the data synchronisation identifier. The column data will not be imported if you change the column name.

Fields

View Details

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:

  • 2023-10-26
  • 2023-07-19

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:

  • Size / S
  • Size / M
  • Color / Blue
  • Color / Black

Optional

Variation

Product variations. Values must be separated by a slash "/". For example:

  • S / Blue
  • S / Black
  • M / Blue
  • M / Black

Optional

Extra options

Extra product options. Values must be separated by a slash "/". For example:

  • Color / Blue
  • Color / Black

Optional

Min. Qty

Minimum quantity of products that can be ordered. The field supports only the numeric format without separators. For example:

  • 1
  • 5
  • 10

Optional

Price

Product price. The field doesn't include any currency symbols. For example:

  • 10
  • 15.55

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

Email

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:

  • 10
  • 15.55

Optional

Discount

Discount amount. The field doesn't include any currency symbols. For example:

  • 0.75
  • 10
  • 15.55

Optional

Shipping price

Shipping price. The field doesn't include any currency symbols. For example:

  • 10
  • 15.55

Optional

Tax

The value of the tax rate. The field doesn't include any currency symbols. For example:

  • 10
  • 15.55

Optional

Total

Cart total. The field doesn't include any currency symbols. For example:

  • 0.75
  • 10
  • 15.55

Optional

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

Import CSV file


1. In the Gridbox dashboard, mouse over the icon Store App ➝ Orders.

2. Click the More Actions button​ ➝  Import CSV.



Importing Gridbox CSV File


Importing a 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:

  • Create store backup before import
  • Overwrite products with the same ID

4. Click the button Import.



Importing 3rd party CSV file


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.

  • If you made a mistake in the file, you will see a notice in the opened modal window: "Invalid date format". Correct the errors and re-upload the CSV file

Related articles