Orders: Sheet Meta

Important

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

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 IDs and their corresponding Store Names
C,D	Customer Groups	All Customer Group IDs and their corresponding Customer Group Names
E	Countries	All available countries in your store
F,G	Order Statuses	All available Order Status IDs and their corresponding Order Status Names
H,I	Affiliates	All Affiliate IDs and their corresponding Affiliate Names
J,K	Languages	All Language IDs and their corresponding Language Names
L,M	Cirrencies	All Cirrency IDs and their corresponding Cirrency Codes
N,O	Shipping Methods	The shipping method names and codes. These are not all possible values. This list is based on your existing store orders.
P,Q	Payment Methods	The payment method names and codes. These are not all possible values. This list is based on your existing store orders.