Post by nyltak » Tue Aug 09, 2011 11:50 am

I have browsed thru quite a few posts regarding people's inability to get google base to work, I noticed links to the 'improved' mod that seems like its been around since 1.4.

first attempt at exporting to google merch data feed resulted in zero items found - file not found.
third attempt I got problem
Line Nr. 2 Column Nr. 39 which I have no idea where columns are in a xml file.

Does the google_base work, and is the problem that the links in the xml file includes these special charactors ?route=product/product&product_id=79

New member

Posts

Joined
Wed Jul 20, 2011 9:56 am

Post by uksitebuilder » Tue Aug 09, 2011 3:11 pm

columns numbers are characters in xml

so, view the source of the err'd feed

go 2 lines down and 39 characters across.

User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by Xsecrets » Tue Aug 09, 2011 8:07 pm

it's not a problem with the links. If I remember correctly the problem is generally a & or some other special character in a product name.

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by nyltak » Wed Aug 10, 2011 6:28 am

So if I am reading this correctly, the problem is in the product link urls? Are you going to tell me that google base only will work with seo friendly urls - or do I need to put some more coding bandages on this program again. Fixing and writing php takes me 100 times as long as someone who actually has been educated on php. I have other things I would rathar be doing.

Code: Select all

  <?xml version="1.0" encoding="UTF-8" ?> 
- <rss version="2.0" xmlns:g="http://base.google.com/ns/1.0">
- <channel>
  <title>Homemaker Furniture</title> 
  <description>Household effects, ergonomic homeoffice furniture executive office highend desk chair leather household furnishings homemaker uptown inexpensive modern contemporary conference restaurant dining</description> 
  <link>http://homemakerfurniturestore.com/</link> 
- <item>
  <title>Sarge</title> 
  <link>http://homemakerfurniturestore.com/index.php?route=product/product&product_id=94</link> 
  <description><p> The Sarge is funky and functional task chair made of durable plastic for the seat and back with a steel tube frame. It has a rolling base with adjustable height.</p></description> 
  <g:brand>Zuo</g:brand> 
  <g:condition>new</g:condition> 
  <g:id>94</g:id> 
  <g:image_link>http://homemakerfurniturestore.com/image/cache/data/office chairs/205006_1-500x500.jpg</g:image_link> 
  <g:mpn>205005</g:mpn> 
  <g:price>90.00</g:price> 
  <g:product_type>Chairs</g:product_type> 
  <g:product_type>Chairs > Office Chairs</g:product_type> 
  <g:quantity>100</g:quantity> 
  <g:upc>205005</g:upc> 
  <g:weight>19.00lb</g:weight> 
  </item>

New member

Posts

Joined
Wed Jul 20, 2011 9:56 am

Post by uksitebuilder » Wed Aug 10, 2011 2:37 pm

you need to convert the ampersand to & in the link

User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by nyltak » Thu Aug 11, 2011 9:34 am

I changed the <link> line in google_base.php from:

Code: Select all

$output .= '<link>' . $this->url->link('product/product', 'product_id=' . $product['product_id']) . '</link>';
To:

Code: Select all

$output .= '<link>' . htmlspecialchars($this->url->link('product/product', 'product_id=' . $product['product_id'])) . '</link>';
which resulted in my xml output becoming:

Code: Select all

  <?xml version="1.0" encoding="UTF-8" ?> 
- <rss version="2.0" xmlns:g="http://base.google.com/ns/1.0">
- <channel>
  <title>Homemaker Furniture</title> 
  <description>Household effects, </description> 
  <link>http://homemakerfurniturestore.com/</link> 
- <item>
  <title>Taffy</title> 
  <link>http://homemakerfurniturestore.com/index.php?route=product/product&product_id=79</link> 
  <description><p> This classic bentwood chair is stackable and durable. The Taffy chair has clean modern lines and an unmistakable silhouette. It has a bent wood seat on top of a chrome frame.</p></description> 
It made no difference in the error given by google base xml formating error, line 2 column 39

New member

Posts

Joined
Wed Jul 20, 2011 9:56 am

Post by Ariskos » Mon Sep 05, 2011 4:09 pm

Same here google base product feed doesn't work on my site too.
I am using oc 1.5.1.1 and my google base url is:
http://atom.gr/index.php?route=feed/google_base
Did anyone found any solution? If not, is there any extension which we can do our work with it?

Web Developer specialized in Opencart. Visit my extensions:
(1)SKU Generator 1.5.x / (2) Opentasks


User avatar
New member

Posts

Joined
Wed Jun 08, 2011 9:28 pm
Location - Athens

Post by jenner » Wed Sep 07, 2011 8:59 pm

When I try and look at my feed all I get is errors about weight class. Does this mean all of my products need weights added to them?

Newbie

Posts

Joined
Tue Jan 18, 2011 10:47 am

Post by uksitebuilder » Wed Sep 07, 2011 9:07 pm

It means you need to edit catalog/controller/feed/google_base.php

find occurrences of weight_class and change to weight_class_id

User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by nyltak » Sun Sep 11, 2011 3:03 am

I have still yet to get this google_base to work the way it should. I can go to my link and save the resulting file as xml, and upload that to google, and it works fine, but if I just give google the direct link to my sites google_base I get errors. I think it is a problem with the headers that google recieves from the link, but I am not sure.

New member

Posts

Joined
Wed Jul 20, 2011 9:56 am

Post by uksitebuilder » Mon Sep 12, 2011 9:54 pm

the content you copy from the page will have the same headers so I doubt it is that.

it is probably due to a timeout feature that Google gives up waiting for the feed to be produced when trying to fetch it, maybe because you have a lot of products.

User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom
Who is online

Users browsing this forum: No registered users and 1 guest