The Restock Suggestions Grid

While the Restock Suggestions grid is laid out in an intuitive way to help you understand your actual restock suggestions and sales velocities, it might look overwhelming at first. Sellers will benefit from having easy access to up-to-date metrics.

Here are the types of data shown in the main grid:

  • Flags - these help you focus on restocks recommended for now or the near future

  • Product IDs and Basic Information - SKU, ASIN, Product Name, UPC and more

  • Supplier Information - Your linked supplier, supplier SKU, and cost

  • Sales and other Financials - Historical sales, estimated margin and pricing

  • Competitor Analysis - Other FBA and non-FBA sellers, and whether Amazon sells

  • Quantities - Various quantities in your supply chain

Flags

Restock Suggestions gives you color-coded flags to narrow your attention on imminent restocks. The flags inform you that action is suggested - either a reorder or shipment that is ready to be placed; they will turn off while you are waiting for an order already placed.

Check out the red-flagged items first - these SKUs have less than your configured target number of days coverage. Next review the yellow items - these items are stocked above your minimum target but less than your max. So these will likely need to be ordered soon. It might make sense to include them now if you are already working on an order from the same supplier. Bigger orders often mean bigger supplier discounts.

RestockPro identifies new SKUs with a blue flag. You can sort to find them quickly. Since there’s no sales history, there won’t be a suggested order quantity, but don’t forget to stock these items. You might want to create a filter to specifically look for items with no QOH and no sales velocity. See below for more on creating custom filters.

 

Product IDs and Basic Information

The Product SKU, Product Name, Image, ASIN, FNSKU, UPC and EAN are the basic information fields related to each product. You can easily search or sort by any of these fields to find a SKU. Tip: Use a bluetooth scanner to quickly search for products by scanning their UPC or FNSKU barcode while your cursor is in the Search box.

magnifying-glass-icon There is also a magnifying glass icon on each line item that lets you view product details. Clicking the product name hyperlinks you to the listing on Amazon.com. Clicking the Product SKU or the ASIN will take you to the listing on Amazon or Seller Central, respectively.
 
Tags
tag-icon  Use tags to set your own product identifiers, such as the season for a particular SKU, the buyer, or any other type of classification system you envision. Click the blue tag icon to set a tag. If you can't see the icon, trying widening the column slightly. To quickly set the same tag value on multiple SKUs, click the checkbox on each one and then click the blue tag. Clicking the checkbox next to the column name will multi-select every displayed product. You may enter one or more tags - enter a comma to separate each tag.

 

Supplier Information

The Supplier Alias, Supplier SKU and Cost give you a glance at your supplier info (handy when it comes time to create an order). The supplier cost shown is the one established for the product on the Products page. The cost will be used when you create a purchase order. The order total keeps tallying in the cost color box at the top of the dashboard. A seller might also decide that it’s less risky to invest in less expensive items when all other factors are equal. To learn more, read about managing profitability.

 

Sales and other Financials

These fields are especially important for assessing product potential and profitability. Your average 7-Day Price displays your average sales price over the last 7 days. Under it, you’ll see your current Listing Price.

Sales figures are shown for several time periods (2D, 7D, 30D… up to 180D) in total or on a per-day basis, known as Velocity. For example, 30D Velocity = 30-day sales divided by 30. This data is crucial to your restock plan and your decisions about SKU profitability. If a product isn’t moving, this data allows you to make an informed decision about your inventory on that item.

calculator-icon Estimated Margin is calculated using a simple formula. You can click the calculator to see the details. Estimated Margin is the estimated amount of money you can expect to make or lose on a sale. You can track your margins even on products you have ceased to offer - RestockPro helps you identify if factors have changed that should cause you to reconsider offering the SKU.

Estimated Margin % is the percentage of price that is profit. Estimated Markup % is the percentage of cost that is profit.

 

Competitor Analysis

No performance indicators are complete without an idea of what the competition is doing. Your Restock Suggestion dashboard shows you whether an item is sold by Amazon. When Amazon begins or stops selling a product, the outlook can change very quickly! The current new buy box price can help you gauge whether you’re pricing your products competitively. This information also helps you make restocking decisions based on potential sales and the going offer price of other FBA sellers.

Restock Suggestions also shows you the number of FBA sellers and the number of non-FBA sellers, along with their respective lowest offer prices.

This grid displays the category and sales rank of each SKU. There are a variety of tools on the market that may help gauge sales based on category and rank.

 

Quantities

Simply put, this information shows you, at a glance, how many units of the SKU you have or are moving between various locations in your supply chain. Your items are on the move constantly, and keeping track of it all is no easy task. Luckily, RestockPro is keeping tabs on it all.

map-icon Supply Chain Map: Click the pin icon located in the Reserved/Unfulfillable column: to display your Supply Chain quantities as a map:

QOH represents the fulfillable quantity that you have on hand at Amazon FBA.

 

Inbound Analyzer:

Inbound is the total quantity on its way to Amazon from either your supplier or your local warehouse. Inbound is calculated based on your inbound shipments shown on the Orders page. Inbound is broken down into Inbound Working, Shipped and Received, based on the states of the shipments. This is all easy to visualize by looking at the Inbound Analyzer (click the Inbound field hyperlink) which shows a detailed list of ship quantities that make up Inbound.

Reserved and unfulfillable are two quantities that RestockPro imports from Amazon. Reserved typically means the units are held up or moving between fulfillment centers. Unfulfillable means the units are not in saleable condition, either because of damage, expired or close to expiring dates, or some other reason.

The Pending quantity refers to the number of units included on RestockPro reorders, where the order is in a state of Pending (ie, the Purchase Order has not been sent). These may be orders that are waiting for internal approval.

The Local field shows you the quantity of the SKU you have in your local warehouse inventory available to be shipped into Amazon. Click the Local Inventory menu option on the left for a complete view of your warehouse quantities.

Last, you see the quantities suggested for shipping and reordering (see details below). You also see the “On Order” quantity which represents the quantity you have ordered from your Suppliers. These units reside in open Purchase Orders in RestockPro. Click the On Order hyperlink to see the details of the Orders that comprise this figure.

 

ASIN Limit

An ASIN limit means that there are restrictions on shipping the item to Amazon because they already have an excess of that SKU. Use care in ordering any items with limits so you don’t get stuck with items you can’t ship. You might consider offering these items on a different sales channel besides Amazon.

 

Suggestions

The suggested quantities are broken into

  • Suggested Ship

  • Suggested Reorder

Suggested Ship is used with the Local model and tells you how many of a SKU to send to Amazon from your own warehouse. Suggested Reorder tells you how many items to reorder from your supplier.

Below these quantities, you see “On Order” and “Restock Need”. “On Order” tells you how many items you’ve already ordered - RestockPro knows the remove its flag once you’ve already placed an order. It will turn the flag back on if you receive an order to local inventory and need to ship it.

The Restock Need is the total quantity needing to be replenished at Amazon. Note that the individual numbers may not sum to the Restock Need because the individual numbers are adjusted in consideration of case packs and minimum order quantities.

calculator-icon Click the calculator to see the details of the suggested quantity calculation. Also notice the map-iconicon which appears when the historical sales period being used to forecast demand includes significant out of stock. You may want to decrease or adjust the order quantity for these scenarios.
 
Click thequantity-icon to add the quantity to the cart.