X-Cart forums

[cflsystems]

It's that part of the query for the images

$q = "SELECT productid, productcode, product, add_date, xcart_products.descr, price, manufacturer, weight, image_type, filename, image_size
FROM xcart_products 
LEFT JOIN xcart_pricing USING(productid)
LEFT JOIN xcart_manufacturers USING(manufacturerid)
LEFT JOIN xcart_images_T ON productid=xcart_images_T.id
WHERE forsale='Y'
ORDER BY add_date DESC
LIMIT 200";

You can either replace xcart_images_T with xcart_images_P which will use actual product images OR take the red out of the query but then there will be no images for the products

[anandat]

Originally Posted by cflsystems

It's that part of the query for the images

$q = "SELECT productid, productcode, product, add_date, xcart_products.descr, price, manufacturer, weight, image_type, filename, image_size
FROM xcart_products 
LEFT JOIN xcart_pricing USING(productid)
LEFT JOIN xcart_manufacturers USING(manufacturerid)
LEFT JOIN xcart_images_T ON productid=xcart_images_T.id
WHERE forsale='Y'
ORDER BY add_date DESC
LIMIT 200";

You can either replace xcart_images_T with xcart_images_P which will use actual product images OR take the red out of the query but then there will be no images for the products

Steve,
I tried with xcart_images_P but then it's not created the feed with above line ! it's just creating single line feed with my site name !!

[cflsystems]

If you don't have images for the products it won't find them. This query returns products which have price, manufacturer, image, are for sale (not hidden or disabled). If one of these is missing the product won't be included