[TYPO3-commerce] deleting old basket records

[hartmut]

ok, thanks Morten.

For anyone interested here is my sql command:

DELETE FROM `tx_commerce_baskets` WHERE `finished_time` = 0 AND `tstamp` 
< UNIX_TIMESTAMP('2009-01-01')

this keeps all the finished baskets from the past and all from this year.

regards
harmut

Morten Olesen schrieb:
> Hi Harmut,
> 
> To the best of my knowledge there is no way to deleted the aborted 
> purchases outside of doing it directly in the DB.
> 
> If a function is made for this purpose it should include a hook to add 
> to / override the where clause of the delete statement - since the 
> basket table is the logical place to store whishlists, saved baskets, etc.
> 
> /Morten Olesen
> 
> hartmut wrote:
>> Hi there,
>>
>> I just noticed that our shop has accumulated thousands of basket 
>> records over time.
>> Is there an elegant way to get rid of them? (other than directly in 
>> the database by sql).
>>
>> Or is there a way to set the lifetime of a basket?
>>
>> hartmut