Adding your own product feed will allow you to use your products from your own product database. This means that you don't need to add all products manually, but you can always work with all the products that are available.

There are different requirements and settings that you should keep in mind in order to provide you with the optimal settings. We'll go through all of them in this article.

Requirements

There are 3 requirements that you can check before getting started importing your feed: the file format, the used delimiter, and 3 must-have columns.

Format

The first one being that your file must be a CSV file accessible online. Learn more about CSV files here. Please contact your developer if you don't know where to get this.

Delimiter

There are two types of delimiters currently allowed in your file: 

  • comma ( , )
  • semicolon ( ; )

Must-have columns

Your product feed must have the following fields with information containing (choosing the names is up to you):

  • ID: a unique ID that products from your database have (suggested name: product_id)
  • Name: the name of the product (suggested name: product_title)
  • URL: the link to your product where visitors can find more information or purchase the item (suggested name: product_url)

These fields are required fields, notice that all your other fields in your feed will be imported as well as additional fields.

Connecting your feed step-by-step

Step 1: Navigate to the assets tab

Starting from the dashboard, the landing page after you log in, click on Assets and then Feeds to go to the correct page.

Step 2: Click "Add feed" 

After clicking Add feed, a new window should pop-up.

Step 3: Fill in information about your feed

In this window, you can give your feed a name. We suggest using a short but descriptive name so you and your colleagues will know where certain products came from. You can always change the Name and Update frequency settings later. 

Note: It is not possible to edit the URL once it is imported.

Below the Auto-update title, you can find a dropdown menu where it's possible to select the update frequency. Below this step-by-step guide, you will find more information about what this means and which options to pick.

After you have filled in all fields, click "Next" to continue.

Step 4: Validate your feed

After step 3, you will see this window.

Note: the rows displayed are only a sample preview, the rest of your data will be imported later.

Here you can see if your feed is interpreted correctly, you need to check a few things:

  • Do you see your own products? Maybe you imported a wrong feed
  • Do you get any errors? Try changing the delimiter.
  • Do the column titles line up with the correct information? Maybe your CSV file is corrupt. 

When everything looks normal, click "Next" to continue.

Step 5: Map your fields to the required fields

After step 4, you should see this window.

At the beginning of this article, you learned about the must-have fields of your feed. In this window, you can map the correct must-have fields to the corresponding columns.

As a reminder, these fields are necessary in your feed:

  • ID: a unique ID that products from your database have (suggested name: product_id)
  • Name: the name of the product (suggested name: product_title)
  • URL: the link to your product where visitors can find more information or purchase the item (suggested name: product_url)

These fields are required fields, notice that all your other fields in your feed will be imported as well as additional fields.

  • Optionally: when your products have an image, you can select it under Image(s) as well. This should be a URL to your image. When you have multiple images per product, you can select these as well.
  • Optionally: when your feed contains multiple languages, you can set this as well.

When the column of your product name is "product_name". You should select it as a "Name" in the dropdown menu.

When you feel like all fields are mapped correctly, click Connect feed to continue.

Step 6: See the status of your feed

On the Feeds tab from Step 1, you can see the current status of your feed.
It can take a few minutes before your feed is imported depending on the size of your feed.

When you see a Connected below your feed name, your feed is imported successfully. 

Auto-update

Auto-update takes care of keeping your products in Spott exactly the same as the products from your own system. They will make your products update dynamically. By selecting a suitable time interval, Spott will go through the feed and update all assets. Including the assets that are currently live on your website.

Example: when you adjust the price in your own product management system, all interactive content made on Spott will adjust itself accordingly. This means that you don’t need to do anything after a one-time set-up.

You can turn on auto-update by selecting a time interval. This can be adjusted to any of the following time intervals:

  • Once an hour
  • Once a day
  • Once a week
  • Once a month

If you don’t need to use the auto-update feature, you can disable auto-update by setting this option to “Disable”. This can be the case if you don't want your products to update.



Did this answer your question?