How can we help you?

Manage Listing Columns Introduction

BQool Support
BQool Support
  • Updated


The detailed introduction of Manage Listing explains the nitty gritty of each feature for a listing. All the underlined headers can be sorted in ascending or descending order. 




The group column indicates which group the listing belongs to. Moreover, the group column is hidden by default. You can add the group column by going to Settings > Preference (upper right-hand corner). The new update will only allow each listing to be assigned to one unique group. In other words, the same listing cannot be assigned to two different groups.


SKU / Status / Condition

  1. SKU: A unique identifier for certain listings
  2. Status: The status of the product will be marked as Active or Inactive based on its Quantity.
    When QTY>0, the status will be Active; when QTY=0 or –, the status will be Inactive. 
  3. Condition: Distinguish as New, Used (Like New, Very Good, Good, Acceptable), Collectable (Like New, Very Good, Good, Acceptable), Certified Refurbished: Condition Guidelines



Title / Fulfillment / Offers / ASIN / BB% / BB Owner / Position / Rank


1. Title: The product name on the Amazon Selling page. This column will only display the first 40 English letters of the title. When the user hovers their mouse over the title, the system can display up to 100 English letters.

2. Fulfillment Type: BQool will only label the fulfillment type as FBA or FBM.


3. Offers: The system displays how many sellers are selling this product.



4. ASIN: Click on ASIN to open an Amazon Selling page for the product.





5. Buy Box win percentage

This will show how frequently this listing has held the Buy Box for a certain period since Amazon’s SQS reports were generated.

Formula: the number of SQS reports with the Buy Box ownership status received in one day/ the number of all the SQS reports received in one day.

For example: If the system has received 100 SQS report for a given day, there are 50 SQS report out of the 100 SQS reports, indicating that the listing is in possess of Buy Box. Following that, the Buy Box win percentage of the listing is 50%. If the system doesn’t receive any SQS  for the given day, the final calculation will indicate 0% for the Buy Box win percentage.


As for the time that BQool start counting the SQS reports with the Buy Box ownership status, it will be starting from UTC00:00:00 every day to count how many SQS reports with the Buy Box ownership status BQool received on each listing.

Please note that this Buy Box win percentage is an estimation which is based on the analytics data of the SQS report received from UTC00:00:00 ~ 23:59:59.


6. Buy Box Owner: This icon indicates the current Buy Box owner, identified as Amazon, FBA seller or FBM seller.

7. Position: The position of the listing’s price offer in the top 20 price competition.


8. Rank: This information indicates the seller’s rank for the listing on Amazon. This information comes from the SQS report directly.


Date Created 

The date when the listing was created at Amazon Seller Central.





The number of product that is available to sell.

The data showing product quantity may take up to 72 hours to update. The system will update the data of the FBA listings every 2 hours and FBM listings every 2-4 hours.

When the quantity is displayed as “-,” there are two possible causes. The first possibility is that the Listing report has not been imported into BQool’s system yet.

The second possibility is when there is a listing data discrepancy in two of the listing reports received from Amazon. One thing that could cause this is if there are any abnormal symbols in the SKU names. The symbol will cause SKU name recognition failure and will display HTML code in the listing report, which will then result in the quantity data not being correctly updated by BQool. For more information on the abnormal symbol issue, please refer to the support article: Listing of Symbol Entities that will cause SKU updating issue.



The cost of the Product. It is recommended that the cost should include all product expenses, including the cost of shipping the product to the Amazon Fulfillment Center.  


Min/Max Price

Min Price: The minimum price that you would agree to sell the product at.  
Max Price: The maximum price that you would agree to sell the product at. (It is not recommended to set the price to be unrealistically high, as it may cause potential pricing errors.)  



Repricing Rule

The given Repricing Rule for the listing.



Your Price +Shipping

Your Price + Shipping is the current price.

The Shipping fee 

This data is retrieved from an Amazon API and will be updated once a day. It’s recommended to click on the refresh button to get the real-time data value.


Low Price + Shipping

This column displays the lowest price with the same fulfillment type under this ASIN on Amazon. For example, if your fulfillment type is FBA, this column will show the lowest FBA price based on the SQS report.

A green tick in this column indicates that your price matches the “Low Price + Shipping” offer.

Once the system has received the new SQS from Amazon, the data for Low Price + Shipping can be updated within an hour. 


Buy Box + Shipping

The Buy Box price of the product is listed under the same ASIN on Amazon. Once the system has received the new SQS from Amazon, the data of Buy Box + Shipping can be updated within an hour.


Units Sold

The number of that’s product’s units that have been sold in the past 7 or 30 days. (Updated once a day) 
Time : UTC+ 0  

Est. Profit 

(Your Price + Shipping) - (Product Cost + Amazon Referral Fee + Closing Fee + FBA Fulfilment Fee).

Est. Profit Margin (%)

(Est. Profit / Your Price + Shipping ) x 100. 

ROI (Return On Investment)

(Est. Profit / Product Cost) x 100. 
*Product cost calculated as: Product Cost+Additional Cost+FBM Shipping Cost



Was this article helpful?

4 out of 6 found this helpful



Article is closed for comments.