[TYPO3-commerce] deleting old basket records

[Ingo Schmitt]

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
-- 
Ingo Schmitt                        mailto:is at marketing-factory.de
Marketing Factory Consulting GmbH   http://typo3.marketing-factory.de/
Content Management mit Typo3: Beratung - Schulung - Realisierung