The User carts data will be removed automatically once a month by cs-cart.
However if you want to remove the data that has been left behind by visitors yourself you can do that to. This is what the help desk told me.
[quote]In order to remove it manually you should click on the “Upgrade center” link on the “DB Backup/Restore” page and enter the following query into the text area of the “Update database” section:[/quote]
DELETE FROM `cscart_user_session_products` WHERE `cscart_user_session_products`.`type` = 'C' AND `cscart_user_session_products`.`user_type` = 'U';
[quote]and click on the “Submit” button at the bottom.[/quote]
This only works for those visitors that are not registrerd. If you want to delete that data as well this is what you need to do:
[quote]Click on the “Upgrade center” link on the “DB Backup/Restore” page and enter the following query into the text area of the “Update database” section:[/quote]
DELETE FROM `cscart_user_session_products` WHERE `cscart_user_session_products`.`type` = 'C' AND `cscart_user_session_products`.`user_type` = 'R';
[quote]and click on the “Submit” button at the bottom.[/quote]