Google Base Feeder Support Thread [OLD]

AlexT:

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

Have you registered the bulk upload file with Google Base?

It can take some time for your first feed to be accepted. Usually updates occur on the same day though.

v1.4.2 GOOGLE BASE FEEDER

1. Removed instock output;
2. Updated readme file instructions;Small update to remove an attribute that Google doesn't use. They base instock on the quantity and this doesn't need to be defined in the feed.

[quote]

adam9110:

Dear Friend,
I just follow your instruction add the
max_execution_time = 300
max_input_time = 90
memory_limit = 32M
to the .htaccess file ( the end of the file)

I got the error.

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

what is happened.

I am not sure whether it is timeout problem ,or just uncompatible with zen cart 1.3.5

i was having also having a time out problem i also i found the thread with the time out issuse and i can't find the php.ini file but the thread also mentioned the htaccess file.. so while im here bord at work i took

max_execution_time = 300
max_input_time = 90
memory_limit = 32M

and added it to the htaccess at the end and

it worked it dosn't time out and my froogle text has all my products in it. over 2900 products. :clap:still have not been able to have it up load it but i can do that thru google if need be.

ok well now how do i say this :oops: it dose not work but yet it dose work..
let me explain the problem now. when i put the code in the htaccess file my template compleatly disappears.:frusty: everything works but its just the words and product pictures. it creates a froogle file but not upload. i take out the code and my web is back to normal but my froogle times out.:censored: so i either have to code it correctly i htaccess (which i have no idea how to do) or somehow get godaddy to change my php.ini. any other sugestions? for now ill put my site down for 10-15 min create the froogle file the put it back up. only way i can think of it so far..

numinix:

Have you registered the bulk upload file with Google Base?

It can take some time for your first feed to be accepted. Usually updates occur on the same day though.

I knew I missed something, but could not find what exactly. The registration of the upload file has fixed it! The items appeared in my google account within hours. Thank you very much for your help!

v1.4.3 GOOGLE BASE FEEDER

1. Added UPC and ISBN;This is a major update as it modifies several admin core files in order to allow users to input the UPC and ISBN as well as extract this data from the database to be used by the Google Base Feeder.

It is going to be a very large task to input all of the UPC information into each product manually so I thought I would get a jump start on Google Base making this attribute absolutely mandatory. I am hoping that someone will update the mod QUICK UPDATES to include the UPC and ISBN fields to make the updating task a lot easier.

Hi and thank you for the updated

And I thought I am done with this :smile:

Is it easy to update as uploading only, will I have to modify any of my files I sent to Google already?

It is working well now, am just afraid I mess it up again.

Thank you

ya hoo :clap: boy i'm i excited. i had this hosting site for years and i have ereased this site a number of time from first website to cre loaded to now my new Zen cart. which zen is #1. ny way i remember a while back when i wiped the website out that it use to have a php.ini file and now it dosn't. so just for the fun of it and nothing to loose i created a php.ini file and put this in it

max_execution_time = 300
max_input_time = 90
memory_limit = 50M
post_max_size = 50M
file_uploads = On
upload_max_filesize = 50m

uploaded to root and wala:cheers: it works. as i said before when it put that above code into my htaccess my website lost all template settings but the mod would create step one and not time out. but with out that code my web worked but the mod timed out and would not create any files.

since i created my own php.ini file the mod works and dose not time out and it creates the froogle files. but------still wont upload:no: i get

Froogle Data Feeder v.1.4.3 12.07.2007 14:40 started 2007/07/12 19:56:30
Feed file - /home/content/s/i/r/sirryche5/html/feed/froogle.txt
Processing: Feed - No, Upload - Yes
Upload started...

and it just sits there. its running now and been about 10 minutes . ill let it run overnight or until it errors. so for now i have to download the up load the froogle file from their site. better than nothing any body that gets it to upload let me know if you had to do anything different to get it to work.. oh ya i use godaddy for my host if anybody wonders and running zen 1.3.7 with the newest google base feeder 1.4.3

That is a good finding. In the next update (no ETA since no issues), I will create a troubleshooting file and state that you can create your own php.ini file if one does not exist and avoid the htaccess file altogether!

Let me know if there are any issues with the UPC/ISBN additions. I hope Zen Cart will add this to the core files in the next release.

i'm back. well after a long night of searching and reseting my database and reinstalling backups i found a bug in google base 1.4.3 i get this message when i try to modify a product under admin->catalog->(product name)

