ExcelPort Products in Bulk Mode: Sheet Special
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.
Important
- Using this sheet is optional. ExcelPort will work even if this sheet is missing, as long as you have a sheet for Products.
- If this sheet is missing ExcelPort will not alter existing product specials. On the other hand, if this sheet exists and has no rows, all product specials (for products listed in the sheet Products) will be deleted!
- All columns must be present in the order specified below.
- Do not change/translate the names of the columns.
- Allowed names for this sheet: Special
Structure of the sheet
Here is a list of every column in the sheet Special.
To follow along, feel free to download an example file.
| Column Letter | Column Name | Extra Info | Allowed Values | Required |
|---|---|---|---|---|
| A | Product ID | The value here must correspond to column A from the Products sheet. | Integer number Minimum: -2147483647 Maximum: 2147483647 |
Yes |
| B | Customer Group | If the customer group does not already exist in your store, ExcelPort will not create it automatically. | A valid name of a Customer Group. See Meta sheet, column R for allowed values. | Yes |
| C | Priority | Integer number Minimum: -2147483647 Maximum: 2147483647 |
No | |
| D | Price | Decimal point must be a dot, not a comma. Example: 10.99 | Floating point number | No |
| E | Date Start | Example: 2017-01-31 | Date Format: yyyy-mm-dd |
No |
| F | Date End | Example: 2017-01-31 | Date Format: yyyy-mm-dd |
No |