Import catalog data from the platform into Content Portal
Export product data from a Productsup site so Content Portal can import it into a catalog.
After you add a catalog, export product data from a Productsup site so Content Portal can import it. Use the Content Portal Catalog export or a Blank export with the Content Portal Catalog destination. Later site runs can update the products in the catalog, if scheduled. After the first successful import, Admins map catalog attributes so search, filters, and assets appear in the portal.
To customize the spreadsheet users download in Content Portal, see Create a custom template for XLSX downloads in Content Portal.
Caution
Until the first successful export run, the catalog in Content Portal stays empty. Add the export, add the destination, complete destination settings, and map attributes in Dataflow. None of these steps is optional. If you omit any of them, product data is not transferred into Content Portal.
Mandatory catalog attributes
The feed must include seven mandatory catalog attributes. Map them in Dataflow and complete the matching dropdowns in destination settings.
| Attribute | Purpose |
|---|---|
id | Unique product identifier |
title | Product name |
description | Product description |
category | Product category |
price | Product price |
image_link | URL of the main product image |
deeplink | URL to the product on your site or shop |
Caution
The attribute names are case-sensitive and must match the list exactly, in lowercase. If an export column is named Title or Image_Link instead of title or image_link, the catalog can still show products, but XLSX downloads and Download assets via email fail. Map destination dropdowns to the lowercase names even when the source column uses different capitalization.
The Content Portal Catalog export, also listed as Content Portal Catalog (Global), already includes these attributes in Dataflow. If you use a Blank export, add the seven attributes as export columns yourself and preserve the exact spelling in the table.
Add the export
Go to Exports in the main menu.
Select Add export.
Search for Content Portal Catalog.
Select Add.
If you use a Blank export instead, add Blank, create the seven mandatory export columns, then continue with the destination steps.
Add the destination
On the Exports page, select the export name.
Select Add Destination.
Choose Content Portal Catalog.
Select Save.
Destination settings
After you select Save, the destination setup page opens. Complete every dropdown before you activate the destination.
In ID, select an attribute that contains unique product identifiers, such as SKU.
In Catalog Identifier, paste the catalog ID from Content Portal. Copy it from the catalog card.
Tip
Paste the catalog ID in Catalog Identifier with the prefix uuid:. For example, uuid:af22423c-8f0e-11e8-981a-1c36bbed83ab.
Select the matching attributes for the remaining mandatory fields: title, description, category, price, image_link, and deeplink.
Toggle Active to On.
Select Save.
Attribute mapping in Dataflow
Go to Dataflow.
Select Content Portal Catalog in the dropdown on the left.
Map the relevant attributes from Import to Intermediate and to Export. You can use Automap connections.
Select Run or Export.
Tip
After the run, open the catalog in Content Portal and confirm that products appear. Then map catalog attributes in Content Portal.
Troubleshoot imports
| What you see | What to check |
|---|---|
| Catalog stays empty | The destination is On, the catalog ID uses the uuid: prefix, and you ran Export after mapping |
| Products appear, but XLSX or asset emails never arrive | The seven mandatory attributes are lowercase in Dataflow and in the destination dropdowns. For custom spreadsheet layouts, see Create a custom template for XLSX downloads in Content Portal |
| ZIP of assets is incomplete | Asset URLs include a file extension such as .jpg or .pdf. See Map catalog attributes in Content Portal |
How is this guide?