1054 Unknown column 'p.products_weight_type' in 'field list'
in:
[select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_upc, p.products_isbn, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_weight_type, p.products_dim_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id from products p, products_description pd where p.products_id = '186' and p.products_id = pd.products_id and pd.language_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

instead of taking the easy way out and ask for help i paniced (using live site, i know stupid me) thought it was my database and long story short spent a long night getting my site back up. anyway

i trace it to the file admin->includes->modules->product->collect_info.php

i did some poking around but could not get it to work(not a programer know very little php) so i replaced the file with my original file(after spending 2 hrs looking for my backups.) and have it working. reinstalled 1.4.2 and no problems if you know a fix let me know and ill give 1.4.3 another try.

Hi numinix,

Great work with this contribution.

I too was suffering from blank froogle.txt files being written. I'm running IIS 6.0 on Windows Server 2003 x64 and after tweaking the permissions for my 'feeds' folder I was able to get everything working.

I have noticed two small errors with the contribution (nothing major), but I felt they should be reported.

1 - In admin>tools>google froogle feeder the link within this text, "NOTE: You may view your product feed file before proceeding to step 2.", does not take into account different feed directories (it just points to /feed/ regardless of the output directory configuration).

2 - The update_1_4_3.sql and googlefroogle.sql in the 1.4.3 release contain a small typo. 'UPC' has been listed in place of ISBN.

(NULL, 'UPC', 'GOOGLE_BASE_UPC', 'false', 'Include products UPC?', @configuration_group_id, 31, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'UPC', 'GOOGLE_BASE_ISBN', 'false', 'Include products ISBN?', @configuration_group_id, 32, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

This then creates two options named 'UPC' in the configuration settings.

I hope this helps. :)

I will issue a fix for the issues reported by the last two posters. Thank you for notifying me. In the meantime, you can simply change the UPC to ISBN, and for the collect_info, take out the section that is surrounded by comments for the CANADA POST SHIPPING MODULE. I accidentally used an already edited core file.

numinix:

I will issue a fix for the issues reported by the last two posters. Thank you for notifying me. In the meantime, you can simply change the UPC to ISBN, and for the collect_info, take out the section that is surrounded by comments for the CANADA POST SHIPPING MODULE. I accidentally used an already edited core file.

Sounds good.

Before posting I had already changed the UPC to ISBN using phpmyadmin.

Like I said they were only small issues and everything else appears to be working just fine.

Thanks again for this great contribution!

v1.4.4 GOOGLE BASE FEEDER

1. fixed bugs and typos;

I will fix the view feed file in the next release. I suggest using /feed/ in the meantime.

It appears to use the correct folder and filename:

define('TEXT_GOOGLE_FROOGLE_INSTRUCTIONS_STEP1_NOTE', '<p>NOTE: You may <a href="' . HTTP_CATALOG_SERVER . DIR_WS_CATALOG . GOOGLE_FROOGLE_DIRECTORY . GOOGLE_FROOGLE_OUTPUT_FILENAME . '" target="_blank" class="splitPageLink"><strong>view</strong></a> your product feed file before proceeding to step 2. </p>');

I installed this G Base Feeder locally and works fine.
But when I installed this same mod in my live site, and when I go to Tools -> Google Froogle Feeder, I get the following error only in the entire page:
TEXT_GOOGLE_FROOGLE_STARTED
TEXT_GOOGLE_FROOGLE_FILE_LOCATION/var/www/vhosts/naso9.com/httpdocs/feed/froogle.txt
Processing: Feed - No, Upload - No

Can anyone plz suggest me what might have gone wrong?
Thanks

You're language definition files for the Admin aren't in the correct location.

I made a mistake in 1.4.4 and accidentally put the modules folder in the admin in the wrong spot. Please move admin/modules to admin/includes/modules. This should fix the definitions error. I'll fix this for 1.4.5 which will include the ability to remove certain categories in the same way that you can limit to only certain categories. Hopefully I'll get to it in the next couple of days.

I'm hoping to being working on a feeder for another auction website that has a lot of potential for Zen Cart users. I'll say more once I've been given confirmation if the project will be sponsored or not.

numinix:

I made a mistake in 1.4.4 and accidentally put the modules folder in the admin in the wrong spot. Please move admin/modules to admin/includes/modules. This should fix the definitions error. I'll fix this for 1.4.5 which will include the ability to remove certain categories in the same way that you can limit to only certain categories. Hopefully I'll get to it in the next couple of days.

I'm hoping to being working on a feeder for another auction website that has a lot of potential for Zen Cart users. I'll say more once I've been given confirmation if the project will be sponsored or not.

Thanks for pointing this out.

I've noticed another little bug (well... I think it's a bug).

From admin>tools>google froogle feeder when you click on the link within the "NOTE: You may view Froogle Merchants FTP content." text a small popup window appears showing your FTP content, which is fine. But, a the same time, the original page returns to the admin home page.

Is this meant to happen?