Overview
The topline numbers on the products page in Flashpricer give you insights into the performance of your products, including revenue, profit, margins, return on investment (ROI), and inventory value. These numbers are calculated based on the cost and sales data in the system. Below is an explanation of how these numbers are generated and how to ensure accuracy, along with a visual guide.
1. Data Calculation for the First 30 Days
For the first 30 days after you start using Flashpricer, we will use the costs you input into the system and apply them to the previous 30 days of sales for each item.
- New Costs Applied Retroactively: If you input a cost for a SKU today and there was no cost entered at the time of a sale, the newly input cost will be applied to the past 30 days of sales for that SKU.
- Missing Cost Data: Without the cost of goods, Flashpricer cannot accurately display profit, margins, ROI, or inventory value. It's crucial to input or upload costs to have a clear financial picture.
2. Handling Missing Costs
- Missing Cost Badge: Products missing cost information will display a "Missing Cost" badge. You can click this badge to filter and easily update the missing cost data for those items.
- Bulk Uploading Costs: You can also upload costs in bulk via the "Uploads" page, which allows for faster entry and more comprehensive coverage.
- Cost Integration: Alternatively, you can filter for missing costs directly within the Flashpricer UI, or import cost data using integrations from one of our trusted software partners.
3. Time Zone Consideration
Data from the past 30 days is calculated using full-day intervals, based on Eastern Standard Time (EST). This ensures consistent day-to-day comparisons.
4. Walmart Sales & CAP
For Walmart sales, it’s important to note that any sales subject to CAP (Commission Adjustment Program) may result in lower profit numbers than expected. CAP can adjust the commission you pay to Walmart, impacting the margins and profitability of certain sales.
5. Exclusions from Calculations
For both Amazon and Walmart:
- Flashpricer does not take into consideration long-term or short-term storage fees or advertising fees when calculating profit and other financial metrics.
6. Dynamic Adjustment with Filters
One of the most powerful features of the products page in Flashpricer is the ability to apply filters to dynamically adjust the topline numbers. These filters allow you to slice the data in various ways and get granular insights based on specific criteria.
- Filters Available: You can filter by sales channel (e.g., Amazon, Walmart), fulfillment type (e.g., FBA, FBM), or even specific products across multiple channels.
- Instant Adjustments: When you apply a filter, the topline numbers (revenue, profit, units sold, profit margin, ROI, and inventory value) will automatically adjust based on the data within the selected filter. This enables you to isolate the performance of specific sales channels or products to get highly detailed insights.
- Granular Insights: For example, if you want to analyze only FBA (Fulfilled by Amazon) sales on Amazon, you can apply the filter, and the topline numbers will reflect the sales and profit for just those transactions. Similarly, you can filter by Walmart’s sales and fulfillment type to gain insights specific to that platform.
The screenshot above showcases the main topline numbers you’ll see on the products page in Flashpricer:
- Revenue (Last 30 Days) – Displays total sales revenue over the last 30 days. In the screenshot, this value is $455,013.85.
- Units Sold (Last 30 Days) – Shows the total number of units sold in the last 30 days. Here, 2,740 units have been sold.
- Profit (Last 30 Days) – Shows the total profit made from sales in the last 30 days. In this case, it is $41,863.75, but note the 6 missing cost badge, which indicates missing cost data for six SKUs. This can impact profit accuracy.
- Profit Margin (Last 30 Days) – Displays the percentage of profit margin over the last 30 days, which is 9.20% in this example.
- ROI (Last 30 Days) – Shows the return on investment percentage over the last 30 days, calculated at 22.75%.
- Total Inventory Value – Displays the current value of the inventory. In this example, it shows $1,076,267.37, but note the warning icon indicating some missing data that could impact this figure.
Summary
To get the most accurate topline numbers on your products page:
-
Ensure all SKU costs are entered, either through the missing cost badge, bulk upload, or by integrating cost data from one of our trusted software partners. Keep in mind that the timing of order reports may affect when these updates are reflected in Flashpricer. Walmart sends order reports at irregular intervals, while Amazon typically sends updates every 3-4 hours. As a result, there may be a slight delay between adding costs and seeing accurate dashboard metrics. We appreciate your patience during this process!
- Regularly check and resolve missing costs to avoid inaccuracies.
- Use filters to slice and dice your data, enabling detailed analysis by sales channel, fulfillment type, or product.
- Be aware of CAP (Commission Adjustment Program) adjustments affecting Walmart sales.
- Remember, storage and advertising fees are not included in profit calculations.
By keeping your data updated and using filters to analyze specific sales or channels, you can gain a more detailed and accurate view of your product performance.