Update a Product Catalog

If you need to add or revise rows of product information within a product catalog, you can perform a partial update through the Data API, via SFTP, or by using the Upload Data wizard in the platform.

When using the Upload Data wizard, you can either drag and drop a file directly into the wizard, or you can input a URL to a dataset file that you store on Amazon S3. Regardless of which of these two upload options you select, the file that you use must be in the CSV or TSV format.

Uploading a File Directly

Follow these steps to add rows to or update existing rows in a product catalog by uploading a dataset file directly to Monetate.

1. Click the upload icon that appears to the far right of a catalog's entry on the All Datasets list page or the Product Catalogs list page, and then select Manual File Upload.

   

2. Select Partial Update and then click NEXT.

   

3. Select Manual File Upload and then click NEXT.

   

4. Drag and drop the file that you want to upload into the wizard.

   

Monetate ingests the file and closes the Upload Data wizard. When the product catalog's details page loads, a message briefly appears that informs you that the file was successfully uploaded. Additionally, PENDING appears where the timeframe of the last update normally appears since the update is in progress.

If the file failed to upload or the platform encountered other errors, you see messages indicating the problem. See Failed Updates in this documentation for more information.

Uploading a File Using an Amazon S3 URL

Follow these steps to add rows to or update existing rows in a product catalog by uploading a dataset file using an Amazon S3 pre-signed URL.

1. Generate the pre-signed URL for the file you want to upload.

   Refer to Sharing objects using presigned URLs in the Amazon Simple Storage Service (S3) user documentation for more information about generating a URL for this purpose.

2. Click the upload icon that appears to the far right of a catalog's entry on the All Datasets list page or the Product Catalogs list page, and then select Manual File Upload.

   

3. Select Partial Update and then click NEXT.

   

4. Select Upload File Using Pre-signed S3 URL and then click NEXT.

   

5. Paste the Amazon S3 URL into the field, and then click FINISH.

   

The Upload Data wizard closes, and then Monetate ingests the file. When the product catalog's details page loads, a message briefly appears that informs you that the file was successfully uploaded from the Amazon S3 URL. Additionally, PENDING appears where the timeframe of the last update normally appears since the update is in progress.

If the file failed to upload or the platform encountered other errors, you see messages indicating the problem. See Failed Updates in this documentation for more information.

Failed Updates

If the platform encounters an error with an update, you see UPDATE FAILED in multiple places within the platform:

• In the LAST UPDATED column for the product catalog's entry on the All Datasets list page and the Product Datasets list page

  

• In place of the last update's timeframe on the product catalog's details page

  

• In the UPLOAD DATE column in the Update History table on the Update History tab

  

Click UPDATE FAILED to view the File Upload Error modal, which contains a brief description of all errors that prevented the platform from performing the update.

Refer to Common Product Catalog Validation Errors for more information about specific errors and how to correct them.