Products in Bulk Mode: Sheet Meta
Using this sheet is optional. ExcelPort will work even if this sheet is missing, as long as you have a sheet for Products.
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 Category IDs, Store IDs, allowed Attribute values (and many 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||Tax Classes||All available Tax Classes|
|B||Yes/No||Yes / No texts|
|C||Stock Statuses||All available Stock Statuses|
|D||Length Classes||All available Length Classes|
|E||Weight Classes||All available Weight Classes|
|F||Statuses||Enabled / Disabled texts|
|H,I||Categories||All Category IDs and their corresponding Category Names|
|J,K||Stores||All Store IDs and their corresponding Store Names|
|L,M||Downloads||All Download IDs and their corresponding Download Names|
|N||Attributes||All pairs of Attribute Group > Attribute Name|
|O||Options||All Option Names|
|P||Required||"Required: Yes" and "Required: No" texts|
|Q,R||Customer Groups||All Customer Group IDs and their corresponding Customer Group Names|
|T,U||Filters||All Filter IDs and their corresponding Filter Names|
|V,W||Profiles||All Profile IDs and their corresponding Profile Names|