Bulk all the photos of the product

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
8 年 前
I am wondering how it is possible to remove all pictures of a particular product.
I understand that in the case where there are three or four pictures, it can be easily done through the administration panel. But in my case, the customer (owner of the store) is going to add 10 - 20 photos!
I tried to export to Excel document, but the document displays only three photos - http://screencast.com/t/r9yBRcqE7.
Help me please!
8 年 前
Hi,

You can do it manually by executing the command command over your SQL Server:
DELETE FROM Picture
WHERE [Id] in (SELECT PictureId FROM Product_Picture_Mapping WHERE ProductId = {PRODUCTID})

Replace {PRODUCTID} with your product ID.
8 年 前
a.m. wrote:
Hi,

You can do it manually by executing the command command over your SQL Server:
DELETE FROM Picture
WHERE [Id] in (SELECT PictureId FROM Product_Picture_Mapping WHERE ProductId = {PRODUCTID})

Replace {PRODUCTID} with your product ID.


Thank you for tour quick response.
As far as I can understand, by executing this command SQL will just delete these images from product properties. But also I need these images to deleted from the storage (server where the are saved).
8 年 前
Pictures are stored into database (by default). So they will also be deleted.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.