Beanshell to remove old carts

[Former Member]

Hi,

I want to write a beanshell to remove all baskets in year 2016. Any help?

Thanks a lot

yamen

[andyfletcher]

Something like this?

 for (o : spring.getBean("flexibleSearchService").search("select {pk} from {order} where {date} between '2016-01-01' and '2017-01-01'").getResult()) {
   spring.getBean("modelService").remove(o);
 }

or in Groovy

 flexibleSearchService.search(/select {pk} from {order} where {date} between '2016-01-01' and '2017-01-01''/).result.each {
   modelService.remove it
 }

[crescenzorega]

hi, try to see if it helps

Removing Old Carts with Cronjob https://help.hybris.com/6.7.0/hcd/8c3a6caf866910148cd58d649958d7e2.html