Export of Product Variants by Orders

The product variant export tool is designed to obtain "raw" data about order products in the form of a table suitable for further processing.

To navigate to the working area of the Orders section in the system menu of the portal, go to Store and Catalog () ➔ Orders.

Note: Export of any entities related to the order is available to users with access: OMS Manager, Company Manager.

Export of Product Variants

1. Go to the working section Orders.
   

Note: Existing orders are displayed in the working area of the Orders section as a list, sorted by the last modification.

2. To export product variants by orders, click Export, then click Export Product Variants by Orders.
   

Note: When exporting product variants from a child tenant, the products of orders created in that tenant are exported. When exporting product variants from the parent tenant, the products of orders created in the corresponding child tenants are exported.

3. After downloading the export file, save the file in the desired location, open the file in a convenient format for work, and process the product data.
   

Note: The file format when exporting from the system is: *.csv. The file format for editing data is *.excel in an application that supports format conversion: .csv ➔ .excel.

Structure of the Product Variants Export File by Orders

The export file represents a data structure and describes product variants by orders in the OMS system database in the form of a table.

Each record in the table describes one product variant concerning the order. The first record of the table contains the names of the attributes (fields) of the table. The names of the table fields are tied to the OMS system database.

Field Name	Description
order_id	Unique identifier of the order in the OMS system database
product_variant_id	Unique identifier of the product variant in the PIM system database
name	Name of the product variant
quantity	Quantity of the product in the order
currency_id	Unique identifier of the currency in the PIM system
currency	Currency of the dealer price
price	Dealer price per unit of the product in the currency of the dealer price
created_at	Order creation date in the format: YYYY-MM-DD HH:MM:SS, where: YYYY — year (4 digits); MM — month (2 digits, from 01 to 12); DD — day of the month (2 digits, from 01 to 31); T — separator between date and time (the letter T is a mandatory marker); HH — hours in 24-hour format (2 digits, from 00 to 23); MM — minutes (2 digits, from 00 to 59); SS — seconds (2 digits, from 00 to 59)
updated_at	Last update date of the order in the format: YYYY-MM-DD HH:MM:SS, where: YYYY — year (4 digits); MM — month (2 digits, from 01 to 12); DD — day of the month (2 digits, from 01 to 31); T — separator between date and time (the letter T is a mandatory marker); HH — hours in 24-hour format (2 digits, from 00 to 23); MM — minutes (2 digits, from 00 to 59); SS — seconds (2 digits, from 00 to 59)