Google Base Feeder Support Thread [OLD]

ZeeRocK:

Hello all,

When I view my products feed the url is www.mysite.com/feed/domain_products.xml and you see all the products there, but when you click on any of the product links I get 404 error and the url looks like www.mysite.com/language/en/category/manufacturer/product_name

Obviously I don't have language (en) in my urls. I have looked into my google base feed admin and there's nothing there. I also use site_map XML module which is working fine.

I have 1.3.8a version and 1.7.4 (latest) version for google base. Anyone also encountered this problem ? How to get rid of that english instance from my urls.

Thanks.
You can check your store admin/configurations/google_base and see what you have set it for. Show Feed Language true or false. You also need to upgrade to the latest version of Google base. See my post above for that.

countrycharm:

You can check your store admin/configurations/google_base and see what you have set it for. Show Feed Language true or false. You also need to upgrade to the latest version of Google base. See my post above for that.

Hello there,

Thank you everything is sorted. For some reason when I don't fill up Query limit and Query offset, it creates products but same language problem, but when I set a query limit it loads products and language problem is also gone. Not sure what causes this problem.

My feed gets disapproved with in 2 minutes of uploads for the last 2 months or so and before it was all ok. I have contacted google and they just sent me an automated mail.

I'm pretty much sure its not the module but something to do with my site and I'll keep looking for the solution.

Thank you for your help.

Enjoy your weekend. :bigups:

I have been using this module for approx 6 weeks now with no issues until lately. Google stopped listing my products eventhough there was no error in my google base account. On querying google I got the following response..

"Please note, CDATA is a special notation for data that allows you to use & (and ONLY &). Therefore, should not be used for
any other characters."

So how can I disable CDATA if that is what is required? I noticed in the google_base.php file that CDATA is set to false

