Export Product Data
In Sana Admin click: System > Scheduled tasks. See the Product data export scheduled task.
The Product data export scheduled task exports product data from the Sana product set selected in the Dotdigital app to Dotdigital. Before running the Product data export scheduled task, product information must be already retrieved from ERP by running the Product import scheduled task.
When you connect Sana Commerce Cloud to Dotdigital and run the Product data export task, your product information is shared with Dotdigital so you can use it in your e-mail campaigns. This includes things like the product name, price, description, image, and stock level. With this data on hand, you can build personalized emails − product recommendations, abandoned cart reminders, back-in-stock alerts − without having to enter any product details by hand. If a product has variants − different sizes or colors, for example, each variant is imported to Dotdigital as its own product.
| Field | Description |
|---|---|
| Id | A unique product identifier. |
| VariantId | A unique product variant identifier. |
| Name | The product name. For a variant, this includes the variant name too, for example, "T-shirt, Blue, Medium". |
| Price | The current product or variant price. |
| SpecialPrice | The product or variant list price. |
| Url | The product page URL in your webstore. |
| Sku | The product SKU. For a product without variants, this matches the product ID; for a variant, it's the variant ID. |
| Description | The product description. |
| Stock | How many units are currently in stock. |
| ImagePath | The URL of the medium-sized product image. For a variant, this is the variant's own image if it has one; otherwise, the main product's image is used. |
| Categories | The category or categories the product belongs to. |