Google Base Feeder Support Thread [OLD]

[customgt]

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

[customgt]

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

[SuperDak]

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.

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