Update existing products in bulk

As a Marketplace Manager you can bulk update product information to your Staging Catalog. Marketplace Managers are typically required to update pricing across multiple products and product editions. These are recurring processes, so manually updating pricing information is time-consuming and inefficient. Using Product Uploader, you can easily download product files and bulk-update pricing.

You can also update custom attributes for products. Customers may have products with custom attributes that require updates from time to time. Use Product Uploader to update the attribute values. Product attributes are defined on the Custom Attributes page (Manage > Marketplace > Settings > Custom UI | Custom Attributes). Although you can update the attribute values using Product Uploader, you cannot change the attribute key or definition.

To update existing products using the Product Uploader

📝 Note: This documentation page may refer to Manage > Marketplace in navigation steps. If the Manage option is not available in your navigation, click the grid icon on the top-left corner of your header and click Marketplace.

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

2. Click Update Catalog.

3. From the Select a section to update drop-down, select one of the following:

   • PRODUCTS

     • Product Editions: Consists the Product UUID, edition UUID, edition code, edition name, feature title, feature description, locale in which the edition of the product is available, target audience, position or the display order of the edition, unit transfer fields to indicate if the edition supports unit transfers and eligibility checks, and the visibility of the edition on the marketplace.
     • Product Basics: Consists information such as Product UUID, name, type, descriptions, vendor details, splash title and description, embedded videos if any, support phone and email details, and custom integration details like if it is a Google, Microsoft, or Adobe product.
     • Product Benefits: Consists the product reference id and the benefits associated with that product.
     • Product Custom Attributes: Consists product id, reference id, name, and the attribute details such as attribute key, label, value, and so on.
     • Product Features: Consists the product reference id and the description of the features associated with that product.
     • Product Feature Characteristics: Consists the product reference id and the details of the feature characteristics associated with that product such as characteristic position, image, and highlight description.
     • Product Images: Consists image details like the product reference ID, locale, product name, image identifier, image type, and image name.
     • Product Media and Resources: Consists of media and resources related details of the products. This is a ZIP file which consits of two separate CSV files, one for Media and one for Resources.

   • PRICING

     • Edition Pricing: Consists information such as the product and edition UUIDs, the trial period details, revenue model, whether the edition is restricted, if the edition can be upgraded, downgraded, or canceled, and the included items amount.

     • Marketplace Prices: Consists of information such as, vendor id, name, product id, UUID, and name, edition UUID, name, and code, pricing plan UUID, billing frequency, service length, contract and flat fee details, and unit details such as unit price, minimum and maximum units, unit currencies. The contract prices, flat fee prices, and unit prices include the commission or discount charged on top of Vendor list price.

     • Price Books: Consists of information such as, pricebook ID, name and start date, product and edition reference IDs and names, pricing information for contract fees, flat fees and setup fees and so on.

       📝 Note: Currently only updating of Prices in a Price Book is supported.

     • Pricing Plans: Consists of information regarding the product, editions, contract terms, usage options, and pricing details for each.

     • Vendor List Prices: Consists of information such as, vendor id, name, product id, UUID, and name, edition UUID, name, and code, pricing plan UUID, billing frequency, service length, contract and flat fee details, and unit details such as unit price, minimum and maximum units, unit currencies. The contract prices, flat fee prices, and unit prices are the Developer list prices set by the Developers, this is the price that they recommend marketplaces charge for the products.

     • Wholesale Prices: Consists of information such as, vendor id, name, product id, UUID, and name, edition UUID, name, and code, pricing plan UUID, billing frequency, service length, contract and flat fee details, and unit details such as unit price, minimum and maximum units, unit currencies. The contract prices, flat fee prices, and unit prices include the commission or discount charged on top of Vendor list price set by the reseller.

   • INTEGRATION

     • Product Integrations - Consists of information such as product reference ID, locale, product name, product integration id, subscription create notification URL, Product Settings Validation URL and other integration related fields.
     • Product Integration Credentials - Consists of information such as, Product reference Id, product name, product integration Id, outbound credentials, token endpoints, client Id, client secret, scope, username and password.

     📝 Note: Currently only the outbound credentials bulk update is supported. Also, in the Integration Credential .cvs file the Client Secret and Passwords are not downloaded due to security reasons.

   • MARKETPLACE PRODUCT SETTING

     • Attribute - Consists of information regarding the product setting attributes such as, product Id, product reference Id, product name, attribute Id, attribute name, is the attribute required or not, attribute option Id, attribute option name, and is the attribute option selected or not.
       📝 Note: You can only bulk update the 'Is Option Selected' column.
     • Billing - Consists of information such as tax code, billing cycle day and patterns, subscription suspension logic, SKUs and so on. Users can download the billing file which contains the existing configured information and update the required values.
     • Category - Consists of information such as, product Id, product reference Id, product name, category Id and name, status of the category whether the category is selected for the product or not, sub-category id and name, and sub-category status that displays which sub categories are selected for the product.
     • General - Consists of information such as, product Id, product reference Id, status of the product if it is visible on the Network or not, status of the child product if it is visible or not, status of the product if it is visible on the marketplace or not, and whether the product is available for the reseller or not.
     • Product Line - Consists of information such as, product Id, product reference Id, product name, line id, product line name and the status of the product whether it is associated with a product line or not.

     📝 Note Currently these options are not enabled by default. Contact your AppDirect technical representative to request it.

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

5. Click Download Catalog. The product file for the section you selected is created and displayed in the Activity Log.

6. To download your Staging Catalog product file, go to the Activity Log, and click the down arrow to 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.

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

8. In the downloaded file, update the specific fields that you want to change and save the file. You can also update the files in multiple languages if required.

   📝 Note: Retaining the details in En-US (English) language is mandatory. Also, all the headers are always in the En-US (English) language. The language support does not apply to the Pricing attributes.

9. Remove the rows that you do not want to update from the CSV format file.

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

11. Click Update.

    📝 Note: A confirmation message dialog appears when the datasets Wholesale price, Marketplace price, or Vendorlist price are being uploded to the production catalog. Click Continue.

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

13. To view the files uploaded, go to the Activity Log and 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.
    • 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.