ExcelPort Customers: Sheet Addresses
Before you begin
This section describes the XLSX stucture for importing customer addresses.
Follow these guidelines to properly structure your customer file. To follow along, feel free to download an example file.
Important
- This sheet is required for Customer import.
- All columns must be present in the order specified below.
- Do not change/translate the names of the columns.
- Allowed names for this sheet: Addresses
Structure of the sheet
Here is a list of every column in the sheet Addresses.
To follow along, feel free to download an example file.
| Column Letter | Column Name | Extra Info | Allowed Values | Required |
|---|---|---|---|---|
| A | Customer ID | This field is mandatory. | A valid Customer ID. See Customers sheet, column A for allowed values. Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes |
| B | Address ID | This field is mandatory. | Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes |
| C | Address First Name | This field is mandatory. | Text | Yes |
| D | Address Last Name | Text | No | |
| E | Address Company | Text | No | |
| F | Address Company ID | Used in OpenCart 1.5.3 - OpenCart 1.5.6.4 | Text | No |
| G | Address Tax ID | Used in OpenCart 1.5.3 - OpenCart 1.5.6.4 | Text | No |
| H | Address 1 | Text | No | |
| I | Address 2 | Text | No | |
| J | Address City | Text | No | |
| K | Address Postcode | Text | No | |
| L | Address Country | A valid OpenCart country name. For a full list of your countries, visit Admin > System > Localisation > Countries | No | |
| M | Address Zone | A valid OpenCart zone name. For a full list of your zones, visit Admin > System > Localisation > Zones | No | |
| N | Custom Field | Not used in OpenCart 1.5.x | JSON-encoded custom field array. | No |