Skip to main content
Importing product data

This guide provides an overview of the product feed integration feature. This feature enables seamless integration of product data into marketing flows, enhancing personalization and engagement in WhatsApp campaigns.

Updated over a month ago

Use cases

  • Enrich product-based Whats with Personalize WhatsApp messages: Events from CDPs such as Emarsys often only provide product SKUs without title or images. By importing product feeds into charles, you can enrich the events within a charles flow using the Define Variable Node

How to configure the Product Feed Import

Before you start, you can check the technical reference to find out about supported file types, max. file size, etc.

To set up the product import visit Integrations > Marketplace.

Enter the Source URL

For SFTP, the URL needs to be in the format: ​sftp://<USERNAME>:<PASSWORD>@<HOST>/<FILE_PATH>.

If the file type is XML, you'll need to select the name of the node that contains the product elements.

Next, configure the field mapping by selecting the columns from your product feed (source field) and the corresponding field on the charles-side (destination field).

You can find detailed information on required and optional fields in the technical reference.

Configure the schedule

The import runs at 12 AM.

After the import runs, you'll be able to see the products in Commerce > Products.

Technical reference

Scheduling the import

The import can be configured to run either daily, weekly or monthly.

Supported data sources and file types

Type

Description

URL Download

Product feeds will be uploaded into charles in the form of CSV or XML file available on the HTTPS secured URL.

SFTP File storage Download

Product feeds will be uploaded into charles in the form of CSV or XML file via a client-owned SFTP. A secured connection is ensured via the exchange of credentials.
​
This is the URL needed for this:
​
​sftp://<USERNAME>:<PASSWORD>@<HOST>/<FILE_PATH>

Supported product catalogue columns

Required fields

Field

Description

sku

Stock Keeping Unit, a unique identifier for products

name

Name of the product

assets_title_image_url

Link to product image

external_link

Link to product detail page

Optional fields

Field

Description

type

Category or type of the product.

price

Contains pricing details for the product.

currency

Currency code (e.g., USD, EUR) used in pricing.

summary

A brief overview of the product. Max length: 16300 characters.

parent

Parent SKU for hierarchical product relationships

assets_gallery_image_url

URLs or references for additional product gallery images

attributes

Additional product characteristics stored as key-value pairs

See errors in the application

coming soon

Currently, we don't show errors that occur during import in the application.

Did this answer your question?