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 a location using SFTP.
- 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:
- Set up integration of Blueshift with your SFTP location and configure at least one adapter. You must have you SFTP details at hand to set up integration.
Set up an import task
To set up a catalog import task, complete the following steps:
- To import catalogs, go to the Setup menu and click Catalogs. Click +CATALOG.
- Select Upload via SFTP credential.
- Add a Name for the task. The import task form opens.
- In the Destination section, you can see the type of data being imported as Products.
- 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.
- In the Source Configuration section, select the adapter that you want to use for the import task.
- Enter the path where the catalog CSV file is located. You can see the complete file path for verification.
Note: The Host Address and the Destination path are the same as you have set in the adapter that you have selected.
- In the File Settings section, select the file format as either CSV, JSON, or XML.
- Select the Encoding and the Delimiter that is used.
- Sample data consisting of 10 records is fetched from the source file in the SFTP location. This data is displayed in the Configuration section.
- 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.
- 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.
- Map the Item Category and Item Tags.
- 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.
- Click Test Run to Destination Data Type is mapped correctly. A maximum of 10 records are fetched during this test run.
- Verify that the data mapping is done correctly. Edit the data mapping if required. Click Test Run again after you make the changes.
- In the Schedule section, set the Start Time for the import task.
- To set up a recurring task, under Schedule select the Is it a recurring data import? option.
- Set the frequency using the Task executes every field. You can set the frequency in minutes, hours, days, weeks, or months.
- Click Save to save the task.
- 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.