PSQQQ > Blog


Bulk update Amazon listings

If you sell your items on Amazon, you know how important it is to keep your listings up to date. You have several products listed on Amazon that need to be changed. One way is to edit each of them individually. Another way is to bulk edit an Amazon listing at one time using the file upload method.

In this article, we will discuss a method for bulk editing Amazon listings – using an inventory file.

Our goal is to show you how easy it is to edit Amazon listings in bulk, without editing each item and uploading an inventory file.

Export of products from PSQQQ to Excel file

To fill in the template file from Amazon, you need up-to-date data on the quantity and prices of products. To do this, you need to unload the goods from the PS to the Excel file:

  1. Go to Configuration ->Export config to the Main Feed -> Export to a file:
  2. From the drop-down list, select the Excel file and click Save. Close this tab.
  3. In the Activity column, put a check mark (this check mark allows you to turn on and off the export) and click Save:
  4. The next step is to start exporting.
  5. We go to the Functions -> Export Main Feed. To start the export, click – Run. At the end of the export operation, the created Excel file will appear in the Export Files column:
  6. From the uploaded file, we need the columns Sku, Quantity and Price.

Editing the Listing Template File from Amazon

  1. Go to the seller’s admin panel. In the Seller Central Dashboard, go to the “Inventory” tab and select “Add products via upload” from the dropdown list.
  2. In the “Need to create a product file” section, click on the “Continue” button.
  3. The ‘Add Products via Upload’ window opens. Click “Download an Inventory file”
  4. Select the categories in which your products are located. If you know the exact category, just select it in the “Product Classifier”. If you don’t know the category, find the product using the search. From the suggested list, select the appropriate category.
  5. In the ‘Step 2: Select the type of template’ section, select ‘Advanced’ and click ‘Generate Template’.
  6. Thus, it becomes possible to download the template in excel format. Open this file and select the ‘Template’ tab at the bottom.
  7. Copy the columns SKU, Price and Availability from the Excel PSQQQ  file and paste into the columns Item_sku, Your price and Quantity in the Amazon template file.  In the ‘country_of_origin’ column, enter the country of origin of this product.
  8. In the ‘update_delete’ column, enter ‘PartialUpdate’ for the product.
  9. Save the file.

Loading Listing Template File to Amazon

  1. Go to the ‘Upload your Inventory File’ tab. In the “File to check” field, click “Choose File” and upload the Excel file. Click on “Check my file”.
  2. The system will check the file and send an error report. In case there are any errors, fix them and try again.
    After all the errors are fixed, you can download the file. Go to ‘Step 2: Upload File’. Click “Choose File” and upload the file here again and click “Upload’.
  3. Amazon will take some time to process the file and update your ads. To check the status, click on the “Monitor Upload Status” button.



OnBuy products update is an international sales channel for companies of all sizes. It is one of the fastest growing online marketplaces. With low selling fees and operations in 51 countries, gives sellers the opportunity to stay competitive in the global market and connect with buyers worldwide.

The API allows to securely communicate with the platform PSQQQ. API OnBuy is necessary to automate the operation of an online store.
The functions of the OnBuy API are focused on quickly uploading product information. The product is identified by the SKU. If the SKU of the product is on the site, it is updated, the price and quantities are updated. If the SKU of the product that we ship from PSQQQ to the site OnBuy is not on the site, a new product will be created.
The main advantage of this method is the automation of the import work without additional settings. Importing products through the API allows you to import all the necessary data (SKU, name, features, images, price, etc.); update prices and quantities on the site; disable products that are out of stock; automatically upload images.
Features of the OnBuy API :
1 Price update
2 Quantity update
3 Create products with images, features, description
4 Scheduler

To set up the integration between PSQQQ and OnBuy, please contact the PSQQQ Support