Users can download the Full and Filter Listings results on the Manage Listings page by clicking the download button on the upper right side of the interface.
Download the Top 2000 Filtered Results
Location: Manage Listing Page>Downlaod
Users can filter on the left menu to define the listings’ requirements and click download. A pop-up will inform users that the system can only download up to the first 2000 listings from the search results to the CSV file.
Users can click yes to proceed to download.
In the downloaded BQool Manage Listings file, users have access to info on different listings, sales performance metrics and Amazon fees.
- The listing data in the file is the most updated data saved on the BQool end. The system won’t request a new listing report through the API when users request to download the file.
- The listing sort sequence in the download file is in accordance with the sort sequence defined in the Preferences setting as seen in the image attached below:
Additional information to the data for the column of Low Price + Shipping and Buy Box+Shipping.
- 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 tickon 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.
Download Full Listing information
Location: Repricing Central > Upload File
Users can download all the listing info from Manage Listing File
- View the status of your last 10 uploads and downloads.
After a user requests to download a Manage Listing file, the system will generate one processing record on the Review File Status and History.
If the latest report downloaded is still pending or in progress on the Review File Status and History, users can’t proceed to request to download other files. The system won’t respond to other requests until it finishes processing the first request.
The records generated by Upload File and Download File will be shown on the Review File Status and History section.
The system can only generate up to 10 file records. The latest record will display at the top of the sequence of the historical records.
Download File Format:
- All the listing info on the Manage Listings table from the given Marketplace
- File Format: CSV
- Filename: BQool Manage Listings File
The definition of the Listing Info Column
In the downloaded BQool Manage Listings file, users have access to info on different listings, sales performance metrics and Amazon fees.
Please refer to the definition of each listing info column.
|
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. |