Expired Carts not Expiring

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

Home / Forums / Developers (Main Products) Forum / Customized Commerce 13 and earlier versions /

Adam Finzel

Vote:

Hey,

I have a lot of carts with a null for meta.modified. This means the Episerver expiry script will not expire those baskets as it says

Meta.Modified <  GETDATE()

am I missing something or is there a bug in the expiry script? Here is the sql I ran to see the missed baskets

select count(*) from ordergroup left outer join OrderGroup_ShoppingCart on ([OrderGroup_ShoppingCart].ObjectId=OrderGroup.OrderGroupId) where modified is null

#205461

Jul 11, 2019 13:10

Quan Mai

Vote:

That is strange, as Modified is always updated to the DateTime.UtcNow when you save the cart via AcceptChanges(). How you ended there, I am not quite sure

#205463

Jul 11, 2019 16:38

Adam Finzel

Vote:

Thanks, so I should be able to remove them?

#205464

Edited, Jul 11, 2019 17:17

Quan Mai

Vote:

Technically you can try to update modified with created value (which is mandatory) then you can remove them by the scheduled job

#205465

Jul 11, 2019 18:56

Adam Finzel

Vote:

Thanks I will remove them then.

#205883

Jul 26, 2019 9:51

This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.