Google Base Feeder Support Thread [OLD]

Alex,

These features existed before my updates, but I will try and have a look at the code and fix them for v1.4.5. Or, I may remove them altogether as they are unimportant.

Also, even though viewing the feed file appears to be correct, there must be something wrong with the coding Andrew used because you are right that the folder name does not change in the link regardless of changes to the config. This is a little more important since those who cannot or do not want to use "feed" as their folder will have to enter in the address manually to view the feed file.

Once version 1.4.5 is complete, I am going to begin working on Quick Updates to allow inputting UPC and ISBN. If anyone feels up to the challenge, you can try and do this yourself and upload it to the downloads section to save me some time. I haven't heard back from the author...

[FONT=Verdana][FONT=Times New Roman]Hi[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]I follow the direction and set up from my host control panel as instruction,[/FONT]
[FONT=Times New Roman]5 * * * GET [/FONT][FONT=Times New Roman]http://www.tiledepot.us/googlefroogle.php?feed=yes&upload=yes[/FONT]
[FONT=Times New Roman]I recive an Email saying /bin/sh: 0: command not found[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Any idea what did I do wrong?[/FONT]
[FONT=Times New Roman]I a musing the 1.4.2 , not planning to upgrade it for now, it look like it working well, don’t want to mess it up[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Thank you[/FONT]
[/FONT]

Ask your host the best command to use

Ok Thank you

I just tried to install this, I uploaded everything, installed the sql patch, but when I goto config>google base, I can't enter anything theres nothing its blank, no variables to change

any ideas

Install the SQL file again. Make sure there are no errors.

Quote:

---

Originally Posted by numinix

Install the SQL file again. Make sure there are no errors.

---

Did it again, only errors I got are the ones saying certain things already exist from running it before. 9 things completed.

I also reinstalled all the files. Still no parameters in config, but I can see things under tools>feeder

There shouldn't be any existing statements since the installation file uninstalls any existing configuration before installing the columns to the database table.

I'm sorry that I am unable to help you with this further.

Quote:

---

Originally Posted by teebo

Did it again, only errors I got are the ones saying certain things already exist from running it before. 9 things completed.

I also reinstalled all the files. Still no parameters in config, but I can see things under tools>feeder

---

v1.4.5 GOOGLE BASE FEEDER

1. Added excluded categories;
2. Esthetic updates;

I have updated Quick Updates to version 2.03a which now includes support for UPC/ISBN. I highly suggest that everyone install/upgrade this version as it will greatly increase the efficiency of updating these new REQUIRED fields. You can download this update from my website and it should also be available in the downloads section shortly.

I am guessing that UPC and ISBN are going to eventually be used by Google to separate products into the correct categories automatically or something along those lines. They are known for their massive databases so this might not be too far fetched. At the moment their categories are messy and not useful to search products by the product_type.

[FONT=Verdana]Hi Numinix[/FONT]

[FONT=Verdana]I do have 2 site , on my live site I install the 1.4.2 and it dose look like all is good.[/FONT]
[FONT=Verdana]I am trying to run the upgrade on my demo site before I upgrade my live site, I keep getting errors when I try to upgrade to 1.4.5 .[/FONT]
[FONT=Verdana] Looking at my Live site I could see that the folder of Image are not in same location as on my live site, just wondering if other file also miss place, also in my live store I got 4 files in my feed folder while on your folder it has only 2[/FONT]

[FONT=Verdana]I completely remove it from my site demo before uploading the files, should I run the upgrade sql also? [/FONT]

[FONT=Verdana]Thank you[/FONT]

The only images folder that the GBF uses is in the admin...

The files in the feed are auto generated.

You only need to run the upgrade.sql if you are upgrading from 1.4.4 to 1.4.5. If upgrading more than 0.0.1 versions, then you'll have to download subsequent versions or just run the googlefroogle.sql file to have the config reset to default settings.

Hi Numinix

Thank you for your respond

In regard to the image , it is not in same order on the 1.4.5, not compare to my other ( live store ) 1.4.2 and it dose work well on my live store , and I do have the Google image ion my admin, that’s why I thought maybe other file miss placed.

Any way I run the un install sql and completely remove all files, I will do fresh install and see how it goes ( on my demo site)

I assume I don’t need to run the upgrade SQL when I do it this way

Thank you

It looks like this may have been covered in th other informal thread a few months ago, but it is obvious that I am still missing something. Here is the error that I get when attempting to create a feed......

Any Ideas?

Michael Humphrey
www.iliketobead.com


Froogle Data Feeder v.1.4.5 15.07.2007 18:02 started 2007/07/16 06:29:43
Feed file - /mnt/Target01/327584/XXX/web/content/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, p.products_upc, p.products_isbn, 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
.
.
.
<end snip>

Quote:

---

Originally Posted by numinix

There shouldn't be any existing statements since the installation file uninstalls any existing configuration before installing the columns to the database table.

I'm sorry that I am unable to help you with this further.

---

Ok i just used to upload method, and it say 9 statements executed, but still nothing under config>froogle config

Hi numinix,

I've noticed an error since (I think) I installed version 1.4.4.

When trying to update a product record (via admin) I receive the following error...

Quote:

---

1054 Unknown column 'products_weight_type' in 'field list'
in:
[update zen_products set products_quantity = '0', products_type = '1', products_model = '1234', products_upc = '', products_isbn = '', products_price = '23.9500', products_date_available = null, products_weight = '0', products_weight_type = 'SYSTEM_WEIGHT_UNITS', products_dim_type = 'SYSTEM_DIMENSION_UNITS', products_length = '0', products_width = '0', products_height = '0', products_ready_to_ship = '0', products_status = '0', products_virtual = '0', products_tax_class_id = '1', manufacturers_id = '18', products_quantity_order_min = '1', products_quantity_order_units = '1', products_priced_by_attribute = '0', product_is_free = '0', product_is_call = '0', products_quantity_mixed = '0', product_is_always_free_shipping = '0', products_qty_box_status = '1', products_quantity_order_max = '0', products_sort_order = '0', products_discount_type = '0', products_discount_type_from = '0', products_price_sorter = '14.3880', products_image = 'products/1234.jpg', products_last_modified = now(), master_categories_id = '41' where products_id = '1065']
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.

---

Now, I think this is due to some code for the Canada Post Module, but I've not installed that. I've upgraded to version 1.4.5, but that's not helped. :(

What do you think?

Quote:

---

Now, I think this is due to some code for the Canada Post Module, but I've not installed that. I've upgraded to version 1.4.5, but that's not helped.

---

Replace admin->includes->modules->product->collect_info.php with the one in v1.4.5.

Quote:

---

Originally Posted by teebo

Ok i just used to upload method, and it say 9 statements executed, but still nothing under config>froogle config

---

I'll have to help you in PM since your error is definitely an issue with your site alone.

[FONT=Verdana]Hi Numinix[/FONT]

As I say last night I completely remove the mod , and re installing it now, with same problem as yesterday,

A point abut the image of Google, I am now positive it is misplace, in the folder I download it is under Admin/include/image, where I right click on the missing picture in my admin it directed me to Admin/Images, if I know more I would look to see if other file are miss placed, but I have no idea what to look for,

I do get same errors as ml-humphrey, if you find the answer please let us know, in the mean time I wait for other to come with same issue hopefully some one solve it soon.

I made abut 5 to 6 installation of the 1.4.5 after each time I got same errors, and I did a complete un install and clean up all the files, and I got same errors every time.

No rush on my behalf , I got on my live site the 1.4.2 working perfect.
This is the link of my demo site

www.tiledepot.us/storedemo if you need it

Thank you

hello you guys. I was browsing for how to get a flash banner up on my site and got carried away with the Google base feeder, can you tell me what it does and does it benefit my store? Thank you for all who reply!:D

Hi

I put it in my words (simple ones) from what i know it publish your product on google, ( mine their ) and also update your product on Auto, after you set it up

Realy cool mod , a must to have one
Good Luck

In regard to your Flash banner, I have no idea , try the search , it dose have lots of info

I messed up the folder heirarchy in v1.4.5, I'm going to test on a clean installation of Zen Cart now and fix the folders. I'll release 1.4.6 in the next little while.

I installed 1.4.5 and all went well. Ran SQL and no errors, but when I try to generate the feed file I'm getting the following error:
1054 Unknown column 'p.products_upc' in 'field list'

Should I run the Uninstall SQL? That step wasn't in the Readme file.

Ohh God

I feel much better knowing i was not annoying for nothing:smile:

P,S what should i do whan i get the 1.4.6 , should i delete the 1.4.5 or overide it?

Thank you Numinix

They are should just be an overwrite unless other mods use those files as well.

v1.4.6 GOOGLE BASE FEEDER

1. Fixed folder heirarchy;
2. Added missing ";" in SQL;
3. Fixed issue regarding viewing feed file folder;

Quote:

---

Originally Posted by numinix

Replace admin->includes->modules->product->collect_info.php with the one in v1.4.5.

---

I've already tried that and it's not worked. I think an error exists in admin>includes>modules>update_product.php.

Version 1.4.6 (installed today) has not solved the problem. :(

Any other ideas?

I have worked around this issue by commenting out the following lines (43-48) in admin>includes>modules>update_product.php.

Code:

---

'products_weight_type' => $products_weight_type,
'products_dim_type' => $products_dim_type,
'products_length' => (float)zen_db_prepare_input($_POST['products_length']),
'products_width' => (float)zen_db_prepare_input($_POST['products_width']),
'products_height' => (float)zen_db_prepare_input($_POST['products_height']),
'products_ready_to_ship' => (int)zen_db_prepare_input($_POST['products_ready_to_ship']),

---

It worked for me! :)

Hi

Yeaaaaaa it is working

I now will try to do the update on my live store

Thank you

Quote:

---

Originally Posted by Alex Clarke

I have worked around this issue by commenting out the following lines (43-48) in admin>includes>modules>update_product.php.

Code:

---

'products_weight_type' => $products_weight_type,
'products_dim_type' => $products_dim_type,
'products_length' => (float)zen_db_prepare_input($_POST['products_length']),
'products_width' => (float)zen_db_prepare_input($_POST['products_width']),
'products_height' => (float)zen_db_prepare_input($_POST['products_height']),
'products_ready_to_ship' => (int)zen_db_prepare_input($_POST['products_ready_to_ship']),

---

It worked for me! :)

---

You are correct. This is more Canada Post code that I missed. I'm issuing 1.4.7 now to cover this mistake. You won't need to download it but everyone who doesn't use Canada Post should.

v1.4.7 GOOGLE BASE FEEDER

1. bug fix;

Canada Post module now completely removed. All unstable versions of the GBF have been removed from my website leaving only stable versions for download.

I applied the 1.4.7 update, and I get this when I try to update an existing product:
1054 Unknown column 'products_weight_type' in 'field list'
It is creating a Feed File.

I was getting that error after the 1.4.5 update, but the suggestion above stopped the error and I was able to update the products, but it would not create a Feed File. Well it created one, but it had nothing in it.

It appears this has not been fixed in the 1.4.7 release.

You'll have to re-apply my 'quick fix' as found here...

http://www.zen-cart.com/forum/showpo...&postcount=128

I completely removed that block of code which pertains to the Canada Post Shipping module from update_product.php

I just tested on a clean installation and it works. If the update_product.php file contains the lines that Alex has brought to our attention, simply delete them.

Alex, hopefully you can assist some of these other users to install and use this mod as I'm very busy writing a new mod.

Downloading UPC/ISBN Module 1.1 will fix the issue. I'll update the GBF yet again :p

v1.4.8 GOOGLE BASE FEEDER

Bug Fix

Hi
This is on my 1.4.2 live store, I keep getting this error, I contact my server as I been advice here, but the say it is nothing to do with the server
/bin/sh: http://www.tiledepot.us/store/google...e.php?feed=yes: No
such file or directory
I did not upgrade to the newer version, as I see it keep changing every day
Is that important think I should take care , or I can live with it, is that mean I only to manually upload every time I have change? Is so I am ok with it
Thank you

1.4.8 nailed it. All is good now.

I actually applied the SQL script even though I guess I was technically updateing from 1.4.6 (which never worked for me).

Thanks!

-Mike

Quote:

---

Originally Posted by numinix

I just tested on a clean installation and it works. If the update_product.php file contains the lines that Alex has brought to our attention, simply delete them.

Alex, hopefully you can assist some of these other users to install and use this mod as I'm very busy writing a new mod.

---

Sure, I can help people. However, the 1.4.8 upgrade should solve all problems. Thanks for this! :)

