Not Taken
Allow filtering on whether a inventory item has a picture
Mark Aldous
said
almost 11 years ago
This will not be implemented into the system.
You can run the below SQL from Dashboards -> Query Data as a custom query to identify SKU's that do not have any images.
SELECT ItemNumber
FROM StockItem si
LEFT OUTER JOIN Stock_ImageReg sir on sir.fkStockItemId = si.pkStockItemID
WHERE sir.pkImageId is null
You can run the below SQL from Dashboards -> Query Data as a custom query to identify SKU's that do not have any images.
SELECT ItemNumber
FROM StockItem si
LEFT OUTER JOIN Stock_ImageReg sir on sir.fkStockItemId = si.pkStockItemID
WHERE sir.pkImageId is null
Kevin Mullard
Updating the filter option so that you can make it show inventory items with / without picture would resolve this issue.
This is relevant when needing to add pictures to inventory items which may have been missed during an original import, or created on the channels and imported.
3 people like this idea