How to Use Seller Assistant Price List Analyzer for Wholesale Catalogs

The Price List Analyzer by Seller Assistant completely changes that. It lets you upload those massive wholesale spreadsheets, cross-reference them with Amazon's database, and see exactly what's profitable in minutes.

Setting Up Your Account Connections

You cannot use the analyzer without linking your seller account. The system needs to know your specific seller metrics before it can give you accurate results.

First, you open Seller Assistant and navigate to the price list analyzer in the side menu. There, you will find your saved price lists and your general cost settings.

The tool fetches information directly from your connected Amazon account to check if you have permission to sell a product. If your seller account is not connected, the software cannot tell you whether a product is restricted for you or not.

Uploading the File and Mapping Columns

To get started, you need to import your catalog and tell the software how to read it. The file does not need a highly specific format, but it must contain at least a product identifier and your cost.

Upload: Click the upload button, pick the specific Amazon marketplace you are targeting, and drop your spreadsheet file into the dashboard.

Vendor Tracking: Link the file to an existing supplier or create a new supplier profile by entering their website link. You can even assign a specific team member to manage that vendor.

Column Mapping: Map the columns from your supplier's spreadsheet to the fields required by the software. Select your identifier type, such as a UPC, ASIN, EAN, or ISBN. Then map your product cost column, product titles, and supplier SKUs. If you upload a file without costs, the tool simply treats the cost as zero and pulls the listing data anyway.

Factoring in Shipping and Hidden Fees

Before hitting the analyze button, you can adjust your cost settings to reflect real-world shipping and warehouse costs. This prevents you from buying products that look profitable on paper but lose money after shipping fees.

If you find a supplier on the opposite coast, your FBA logistics costs will naturally go up. You can easily override your default settings to add an extra per-item or per-pound shipping fee.

The tool also includes dedicated spaces to add flat costs for prep centers, bubble wrapping, hazmat handling, and oversized items.

You can even estimate Amazon's inbound placement service fees using a dropdown menu. If you are placing a smaller order, you can account for minimal shipping splits so Amazon's partial shipment fees don't catch you by surprise.

Protecting Your Capital Against Price Volatility

One of the best features in the advanced settings is how it handles Buy Box pricing. Relying on the live, current Buy Box price is incredibly risky because prices fluctuate constantly.

If a product's price spikes for a few hours and you base your purchasing decision on that moment, you will likely lose money when the price drops back down.

Instead, configure the analyzer to use 30-day or 90-day Buy Box averages. This gives you a realistic view of what the product actually sells for over time. You can also add extra fees here, such as a 2% credit card processing fee if your supplier charges extra for card payments.

Filtering Out Toxic and Gated Products

Once you run the analysis, the software builds a queue, matches the products on Amazon, and calculates your exact margins. It then presents everything in a neat data grid. You can view this using presets like the Primary Data Set, Full Data Set, or Potential Leads view.

To quickly find the best items, you need to filter out the bad ones. You can easily drag and customize your columns to focus entirely on net profit and ROI.

Start by setting a filter to only show items that make at least $1 of profit. Next, use the quick-access toggles to filter out hazardous materials, oversized cargo, fragile items, and listings where Amazon itself is in the Buy Box.

You should also exclude generic brands. Amazon's strict policies often prevent you from listing under generic tags if you haven't sold them before, even if the listing looks open.

Finally, filter out yellow-flagged warnings, such as products completely missing Buy Box prices or items that have never actually been sold via FBA.

Verifying Restrictions in Real Time

Once your filters narrow the list down to a few hundred potential leads, you need to check if Amazon will actually let you sell them.

Select all the remaining items in your clean list and click Check Restrictions. The software checks your connected seller profile in real time, and within about a minute, it updates every row with a visual status lock icon:

• Green Open Lock: You are completely cleared to sell the item right now without submitting invoices or brand letters.

• Red Closed Lock: You need brand approval. You will need to submit supplier invoices to get ungated.

• Red Lock with Exclamation Mark: Your seller account is not qualified to sell this item under any circumstances.

Click the quick-access filter to show only "Eligible to Sell" products, and you will instantly isolate the green open locks.

Staging and Exporting Your Purchase Orders

Now that you have a clean list of open, profitable products, you can finalize your order right inside the software.

If you click the search icon next to any ASIN, it opens the Seller Assistant side-panel extension view right in your dashboard so you can double-check historical charts.

Any likes, dislikes, or custom sourcing notes you type here sync instantly with your browser extension layout. You can also change the package quantity fields on the fly to see how your profit changes if an item sells as a pack of two.

To order the inventory, select your winning products and click Send to Purchase Order. This moves them into a built-in purchase order screen linked directly to your supplier's profile.

The system automatically fills in your prep center's shipping address, the supplier's SKUs, and your exact wholesale unit costs. You can set your exact target order quantities for each product row, add any extra freight costs, and review the final total cost.

Once everything looks perfect, click export to save the document as a clean PDF or Google Sheet that you can send straight to your wholesale supplier.