If you run the SQL script it wil simply overwrite all of your stored configurations which isn't that big of a deal.

If no SQL upgrade is required since the last release, I normally remove the update files. But, perhaps I will include them all in the next release which HOPEFULLY will not happen for some time. However, I did notice one problem:

WARNING when uninstalling your copy of the Google Base Feeder, do NOT run these two lines in your uninstall.sql unless you want to completely remove the stored UPC and ISBN information from your database:

PHP Code:

---

ALTER TABLE products DROP COLUMN products_upc;
ALTER TABLE products DROP COLUMN products_isbn; 


---

The uninstall.sql should look like this:

PHP Code:

---

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Configuration'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id; 


---

I will remove this in the next release and make a note to only use these if you want to completely remove the GBF and never use it again. In most cases people are just uninstalling to reinstall and having to reinput all of the UPC information can be very tiresome.

Using the 1.4.6 version with no problem at all. Install went as smooth as glass. Simply installed this version over my original 1.? version.

I had no problem with this upgrade just left out the shipping because its so darned confusing. Google made this part of their feed very difficult to set-up, and in my opinion very useless. Most of the sites that I have been on spell out their shipping better than you could on the Google site.

One other thing - if you previously had a feed set-up make sure you use that in your configuration or if you are going to do a new one delete the old.

