Google Base Feeder Support Thread [OLD]

kitcorsa:

any idea why my site wont upload??

www.fire2you.co.uk

ive just been doing it manually via the google page but will want to do this via a cron job

kitcorsa, check my previous posts. i think i had the same problem as you and i found a solution.

You can just create two cron jobs.

One for feed=yes and one for upload=yes a couple of minutes later.

is this mod compatible w/ 1.3.8? I just use the generate not the upload....

greenhat:

kitcorsa, check my previous posts. i think i had the same problem as you and i found a solution.

just cant understand why my rubberduckbathrooms.co.uk site works perfectly fine but the fire2you.co.uk site doesn't

they both running 1.3.7 and both had the google base installed at the same time.

only difference is that fire2you.co.uk, the site which isn't working correct, has the patches for 1.3.8 to allow me to use paypal express checkout.

uploading the thing manually through filezilla or google page aint to big of a problem but would be nice to just do it as a cron job.

kitcorsa:

just cant understand why my rubberduckbathrooms.co.uk site works perfectly fine but the fire2you.co.uk site doesn't

they both running 1.3.7 and both had the google base installed at the same time.

only difference is that fire2you.co.uk, the site which isn't working correct, has the patches for 1.3.8 to allow me to use paypal express checkout.

uploading the thing manually through filezilla or google page aint to big of a problem but would be nice to just do it as a cron job.

I guess if you're using the same host for both sites, maybe the problem is different.. but you can still use the solution described here:
http://www.zen-cart.com/forum/showpost.php?p=487468&postcount=722

just on the same host (you dont need to make another account since your host is not the problem).. just use the script to manually ftp to the google ftp server.

7. Go to Admin->Tools>Google Froogle Feeder

This is not thier to do? Its missing from the menu.

5. Go to Admin->Configuration->Google Froogle Configuration and setup all parameters;

This one is thier tho? Didnt see any errors when I ran the SQL installation... ? What should i check

evermind figured out you got to put the files in the appropriate directories not just one directory for all the files of this mod :D

Is there a way to modify the output file to exclude certain products?? I'm currently running the MAP pricing module ( http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=158 ) and need to exclude products that have a 1 in the map_enabled field in the products table. Any help would be appreciated.

in the sql query you would want to put a WHERE clause when map_enabled != 1. //If it equals 1, it won't be included.

numinix:

in the sql query you would want to put a WHERE clause when map_enabled != 1. //If it equals 1, it won't be included.

would that be somwhere in the googlefroogle.php file??

