Google Base Feeder Support Thread [OLD]

[SuperDak]

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 

[numinix]

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.

[SuperDak]

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...acturers_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. ;)

[numinix]

try "= 0"

[SuperDak]

try "= 0"

No Dice.

[point0fsale]

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.

[numinix]

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

[MichaelD]

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.

[numinix]

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.

[aqua0322]

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