12 most common XML feed errors and how to correct them. Part 2

Article published 07.12.2017
12 most common XML feed errors 2

I think we can all agree that having an eCommerce business and running a product campaign on comparison shopping services while not having a flawless product feed can lead to significant loss in sales, especially before Christmas. That’s why we now present you these 12 most common XML feed errors with simple step-by-step instructions how to correct them.

Before we start, let me remind you that you can easily check if your XML feed contains any errors using our free online XML audit. All you need is a URL address of your XML file and an email where the audit results will be sent.

Last week we discussed the first two common product feed errors. Now let’s look at the next ones.

#3 CATEGORYTEXT element has invalid value

To correct this error you can use a special rule in Mergado called “renaming categories in bulk”. Great feature of this rule is that it will offer you suggestions of correct category names of a given comparison shopping service depending on the output XML format that you chose. Just type any character in the field on the right that you think the correct category could contain and the suggestions will automatically appear.

How to rename categories in xml feed

#4 DELIVERY_DATE element is missing or empty

If this element is reported as missing, you need to add it and fill it with a value the same way as in the missing MANUFACTURER element example (error #2, part 1).

It the element is present but does not contain any data, the delivery date must be set, ideally directly in your eCommerce store administration.

#5 PRODUCT element contains inappropriate words

Some comparison shopping services fight against extremely long product names or names containing inappropriate words by banning some words. It can be for example an information about a free gift, free shipping etc. It depends on the comparison shopping service policy and product feed specifications.

How to deal with such situation?

If you know which words from your product names are banned - e.g. free shipping - simply use the “Find and replace” rule. This rule will search all your product names and replace it with an empty character = delete it. We recommend to select the “Regular expression” option which will make the rule more accurate.


How to delete words in an element

In case you have different banned words in your product name you can try using regular expressions.

E.g. you have different two-word offers (free shipping, free gift,...) at the end of your product name. In this case you could use this regular expression in the “Find and replace” rule: (\s*\S+\s*){2}$

This regular expression will find the two words at the end of your product name, including the space before these words. Example: product name “Long sleeve T-shirt free shipping”, the reg. expression will find “ free shipping”.

How to delete words in an element using regular expression

Alternatively you can use this regular expression - \s*-[^-]*$ - that will find any long text at the end of a text up to a dash, including the dash and the space before. Example: product name “Long sleeve T-shirt - free shipping included”, the reg. expression will find “ - free shipping included”.

To see the other articles from the “12 most common XML feed errors and how to correct them” series, go to Part 1 in our blog.

If you need any assistance with your product feed you can describe your issue in our forum or contact us at mergado@mergado.com.

Add new comment