Options: Sheet Meta
Using this sheet is not obligatory. ExcelPort will work even if this sheet is missing, as long as you have a sheet for Options.
This sheet is not regarded during import. Deleting this will not impact the import process in any way.
The Meta sheet is useful for two primary purposes:
- Data Validation: This is where Excel pulls the available values when validating your data. More information on data validation here.
- User reference: For finding the appropriate option type names.
Structure of the sheet
To follow along, feel free to download an example file.
|Column Letter||Column Name||Extra Info|
|A||Option Types||All available option types. For a default OpenCart these are:
Select / Radio / Checkbox / Image / Text / Textarea / File / Date / Time / Date and Time