Just an opinion.

Quote:

---

Originally Posted by Mr_B

Using the 1.4.6 version with no problem at all. Install went as smooth as glass. Simply installed this version over my original 1.? version.

I had no problem with this upgrade just left out the shipping because its so darned confusing. Google made this part of their feed very difficult to set-up, and in my opinion very useless. Most of the sites that I have been on spell out their shipping better than you could on the Google site.

One other thing - if you previously had a feed set-up make sure you use that in your configuration or if you are going to do a new one delete the old.

Just an opinion.

---

Versions 1.4.3 to 1.4.7 will only work if you have the Canada Post Module installed. 1.4.8 has removed these and I believe I removed the shipping options in an older release. Did it somehow creep back into my SQL file?

This may have been posted previously but worth repeating...

If having troubles uploading, submitting your bulk upload be sure to visit
http://groups.google.com/group/base-...2d25947786ee96

For instance a recent post to the above thread:

SYSTEM ALERT: 6:00 PM: Our bulk upload processing system will be undergoing a scheduled maintenance for the next two days (7/16 to 7/18). During this time, bulk uploads submitted through the Google Base web interface or via FTP will not be processing. We'll update
this thread once the scheduled maintenance has been completed.

Thank you Woodymon. Google was down for accepting bulk uploads during those dates. It's possibly due to a bug that I reported to them in which the price was not displaying in base.google.com but was displaying in google.com/products. The bug has been fixed and now they are accepting bulk uploads again.

