Manufacturers: Sheet Manufacturers

Before you begin

This section describes the XLSX stucture for importing manufacturers.

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

Important
  • This sheet is required for Manufacturers import.
  • All columns must be present in the sequence specified below.
  • Do not change/translate the names of the columns.
  • Allowed names for this sheet: Manufacturers

Spreadsheet structure

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

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

Column Letter Column Name Extra Info Allowed Values Required
A Manufacturer ID If you have an existing manufacturer in your store with this Manufacturer ID, it will be overwritten. If left empty, the manufacturer will be imported as a new manufacturer. Integer number
Minimum: -2147483647
Maximum: 2147483647
(Conditional)*
B Manufacturer Name Text Yes
C Stores Comma-separated Store ID's. 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
D SEO Keyword Text No
E Image If your image file is placed in image/catalog/manufacturer/theimage.JPEG, insert catalog/manufacturer/theimage.JPEG (case-sensitive) Image path, relative to your image/ directory. The field is case-sensitive. No
F Sort Order Integer number
Minimum: -2147483647
Maximum: 2147483647
No
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.