Feeds via HTTP URL

Integrating your product or content feeds allows Blueshift to include relevant and up to date recommendations in your messages. One way to import catalog data into Blueshift is to set up feeds for JSON or CSV file uploads from your preferred location using an HTTP URL.

Prerequisites

• Prepare the catalog data that you want to import and upload it to your SFTP location. For more information about the catalog information to include, see Catalog Attributes. The data can be uploaded in the following formats:
  • CSV
  • JSON
  • XML
• Keep details of the location’s HTTP URL at hand.

Set up an import task

To set up a catalog import task, complete the following steps:

1. To import catalogs, go to the Setup menu and click Catalogs. Click +CATALOG.
2. Select Upload via HTTP URL.
    

   

3. Add a Name for the task. The import task form opens.
    

   

4. In the Destination section, you can see the type of data being imported as Products.
5. Set up Notification Preferences to send a notification email to the specified email addresses when there is a change in the status of the task or when a certain percentage of records fail during import.
6. In the Source Configuration section, enter the HTTP URL for the file that is to be uploaded.
   

   

7. In the File Settings section, select the file format as either CSV, JSON, or XML.
8. Select the Encoding and the Delimiter that is used.
    

   

9. Sample data consisting of 10 records is fetched from the source file in the HTTP location. This data is displayed in the Configuration section.
    

   

10. Map the fields from the imported data to the fields in Blueshift and specify the Destination Data Type.
    • The Source Attribute Name is the attribute in your file and the Destination Attribute Name is the attribute in Blueshift.
    • You must select a corresponding destination attribute for each source attribute. Only source attributes that are mapped to a destination attribute will be imported.
    • For source data of floating point numeric data type, select the matching data type in Blueshift as Decimal.
    • One column from the source data must be mapped to the product attributes: item_id and item_title and item_url and main_image.

    

11. Specify the item availability pattern. For example, “in_stock” for IN STOCK PATTERN indicates that an item is available and “out_of_stock” for OUT OF STOCK PATTERN indicates that an item is not available.
     

    

12. Map the Item Category and Item Tags.
13. Click Check Data Quality to verify that the imported data has the right values for all the records, based on what the field mapping.
    • Ensure that all fields are mapped.
    • Fix any data quality issues identified for better quality data and to ensure that data import is successful.

    

14. Click Test Run to Destination Data Type is mapped correctly. A maximum of 10 records are fetched during this test run.
     

    

15. Verify that the data mapping is done correctly. Edit the data mapping if required. Click Test Run again after you make the changes.
16. In the Schedule section, set the Start Time for the import task.
17. To set up a recurring task, under Schedule select the Is it a recurring data import? option.
18. Set the frequency using the Task executes every field. You can set the frequency in minutes, hours, days, weeks, or months.
     

    

19. Click Save to save the task.
20. Click Launch to run the import task.

You will receive an email confirmation after the catalog has been uploaded. The email includes information for both processed and failed records.

Import task status

The index page for catalog imports indicates the status for the catalog import task as either Draft, Launched, Paused, or Completed. For more information, see View Catalog Status.