Contents
How to Generate a Sales Report in OMS
Understanding Sales Report Sections
Best Practices for Sales Report Analysis
Introduction
Sales reports are crucial for tracking performance, identifying trends, and optimizing your e-commerce operations. This guide explains how to generate sales reports in OMS OMS and understand key metrics.
How to Generate a Sales Report in OMS
Step-by-Step Process
- Log in to your OMS account.
- Navigate to the Reports tab in the left panel.
- Click "Generate Reports" > "Create New."
- In the pop-up window:
- Select the Report Type (Sales, Order List, or Order Details).
- Choose between Order Date or In Transit Date.
- Set the date range for the report.
- Click "Generate Report" to create and download it.
Pro Tip: Schedule automated reports to save time on manual generation.
Understanding Sales Report Sections
1. Sales Tab Overview
| Header | Definition |
| Date | The date of recorded sales data. |
| Marketplace Name | The connected marketplace for the sales data. |
| Data shown under MP | Total sales value for the marketplace (based on forex rates at order time). |
2. Order List Tab Breakdown
Key columns include:
| Header | Definition | Calculation (if applicable) |
| Order Created Date | When the order was placed. | - |
| Order Number | Unique identifier for the order. | - |
| Marketplace | Platform where the order originated. | - |
| Total Units | Number of items in the order. | - |
| Order Total Value | Full order amount (subtotal + shipping + tax + tip). | Sub Total + Shipping + Tax + Tip |
| Total Price Paid | Final amount paid by the customer. | Order Total - Discounts - Shipping |
Note: Additional columns track fulfillment, shipping details, and customer information.
3. Order Details Tab (Item-Level Data)
This section provides granular insights into each product sold:
| Header | Definition |
| Product Name | Name of the ordered item. |
| Channel SKU (CSKU) | Marketplace-specific product ID. |
| Inventory SKU (ISKU) | Internal warehouse product ID. |
| Selling Price | Final price after discounts. |
| Channel Vouchers | Discounts applied by the marketplace. |
| Fulfillment By Marketplace | Whether the marketplace handles shipping. |
Best Practices for Sales Report Analysis
- Compare date ranges to identify sales trends.
- Filter by marketplace to assess platform performance.
- Track discounts & shipping costs to optimize pricing.
- Monitor fulfillment metrics (e.g., shipping time, carrier performance).
Missing data? Ensure:
- The correct date range is selected.
- Marketplaces are properly connected.
Incorrect values? Verify:
- Currency conversion rates.
- Discount and tax calculations.
Conclusion
Sales reports in OMS OMS provide powerful insights into your e-commerce performance. By following this guide, you can:
- Generate reports efficiently
- Interpret key metrics
- Make data-driven decisions
Comments
0 comments
Please sign in to leave a comment.