Yes my latest upload was accepted, reviewed and published within an hour. And I'm not (yet) including all of the required attributes or substitute item type, optional or custom attributes that GoogleBase says they require.

Quote:

---

Originally Posted by Woodymon

Yes my latest upload was accepted, reviewed and published within an hour. And I'm not (yet) including all of the required attributes or substitute item type, optional or custom attributes that GoogleBase says they require.

---

Yes, although Google says they require the UPC attribute, they do not seem to enforce it yet. I did the Zen Cart community a favour and added this feature in advance and also modified a couple of contributions to make adding the information a lot easier. I hope it is appreciated :)

I have a problem.

If I change the name of the file that is produced in the configuration, it still seems to produce the file name frooglefeed.txt and not the new file name.

I want to use the name froogleupload.txt

Regards
Laurie

I am using the latest version.

Quote:

---

Originally Posted by numinix

I did the Zen Cart community a favour and added this feature in advance and also modified a couple of contributions to make adding the information a lot easier. I hope it is appreciated :)

---

I'm still using Andrew's latest version ;-)

I sure hope Andrew returns to the Zen Cart mod development!

That shouldn't be possible since his version doesn't support the product_type...?

Quote:

---

Originally Posted by chalfontgifts

I have a problem.

If I change the name of the file that is produced in the configuration, it still seems to produce the file name frooglefeed.txt and not the new file name.

I want to use the name froogleupload.txt

Regards
Laurie

I am using the latest version.

---

Just to add to my problem above, if you add the filename directly to the database it works fine, so it must be something to do with the code that writes the new file name to the datatabase in the configuration. I have tried to find where this is in the code but with no results. Anyone any ideas. Does anyone else have the same problem.

Regards
Laurie

[FONT=Times New Roman]Hi[/FONT]
[FONT=Times New Roman]Finally I took the chance and upgrade to the 1.4.8, it look fine, but just look, I am getting errors when trying to upload to Google, [/FONT]
[FONT=Times New Roman]Froogle Data Feeder v.1.4.8 17.07.2007 18:06 started 2007/07/22 21:13:25
Feed file - /home/tiledepo/public_html/store/feed/froogle.txt
Processing: Feed - No, Upload - Yes
Upload started...
Connection failed: uploads.google.com

