Logo
  • Support
  • Contact Us
  • Contact Us
  • Language
    • English
    • 简体中文
  • LOGIN START FREE TRIAL
English 简体中文
  • LOGIN
  • START FREE TRIAL
  1. BQool Support
  2. Repricing Central
  3. Advanced Topics

Export Filtered Result from Manage Listing page

Jimmy Liu

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
mceclip0.png

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.

mceclip1.png

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:mceclip0.png

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 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.

Download Full Listing information

Location: Repricing Central > Upload File

Users can download all the listing info from Manage Listing File

mceclip2.png

mceclip6.png

 

  • View the status of your last 10 uploads and downloads.

mceclip4.pngAfter 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.

mceclip5.png

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.

 

share:
  • Facebook
  • Twitter
  • LinkedIn
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us

Related articles

  • 2019-11 Repricing Central v3.3
  • Manage Listing Introduction
  • Bulk Action: Bulk Method to Enter Min and Max
  • 2020-09 BigCentral v1.3
  • Introduction to Repricing Rules- Updated!
Logo

Products

  • BigCentral
  • BigTracker Extension
  • Repricing Central

Pricing

  • BigCentral
  • Repricing Central

Resources

  • Blog
  • News
  • Support
  • Webinars
AWS partner

AWS partner

AWS Case Study

AWS Case Study

BQool is now available on Amazon Global Selling

Solution Provider Network

Amazon, Amazon Global Selling and the Amazon Global Selling logo are trademarks of Amazon.com, Inc. or its affiliates.

© BQool Inc. All Rights Reserved.