How can we help you?

File Upload / Download Feature

BQool Support
BQool Support
  • Updated

Upload Repricing Data

You can upload repricing data in bulk. This allows you to edit Min Price, Max Price, rule, and Cost for multiple listings at a time. To upload repricing data in bulk, please follow the steps below:

Step 1: Go to Upload File.

Step 2: Click Blank Template. You will now have a template for entering your repricing data.

Step 3: Please follow the instructions and Data Definitions in the Excel file to ensure your data to be uploaded correctly.

☛ Do not delete any columns in the file. If a column doesn't require updating, simply leave it unchanged.

The fields you need to fill out are:
mceclip0.png

  • Channel: the Marketplace you’re uploading data for.
  • SellerSKU: Seller SKUs are product identifiers associated with each Marketplace listing.
  • Rule Name: the rule you want to use for this listing.
  • Min Price: the lowest possible price you want to sell your product for. Please include shipping in your calculations.
    ✶Do not use symbols or spaces in your Min and Max Price
    ✶Do not use the currency symbol (e.g. $).
    ✶Please use periods (.) for decimal points.
  • Max Price: the highest price you want to sell your product for. Please include shipping in your calculations.
    ✶Do not use the currency symbol (e.g. $).
    ✶Please use periods (.) for decimal points.
  • Optional - Add/Delete: Enter an “a” for the repricing settings you want to update or add. Enter a “d” for the settings you want to remove. If this field is left empty, the default is to update and add.

    If the user fills in "add, " instead of the designated "a" for a listing, it will cause an unrecognizable upload to the system. An error message will appear to notify the user.

    If the user fills in "d, " for the selected listings, the system will clear out the data of cost, Min & Max, Rule and shipping. 

  • Optional - Shipping: update the shipping when Amazon's listings Report still showing "null," so you can use the profit calculator before shipping available.
  • Optional - Group: assign the SKU to the group you want.
    ✶The system will create the Group for you if the Group name enter is new.
  • Optional - Small and Light: enable SL on listings.

    US, UK, DE, ES, FR, IT, JP only.
    1: Enable Small and Light for this FBA Seller SKU
    0: Disable Small and Light for this FBA Seller SKU

  • Optional-Enable Repricing: Enable or Pause repricing on multiple listings at once. 
  • Optional-Cost: Total manufacturing and overhead costs for producing and/or acquiring the product.  
  • Optional-Additional Cost: Allow users to factor other product-related costs (i.e.Inbound shipping, prep center fees and so on). 

Step 4: When you are done entering your data, remember to save the file as a .txt (tab-delimited) file. Or if you are using Google Sheet, please save it as .tsv file. 

Step 5: When you are ready to upload your data, click Choose File to locate the file you want to upload.

Step 6: Click Upload Now to upload your file.

After uploading the file, you will see a list of past uploads under Review File Status and History.

When you are finished, please keep a copy of the Excel document containing your data. You can use this file when you want to edit your repricing data in the future.

 


Download Repricing Listings Data

You can download repricing data for editing. This is useful if you can’t locate your previous upload or if you would like a list of Seller SKUs. To download repricing data, please follow the steps below:

Step 1: Go to Upload File.

Step 2: Choose Repricing Central File and Click Full Template. Your repricing data will be downloaded as a text (tab delimited) file.


You can download a list of your Seller SKUs before you start filling out your Repricing Central template file. Alternatively, you can go into your Amazon Seller Central to download a list of your Seller SKUs.

 


How to Upload Your Product Costs

There are two options to upload your product costs at bulk. One is using the Active Listing File and the other is Closed-Batch-Report from InventoryLab. 

mceclip4.png

Active Listing File

Step 1: Choose Active Listing File and click the Blank Template so you will now have a blank template for entering your data.

Please follow the Instructions and Data Definitions in the Excel file and refer to the samples to ensure your data is uploaded correctly.

Step 2: Click the Full Template to download a .txt file displaying the listings information in the system. The image below show an example of the Full Template. 

Step 3: Copy the data in the Full Template and paste it to the Blank Template > Active Listings File tab.

After pasting the data, remember to delete these 2 rows.

The correct format should appear as shown in the image below.

Step 4: When you are done entering your data, remember to save the file as a .txt (tab-delimited) file. Or if you are using Google Sheet, please save it as .tsv file. 

Step 5: When you are ready to upload your data, click Choose File to locate the file you want to upload.

Step 6: Click Upload Now to upload your file.

Closed-Batch-Report from InventoryLab

If you are using the InventoryLab to managing your inventory, please follow the steps below to use the Closed-Batch-Report to upload your Inventory Costs:

Step 1: Navigate to “Export the Closed-Batch-Report” from your InventoryLab account.

Step 2: It will be under the CSV format. Please remember to Click "Save As" and choose "Text (Tab delimited)" as the file type. Also, remember to choose the location for storing your file and click "Save" when complete.

Step 3: (Alternative option) If you have downloaded the FBA/FBM Inventory report, please use the Blank Template to create upload file. Please follow the Instructions and Data Definitions in the Excel file to ensure your data to be uploaded correctly. Copy the MSKU, ASIN and "your Price Per Unit" from the Inventory report into the template's MSKU, ASIN, and Cost.

Step 4: When you are ready to upload your data, click Choose File to locate the file you want to upload.

Step 5: Click Upload Now to upload your file. (Please refer to the process report detail from above)

Here is a video tutorial on our Youtube Channel and click here to see the Support link from Inventory Lab, where you can find the guide about how to export the report for Closed Batch.

Was this article helpful?

0 out of 3 found this helpful

Comments

0 comments

Article is closed for comments.