Categories: Sheet Meta
Using this sheet is optional. ExcelPort will work even if this sheet is missing, as long as you have a sheet for Categories.
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 Filter IDs, Store IDs, Layout IDs (and more) when populating your XLSX files.
Structure of the sheet
Here is a list of every column in the sheet Meta.
To follow along, feel free to download an example file.
|Column Letter||Column Name||Extra Info|
|A||Yes/No||Yes / No texts|
|B||Statuses||Enabled / Disabled texts|
|C,D||Stores||All Store IDs and their corresponding Store Names|
|E,F||Layouts||All Layout IDs and their corresponding Layout Names|
|G,H||Filters||All Filter IDs and their corresponding Filter Names|