Update pricing for products in bulk

Marketplace Managers can use Product Uploader to bulk-update the following prices:

• Edition Pricing
• Marketplace Prices
• Price Books
• Pricing Plans
• Vendor List Prices
• Wholesale Prices

This feature enables partners to manage pricing changes across ISVs without much effort.

AppDirect enforces a pricing hierarchy model and so prices should be updated in accordance to that. In other words, the Vendor List price should be updated before the Marketplace Sale price.

Note that bulk-changes using Product Uploader can impact pricing across the entire production catalog and so pricing changes should be validated before making them using Product Uploader.

To bulk-update pricing using Product Uploader

📝 Note: If the AppDirect logo appears in the upper-left corner of the page, when Manage > Marketplace appears in this topic, click the grid icon > Switch to | Store, instead.

1. Go to Manage > Marketplace > Products > CATALOG | Product Uploader.

2. Click Download Catalog. From the Select a section to update drop-down, select PRICING | <the dataset you want to update>.

3. Check the Use production catalog data instead of staging catalog checkbox to download the production catalog data, or leave it unchecked to download the staging catalog data.

   📝 Note: Currently this checkbox is enabled when downloading the Wholesale and Marketplace prices datasets only.

4. click Download, a new entry is created in the Activity Log indicating the progress of the download.

5. To download your CSV file, go to the Activity Log, and expand the required activity row. The expanded section displays the total number of products that are in the file, number of products successfully downloaded and the number of products failed to be downloaded.

6. Click the download icon for Products Successfully Downloaded. This file contains the information about the successfully downloaded products.

📝 Note: If there are any errors in downloading, you can view the error file by clicking the download icon for Products Failed to Be Downloaded.

6. Update the prices in the downloaded .csv file.

7. After making the pricing changes, click Update Catalog. In the Update section, from the Select a section to update drop-down select PRICING | <the dataset you are updating>.

8. Check the Update to production catalog data instead of staging catalog data checkbox to update the production catalog data, or leave it unchecked to update the staging catalog data.

   📝 Note: Currently this checkbox is enabled when updating the Wholesale and Marketplace prices datasets only. Also, if you have updated the Production catalog data you cannot update the changes to staging catalog and if you have updated the staging catalog data it cannot be updated to the production catalog.

9. Upload your CSV file by either dragging and dropping the file in the provided space or click the link in the provided space and select the required file.
   

   📝 Note: Ensure that the option in the Select a section to update drop-down corresponds to the changes you have made. For example, if you updated wholesale pricing, select Wholesale Prices.

10. Click Update, a confirmation message dialog appears, click Continue.

    📝 Note: The confirmation message appears only when the datasets Wholesale price, Marketplace price, or Vendorlist price are being uploded to the production catalog.

11. Click Done. The update request is added to the Activity Log.

12. A new entry is created in the Activity Log indicating the progress of the pricing update.

13. To view the files uploaded, go to the Activity Log, and click the arrow to expand the required activity row. Click the download icon to download any of the following options:

    • Total Products Uploaded- This is the original file uploaded.
    • Products Successfully Uploaded - This file contains the information about the successfully processed products. It also contains the post processed information such as product IDs that are generated when a product is successfully uploaded.
    • Products failed to be uploaded- This file contains the information about all the products uploaded along with the products that were not uploaded due to errors. You can fix the errors and re-upload the file.