London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

AI OnAI Off

Delete all data in price table

Vote:
 

Hello, how to delete all data from pricing programmatically ?
Thank you

#207315
Sep 17, 2019 8:41
Erik Norberg
Erik Norberg
Vote:
 
#207394
Sep 18, 2019 16:32
Quan Mai
Quan Mai
Vote:
 

Here is a starting point https://vimvq1987.com/permanently-drop-prices-products/

You can change UpdatePrices to something like this

            var prices = _priceDetailService.List(contentLink);
            _priceDetailService.Delete(newPrices.Select(x => x.PriceValueId));

You can also use IPriceService.SetCatalogEntryPrices() which can delete prices if you pass an empty price list.

It'd be interesting to see which is faster ...

#207427
Sep 19, 2019 16:45
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.