Sorry for not being specific.. I meant the googlefroogle.php at the store root. Not enough sleep the past few days! :(

Was this what you were referring to??

					$products_query = "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, s.specials_new_products_price, s.expires_date, 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, p.products_condition, p.products_category
												 FROM " . TABLE_PRODUCTS . " WHERE "p.map_enabled != 1 ."p

That is one of the areas. You would need to add it to the correct sql query that would be used depending on your google base feeder configuration settings.

The code you wrote though is wrong:

AND p.map_enabled != 1
```

you also need to add p.map_enabled to the SELECT line.

numinix:

in the sql query you would want to put a WHERE clause when map_enabled != 1. //If it equals 1, it won't be included.

I entered the code you mentioned, still included the map_enabled products:

                if (GOOGLE_BASE_ASA == 'true') {
                    $products_query = "SELECT p.products_id, p.map_enabled, 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, s.specials_new_products_price, s.expires_date, 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, p.products_condition, p.products_category
                                                 FROM " . TABLE_PRODUCTS . " p
                                                     LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)
                                                     LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)
                                                     LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON (p.products_type=pt.type_id)
                                                     LEFT JOIN " . TABLE_SPECIALS . " s ON (s.products_id = p.products_id)
                                                 WHERE p.products_status = 1
                                                      AND p.products_type = 1
                                                      OR p.products_type = 4
                                                      OR p.products_type = 2
                                                      OR p.products_type = 5
                                                     AND p.product_is_call = 0
                                                     AND p.product_is_free = 0
                                                     AND pd.language_id = " . (int)$languages->fields['languages_id'] ."
                                                     AND p.map_enabled != 1
                                                 ORDER BY p.products_last_modified DESC";
                } else {
                    $products_query = "SELECT p.products_id, p.map_enabled, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, s.specials_new_products_price, s.expires_date, 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 " . TABLE_PRODUCTS . " p
                                                     LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id)
                                                     LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON (p.products_id = pd.products_id)
                                                     LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON (p.products_type=pt.type_id)
                                                     LEFT JOIN " . TABLE_SPECIALS . " s ON (s.products_id = p.products_id)
                                                 WHERE p.products_status = 1
                                                      AND p.products_type = 1
                                                      OR p.products_type = 4
                                                      OR p.products_type = 2    
                                                      OR p.products_type = 5
                                                      AND p.product_is_call = 0
                                                     AND p.product_is_free = 0
                                                     AND pd.language_id = " . (int)$languages->fields['languages_id'] ."
                                                     AND p.map_enabled != 1
                                                 ORDER BY p.products_last_modified DESC";

For example, all of our Magnaflow products have the MAP pricing enabled, but your feeder is still including them:

Products: http://moesperformance.com/index.php?main_page=index&manufacturers_id=26

XML Feed: http://moesperformance.com/feed/domain_products.xml

I thank you for your help so far, hopefully it's just something simple. ;)

try "= 0"

numinix:

try "= 0"

No Dice. :(

bekinky:

Hi all - can someone tell me why I get the following message from the cron email:

Processing: Feed - Yes, Upload - No

I am assuming it is not being uploaded to Google and have no idea why. Can anyone shed any light on it? The ftp username and password are set the same as shown in the googlebase account.

Thanks

Paul
It did not upload the file. If you will separate the crons for create and then have one about 15 minutes later to upload it should work. Have one cron for create only and another for upload only.

SuperDak:

No Dice. :(

You need to set all your products that are not map_enabled to 0.

Then if map_enabled = 0, it will be included, otherwise it won't.

Or try <> 1

There isn't != for SQL

Please can anyone help me with an install problem I'm having? I've searched and searched and searched for this with many different keywords but found nothing.

1. I've uploaded all the files to my store directory as per instructions and checked that they are all in the proper locations.
2. I set the permissions on the feed directory to 777
3. I opened the file googlefroogle.sql in my text editor and copied the code to the clipboard.
4. I went to Admin->Tools->Install SQL Patches and pasted the code into the Enter the query to be executed box and clicked send.
5. I got the following error message in my browser: > 406 Not Acceptable

An appropriate representation of the requested resource /admin/sqlpatch.php could not be found on this server.

6. I checked on my server and the file exists in the admin directory and...
7. I've tried changing its permissions to 777
8. I've tried re-uploading the file and again switching it to 777
   But all I get is the 406 error message quoted above and I've run out of ideas.

I'm using Google Base Feeder v1.6.7 with Zen Cart 1.3.7 and ** Database Patch Level: 1.3.7**

Database: MySQL 4.1.21-standard-log
HTTP Server: Apache/1.3.37 (Unix)
PHP Version: 4.4.4 (Zend: 1.3.0)
Server Host: green.sashbox.net
Server OS: Linux 2.4.21-37.0.1.ELsmp

Any help would be much appreciated,

Regards to all,

Michael.

Hmm, do you get this error with all SQL patches? Perhaps you should make a new thread as this thread is for issues specific to the Google Base Feeder.

hi,

this is specific to the google base feeder install.

the configuration entry shows up, but the entry to run the feed is not there.

this guy had the same issue
"7. Go to Admin->Tools>Google Froogle Feeder

This is not their to do? Its missing from the menu.

5. Go to Admin->Configuration->Google Froogle Configuration and setup all parameters;

This one is their tho? Didn't see any errors when I ran the SQL installation... ? What should i check"

he said he didnt have the files installed in the correct directories, what are the correct directories?

thanks