function google_base_xml_sanitizer($str, $cdata = false) {

however it appears in the xml feed??

http://www.ethoil.com/store/feed/google/ethoil_products.xml

jdalton:

I have been using this module for approx 6 weeks now with no issues until lately. Google stopped listing my products eventhough there was no error in my google base account. On querying google I got the following response..

"Please note, CDATA is a special notation for data that allows you to use & (and ONLY &). Therefore, should not be used for
any other characters."

So how can I disable CDATA if that is what is required? I noticed in the google_base.php file that CDATA is set to false

function google_base_xml_sanitizer($str, $cdata = false) {

however it appears in the xml feed??

http://www.ethoil.com/store/feed/google/ethoil_products.xml

Swap out your google_base.php code with this one and see if it will make a difference. Download it from here.

In \includes\classes\google_base.php make a backup and upload the new google_base.php Maybe this will solve your problem.

I've just installed google base feeder and got it working, to some extent...

The output from the cron shows everything seems to work as expected, with no errors, except that it only parses 23 products.

The 23 products it does parse, I can see in the google merchant system fine, but why isn't it doing the entire catalogue.

I can't find any reference to a threshold anywhere.

Any ideas?

tia

a

countrycharm:

Swap out your google_base.php code with this one and see if it will make a difference. Download it from here.

In \includes\classes\google_base.php make a backup and upload the new google_base.php Maybe this will solve your problem.

I have applied the new google_base.php file. However when creating a new xml file it now created two new files ethoil_products.xml & ethoil.xml?? The CDATA attribute is found on both? I have uploaded the ethoil_products.xml to google anyway to see if that makes any differences. Should know either way in 24-48hrs...

jdalton:

I have applied the new google_base.php file. However when creating a new xml file it now created two new files ethoil_products.xml & ethoil.xml?? The CDATA attribute is found on both? I have uploaded the ethoil_products.xml to google anyway to see if that makes any differences. Should know either way in 24-48hrs...

Just got an error now on my google base account after uploading the new feed?

"No items inserted"

jdalton:

I have applied the new google_base.php file. However when creating a new xml file it now created two new files ethoil_products.xml & ethoil.xml?? The CDATA attribute is found on both? I have uploaded the ethoil_products.xml to google anyway to see if that makes any differences. Should know either way in 24-48hrs...
When it creates the 2 files, one of them will not work because there is nothing in the xml file. The other one is the one you need to upload to google. Click on view to see your data file before uploading it to google. I don't use the auto feature that google base offers, I go to google and upload it from there. You can set a time within google merchant center to automatically retrieve your data feed file whenever you want it to. Make sure your data feed file name you created with google is the same as your out put file name or google will reject it. The file you downloaded from me is the one I have being using a long time and google always accepts all my product.

feef:

I've just installed google base feeder and got it working, to some extent...

The output from the cron shows everything seems to work as expected, with no errors, except that it only parses 23 products.

The 23 products it does parse, I can see in the google merchant system fine, but why isn't it doing the entire catalogue.

I can't find any reference to a threshold anywhere.

Any ideas?

tia

a

Is your script timing out or does it create all your product in the XML file.
If your script is timing out, in the root of your server (not store root), create/open a file called php.ini and add the following lines:

max_execution_time = 300
max_input_time = 90
memory_limit = 32M

countrycharm:

When it creates the 2 files, one of them will not work because there is nothing in the xml file. The other one is the one you need to upload to google. Click on view to see your data file before uploading it to google. I don't use the auto feature that google base offers, I go to google and upload it from there. You can set a time within google merchant center to automatically retrieve your data feed file whenever you want it to. Make sure your data feed file name you created with google is the same as your out put file name or google will reject it. The file you downloaded from me is the one I have being using a long time and google always accepts all my product.

Both files seem to work... see both links below?

http://www.ethoil.com/store/feed/google/ethoil_.xml
http://www.ethoil.com/store/feed/google/ethoil_products.xml

I used the ethoil_products.xml as that is file I have created on google base??

I used the upload feature in admin>tools to upload the new file...

jdalton:

Both files seem to work... see both links below?

http://www.ethoil.com/store/feed/google/ethoil_.xml
http://www.ethoil.com/store/feed/google/ethoil_products.xml

I used the ethoil_products.xml as that is file I have created on google base??

I used the upload feature in admin>tools to upload the new file...

The bottom link does like I said nothing in it except
XML Parsing Error: no element found
Location: http://www.ethoil.com/store/feed/google/ethoil_products.xml
Line Number 1, Column 1:
This is what mine does also. Nothing to worry about on that one.
The other one is the one you need to upload.

Is that all you have 9 products in your feed?

I used the upload feature in admin>tools to upload the new file...

Try going straight to Google base merchant center and uploading your file. I never like this feature because it has always cause problems.

countrycharm:

The bottom link does like I said nothing in it except
XML Parsing Error: no element found
Location: http://www.ethoil.com/store/feed/google/ethoil_products.xml
Line Number 1, Column 1:
This is what mine does also. Nothing to worry about on that one.
The other one is the one you need to upload.

Is that all you have 9 products in your feed?

I used the upload feature in admin>tools to upload the new file...

Try going straight to Google base merchant center and uploading your file

so I need to upload the ethoil_.xml file.... yep there are the nine products

jdalton:

so I need to upload the ethoil_.xml file.... yep there are the nine products
Yes thats right. Try this create a new feed in the google merchant center named ethoil.xml

Google base when it creates your feed puts and _ at the end of ethoil file. What I do is go to my sever when it creates it and take off the _ at the end of the name. Goole always excepts my files. Hope this make sense.

countrycharm:

Yes thats right. Try this create a new feed in the google merchant center named ethoil.xml

Google base when it creates your feed puts and _ at the end of ethoil file. What I do is go to my sever when it creates it and take off the _ at the end of the name. Goole always excepts my files. Hope this make sense.

I have created the new file on google ethoil_.xml & have uploaded it... Google looks to have accepted it so just need to wait now for a day or so for my new products to show!! hopefully!!

jdalton:

I have created the new file on google ethoil_.xml & have uploaded it... Google looks to have accepted it so just need to wait now for a day or so for my new products to show!! hopefully!!

I think they will. Just setup a schedule for them to craw your feed every week, month etc.

countrycharm:

Is your script timing out or does it create all your product in the XML file.
If your script is timing out, in the root of your server (not store root), create/open a file called php.ini and add the following lines:

max_execution_time = 300
max_input_time = 90
memory_limit = 32M

If it is not creating all your products try this.
http://www.zen-cart.com/forum/showpost.php?p=905433&postcount=2330

No errors:

Google Base Feeder v1.7.4 started 2010/07/06 18:50:11
Feed file - /path/to/feed/products.xml
Processing: Feed - Yes, Upload - Yes
Google Base File Complete In 1.389645 Seconds 23 Records
Upload started...
Uploaded Successfully
-r--r----- 1 ftp ÷ root ÷ 22920 Jul 6 10:50 products.xml
Connected to: uploads.google.comLogin ok:Current Directory Is: /-r--r----- 1 ftp ÷ root ÷ 22920 Jul 6 10:50 products.xml

Upload ok!

Nothing in /var/log/apache2/error.log either.

I tried downloading that ZIP file you linked to, but it's spitting an error when I try to decompress it, either on the server or on my desktop. (I'm using Ubuntu on my laptop, and Debian on the server)

The XML only has 23 products too.

The script is being called by...

googlefroogle.php?feed=fy_uy_tp

running the select manually returns all 743 products

Running the select from within the googlefroogle.php page gives the full products listing (743 products)

SELECT distinct(p.products_id), p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight
FROM products p
LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN products_description pd ON (p.products_id = pd.products_id)
LEFT JOIN product_types pt ON (p.products_type=pt.type_id)WHERE p.products_status = 1
AND p.products_type <> 3
AND p.product_is_call <> 1
AND p.product_is_free <> 1
AND pd.language_id = 1
GROUP BY p.products_id
ORDER BY p.products_last_modified DESC

feef:

No errors:

Google Base Feeder v1.7.4 started 2010/07/06 18:50:11
Feed file - /path/to/feed/products.xml
Processing: Feed - Yes, Upload - Yes
Google Base File Complete In 1.389645 Seconds 23 Records
Upload started...
Uploaded Successfully
-r--r----- 1 ftp ÷ root ÷ 22920 Jul 6 10:50 products.xml
Connected to: uploads.google.comLogin ok:Current Directory Is: /-r--r----- 1 ftp ÷ root ÷ 22920 Jul 6 10:50 products.xml

Upload ok!

Nothing in /var/log/apache2/error.log either.

I tried downloading that ZIP file you linked to, but it's spitting an error when I try to decompress it, either on the server or on my desktop. (I'm using Ubuntu on my laptop, and Debian on the server)

