Google Base Feeder Support Thread [OLD]

[countrycharm]

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/goo...l_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.

[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

[countrycharm]

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

If it is not creating all your products try this.
http://www.zen-cart.com/forum/showpo...postcount=2330

[feef]

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/showpo...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

[feef]

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

[countrycharm]

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.

[feef]

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.

[countrycharm]

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

[jdalton]

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"