Catalogs - 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 information about data types, catalog attributes, and data formats, see Import catalog data.
  • 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 Catalog in the left navigation. Click +CATALOG.
  2. Select Upload via HTTP URL.
     

    catalogs_source.png

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

    catalogs_http_preferences.png

  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.

    catalogs_http_source.png

  7. In the File Settings section, select the file format as either CSV, JSON, or XML.
    Note: XML feeds require custom setup. Contact support@blueshift.com for details.
  8. Select the Encoding and the Delimiter that is used.
     

    catalogs_filesettings.png

  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.
     

    catalogs_sample.png

  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.
    • Source attributes in the imported data are auto-mapped to destination attributes in Blueshift.
      • To clear the auto-mapping, click the Clear Destination Attribute Mapping icon.
      • To restore auto-mapped suggestions, click the Reset Destination Attribute Mapping icon.
    • You must select a corresponding destination attribute for each source attribute. Blueshift attributes and Custom attributes are grouped separately in the drop-down list so that you can easily distinguish between them.
      Note: 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.

    catalogs_map_jun23.png

  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.
     

    catalogs_map2.png

  12. Map the Item Category and Item Tags.
    1. Use the Split a field option for Category and Location Item tags if the hierarchy for these is captured in a single field. For example, "Travel > Europe > Italy". If you select the Split a field option, you must select the correct incoming attribute header and then select the appropriate delimiter. In this example, the delimiter is ">".
    2. If the category or tag hierarchy is captured in more than one field in the incoming file, use the Select Field(s) option to select multiple headers. Ensure that each header is a single string and not a delimited value.
  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. You can download the data quality report in JSON or CSV format.

    import_catalog_data_quality.png

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

    catalogs_testrun.png

  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.
     

    catalogs_schedule.png

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

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.