Expired Carts not Expiring

Calling all developers! We invite you to provide your input on Feature Experimentation by completing this brief survey.

AI OnAI Off

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

Expired Carts not Expiring

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.