Upload failed...[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Also trying to upload it directly from Google ( under my item list I click on Bulk upload file, it work well before from there , but now , nothing happen after I send it.[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Also under my Admin/tools it say Google base feeder , but under my configuration it show Google froogle.[/FONT]
[FONT=Times New Roman]Do I need to change anything in my configuration ( I did not change any of it)[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]I did got 2 new lines in my admin product, upc and another one[/FONT]
[FONT=Times New Roman]Thank you[/FONT]

The discrepency in names under the configuration and tools isn't important. I'll change it in the configuration in the next release.

If you are having trouble connecting with FTP it may be an issue with your hosting.

I am getting the following error when I try to connect to google:

Froogle Data Feeder v.1.4.8 17.07.2007 18:06 started 2007/07/24 14:54:41
Feed file - /home/commtech/public_html/catalog/feed/froogle.txt
Processing: Feed - No, Upload - Yes
Upload started...
Connection failed: ftp://uploads.google.com
Warning: ftp_connect(): php_network_getaddresses: getaddrinfo failed: No address associated with hostname
Upload failed...

Never mind I am not getting that error any more but I am getting the same error as post #152.

Quote:

---

Originally Posted by rbepple

Never mind I am not getting that error any more but I am getting the same error as post #152.

---

Quote:

---

Originally Posted by numinix

If you are having trouble connecting with FTP it may be an issue with your hosting.

---

Also, sometimes the upload will fail on the first attempt but if you attempt again right away, it will connect. The FTP portion of the code works and was written by Andrew Berezin. It uses basic PHP FTP functions through your server to connect to the Google FTP. If there are issues with using FTP on your server, this is an issue with your hosting. From time to time there may also be issues on Google's end of the FTP. These are all isolated from the Google Base Feeder.

Sorry dumb question but I have to ask..

I am using Andrews (a_berezin) version (1.3.7 or earlier) and I need to upgrade.

For an upgrade to the new 1.4.8 is this the correct procedure?..

1. Run ‘uninstall.sql’
2. Upload new files
3. Run ‘Googlefroogle.sql’

Cheers!

Yes, that is correct. You can overwrite the files that are uploaded. However, be careful with the files which are core overwrites. For these files rename to .bak before uploading and also do a database backup.

Quote:

---

Originally Posted by numinix

That shouldn't be possible since his version doesn't support the product_type...?

---

The version I use does ;-)

Ah, then you are using a custom version. The final version by Andrew (v1.3.3) uses "label" in place of the "product_type" which was the first change I ever made in version v1.3.4.

I am considering switching to rss 2.0 but this would be a major update and I have yet to learn XML. Could you please reply to my PM.

numinix,

Well the installation went fine. I created the feed just fine. Nothing uploads. Yet it says it did. When I log into google base no file is there.
My username & password match. Filename at google & on my site match.
I have to manually upload the file from my computer. I thought maybe it was the settings for the file at google.
What settings for the file should I use at Google? UTF8 etc. ??? please post all settings needed to match the file format.
(using version 1.4.8)
Thanks,
grumpy
p.s. I have Ultimate SEO URLs installed.

It takes hours for the upload to appear in Google and you wouldn't be able to check it until it has been processed. By uploading it manually we cannot tell whether or not the original update succeeded. Please try the FTP upload again and check back tomorrow to see what time the last update was processed. If you are unable to use the FTP, you'll have to upload it manually.

GBF is SEO-URL friendly.

I too cannot get the feed to upload from Zencart - nor could I FTP it directly to GoogleBase, but I was able to upload it via Googlebase itself. :shocking:

(Having said that, it hasn't appeared in the FTP directory, but Google states it could take an hour to process it)

I also had trouble getting the file to write in the first place, constantly being given access denied errors even though directory permissions were correct. However, I managed to get around this by creating a file with the same name as my feed file, CHMODding that to 777, and voila! No problems with the file creation.

But back to the upload...after about 3 mins I get the foillowing error:

Quote:

---

Froogle Data Feeder v.1.4.8 17.07.2007 18:06 started 2007/07/30 23:27:52
Feed file - /hsphere/local/home/xxxxxxx/xxxxxxxxx/feed/froogle.txt
Processing: Feed - No, Upload - Yes
Upload started...
Warning: ftp_rawlist(): php_connect_nonb() failed: Connection timed out (110) in /hsphere/local/home/xxxxxxx/xxxxxxxxx/googlefroogle.php on line 406 Upload Failed
Connected to: uploads.google.comLogin ok:Current Directory Is: /Warning: ftp_put(): php_connect_nonb() failed: Connection timed out (110) in

Upload failed...

---

Suggestions welcome!

I've recently read archived support from the Google Froogle Feeder v1.3.3 and previous. Apparently some others have also had problems with using the ftp feature. I, however, have no problem uploading to Google Base and my upload was accepted every night while I was away on holidays.

I have not had recent issues generating the mod file. I do recall having some previous issues deleting or renaming the mod file and hosting provider intervention was required;-)

I have had only occasional issues either FTPing and uploading from ZC mod to GoogleBase. But such issues also seem to resolve themselves. So I suspect GoogleBase server is source of time outs and nothing to do with the mod.

I just uploaded via the mod (internal FTP) without issue.

I previously understood GoogleBase/Product Search only supported shops located in USA. Has this changed? Maybe upload and/or FTP success is negatively impacted based on the IP you are uploading from?

Maybe forward the php_connect error you are having to your hosting provider.

When using a distinct FTP client to upload what errors and/or log entries are you observing?

Woody

Quote:

---

Originally Posted by Ryk

I too cannot get the feed to upload from Zencart - nor could I FTP it directly to GoogleBase, but I was able to upload it via Googlebase itself.

I also had trouble getting the file to write in the first place,...

But back to the upload...after about 3 mins I get the foillowing error:

---

Quote:

---

Originally Posted by Woodymon

I previously understood GoogleBase/Product Search only supported shops located in USA. Has this changed? Maybe upload and/or FTP success is negatively impacted based on the IP you are uploading from?

---

Not sure about that - but following the upload via Googlebase itself last night, the products are now showing.

The site from which I'm trying to FTP via the mod is on a UK server, as is my own connection from which I'm trying to FTP direct. When I make the direct transfer, I don't get an error message but the file shows as 0kb in size and is not viewable in a text editor...but does that mean that google simply moves it elsewhere the moment it arrives?

I'll have a word with the host about the time-outs.

Ryk:

Google (lately) does seem to move it the moment it arrives - I haven't been able to 'view' it on the Google FTP server for quite some while. It might be an idea to remove that bit of text and link from the mod's admin screen.

Thanks for that Pixxi - that sort of ties in with what Google themselves say in that you can only see what you've FTP'd immediately after you've done it...looks like "immediately" is a matter of nanoseconds! :D

Well it was my bad I went brain dead :wacko: I was using the login for my eBay store.
I have a different account now for my website site & set up a new FTP log in.
I was able to manually upload & got no errors today. And not much of a wait time either.
Also I think that google may have been way busy yesterday since the upload I made yesterday hadn't finished processing but had done some of the items & showed me that I can't upload into the same account as my ebay store.

Hi,

I had a problem and partially solved it. I would like to know how to get the google base feeder (thank you very much for this contribution, it is Excellent) to work properly without my need to intervene.

Problem:
When the froogle.txt file is created, all the values for the field "brand" are empty. This causes google base to invalidate the upload.

Solution:
Add my store name in the "brand" field for every product and upload manually.

Question:
What is the field from my product database that is mapped to the "brand" field in the froogle.txt?; I just might add my store name to all the products for this value.
Is this a bug?

Thank you very much in advance

Quote:

---

Originally Posted by onlyrey

Hi,

I had a problem and partially solved it. I would like to know how to get the google base feeder (thank you very much for this contribution, it is Excellent) to work properly without my need to intervene.

Problem:
When the froogle.txt file is created, all the values for the field "brand" are empty. This causes google base to invalidate the upload.

Solution:
Add my store name in the "brand" field for every product and upload manually.

Question:
What is the field from my product database that is mapped to the "brand" field in the froogle.txt?; I just might add my store name to all the products for this value.
Is this a bug?

Thank you very much in advance

---

Ok,

Here is a partial answer to the "brand" question.

I looked up the code, and the brand field in the froogle text file corresponds to the "manufacturer" field in Zen-cart.

I will solve this problem by applying a manufacturer to ALL my products.

So, if you have manufacturers as "none" you might have problems with the google validation (the actual feeder code is fine and sends an empty field, but the google side takes it as an error).

Thanks very much fot this wonderful module

Google doesn't take it as an error. The brand attribute is required and leaving it blank will cause your feed to not be validated. If your products are something that your own company produces/manufactures, then your company is definitely the brand name of the product.

IMPORTANT

More renegade code has been found in the UPC/ISBN mod and MAY be in the GBF as well. As I haven't heard of any problems, this is probably not the case. Either way, I am not going to release a patch and ask that anyone experiencing SQL problems from the UPC/ISBN mod included with GBF v1.4.8 please visit, and bookmark, this thread: http://www.zen-cart.com/forum/showth...765#post411765

You can fix this error by quickly moving the lines found by another forum member that lead to the release of UPC/ISBN v1.2

Quote:

---

Originally Posted by Woodymon

I previously understood GoogleBase/Product Search only supported shops located in USA. Has this changed? Maybe upload and/or FTP success is negatively impacted based on the IP you are uploading from?

---

You may be on to something. I am in Canada myself but my host is in the USA. I've never used the manual FTP and have either used their webform or the FTP included with the GBF to upload the feed file. I suggest non-US with non-US hosting to email Google. They should allow everyone to use the service as long as prices are quoted in USD.

Hey Everyone,

If this was answered then sorry. I read everything on it and tried all the fixes but still a no go. My problem is the feeder creates my froogle.txt and can upload fine but not all products are in the txt file. I have 500 products and the txt file only shows 72. I do not think it is a timing issue as the 72 products are done in 3 sec. I also am not allowed to get to root for the php.ini file. If I put that code for the php.ini file in my .htaccess than zencart bombs until the lines are removed. Any help would be appreciated. My 72 products upload just fine to googlebase but I want all of the products up there. thanks again.

Jack

It would be great and cleaner to provide update SQL for this mod (especially since you took it over from where Andrew left off). The current SQL doesn't take into account that other mods your provided already created the UPC/ISBN fields in products table.

Not providing a cleaner upgrade path definitely leads to too many DB errors and makes using mod more complicated than it needs to be.

Thanks!

There is an undesired effect that is happening with this mod that didn't exist with the version that was created by Andrew. This version 1.4.8 is generating duplicate products if a product is linked. Previous version on generated one product no matter how many category the product is linked to. It would be great if this can be fixed. Thanks!

Quote:

---

Originally Posted by BlessIsaacola

It would be great and cleaner to provide update SQL for this mod (especially since you took it over from where Andrew left off). The current SQL doesn't take into account that other mods your provided already created the UPC/ISBN fields in products table.

Not providing a cleaner upgrade path definitely leads to too many DB errors and makes using mod more complicated than it needs to be.

Thanks!

---

An error will not be produced, the SQL will ignore those lines. If an upgrade to the SQL is needed, an upgrade SQL file is provided. If one is not provided, the update merely requires file overwrites. The installation documentation has been greatly lengthened to avoid any issues.

Quote:

---

There is an undesired effect that is happening with this mod that didn't exist with the version that was created by Andrew. This version 1.4.8 is generating duplicate products if a product is linked. Previous version on generated one product no matter how many category the product is linked to. It would be great if this can be fixed. Thanks!

---

Which version were you using before? Andrew's latest version was v1.3.3. This mod works by going through each productID until it reaches the end of the DB file. Unless your links are creating brand new productID's in the database, it will not include a duplicate of your product.

Hi

I must have done something not right.
The only way I am able to upload is by FTF my feed and froogle files, than I open the froogle copy /paste it to my feed ( look like froogle files are update better then the feed file) then I upload it manually thru Google., I can’t do it via Admin I always get error.

If that the best way around that’s ok, but if there is a way to make it more simple, please let me know
Thank you

hi

i was using 1.3.2 for all others wont create a file and i kept geting errors. i can create a file but have to use google to upload file with 1.3.2. i upgraded to 1.4.8 and dose the some thing but with out any errors. when i create a file i get


Froogle Data Feeder v.1.4.8 17.07.2007 18:06 started 2007/07/31 22:36:58
Feed file - /home/content/s/i/r/sirryche5/html/feed/froogle.txt
Processing: Feed - Yes, Upload - No
Froogle File Complete In 15.527858 Seconds 3214 Records

with no errors and no up loads so i do step 2 AND GET

Froogle Data Feeder v.1.4.8 17.07.2007 18:06 started 2007/07/31 22:37:56
Feed file - /home/content/s/i/r/sirryche5/html/feed/froogle.txt
Processing: Feed - No, Upload - Yes
Upload started...

i it stays that way . i have let it run for over 10 hrs while i was at work and come home and still the same. when i check the google ftp view in step 2 i get

Google Base FTP content:
Connected to: uploads.google.com
Connection failed: uploads.google.com

but i can use my ftp program and i connect right up? would like to get the upload working with out going to google to upload any suggestions would be great. using zen 1.3.7

could it be that my data is to big. i have over 3000 items i was uploading. thanks

Quote:

---

Originally Posted by numinix

An error will not be produced, the SQL will ignore those lines. If an upgrade to the SQL is needed, an upgrade SQL file is provided. If one is not provided, the update merely requires file overwrites. The installation documentation has been greatly lengthened to avoid any issues.



Which version were you using before? Andrew's latest version was v1.3.3. This mod works by going through each productID until it reaches the end of the DB file. Unless your links are creating brand new productID's in the database, it will not include a duplicate of your product.

---

I have reconfirmed that Andrew's version v 1.3.2 30.01.2007 7:05 DOES NOT produce duplicate, does not include products that have been deactivated and does not include products with $0 (free products).

However version 1.4.8 includes duplicates. The id for the duplicates are not different (which is expected because these are LINKED products not COPIED). If you like I can send you a sample of the file generated to show you how it's picking up duplicates. I have compared your googlefroogle.php in the root of the store to Andrew's and while there are differences I am not sure how and where these differences affect what's generated.

Are you saying that you have linked products on your site but when you generate Google Base yours doesn't include duplicates?

Thanks!

Quote:

---

Originally Posted by BlessIsaacola

I have reconfirmed that Andrew's version v 1.3.2 30.01.2007 7:05 DOES NOT produce duplicate, does not include products that have been deactivated and does not include products with $0 (free products).

However version 1.4.8 includes duplicates. The id for the duplicates are not different (which is expected because these are LINKED products not COPIED). If you like I can send you a sample of the file generated to show you how it's picking up duplicates. I have compared your googlefroogle.php in the root of the store to Andrew's and while there are differences I am not sure how and where these differences affect what's generated.

Are you saying that you have linked products on your site but when you generate Google Base yours doesn't include duplicates?

Thanks!

---

Can you show me samples of linked products on your site? I believe that $0 dollar products are also taken out automatically. In the code it should say $price > 0... I do not have duplicates on my site so an example would be helpful.

As for the FTP, there have been problems with it since v1.3.3 and older that have existed for some members, not all. I will take a look at it for my next update. The FTP functionality has remained the same since Andrew's last version.

For those whom employ Google Checkout I have heard a rumour that a future update to the GC mod will integrate Google Base feed functionality.

Woody

Quote:

---

Originally Posted by numinix

Can you show me samples of linked products on your site? I believe that $0 dollar products are also taken out automatically. In the code it should say $price > 0... I do not have duplicates on my site so an example would be helpful.

As for the FTP, there have been problems with it since v1.3.3 and older that have existed for some members, not all. I will take a look at it for my next update. The FTP functionality has remained the same since Andrew's last version.

---

I am not really sure how this link: http://www.clevershoppers.com/index....ducts_id=13371 is going to help. The product is linked in both http://www.clevershoppers.com/index....ex&cPath=9_168 and http://www.clevershoppers.com/index....x&cPath=12_186 notice I used the word link not copied. This product only exist with one id in the database but when I use the Google Base mod, it's generated twice with the same id.

If I revert to 1.3.3 the problem is gone. If this a problem unique only to our site, I will revert back to 1.3.3 and that will for sure solve my problem. I upgraded simply for the UPC field but I guess deleting more than 4,000 duplicates will not work for me.

Quote:

---

Originally Posted by Woodymon

For those whom employ Google Checkout I have heard a rumour that a future update to the GC mod will integrate Google Base feed functionality.

Woody

---

Thanks for the heads up Woody! That's good news! I just the latest GCO and it's working flawlessly and I love that it now returns to checkout_success.

As I said before, I'll take a look at it. I've noticed one issue that I fixed in the eBay version which I'll add to the GBF as well. I'll take a look at the two scripts side by side sometime tonight.

v1.4.9 beta - GOOGLE BASE FEEDER

1. Code optimization;
2. Updated configuration_group_title;

Code optimization includes a mistake on the specials pricing. Not sure if this will correct the duplicate entries issue as stated above.

Also changed the configuration name to GOOGLE BASE FEEDER CONFIGURATION. Use the update.sql to change the name.

Upload/Overwrite the following files:

/googlefroogle.php
/includes/languages/english/googlefroogle.php

P.S. reason for beta is because I have not determined what is causing the duplicate entries for above poster and may or may not have corrected it with this version.

Hi

Is that will solve my issue i post on Tread 178 ?

Ty

Quote:

---

Originally Posted by motti

Hi

Is that will solve my issue i post on Tread 178 ?

Ty

---

I didn't touch the FTP portion of the code as it currently works for myself and many others. Is your host within the USA?

HI
Yes, it is with hostmonster.

And my Issue like I post before is that even thru Google I am only able to do it if I copy the content of froogle.txt in to feed.txt

Quote:

---

Originally Posted by motti

HI
Yes, it is with hostmonster.

And my Issue like I post before is that even thru Google I am only able to do it if I copy the content of froogle.txt in to feed.txt

---

Try deleting both froogle.txt and feed.txt via cpanel. Then create a new text file with the filename you want to use, and set appropriate write permissions.

Then be sure to reset the name of the file in both your GBF mod configuration and in your Google Base account.

Then attempt to regenerate the file with the GBF mod.

Be sure to disable write permissions on your "feed" directory when you are finished.

BTW I would not name the feed file or directory "feed" or "froogle". Hackers look for such file and directories names. Such names act as a beacon for files/directories with public write permissions potentially left enabled, where pharma and other html can then be easily dumped.

Watch your permissions!

Woody

Woodymon, that is a good point. In fact, from now on I'll have the file chmod the feed file to 777 and then back to 655 before closing. For now, rename as woodymon has suggested.

Quote:

---

Originally Posted by numinix

Woodymon, that is a good point. In fact, from now on I'll have the file chmod the feed file to 777 and then back to 655 before closing. For now, rename as woodymon has suggested.

---

Relatedly I think the directory the feed file is written to needs to be 777 or similar so the file can be overwritten during the feed generation.

Can you automate changing directory permissions also?

Woody

[FONT=Times New Roman]Hi [/FONT]
[FONT=Times New Roman]Yes my folder and my froogle and feed are on 777[/FONT]
[FONT=Times New Roman]I will explain exactly what I am doing, maybe it will help finding what I am doing wrong[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]From my Google item list I click on Bulk upload files, then I click on Update your item by uploading a new version of feed.txt, then I have to go to my admin and update my list , download my 2 file froogle and feed copy the content of froogle in to feed, ( my feed.txt not getting update with the new item I add to my shop) then going back to Google and uploading it, any other way are either not updating my the additional item I add to my Zen shop, or doing nothing at all.[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]I will read thru your post and the link you post , hope I find a shirt way to upload my items[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Thank you [/FONT]

Quote:

---

Originally Posted by numinix

v1.4.9 beta - GOOGLE BASE FEEDER

1. Code optimization;
2. Updated configuration_group_title;

Code optimization includes a mistake on the specials pricing. Not sure if this will correct the duplicate entries issue as stated above.

Also changed the configuration name to GOOGLE BASE FEEDER CONFIGURATION. Use the update.sql to change the name.

Upload/Overwrite the following files:

/googlefroogle.php
/includes/languages/english/googlefroogle.php

P.S. reason for beta is because I have not determined what is causing the duplicate entries for above poster and may or may not have corrected it with this version.

---

1.4.9 generated the google base file faster but it did not resolve the duplicate issue. If you want me to email you a subset of the file generated please let me know.

Hi,

I am getting ready to put my store live, I am using google checkout, and would like to have the "google checkout" badge show for the products in my google base account.

The google base people suggest that you set a "Google Checkout" attribute (don't know if the space should be there or not) for the payment_notes (and not the payment_) column on the bulk upload file.

A couple of questions about this:
1. Do I really need that the payment_notes column with the "Google Checkout" attribute to have the badge show up? (there is also some general confusion about the payment_accepted field, I am included here)
2. If so, how do you deal with this detail? I am thinking on modifying my uploaded googleFroogle.PHPs which might end up being a butchery:)

Thanks very much in adavance

Quote:

---

I am getting ready to put my store live, I am using google checkout, and would like to have the "google checkout" badge show for the products in my google base account.

---

Find out the attribute and I'll have it added in a couple of days.

[FONT=Times New Roman]

Quote:

---

[FONT=Times New Roman]From my Google item list I click on Bulk upload files, then I click on Update your item by uploading a new version of feed.txt, then I have to go to my admin and update my list , download my 2 file froogle and feed copy the content of froogle in to feed, ( my feed.txt not getting update with the new item I add to my shop) then going back to Google and uploading it, any other way are either not updating my the additional item I add to my Zen shop, or doing nothing at all.[/FONT]

---

What you are saying is that although you've set in the Google Base Configuration to use file feed.txt, it continues to write to froogle.txt? When you upgraded to the latest version, did you reupload all the files (except the core overwrites identified in the readme.txt file)? Talk to me in PM and I will take a look at your configuration.[/FONT]

Quote:

---

1.4.9 generated the google base file faster but it did not resolve the duplicate issue. If you want me to email you a subset of the file generated please let me know.

---

It's strange because the two files are nearly identical in structure (1.3.3 and 1.4.9). I will take a look at it again today. You can email me a sample to webmaster AT numinix DOT com

I've figured out the problem and will have it corrected shortly.

v1.4.10 GOOGLE BASE FEEDER

1. Fixed duplicate entries from linked products;
2. Code optimization;

This is not a beta version and will be available in the downloads section or by following the link above.

Hello,

I just downloaded the Google base feeder ver 1.4.8 and its great.. Thank you for everyones help.

I would like to find out how to add one thing. I need to add the weight into every product and the product hiearchy
(meaning: dvd player>samsung>battery>LP1654A, basically the breadcrumb trail) which file do I alter and how???

Thank you,

Avel