Sales Report
Export your complete sales dataset for advanced analysis, spreadsheet modeling, or database integration.
The sales export feature allows you to extract comprehensive sales records for offline analysis, reporting, or external system integration. While the export structure may appear complex initially, its dimensional design provides maximum flexibility for handling complex multi-platform order data.
Export Configuration and Generation
You can export either your complete sales dataset or a filtered subset based on specific criteria.
- Dataset Filtering: To export a partial dataset, apply predefined filter lists using set logic as explained in the Command Filters Guide.
- Initiating the Export: Navigate to the sales orders list view, locate the Export Orders action button near the search bar, and configure your export scope in the modal window. Leaving the parameters blank will export the entire dataset by default.
- File Format: The generated file is delivered in standard CSV format for universal compatibility.
Core Structure
Each row in the CSV represents a master Talk2sync Sales Order, while columns represent individual order attributes replicated across active sales channels.
- Multi-Connection Scaling: Attribute columns repeat sequentially for each active sales channel. If your account has $4$ active connections, the total column count equals $\text{number of fields} \times 4$.
- Data Alignment: Rows correspond to sales orders, while columns extend horizontally per connection.
- Sparse Data Handling: If an order lacks an equivalence on a specific connection, the corresponding attribute cells remain blank.
Metadata Columns
Auxiliary metadata columns located on the left side of the CSV provide structural context and platform existence flags.
- t2s ID: The unique identifier representing an order within Talk2sync. You can access the graphical interface directly via
[https://app.talk2sync.com/order/](https://app.talk2sync.com/order/){t2s_id}. - Existence Flags: Boolean indicators (
1or0) showing whether an equivalence exists on a specific connection. Missing equivalences result in blank cells.
Sync State Metadata Columns
The rightmost columns of the CSV report the real-time synchronization status for each attribute per connection. Talk2sync utilizes four distinct sync states:
- A (Green): Pending creation.
- H (Head): Fully synchronized.
- M (Yellow): Pending update.
- D (Red): Pending deletion.
For more details on color-coded states, refer to the Colors Documentation.
Next Steps
- Review filter usage in the Command Filters Guide.
- Learn about sync indicators in the Colors Documentation.