[TYPO3-commerce] deleting old basket records

[Ralf Merz]

Hi Ingo,

I know I wanted to do that some time ago. But it didn´s happen yet 
because of having no time.
But if someone else is interested to write that script, this would be nice.

Regards
Ralf


On 2009-01-30 07:34:23 +0100, Ingo Schmitt <spam at marketing-factory.de> said:

> Hi,
> 
> anyone interested to write a cli skript for commerce for this task?
> 
> ingo
>> 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
> 
> 
> 
> Mit freundlichen Gruessen