API Modified for Product feeds

default: all products
http://megastore.onlineofficefurniture.co.nz/index.php?route=feed/api&func=getProducts
no product detail
http://megastore.onlineofficefurniture.co.nz/index.php?route=feed/api&func=getPromo
SELECT product.product_id, product.model,product.image,product.price,product_description.name FROM product, product_description WHERE quantity >0 AND product.product_id = product_description.product
get with product description
http://megastore.onlineofficefurniture.co.nz/index.php?route=feed/api&func=getPromoAll
SELECT product.product_id, product.model,product.image,product.price,product_description.name, product_description.description FROM product, product_description WHERE quantity >0 AND product.product_id = product_description.product_id
Get Categories
http://megastore.onlineofficefurniture.co.nz/index.php?route=feed/api&func=getCategorys

http://megastore.onlineofficefurniture.co.nz/index.php?route=feed/api&func=getCategory2Product
SELECT category_description.category_id, category_description.name FROM category_description
Get desks
http://megastore.onlineofficefurniture.co.nz/index.php?route=feed/api&func=getDesks
Get storage
http://megastore.onlineofficefurniture.co.nz/index.php?route=feed/api&func=getStorage
Get Filing
http://megastore.onlineofficefurniture.co.nz/index.php?route=feed/api&func=getFiling
SELECT product.product_id, product.model,product.image,product.price,product_description.name FROM product, product_description, product_to_category WHERE quantity >0 AND product.product_id = product_description.product_id AND product_to_category.product_id = product.product_id AND product_to_category.category_id = 76
Possible
http://megastore.onlineofficefurniture.co.nz/index.php?route=feed/api&func=getgetProductSpecials

SEO updates