Publitas supports importing both XML and TSV product feeds, available via a web address or an (S)FTP location. Click here for more information about setting up a product feed for Publitas.
Why is the product feed not importing successfully? It can happen that a feed fails to import correctly. Usually when a feed does not import correctly this either has to do with the formatting of the data or the hosting of the feed. With this article we hope to help you troubleshoot these incidents and import your product data successfully.
If you need help troubleshooting your product feed, feel free to reach out and share the feed URL with our support team at firstname.lastname@example.org.
In this article:
- Troubleshooting error messages
- Troubleshooting the feed's hosting
- Troubleshooting the feed's formatting
Troubleshooting error messages
In the Product Feed menu, recent imports are logged. Below are you can find the different log entries explained:
- X products imported. This indicates a successful import, reporting the number products that have been imported. If less products are imported than you know are in the feed, it means not all products have a unique id. If multiple products share the same product id, only one of them gets imported into Publitas (read more).
- WARNING: only X of Y products imported. The id and title attributes are required elements for products to be imported. If one of the required elements is not present, the product will not be imported.
- 300000 products imported. This is not really an error message but if your feed contains more than 300.000 products Publitas will only import the the first 300.000 products. This is the maximum number of products that can be imported from a single feed.
- Feed not found or invalid. This indicates that the system was not able to access the data or process the data correctly, in which case the next chapter will help you troubleshoot the issue.
Troubleshooting the feed's hosting
To import a product feed, our system requires access to the server where the feed is being hosted. It can happen that the server has security measures in place that restrict access, blocking our platform from downloading the hosted product feed. The importing of a feed can also fail if the feed URL redirects traffic to the download URL.
- Make sure traffic from the EU is not blocked.
- Avoid redirecting traffic by making sure the feed URL directly points to the feed file.
- If you are using a Web Application Firewall (WAF) that filters out traffic from our system, whitelist the following user-agent string: requests Publitas-FeedImport 078DGH579984
Troubleshooting the feed's formatting
When an XML feed fails to import into Publitas this is usually caused by one of the following reasons:
- The feed is not UTF-8 encoded
- The feed syntax is incorrect
The content of the feed needs to be UTF-8 encoded. If the feeds contains characters that are not UTF-8 encoded the import may fail. Make sure the first line in an XML feed reads:
<?xml version="1.0" encoding="UTF-8"?>
You can find the required syntax in Setting up your Product Feed. Often, syntax errors occur when the following elements are not correctly set up:
- Apply the RSS 2.0 syntax:
line 2: <rss version="2.0" xmlns:g="http://base.google.com/ns/1.0">This format requires the products to be listed as items (<item>...</item>) and all items be enclosed in a single channel (<channel><item>...</item><item>...</item></channel>)
- Make sure the g: prefix is applied to the following attribute at least:
- Use lower case characters only in the attribute names
- Product ids and titles cannot be empty
When a TSV feed fails to import into Publitas this is usually caused by one of the following reasons:
- Incorrect headers
- Descriptions include additional tabs
- Missing title and/or IDs
- Prices use a thousands-separator
Make sure the correct headers are used in the TSV file. You can find the required headers here.
Also make sure to remove additional spaces before or after the headers and to use lower case characters only.
Descriptions include additional tabs
The TSV format uses Tab Separated Values. Think of it like an Excel sheet where each line in the feed is a row and where each tab separates the columns. Sometimes product descriptions use tabs to indentation to the content. If this tab is also stored in the feed it disrupts the required tab sequence to complete the import. This is why you should avoid additional tabs being added to the descriptions or any other attribute.
TIP: If you import the TSV in Excel or Google Sheets, you'll see if additional tabs indeed compromise the feed. When you scroll down the imported list you'll notice rows where part of the content is shifted to the right. In these rows, an additional tab is present.
Missing title and/or IDs
Usually, this does not trigger the import to fail, instead, these particular products won't be imported.
Prices use a thousands-separator
When the thousand separator is used for the prices in the feed (e.g. 1,000.00 ends up in Publitas as 1.00), it can help to remove the thousand separator and try again (e.g. 1000.00).
TIP: Also make sure to use a dot for the decimal separator instead of a comma.
If you need help troubleshooting your product feed, feel free to reach out
and share the feed URL with our support team at email@example.com.