Google Base Feed Addon error – EntityRef: expecting

[Gareth Prandle]

Hello,

I’m using Google Base Feed Addon, but I’m having problems with it. I followed your instructions and got product feed url, but when I click on it I get error:

error on line 125 at column 121: EntityRef: expecting ‘;’

Here is the url of the feed: [http://watercoolerking.co.uk/?estore_google_xml_feed=1]

Why is this happening and how can I fix it?

Best regards,

Gareth

[Peter]

Hi, I’m not entirely sure why this error is occurring but when looking at your error page I can see that you have a bunch of images which have names with spaces, eg,

[http://watercoolerking.co.uk/wp-content/uploads/DC798HCS HOT AND COLD CARBONATED Elite Water Cooler Floor Standing WK.jpg]

Just to eliminate the possibility that this might be causing a problem can you please go through all of your product images and ensure that they’re named without spaces. A valid URL should not have any space characters.

Let us know if that solves the issue.

[Gareth Prandle]

Hello Peter,

I will change this, and let you know if this solved problem.

Thanks.

[Gareth Prandle]

Hello, I renamed problematic pictures (also, changed URLs of the pictures in admin panel), but I still get same error and I’m not able to use this feed to add me products to Google Base.

Any other suggestion?

[Peter]

Hi Gareth,

I think your problem lies in the product link you have entered for the “Water Cooler Hot Tap” product.

You appear to have entered a link pertaining to the page when it was in draft mode, ie,:

[http://watercoolerking.co.uk/our-water-coolers/water-cooler-spares/hot-water-cooler-tap/?preview=true&preview_id=527&preview_nonce=683b68586f]

The correct link should have been as follows:

[http://watercoolerking.co.uk/our-water-coolers/water-cooler-spares/hot-water-cooler-tap/]

If you fix this your base feed should work properly.

[Gareth Prandle]

Hello Peter,

Yes, this fixed my problem, but now I have another problem. Although I added Google Product Category (Food, Beverages & Tobacco), when I upload my feed I get error:

Missing recommended attribute: google product category

When I view .xml feed, I also don’t see any line containing my product category.

Best regards

[Peter]

Can you please post a link to your feed which has the problem? I want to see the error for myself.

[Gareth Prandle]

Hello Peter,

here is link: [http://watercoolerking.co.uk/?estore_google_xml_feed=1]

[Peter]

Hi Chris,

When looking at your feed I can see the following two errors which appear to be coming from some other plugin (perhaps “BFT Autoresponder”):

WordPress database error: [Unknown column ‘send_on_date’ in ‘where clause’]

SELECT * FROM wp_bft_mails WHERE days>0 AND send_on_date=0 ORDER BY id

WordPress database error: [Unknown column ‘send_on_date’ in ‘where clause’]

SELECT * FROM wp_bft_mails WHERE send_on_date=1 AND date=CURDATE()

Have you by any chance modified the eStore Google Base Feed addon in any way?

If not can you please try deactivating “BFT Autoresponder” to see if the errors go away.

Regarding the “google product categories” – we are going to update the addon to include this tag in the xml feed. We hope to have an updated version within the next few days.

[Author]

Posts