Products in Bulk Mode: Sheet Products

Before you begin

This section describes the XLSX stucture for importing products in Bulk mode. Note that you may also use Basic mode, or Grouped mode.

Follow these guidelines to properly structure your product file. To follow along, feel free to download an example file.

Important
  • This sheet is required for Bulk mode 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: Product, Products
  • Maximum number of rows: 800. More info here

Structure of the sheet

Here is a list of every column in the sheet Products.

To follow along, feel free to download an example file.

Column Letter Column Name Extra Info Allowed Values Required
A Product ID If you have an existing product in your store with this Product ID, it will be overwritten. If left empty, the product will be imported as a new product, and it will be linked with any entries from the rest of the sheets (Attributes, Options, Discounts, etc.). Integer number
Minimum: -2147483647
Maximum: 2147483647		 (Conditional)*
B Name Make sure to always provide a value for this field. Text Yes
C Model This is a required field in the standard OpenCart admin panel. However, ExcelPort will allow you to import products without a model. Text (Conditional)*
D SKU Text No
E Description Text No
F Meta Tag Description Text No
G Meta Tag Keywords Text No
H Tags Entries must be comma-separated. Example: tag1, tag2, tag3 Text No
I UPC Text No
J EAN Text No
K JAN Text No
L ISBN Text No
M MPN Text No
N Price Decimal point must be a dot, not a comma. Example: 10.99 Floating point number No
O Location Text No
P Status Any value different than "Enabled" will disable the product. Enabled / Disabled No
Q Tax Class See Meta sheet, column A for allowed values. No
R Quantity Integer number
Minimum: -2147483647
Maximum: 2147483647		 No
S Minimum Quantity Integer number
Minimum: -2147483647
Maximum: 2147483647		 No
T Image If your image file is placed in image/catalog/product/theimage.JPEG, insert catalog/product/theimage.JPEG (case-sensitive) Image path, relative to your image/ directory. The field is case-sensitive. No
U Subtract Stock Any value different than "Yes" will be regarded as "No". Yes / No No
V Out Of Stock Status See Meta sheet, column C for allowed values. No
W Requires Shipping Any value different than "Yes" will be regarded as "No". Yes / No No
X SEO Keyword Text No
Y Date Available Example: 2017-01-31 Date
Format: yyyy-mm-dd		 No
Z Length Decimal point must be a dot, not a comma. Example: 10.15 Floating point number No
AA Width Decimal point must be a dot, not a comma. Example: 10.15 Floating point number No
AB Height Decimal point must be a dot, not a comma. Example: 10.15 Floating point number No
AC Length Class See Meta sheet, column D for allowed values. No
AD Weight Decimal point must be a dot, not a comma. Example: 10.15 Floating point number No
AE Weight Class See Meta sheet, column E for allowed values. No
AF Sort Order Integer number
Minimum: -2147483647
Maximum: 2147483647		 No
AG Reward Points Integer number
Minimum: -2147483647
Maximum: 2147483647		 No
AH Manufacturer See Meta sheet, column G for allowed values. No
AI Categories Comma-separated Category IDs. Example: 10,42 See Meta sheet, column H for allowed values. No
AJ Filters Comma-separated Filter IDs. Example: 10,42 See Meta sheet, column T for allowed values. No
AK Stores Comma-separated Store IDs. Example: 0,1,2. Note that the default store has Store ID = 0. If you leave this field without a value, the product will not be linked with any stores. See Meta sheet, column J for allowed values. No
AL Downloads Comma-separated Download IDs. Example: 10,42 See Meta sheet, column L for allowed values. No
AM Related Products Comma-separated Product IDs. Example: 10,42 Any existing Product ID in your store is allowed. No
AN Meta Title Not used in OpenCart 1.x. This is a required field in the standard OpenCart admin panel. However, ExcelPort will allow you to import products without a meta title. Text (Conditional)*
Note* (Conditional) fields accept empty values for the purposes of an ExcelPort import. There are cases when you might need a value for this field. More information in column Extra Info.