Query to remove problem orders:
DELETE FROM [XC.Commerce.SharedEnvironments].[dbo].[CommerceEntities]
WHERE [Id] in (SELECT[CommerceEntityId]
FROM [XC.Commerce.SharedEnvironments].[dbo].[CommerceLists]
where ListName = 'List-problemorders-ByDate')
and
DELETE FROM [XC.Commerce.SharedEnvironments].[dbo].[CommerceLists]
where ListName = 'List-problemorders-ByDate'
No comments:
Post a Comment