The Excel results workbook: Results, Dashboard and All Details

Every scan comes as one Excel workbook with three sheets. Use it to filter offline, share the results with a partner, or send target prices to your supplier.

Get the workbook

• By e-mail: when a scan finishes, the workbook is sent to you as an attachment. If the file is too large to attach, the e-mail links to the scan instead.
• From the scan: open the scan and select Export to Excel, next to the search box. You always get every product and every column, not only the current page.

The file is named wsa_result_<your file name>_<date>.xlsx, so the workbooks of the same supplier sort together. Excel export is part of the paid plan; the free scan e-mails you a summary with a link to its report.

Sheet 1: Results

Every product, with the same columns as the results grid and in the same order. FBA and FBM profit and ROI are side by side. The most used columns are:

• Decision and Brand / IP Risk.
• Buy Box Price, Cost, Net Profit (Landed) and ROI % (Landed), which include your prep and shipping costs.
• Max Buy Cost: the highest price that still meets your targets.
• Price War Risk, Dead Stock Risk, Recommended Order Qty, Investment and Months to Sell MOQ.
• Why (Not a BUY): the reasons a product missed BUY, and Notes for products Amazon could not find or price.

The ASIN opens the product page on Amazon. Long texts wrap inside their cell so the rows stay compact.

Sheet 2: Dashboard

The scan at a glance, to read from top to bottom:

• Headline numbers: products matched, BUY, REVIEW and AVOID, capital for all BUYs, expected profit, average ROI and monthly profit.
• Decisions: the split, with the investment and profit of each decision.
• From supplier file to BUY: each step keeps only the products that pass it. The biggest drop shows what holds this supplier back.
• Best products to buy: ranked by decision, score and monthly profit. Start your order with these.
• Spending your capital: the best mix of products for your available capital.
• Brands: the brands with the most BUY products, with their brand and IP risk.
• Risks to check: how many products have each warning (IP risk, price war, dead stock, restricted, approval required, no cost, not found) and what to do about it.
• Ask your supplier for a better price: products that are not a BUY today but would be at the target price shown, with the discount needed.
• Next steps: what to do with this scan, in order.

Sheet 3: All Details

Every field of every product, in the order sellers read them. It includes the identifiers, catalog details, package and item dimensions, Buy Box and lowest offers (FBA and merchant), total offers (new and used), fees, selling eligibility with Amazon's note, the IP risk reasons, the wholesale score and the order sizing. Use it when you need a number the Results sheet does not show.

Tips

• Turn on Excel's filter on the Results sheet and filter Decision to BUY to build your order.
• To work on one risk from the Dashboard sheet, filter its column on the Results sheet, for example Price War Risk = High.
• Copy the Ask your supplier for a better price table into your e-mail to the supplier. See how to negotiate with wholesale suppliers.