Google Base Issue

Hi,

I'm using Opencart 2.1.0.1 and cannot get the inbuilt Google Base extension to write products to the google_base.xml file

I have checked and there are no products included in the file.

HELP PLEASE!

Regards

John

The google base feed doesn't create a file, once enabled the XML is generated as you hit the Data Feed URL. You can just use that link as the source of your feed in the merchant centre.

The feed url is http://www.yoursite.com/index.php?route=feed/google_base

Hi

When I use that link it uploads successfullu but there are no products?

Regards

I have the same problem. No products show on the feed just the rss heading. I have reinstalled the google base extension, but still the same. Can anybody help as to where I am going wrong. Thanks

Fixed.

To get the Google base RSS file full of products you will need to download and install the Google Category list from here https://support.google.com/merchants/an ... 0081?hl=en choose the taxonomy with numeric IDs in Plain Text file. Once you have downloaded you will need to install the file to your opencart installation. Go to the Googlebase set up page. admin|feeds|googlebase. Click on the green import button at the top right and select the file you have just saved.

Once you have done that you then need to match your categories to the Google category list. Type in the google category box a google category which matches your shop category. Then move down to the next box and select your shop category. Once you have done this click on the blue add category button to store the match.

If you have another look at your feed you should see your products listed for the category selected. Repeat the above for all other categories. I selected just my top level categories as you will end up with duplicate items and google dosn't like them.

Hi ElmTree

I followed your method, download the taxonomy text file and install to my opencart 2.1.0.2.
But I got errors, please see attached file

help please

Regards

Hi All,

I'm getting the following error:
Notice: Array to string conversion in /home/dochsa/public_html/catalog/controller/feed/google_base.php on line 9

Any ideas?

www.dochsa.com

Donovan

Hi

I have added the categories however only 17 of the items are uploading.

I am really stuck what to do. It also says there is an XML formatting error.

Please help.

Regards

John

jrs91 wrote:Hi

I have added the categories however only 17 of the items are uploading.

I am really stuck what to do. It also says there is an XML formatting error.

Please help.

Regards

John

What is your site's URL for google base? My bet is you have HTML in your descriptions that it is choking on but I can't for a fact state that without looking at your feed.

Mike

Hi

The url is https://www.contemporaryspaces.co.uk/in ... oogle_base

Thank you so much

Regards

John

Ok.... I looked at this again.....

<description><![CDATA[<p><span style="font-family: Verdana; color: rgb(0, 0, 0);">The Baird TV Stand With Cupboard is a lovely piece which is extremely heavy duty. Not only can it be used as a TV stand but it may also be used as a sideboard. There is also a storage cupboard to help keep things tidy.</span></p><p><span style="font-family: Verdana; color: rgb(0, 0, 0);"><br>The shelves are made from robust French Oak which has been hand picked, sanded and finally buffed to a beautiful smoothness. 3mm thick mild steel and industrial grade bolts and washers hold everything together.</span></p><p><span style="font-family: Verdana; color: rgb(0, 0, 0);"><br></span></p><p><span style="font-family: Verdana; color: rgb(0, 0, 0);">We can make this item to any size with any of the stain options (Rugger Brown shown) available. Please contact us for any amendments you may wish to make to the item.</span></p><p><span style="font-family: Verdana; color: rgb(0, 0, 0);"><br></span></p><p><span style="font-family: Verdana; color: rgb(0, 0, 0);">As with any oak wood product over time you may see surface cracks appear. If you would like to avoid this happening please let us know you would like Prime Oak to be used.</span></p><p><span style="font-family: Verdana; color: rgb(0, 0, 0); font-weight: bold;"><br></span></p><p><span style="font-family: Verdana; color: rgb(0, 0, 0); font-weight: bold;">Dimensions</span></p><p><span style="color: rgb(0, 0, 0); font-family: Verdana; line-height: 1.42857;"><br></span></p><p><span style="color: rgb(0, 0, 0); font-family: Verdana; line-height: 1.42857;">Length 120cm x Depth 30cm x Height 60cm&nbsp;</span></p>]]></description>

You do have a lot of junk in your descriptions but right now my xml reader is choking and will not load your page... I would say there has to be something in one of your descriptions that is choking but unless I can get yours to load I can't...

I would look for some microsoft characters like that - that ms excel makes into a double like -- and that is one google will choke on...
IF I can find out why the parser will not work I'll look at your site again.

Mike

The error I get is:
An invalid character was found in text content.
Line: 1 Character: 1132
Looking at the last product that it shows:
https://www.contemporaryspaces.co.uk/po ... uxe-cube-4
The description has:
<description><![CDATA[<p style="margin-bottom: 9px; padding: 0px; border: 0px rgb(221, 221, 221); font-size: 13px; vertical-align: baseline;"><span style="color: rgb(0, 0, 0); font-family: Verdana;">This cube 4 set includes a glass topped table, four armchairs with extendable back rests and four footstools.&nbsp;</span><span style="color: rgb(0, 0, 0); font-family: Verdana;">The Luxe Cube 4 set is&nbsp;</span><span style="color: rgb(0, 0, 0); font-family: Verdana;">manufactured</span><span style="color:

Not anything I see right off but a LOT of CSS mixed into your descriptions. Also a lot of oddly placed CSS.

Like between "...Cube 4 set is..." and "manufactured" there is
&nbsp;</span><span style="color: rgb(0, 0, 0); font-family: Verdana;">

My bet is something in all this is being read by google and choking it....

Mike

Hi Mike

Thanks for looking into it.

What would your advice be to fix this?

Regards

John

jrs91 wrote:Hi Mike

Thanks for looking into it.

What would your advice be to fix this?

Regards

John

The first I would remove all of that css and any html on that product. I would look to see if it makes it further. If it DOES make it further then I would then put part of your description back in and try again. If it chokes remove some more of the description and try again... Meaning you'll need to narrow down what part is causing google to choke.

My descriptions have almost no CSS and HTML... I found it causes a lot less problems. (This is actually my real advice).

Mike

Hi

I am trying to work out how to fix this.

It really is problematic and I'm struggling and losing lots of sales.

Regarding googe base feed, i will post my question here.

So, how to modify google base feed (oc 2.0.1.1) to show only products with price above 20€ (for an example)

Is this doable?

Thanks, grazie, danke,
Regards,