Google Base Feeder Support Thread [OLD]

I am giving it a shot. I did see that Google Base requires a UPC so I have a feeling my file may get rejected. Hopefully not!

So far so good... they are showing up! Now to get Zen to handle the load!

UPDATE!

Google Base has alerted me, as I had just completed the Google Base Adwords support, that they are discontinuing Google Base Adwords.

Please revert back to v1.3.8 until I release v1.4.1 which will also allow you to feed only certain categories. Should be ready in the next few days.

v1.4.1 - GOOGLE BASE FEEDER

1. Removed Google Base Adwords;
2. Allow category selection;
3. Module now known as Google Base Feeder;#2 was completed as a special request by a user in this thread. I will consider requests for the Google Base Feeder, but please donate as a lot of time and effort is put into updating this module.

numinix:

• GOOGLE BASE FEEDER
  Module now known as Google Base Feeder.

Time to create a brand new thread titled "Google Base Feeder support" or similar ;-)

Woody

Numinix,

I uggraded to the current version ( I was two back) and I still get the same message when I try to see the files in google base:

Froogle Merchants FTP content:
Connected to: uploads.google.com
Connection failed: uploads.google.com
I do have the correct username / pw in the cart. It does create the file but I have to manually load it in google base to make it work. Any suggestions?

Hi

This is the error I am getting

It is a fresh install of the 1.41 on zen 1.37 , I set the feed and his folders to 777

Froogle Data Feeder v.1.4.1 09.07.2007 12:00 started 2007/07/09 16:22:35
Feed file - /home/tiledepo/public_html/store/feed/GOOGLE_FROOGLE_OUTPUT_FILENAME
Processing: Feed - Yes, Upload - No
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY p.products_id ASC' at line 13
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, pc.categories_id, cd.categories_name, c.parent_id 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) LEFT JOIN products_to_categories pc ON (p.products_id = pc.products_id) LEFT JOIN categories_description cd ON (pc.categories_id = cd.categories_id) LEFT JOIN categories c ON (c.parent_id = pc.categories_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_id ASC]

please advice

p.s i tought i already post it here, for some reason i dont see my earlier post
Thank you

I got it to work

Just run the sql file again and it all ok now

PastGenToys:

Numinix,

I uggraded to the current version ( I was two back) and I still get the same message when I try to see the files in google base:

Froogle Merchants FTP content:
Connected to: uploads.google.com
Connection failed: uploads.google.com
I do have the correct username / pw in the cart. It does create the file but I have to manually load it in google base to make it work. Any suggestions?

You are using the FTP username and password and not your Google Base account settings right?

I got it to work

Just run the sql file again and it all ok now

It clearly says to cut and past the SQL file and not use UPLOAD in order to avoid any errors.

Woodymon:

Time to create a brand new thread titled "Google Base Feeder support" or similar ;-)

Woody

The mod name was changed automatically when I upgraded to 1.4.0b so I thought I might as well make it official. I'll just get this thread renamed.

numinix:

You are using the FTP username and password and not your Google Base account settings right?

I am using the FTP creds. I tested that by using the same creds to open the actual FTP site within Google Base.

Oops, the error you are getting has nothing to do with your login information. Your host isn't connecting to Google. This part of the script was written previous to my updates so I am not too familiar with the requirements for the ftp_connect() functions used in the script. Try contacting your host.

Also, could you please time the length it takes to return the "connection failed".

The script uses the default timeout of 90 seconds.

Try changing the code on line 366 and 368 from:

 
if($ssl)
   $cd = ftp_ssl_connect($url);
  else
   $cd = ftp_connect($url);

to:

 
if($ssl)
   $cd = ftp_ssl_connect($url, 21, 120); // port 21: timeout: 120 seconds
  else
   $cd = ftp_connect($url, 21, 120);

Ill give that a shot. Can you verify the exact path and file I need to update. I am rather new and dont want to create a bigger mess for my self. Thanks!

Hi All

I have just installed the foogle feeder mod, but I click step one to produce feed, then go on step two to upload feed and get the following
message
Warning: ftp_rawlist() [function.ftp-rawlist]: php_connect_nonb() failed: Connection timed out (110) in /home/mysite/public_html/shop/googlefroogle.php on line 406
Upload Failed

Connected to: uploads.google.comLogin ok:Current Directory Is: /Warning: ftp_put() [function.ftp-put]: php_connect_nonb() failed: Connection timed out (110)

I have put my google base ftp name and password in the settings, and (think) I have done everything right on my google base, can anyone help.
Thanks Mag

PastGenToys:

Ill give that a shot. Can you verify the exact path and file I need to update. I am rather new and dont want to create a bigger mess for my self. Thanks!

googlefroogle.php in the root directory.

magpie, you may also try to increase the timeout for the functions that are timing out for you.

numinix:

Also, could you please time the length it takes to return the "connection failed".

It bombs after about 15 seconds with and with out the new code.

PastGenToys:

It bombs after about 15 seconds with and with out the new code.

Ok, let me know what your host says.

hi

i just installed your mod 1.4.1, installed the sql file, copy paste and when i run the file to create a foogle file i get

Froogle Data Feeder v.1.4.1 09.07.2007 12:00 started 2007/07/10 23:37:04
Feed file - /home/content/s/i/r/sirryche5/html/feed/froogle.txt
Processing: Feed - Yes, Upload - No

so i go to the froogle.txt and there is nothing there. its empty i have reinstalled this mod 4 times and reinstalled the database both from zen and my cpanel. i do have over 1200 products and tried with the id and with model, it seems to act like its creating something but even if you use the view button before step 2 it comes up blank. :frusty: any ideas? thanks

Hi,

Does anyone know how long should it take before the uploaded items apper on the Google base?

Google quotes 48 hours, I uploaded my stuff on the 8th, there is still nothing. The mod reported no errors, the froogle.txt file is not empty.

Thanks,
Alex

sirryche:

hi

i just installed your mod 1.4.1, installed the sql file, copy paste and when i run the file to create a foogle file i get

Froogle Data Feeder v.1.4.1 09.07.2007 12:00 started 2007/07/10 23:37:04
Feed file - /home/content/s/i/r/sirryche5/html/feed/froogle.txt
Processing: Feed - Yes, Upload - No

so i go to the froogle.txt and there is nothing there. its empty i have reinstalled this mod 4 times and reinstalled the database both from zen and my cpanel. i do have over 1200 products and tried with the id and with model, it seems to act like its creating something but even if you use the view button before step 2 it comes up blank. :frusty: any ideas? thanks

This has been an issue for quite some time and remains since Andrew's original script. I haven't duplicated this error myself and don't know if it is a timeout issue or not. It should at least print some lines before timing out. I will PM you to see if we can try to resolve this issue once and for all.