Guest Posted January 26, 2011 Share Posted January 26, 2011 I am looking for an add-on that will produce a feed file that I can upload to Google merchant account can someone let me know if there is one I can use Quote Link to comment Share on other sites More sharing options...
Guest Posted January 26, 2011 Share Posted January 26, 2011 Adam, I have noticed you are looking for quite a few 2.3.1 contributions. If they are not in the contribution area, chances are they are not available. So, as in the past with new versions and updates there are a few options for those who want contributions: 1) Wait for the contribution to be rewritten by someone else so you can use it. 2) Rewrite the contribution yourself to be compatible with the new version. 3) Hire someone to rewrite the contribution so you will be the first to have it AND it an be uploaded to the contribution area for others to use as well. You can even put your name on it if you want :thumbsup: So, with those two options in mind.......you get to either wait, write it or pay for it. Choices choices eh ? (sorry, I am Canadian, the 'eh' slipped out) :D Chris Quote Link to comment Share on other sites More sharing options...
spoofy Posted January 26, 2011 Share Posted January 26, 2011 I have used both of these: http://addons.oscommerce.com/info/4513 http://addons.oscommerce.com/info/4385 Quote My Contributions: Google XML Sitemap SEO compatible with Ultimate SEO URL by FWR Media ::: Accurate & Precise Bread Crumb Trail Link to comment Share on other sites More sharing options...
Guest Posted January 26, 2011 Share Posted January 26, 2011 (edited) Spoofy, looking for an add-on for ver 2.3.1 Neither of those is up to date, especially the second one. Chris Edited January 26, 2011 by DunWeb Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 26, 2011 Share Posted January 26, 2011 The google base feed contribution by Geoffrey should work for you. It is not as flxible as the othes and the code has not been updated but it works and doesn't require edits to the shop files, which makes it compatible with all versions. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Guest Posted January 27, 2011 Share Posted January 27, 2011 okay I found one that seems to be working it is Automatic Store Feeds v3.0 but when I try to run the feed all I get is this : SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.techsonhandstore.com/product_info.php?products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.techsonhandstore.com/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM categories, categories_description, products, products_description, products_to_categories left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND products.products_status != 0 AND products.products_price != 0 AND products.products_price != '' ORDER BY products.products_id ASC can someone tell me what is wrong why it wont work Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.