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

Ciao di nuovo, mi spiace per questo errore! I `ve visto, è wasn` t ha caricato il file di modello. Ora funziona, grazie.

--- Giorgio

I wish to insert a bigger logo into the template. How to I increase the margins for this? Replacing the default image with a bigger image causes the entire nav bar to move down. 

--- Milan Beharie

Спасибо за ссылку. Можете ли вы обеспечить hook.jpg для модуля позиции.

--- Mikhail

Computer Hardware Magento Theme 57699 work fine for my site, thantk you man. 

--- ANDREJA

Ναι. Έχω εγκαταστήσει ελληνική γλώσσα σε αυτό το Magento πρότυπο. Σας ευχαριστώ για τη βοήθειά σας.

--- CLYTEMNESTRA

Thank you for your answer. I will try and let you know if it's work on my prestashop theme.

--- Claudia Monsalve

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