Multi-Channel E-Commerce Command Center

Multi-Channel E-Commerce Command Center brings every sales channel into one workbook. Choose the account and paste each platform's order report into the Import tab exactly as downloaded, header row included. Report profiles find the columns by their header names, so column order does not matter and extra columns are ignored. Example profiles cover an Amazon all orders report, an eBay orders report, Etsy sold order items, a Shopify orders export and a manual layout for markets and in-person sales, and you can add your own.

Each line is read, mapped and costed on the Sales Ledger. Dates in different formats are converted, $ signs are handled, and multi-line orders count shipping and discounts once. Platform SKUs that differ from your own are mapped to one product through alias columns. Amazon lines switch between FBA and FBM fee rules automatically from the fulfillment column. Overlapping reports are counted once, cancelled and refunded orders are skipped, and every line gets a status of OK, Review or Error with the reason.

Fee Rules hold each channel's sale fee percentage with a minimum per item, fixed fees per item and per order, payment processing, ads fees and whether the fee applies to shipping, with per-SKU overrides for category-based referral fees. Example rates for Amazon, eBay, Etsy, Shopify and in-person card sales are included and are easy to update. Each line then subtracts the marketplace fulfillment fee or your own shipping cost, and cost of goods at average landed cost.

Products holds each product's cost, packaging, fulfillment fee, shipping cost and reorder rules, and calculates stock on hand, units sold, sales over the last 30 days, days of cover, a stock status of OK, Watch, Reorder now, Out of stock or Overstock, a suggested reorder quantity and a reorder-by date. Purchases log restocks with freight and duty so the average cost stays accurate.

The Dashboard shows revenue, net profit after overheads, margin, profit per order, fees and cost of goods as a share of revenue, inventory value, profit and loss by channel, stock alerts, import checks, monthly revenue and profit, and top products by profit for any date range. The Price Planner shows the profit on one unit for every channel side by side, with the break-even price and the price that hits your target margin. Monthly P&L and Overheads complete the picture. Capacity covers 2,000 report lines, 200 products and 500 purchases. Formulas sit in locked cells and protection has no password. Sample data from a fictional shop is included. Built for Microsoft Excel 2016 or later (desktop or Excel for the web) and contains no macros.