Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

How do I find all products with no image? Rate Topic   - - - - -


Posted 03 December 2009 - 06:54 PM #1

Hi All, I'm trying to catch up with product details and tracking down the odd product here and there with no image. What's the easiest way to bring up this list?

I've tried diggin through the database and create a view with just those product, but I haven't quite got it. It seems that no_image isn't stored by default, but it's in the application logic instead of the db.

Any ideas? Thanks,
Next Adventure- New & Closeout Outdoor Gear


Posted 03 December 2009 - 07:26 PM #2

Alright, for future reference this is what I came up with for now:
SELECT prod.product_id, prod.product, img.image_id  FROM cscart_product_descriptions as prod
left join cscart_product_images_links as img
ON prod.product_id = img.product_id
WHERE img.image_id is NULL

Hope that helps someone. Thanks!
Next Adventure- New & Closeout Outdoor Gear