Thread: manipulating data in back end.

Are there any implications of making updates / deletes to products through the back end.

I would like to delete all products for a certain manufacturer. There are about 10. Will run into any problems doing it this way?

DELETE FROM Products
WHERE PRODUCT ID IN (1,2,3,4,5,6,7,8,9,10)

DELETE FROM ProductVariant
WHERE PRODUCT ID IN (1,2,3,4,5,6,7,8,9,10)

Thank you.

You could try a more simply query instead of passing in specific Ids.

Try something like this:

Delete From Product
Where ProductId IN (
Select p.ProductId From Product p inner join ProductManufacturer pm on pm.ProductId = p.ProductId
Where m.ManufacturerId = 1234
)

1234 = The ID of the Manufacturer you want to delete products for.

The query for the ProductVariant table is very similar.

Just ensure you remove records from ProductManufacturer, Product, and ProductVariant.

I am actually using the nukeproduct sp. Figured this is the best way to go.