Reports & Analytics

Your seller dashboard includes two dedicated reporting sections: **Sales Dashboard** and **Inventory Dashboard**. Both are scoped to your own listings — you only ever see data for items you created. Access them from your dashboard sidebar under **Reports**. --- ## Sales Dashboard **Path:** Dashboard > Reports > Sales The Sales Dashboard covers all paid orders that include your items. Use the date range selector at the top to filter results. Available ranges: - Today / Yesterday - Last 7 Days / Last 30 Days - This Month / Last Month - This Year ### What you see | Metric | What it means | |---|---| | **Total Sales** | Sum of revenue from your sold items in the period | | **Total Orders** | Count of distinct paid orders containing your items | | **Items Sold** | Total line items sold (one order can contain multiple items) | | **Average Order Value** | Total Sales / Total Orders | **Sales by Item Type** breaks your revenue into Jewelry vs. Gemstones — useful for understanding which category drives most of your income. **Top Selling Items** lists your 10 best performers by quantity sold, with revenue for each. This table resets whenever you change the date range. **Sales Trend** shows daily totals — how many orders came in and how much revenue each day generated. Useful for spotting slow periods and high-traffic days. ### Exporting sales data Click the **Export** button to download a CSV of all order line items in the selected period. Columns: Order ID, Order Date, Item ID, Title, SKU, Type, Quantity, Amount. Opens correctly in Excel. --- ## Inventory Dashboard **Path:** Dashboard > Reports > Inventory The Inventory Dashboard is a snapshot of your current listings — not time-bounded. It reflects the state of your catalog right now. ### What you see **Summary cards** at the top show: - Total items across all types - Jewelry item count - Gemstone item count Each card has a direct **Export** link for that category. **Inventory Value** charts compare: - **Retail value** — sum of `price × quantity` across your listings - **Wholesale value** — sum of `wholesale_price × quantity` (falls back to retail price if wholesale is not set) These are shown separately for Jewelry and Gemstones. **Category Breakdown** shows how your inventory is distributed across categories. For jewelry, categories come from the item's assigned category. For gemstones, categories come from the gemstone type property. Each row shows item count and the percentage of your total for that type. ### Exporting inventory data Each summary card has an Export link, or use the export routes directly: - All items: Dashboard > Reports > Inventory > Export All - Jewelry only: Export (Jewelry) - Gemstones only: Export (Gemstones) CSV columns: ID, Title, SKU, Type, Price, Sale Price, Wholesale Price, Quantity, Status, Stock Number, Brand, Featured, New, Trending, On Sale, Taxable, Location, Created At, Updated At. --- ## Overview Dashboard (Reports Home) **Path:** Dashboard > Reports The Reports home page shows a combined analytics view with period-over-period comparisons. It uses a 30-day default window but accepts custom date ranges. Key metrics shown: - **Sales growth** — current period vs. prior equivalent period (e.g., last 30 days vs. the 30 days before that) - **Inventory health** — total items, items with low stock (5 or fewer), out-of-stock items - **Top categories** — which product categories generated the most revenue - **Sales trend chart** — daily revenue and order volume over the period --- ## Using Reports to Grow Your Business **Identify your best sellers.** Check the Top Selling Items table monthly. If the same few items keep appearing, those are your anchors — keep them stocked, consider expanding into similar styles, and highlight them in your storefront description. **Compare month over month.** Use "Last Month" and "This Month" back-to-back to spot trends. A declining average order value often means buyers are choosing lower-price items — consider whether your higher-value listings need better photography or descriptions. **Spot slow periods.** The daily Sales Trend table shows which days of the week and month tend to be quieter. Use slow periods to update listings, add new items, or refresh photos rather than waiting for sales to pick back up. **Balance your inventory mix.** The Inventory Dashboard category breakdown shows if your catalog is heavily skewed toward one category. Buyers who visit your storefront expect variety — if 90% of your items are in one category, you may be missing cross-sell opportunities. **Track retail vs. wholesale value.** If your wholesale value is significantly lower than retail, that gap represents margin. Watch for it shrinking over time — it may indicate you're setting sale prices too aggressively or your wholesale costs have risen. **Export for external analysis.** Both exports are compatible with Excel and Google Sheets. Use a pivot table on the sales export to see revenue broken down by item type, or to calculate your effective sell-through rate against your inventory counts. **Low stock is a warning signal.** Items with 5 or fewer units show in the Inventory Dashboard low-stock count. Cross-reference with your top sellers — if a popular item is nearly out of stock, restock before it goes to zero rather than after. Out-of-stock items still appear in your catalog but cannot be purchased.