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

Hi

I follow the direction and set up from my host control panel as instruction,
5 * * * GET http://www.tiledepot.us/googlefroogle.php?feed=yes&upload=yes
I recive an Email saying /bin/sh: 0: command not found

Any idea what did I do wrong?
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

Thank you

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.

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.

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.

Hi Numinix

I do have 2 site , on my live site I install the 1.4.2 and it dose look like all is good.
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 .
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

I completely remove it from my site demo before uploading the files, should I run the upgrade sql also?

Thank you

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
https://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>

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

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?

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.

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.

Hi Numinix

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