Products in Bulk Mode: Sheet Meta

Important

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
G Manufacturers All Manufacturers
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
S Layouts All Layouts
T,U Filters All Filter IDs and their corresponding Filter Names
V,W Profiles All Profile IDs and their corresponding Profile Names