Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: advanced search

  1. 06-16-2010, 01:54 PM #1
    moystoys is offline Junior Member
    Join Date
    Jun 2010
    Posts
    1

    Default advanced search

    I have about 15000 products on my website and there seems to be a few hundred with missing images, is there a way to do an advanced search to list all products with missing images?

    moystoys
  2. 06-16-2010, 10:42 PM #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    You can select your products directly in the sql by executing this query: Select ProductId, Name, SKU from product. Take note of the ProductID, go to {root}/images/products/Large folder, you can determine if the product do not have image uploaded yet because it's not there in that folder. That's pretty much a manually process, since we do not store any images into the DB.