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

Spreadsheet structure

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 For OpenCart 2.0.0.0 - 2.0.3.1:
Serialized custom field array.

For OpenCart 2.1.0.1+:
JSON-encoded custom field array.
No