How can we help you?

Export Listings on Manage Listing Page

BQool Support
BQool Support
  • Updated

You can download the full listings or filtered listings results on the Manage Listings page by clicking the Download button on the upper right side of the interface. 

There are 2 options you can choose: download listings or download reports. 

Download Listings

For downloading less than 2000 listings, it's recommended to click on this option, which allows you to download up to the first 2000 listings from the search results to the Excel file instantly.

Click "Yes" in the pop-up window displaying “Download up to 2,000 listings to csv file instantly“ to proceed with the download.

Download Reports

For downloading more than 2000 listings, it's recommended to click on this option, which the system will generate an file under "Reports > Download Reports".

Click "Yes" in the pop-up window to proceed with the download.

 

After requesting to download the report, you can view the status of the last 10 downloads under "Reports > Download Reports".

Click on the Refresh button to check on the status of the report. Once the report is ready, you will be able to Preview it before Downloading it.

  • If the latest report downloaded is still pending or in progress, you cannot proceed to request the download of other files. The system will not respond to additional requests until it completes processing the initial request.
  • The system can only generate up to 10 file records, with the most recent record displayed at the top of the historical records sequence.

 

In the downloaded file, you have access to information on each listing, such as sales performance metrics and Amazon fees.

  • When requesting to download the file, the system does not initiate a new listing report request through the API. Instead, it uses the latest data already available on the BQool end. In essence, the listing data in the file represents the most recent information stored on the BQool platform.
  • The listing sort sequence in the download file is in accordance with the sort sequence defined in the Preferences setting.

Column Definitions in the Download File

Following are definitions of each column in the downloaded Excel file.

Column

Description

Channel

Amazon Marketplace(s)

The source of data: Manage Listings page.

Seller SKU

Seller SKUs are the product identifiers associated with each Marketplace listing. 

The source of data: Manage Listings page.

Status

The status of the product can be marked as Active or Inactive

The source of data: Manage Listings page.

Condition

Product condition.

The source of data: Manage Listings page.

Title            

The product name on the Amazon Selling page.

The source of data: Manage Listings page.

Fulfillment

How the order is fulfilled.

The source of data: Manage Listings page.

Offers

The system displays how many sellers are selling this product.

The source of data: Manage Listings page.

ASIN

Product ASIN.

The source of data: Manage Listings page.

BB%

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

The source of data: Manage Listings page.

BB Owner

BuyBox Owner

The source of data: Manage Listings page.

Position

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

The source of data: Manage Listings page.

Rank

This information indicates the seller’s rank for the listing on Amazon. 

The source of data: Manage Listings page.

Date Created

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

The source of data: Manage Listings page.

Qty

The number of products that is available to sell.

The source of data: Manage Listings page.

Cost

The cost of the Product

The source of data: Manage Listings page.

Min Price

The minimum price that you would agree to sell the product at.  

The source of data: Manage Listings page.

Max Price

The maximum price that you would agree to sell the product at. 

The source of data: Manage Listings page.

Rule

The given Repricing Rule for the listing.

The source of data: Manage Listings page.

Your Price

Your Price is the list price which sellers want to sell the product for.

The source of data: Manage Listings page.

Shipping

This data is retrieved from an Amazon API and will be updated once a day.

The source of data: Manage Listings page.

Your Price+Shipping

Your Price is the list price that sellers want to sell the product for.

The source of data: Manage Listings page.

Low Price+Shipping

The lowest price offered under this ASIN on Amazon. 

The source of data: Manage Listings page.

Buy Box+Shipping

The Buy Box price of the product is listed under the same ASIN on Amazon. 

The source of data: Manage Listings page.

Units Sold (Last 7or 30 days)

The number of that’s product’s units that have been sold in the past 7 or 30 days. 

The source of data: Manage Listings page.

FBM Shipping Cost

FBM Actual Shipping Cost

The source of data: Profit Calculator

Additional Cost

Other product-related costs (i.e. inbound shipping fee, pre fee, Sales Tax...etc).

The source of data: Profit Calculator

Amazon Referral Fee

Amazon Referral Fee

The source of data: Profit Calculator

Closing Fee

Amazon Closing Fee

The source of data: Profit Calculator

FBA Fulfillment Fees

FBA Fulfillment Fees

The source of data: Profit Calculator

VAT Rate

VAT Rate

The source of data: Profit Calculator

Est. Profit

The estimated profit based on the difference between the sourcing price and the estimated sales price

The source of data: Manage Listings page.

Est. Profit Margin

Profit margin % is calculated by breaking down the item price into cost and profit

The source of data: Manage Listings page.

ROI

ROI focuses on the investment value of a product

The source of data: Manage Listings page.

Group

The group column indicates which group the listing belongs to. 

The source of data: Manage Listings page.

Enable Repricing

The status of the repricing mechanics

The source of data: Manage Listings page.

 

Low Price+Shipping / Buy Box+Shipping Column

  • If the listing data under the Low Price +Shipping column indicates a green tick mceclip1.png on the Manage Listing page, the corresponding column in the download file will be shown as TRUE.
  • If the listing data under the Buy Box+Shipping column indicates a green tickmceclip1.pngon the Manage Listing page, the corresponding column in the download file will be shown as TRUE.
  • If listing data on the Manage Listing table shows a blank, then the corresponding column in the download file will display blank as well.
  • If listing data on the Manage Listing table shows a dash “-”, then the corresponding column in the download file will display a dash “-” as well.

mceclip0.png

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.