Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
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/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
Re: Google Base Feeder Support Thread
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
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
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.
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
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.
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
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
Re: Google Base Feeder Support Thread
unfortunately my products are still not showing up on a search? Any other ideas??
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
countrycharm
I think they will. Just setup a schedule for them to craw your feed every week, month etc.
Unfortunately my products are still not showing up on a search. Any other ideas??:(
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
jdalton
Unfortunately my products are still not showing up on a search. Any other ideas??:(
Is Google accepting them in Google Merchant Center? If they are they are being listed somewhere.
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
countrycharm
I think they will. Just setup a schedule for them to craw your feed every week, month etc.
Quote:
Originally Posted by
countrycharm
Is Google accepting them in Google Merchant Center? If they are they are being listed somewhere.
They are being listed in my google merchant account with no errors reported. It never showed any issues in my merchant account!
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
jdalton
They are being listed in my google merchant account with no errors reported. It never showed any issues in my merchant account!
Click on products in the Google merchant account. Click one of your products and see what it looks like. Copy the name of the product, open a new browser to Google.com, go to the top of the page click shopping, enter your product name and search for the name of your product and store name. You should see it there.
