How to automatically send data feed to Froogle?

E-mail Print PDF

The product line in your osCommerce Template does not change often, so I did not combine limited the export to ACTIVE products. If you have inactive products, you might need to change the script.

Also, the category levels are only 2 deep, and the 2nd level would not make too much sense to Froogle. Again, if you have a different method for your categories and naming, you might need to change the script.
Also, even though I got my feed approved / validated by Google, please make sure to go through the process to get it validated by Google for your store.


mysql -uXXX -pXXX -DXXX -e "select concat('http://YOUR_DOMAIN_GOES_HERE

/product_info.php?products_id=',products.products_id) AS product_url, products_description.products_name

AS name, products_description.products_description AS description, FORMAT(products.products_price,2) AS

price, CONCAT('http://YOUR_DOMAIN_GOES_HERE/images/',products.products_image) AS image_url,

categories_description.categories_name AS category FROM categories, products, products_description,

categories_description, products_to_categories 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_description.categories_id=IF(categories.parent_id='0',categories.categories_id,categories.parent_id)"

/tmp/FILENAME_PER_GOOGLE_SPECS.txt

Testimonials

Le agradezco su ayuda y apoyo.Laughing

--- Migual

Dziękujemy za radą i dziękuję za instalowanie temat Magento i Magento dla mnie

--- A. Drwal

Bedankt voor je snelle antwoord. Ik ben momenteel de overdracht van de site naar een nieuwe server. Stuurt u de link zeer binnenkort.

--- Piet de Wolf

I have no idea how to remove the catagories, could you try and do it via the admin panel please? 

--- Pete

Fishing Store Responsive PrestaShop Theme for my PrestaShop 1.6.x shop, good!

--- GØRAN

 
You are here: Tips and Tricks How to automatically send data feed to Froogle?