Not Taken

Allow filtering on whether a inventory item has a picture

Currently there seems to way to determine which products have Pictures and which do not which manually scrolling through the entire list with pictures enabled.

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
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

Login to post a comment