Bulk Upload: File Upload Method (Excel) - Updated!

Follow

 


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 Repricing Central > Marketplaces > Upload File.
    Upload_File.png
     
  2. Next to Download File, click Blank Template. You will now have a template for entering your repricing data.

     
  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:
    Repricing_Central_File_1.2.1.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.

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


 

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 Repricing Central > Marketplaces > Upload File.
       
    2. Click Repricing Listings Report. 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 Closed-Batch-Report from InventoryLab. 

For the Active Listings File please follow the steps below

  1. Go to Download File and click Blank Template if you will enter or paste the require data on your own. Click the Full Template to download the Channel and SellerSKU.

  2. Please follow the Instructions and Data Definitions in the Excel file to ensure your data uploads correctly.
    Active_Listings_1.2.1.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.

  3. When you are done entering your data, remember to save the file as a text (tab delimited) file.
     
  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.


 

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

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

    (Alternative option) If you have downloaded the FBA/FBM Inventory report, please use the Blank Template to create upload file. You need 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.

  3. When you are ready to upload your data, click Choose File to locate the file you want to upload.
     
  4. 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 on where find how to export the report for Closed Batch.

 

Have more questions? Submit a request

Comments

United States support
Business Hours: Monday-Friday 9am- 5pm PST
Tel: +1(650)396-2777
www.bqool.com
United Kingdom support
Business Hours: Monday-Friday 9am- 5pm PST
Tel: +1(650)396-2777
www.bqool.com
Taiwan support
Business Hours: Monday-Friday 9am- 6pm (GMT+8)
Tel: +1(650)396-2777 (English)
Tel: +886-02-7720-6858 (Chinese)
www.bqool.com.tw
China support
Business Hours: Monday-Friday 9am- 6pm (GMT+8)
Tel: +886-02-7720-6858 (Chinese)
www.bqool.cn