Before you begin

Product feed

Add product feed

To track new products and their performance, do the following:

Go to Tools > Product feeds > New product feed.
On the Settings tab, click the toggle to enable the feature.
In the Product feed name, enter the title of the feed.
In the Select advertiser drop-down, select the advertiser the product feed relates to.
Select Retrieve from a website. The setting defines the method of adding a product feed into the system (the Add manually option will be added soon).
In the Product feed URL, enter the website that hosts the file.
Optional. In the Username field, enter the name of the user if your site requires this data for access.
Optional. In the Password field, enter the password if your site requires this data for access.
Specify product feed lifecycle:
- In the From date field, specify the date when the system starts importing the product feed into the platform.
- In the Till date field, specify the date when the system stops importing the product feed into the platform.

🔎 This setting is extremely useful for promotional campaigns or seasonal products. For example, you want to import a product feed containing Christmas products only during the holiday season. You can set a start date of December 1st and an end date of December 31st. The system will only import the relevant products during that time period, which can help to keep the user's product data up-to-date.

10. In the Duration field, select the time range within which the system will update product feed data:

Every 1...23 hours
Every day
Every week
Every month

11. In the Root element field, enter the root element that contains product information.

🔎 The root element refers to the top-level key in a JSON file that contains the relevant items. You can easily spot it by opening the file in a JSON-aware editor or browser - just look for the key that holds the data you're interested in.

Simple example:

{  
  "results": [ {}, {}, {} /* ... */ ]  
}

Here, results is the root element, as its value is an array ([...]) containing the items of interest.

A JSON file can be more complex and contain additional fields, but the principle remains the same: we look for the key whose value starts with [ and contains the items we need.

Complex example (JSON):

{
  "currency": "USD",
  "name": "feed name",
  "createdAt": "2025-06-23",
  "lastUpdated": "2025-06-23",
  "meta": {
    "id": "271d54d9-1b5a-4950-bfbd-6c7fd14d7f01",
    "state": "new"
  },
  "products": [
    {
      "id": 101,
      "name": "Wireless Mouse",
      "price": 25.99,
      "inStock": true,
      "productUrl": "https://example.com/products/101",
      "imageUrl": "https://example.com/images/101.jpg"
    },
    {
      "id": 102,
      "name": "Mechanical Keyboard",
      "price": 89.50,
      "inStock": false,
      "productUrl": "https://example.com/products/102",
      "imageUrl": "https://example.com/images/102.jpg"
    },
    {
      "id": 103,
      "name": "27-inch Monitor",
      "price": 199.99,
      "inStock": true,
      "productUrl": "https://example.com/products/103",
      "imageUrl": "https://example.com/images/103.jpg"
    }
  ]
}

Complex example (XML):

<?xml version='1.0' encoding='utf-8'?>
<rss xmlns:g="http://base.google.com/ns/1.0" version="2.0">
<products>
    <product>
      <ProductSKU><![CDATA[sku1]]></ProductSKU>
      <ProductName><![CDATA[Product 1]]></ProductName>
      <Description><![CDATA[Description for product 1]]></Description>
      <Category><![CDATA[Category 2]]></Category>
      <Price>10</Price>
      <CompareAtPrice>12</CompareAtPrice>
      <ProductURL><![CDATA[https://example.com/product1]]></ProductURL>
      <ManufacturerSKU><![CDATA[]]></ManufacturerSKU>
      <ManufacturerName><![CDATA[Brand B]]></ManufacturerName>
      <EAN><![CDATA[]]></EAN>
      <Quantity>0</Quantity>
      <ImageURL><![CDATA[]]></ImageURL>
    </product>
    <product>
      <ProductSKU><![CDATA[sku2]]></ProductSKU>
      <ProductName><![CDATA[Product 2]]></ProductName>
      <Description><![CDATA[Description for product 2]]></Description>
      <Category><![CDATA[Category 3]]></Category>
      <Price>20</Price>
      <CompareAtPrice>22</CompareAtPrice>
      <ProductURL><![CDATA[https://example.com/product2]]></ProductURL>
      <ManufacturerSKU><![CDATA[]]></ManufacturerSKU>
      <ManufacturerName><![CDATA[Brand C]]></ManufacturerName>
      <EAN><![CDATA[]]></EAN>
      <Quantity>0</Quantity>
      <ImageURL><![CDATA[]]></ImageURL>
    </product>
</products>
</rss>

The root element is products because it contains the array of items we need.

Also, to view the structure of the file, you can open it in a browser using the direct link (Product feed URL). This way, you'll see the file's contents and can easily identify the root element.

12. Click Create new product feed.

13. Once you specify all the parameters on the feed creation tab, go to the Mapping tab and specify which fields will be presented in the product feed.

The system adds the product feed to the Product feed table.

⚠️ If the system successfully saved the feed, but then it got invalidated upon the next feed update, then you get the email about the product feed error. Check your product feed to make sure it works correctly.

Please contact the Affise Customer Support team regarding all raised questions via the e-mail: [email protected].