How can we help you?

Bulk Upload: 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:

  1. Go to  Upload File.
     
  2. Next to Download File, click Blank Template. You will now have a template for entering your repricing data.
    mceclip1.png
     
  3. Please follow the instructions and Data Definitions in the Excel file to ensure your data uploads correctly.

    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.

      Note: Do not use symbols or spaces in your Min and Max Price
      Note: Do not use the currency symbol (e.g. $).
      Note: Please use periods (.) for decimal points.

    • Max Price: the highest price you want to sell your product for. Please include shipping in your calculations.

      Note: Do not use the currency symbol (e.g. $).
      Note: Please use periods (.) for decimal points.
      Add-Delete: this field is optional. 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-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). 
         
  4. When you are done entering your data, remember to save the file as a text (tab-delimited) file.
     
  5. When you are ready to upload your data, click Choose File to locate the file you want to upload.
     
  6. Click Upload Now to upload your file.

 

You can see a list of past uploads under Review File Status and History.

mceclip2.png
 

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:

 

    1. Go to Upload File.
       
    2. Choose Repricing Central File and Click Full Template . Your repricing data will be downloaded as a text (tab delimited) file.
      mceclip3.png

      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 Closed-Batch-Report from InventoryLab. 

mceclip4.png

For the Active Listings File please follow the steps below

  1. Choose Active Listing File  if you will enter or paste the require data on your own. Click the Full Template to download the Channel and SellerSKU.

mceclip5.png

2. Please follow the Instructions and Data Definitions in the Excel file to ensure your data uploads correctly.
mceclip6.png

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

  1. When you are done entering your data, remember to save the file as a text (tab delimited) file.
     
  2. When you are ready to upload your data, click Choose File to locate the file you want to upload.
     
  3. Click Upload Now to upload your file. 

 

Cost Data Upload by using 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:

  1. You can navigate to “Export the Closed-Batch-Report” from your InventoryLab account.

  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.

  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 uploads. Copy the MSKU, ASIN and "your Price Per Unit" from the Inventory report into the template's MSKU, ASIN, and Cost.

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

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

Her 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

Please sign in to leave a comment.