The XML only has 23 products too.

The script is being called by...

googlefroogle.php?feed=fy_uy_tp

The zip file is created by WinRAR so try downloading a copy of that and unzipping it.
If google base is creating all 723 product, go to google merchant center and try uploading from there and see what happens. I personally don't like uploading them from the google base ftp anyway. to many mistakes happen.

countrycharm:

The zip file is created by WinRAR so try downloading a copy of that and unzipping it.
If google base is creating all 723 product, go to google merchant center and try uploading from there and see what happens. I personally don't like uploading them from the google base ftp anyway. to many mistakes happen.

Ignore me... I'm a muppet.

Turned on simple debugging and spotted that a lot of products weren't being included as their descriptions are too short.

For many of our products, the product name is more than enough info and there's no additional description. I've modified the SQL select to use the product title as the description when the product description is a zero-length string.

Job done.

btw, Zip should be a standard across all OSs.. it sounds like your WinRAR is doing something strange to the zipfile if I can't open it in Ubuntu.

feef:

Ignore me... I'm a muppet.

Turned on simple debugging and spotted that a lot of products weren't being included as their descriptions are too short.

For many of our products, the product name is more than enough info and there's no additional description. I've modified the SQL select to use the product title as the description when the product description is a zero-length string.

Job done.

btw, Zip should be a standard across all OSs.. it sounds like your WinRAR is doing something strange to the zipfile if I can't open it in Ubuntu.

Glad you got it figured out. No the zip works just fine. I just checked it. jdalton downloaded it and unzipped it also. Thats strange. Anyway