Column mappings
In a nutshell, column mappings section defines the structure of the file that will be exported, and what data will be contained in the file
Last updated
In a nutshell, column mappings section defines the structure of the file that will be exported, and what data will be contained in the file
In column mappings you create a record for every column that your export file will contain. In this record you have to spefily following parameters.
This field defines the entity that value will be taken from. In a nutshell, entity is a classification of values.
Among long list of entities that are supported by our plugin, the main are:
Order (has fields about customer Info, payment info, taxes, discounts, etc.)
OrderItem (has info about item in the order)
Billing address/Shipping address
Product (has all information about product: name, SKU, etc.)
Vendor/Store/Warehouse
If you have multiple items in one order, and you are exporting as CSV or XLSX, a separate line will be created for every item in that order.
There is also entity called Static field. It will just print a constant value to this column.
After selecting Entity, you need to select column source. This is the exact value that will be exported.
For example, in entity Order you can find column source Order #. If you select this column source, after export there will be a column containing order number.
This is the name of the column in your exported file.
This value defines the order of columns in your export file.
Last updated