Missing Images report

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
7 years ago
How can I run a query to find out what images I am missing for my products.
0
7 years ago
Can you explain what you mean by "missing images"? I can mean a few. :)
Lam Woon Cherk
https://www.pronopcommerce.com

Looking to double your store's sale? Check out this plugin: http://bit.ly/2YVP8GT
(And no, it's not about putting more marketing money to get more traffics)

Sign up to my mailing list for tons of tips on nopCommerce: http://bit.ly/2fg5fMy
0
7 years ago
If you mean 'which products have not been set up with any pictures', then you can run this from a SQL tool like SSMS (or your host's SQL control panel)


select p.Name, p.Sku, p.Published
  from [Product] p
 where p.Deleted = 0
   and NOT EXISTS (select 1 from [Product_Picture_Mapping] ppm where ppm.ProductId = p.Id)
www.noptools.com
2
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.