Google Base Feeder Support Thread [OLD]

[batteryman]

You would need to edit the SQL query to also pull the products_weight and then write a line to output the products_weight under the appropriate heading.

I'm not sure what the breadcrumbs are as I've never used them.

I tried doing this but this is the error I got.

1066 Not unique table/alias: 's'
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_weight, 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, 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 FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) LEFT JOIN zen_specials s ON (s.products_id = p.products_id) LEFT JOIN TABLE_PRODUCTS_WEIGHT s ON (s.products_weight = p.products_weight) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = 1 ORDER BY p.products_id ASC]

I edited the file file googlefroogle.php in the main folder. pleasse help me get this fixed.

I have added the file as an attachment if some wants to see what I did. I am not a php or mysql programmer so I pieced it together .

thank you