Orders: Sheet Meta


Using this sheet is optional. ExcelPort will work even if this sheet is missing, as long as you have sheets for Orders, Order Products, Order Options, Order Downloads, Order Totals, Order Histories and Order Vouchers.

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 Store ID's, Customer Group ID's, Countries, Order Statuses (and others) when populating your XLSX files.

Spreadsheet structure

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,B Stores All Store ID's and their corresponding Store Names
C,D Customer Groups All Customer Group ID's and their corresponding Customer Group Names
E Countries All available countries in your store
F,G Order Statuses All available Order Status ID's and their corresponding Order Status Names
H,I Affiliates All Affiliate ID's and their corresponding Affiliate Names
J,K Languages All Language ID's and their corresponding Language Names
L,M Cirrencies All Cirrency ID's and their corresponding Cirrency Codes