Google Base Feeder Support Thread [OLD]

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

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

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

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