Supplier Price List Guide and CSV Template

Supplier file guide and template

Use this guide and fictional template to prepare a supplier CSV or Excel catalog. Product matching and analysis begin after you upload the file to Rocket Source.

The downloadable template contains fictional products and prices. It is a formatting example, not a sourcing list or buying recommendation.

Download the fictional CSV template Read the CSV preparation guide

A supplier file that keeps the evidence

Use one row per supplier offer. Keep source fields separate from matched Amazon fields and from the calculations you add during analysis.

Supplier SKU and product title
UPC, EAN, ISBN, or ASIN
Unit cost and case quantity
Minimum order and available quantity
Supplier name, source URL, and notes

From supplier catalog to reviewable shortlist

1. Preserve and clean the source file

Keep an untouched copy, remove decorative rows, and store identifiers as text. Separate unit cost, case quantity, MOQ, and availability.

2. Map identifiers and costs

Tell the analysis which columns contain identifiers and acquisition costs while keeping supplier SKU and source details attached to every row.

3. Confirm listing matches

Check title, brand, model, variant, pack quantity, and condition. Route uncertain matches to manual review instead of treating them as correct.

4. Calculate with complete costs

Include fulfillment and referral fees, inbound shipping, prep, and other direct unit costs. Compare profit, margin, and ROI using a cautious selling-price estimate.

5. Export a shortlist, not an order

Filter the catalog, then verify supplier, offer, restrictions, demand, safety, MOQ, and availability before committing capital.

Upload a structured CSV or Excel file and map the fields used for product matching and calculations.

Uploading a supplier CSV into Rocket Source — Upload a structured CSV or Excel file and map the fields used for product matching and calculations.

Matched results keep the supplier row connected to the Amazon listing that needs review.

Supplier products matched in Rocket Source — Matched results keep the supplier row connected to the Amazon listing that needs review.

Supplier and source fields remain visible so a promising result can be traced back to the real offer.

Supplier and source fields for a product — Supplier and source fields remain visible so a promising result can be traced back to the real offer.

A conservative price basis helps test whether margin survives less favorable pricing.

Conservative price basis for profit calculations — A conservative price basis helps test whether margin survives less favorable pricing.

Build a clear supplier-file review process

Explore all free Amazon seller tools

Ready to analyze the full catalog?

Upload the cleaned file to Rocket Source and apply the same matching, fee, profit, ROI, pricing, and exclusion rules across every row.

Start a Rocket Source scan

Supplier price list questions

Can I analyze CSV and Excel supplier files?

Yes. Use a clear header row and one supplier offer per row. Confirm that identifiers, costs, quantities, and formula results survived the export before upload.

Does a profitable result mean I should buy the product?

No. It is a shortlist signal. Verify the exact listing, supplier, invoice quality, selling eligibility, demand, price stability, product safety, MOQ, and current offer before ordering.

Should duplicate ASIN rows be removed?

Not when they represent different supplier offers. Keep each offer as its own row and compare unit cost, MOQ, stock, shipping, terms, and supplier risk.