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
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 tick
- 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.
Comments
0 comments
Article is closed for comments.