Export mode

 

 

Export each specific product/service specification (SKU) in the order as a separate row of data. When an order contains multiple different specifications, it will be split into multiple rows.

When you need to analyzespecific resources(such as specific room types, cabin classes, ticket types, and additional services) for sales performance, inventory utilization, or conduct detailed accounting at the supplier/product level.

Count the number of bookings for each room type at a hotel on a specific date, calculate the ticket revenue for local and non-local tourists separately, and verify the settlement cost of each individual product.

Export the entire package as a single row of data. All product/service specification information included in the package will be aggregated within this row (usually listed through specific fields or by merging and calculating key values).

When you need to analyze or process packages as a whole , this is the most commonly used and comprehensive order view.

 

Conduct financial reconciliation at the order level (total amount, payment status), view overall sales trends (number of orders, total sales), evaluate customer ordering behavior (average order amount), enable customer service to quickly query the full picture of orders, and generate an order transaction list for archiving.

Export the entire order as a single row of data, but only include the most core summary information, omitting the details of specific products/services within the order. Usually only key fields such as order number, customer information, total amount, date, and status are retained.

When you only need to quickly understand the key overview information of an order, without the need for detailed item details, and are pursuing higher processing speed and smaller file size.

 

For example, senior management can view daily/weekly sales bulletins (total number of orders, total revenue), conduct preliminary batch checks on order status (such as exporting all "pending payment" order numbers), and perform macro statistics on the number of customer orders.