ExcelPort 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
Structure of the sheet
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 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 |
| 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.