OpenCart Community

Opencart seems to save items in the shopping cart from previous shopping sessions. Is there an easy way to have shopping cart contents cleared after a certain amount of time? I have tried both extensions for this and neither of them work.

Version 2.0.3.1

You mean logged customer shopping cart, right?

Yes that is correct. Logged customer shopping cart

You can do it easily. In the file system/library/cart/cart.php, find following line
Above line basically remove all the expired carts with no customer ID. You can modify it for any customer. For example:

This is actually interesting because my abandon cart module save the cart after every login by the customer.
Even when the abandon cart triggers the mail, then tomorrow when customer logs in, the products in cart are still there and abandon cart will save them once again.

@opencartmart
Will work on 2.1.0.2?

thanks!

I am not sure about working with abandon cart module. It depends how abandon cart module works actually.

Well there is only 1 way to find out.

Using your query. Is there a way to make it in seconds or in minute interval only?

$this->db->query("DELETE FROM " . DB_PREFIX . "cart WHERE date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)");

Yes you can use MINUTE or SECOND instead of DAY but what is the point?

to test if it really got cleared so I do not have to wait 1 hour

do you put this query in a php file or where?

The above solution will work for OC version > 2.1, for other version, you can do following

in the file system/library/customer.php, You can replace following line
by
Thanks

Thanks, what exactly does this change do?

It will clear customer old cart whenever he/she login

I just tried it and it didnt work.

Could I insert this line below this code?


$customer_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "customer WHERE LOWER(email) = '" . $this->db->escape(utf8_strtolower($email)) . "' AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('" . $this->db->escape($password) . "'))))) OR password = '" . $this->db->escape(md5($password)) . "') AND status = '1' AND approved = '1'");
}




$this->db->query("UPDATE " . DB_PREFIX . "customer SET cart = ''");

Can you share your code? Have you replaced correctly?

opencartmart wrote: ↑

Thu Dec 29, 2016 1:18 pm

You can do it easily. In the file system/library/cart/cart.php, find following line

Code: Select all

$this->db->query("DELETE FROM " . DB_PREFIX . "cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)");

Above line basically remove all the expired carts with no customer ID. You can modify it for any customer. For example:

Code: Select all

$this->db->query("DELETE FROM " . DB_PREFIX . "cart WHERE date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)");

Thank you! This worked for me!

Glad to hear. Thanks

opencartmart wrote:in the file system/library/customer.php, You can replace following line

Code: Select all

$cart = unserialize($customer_query->row['cart']);

by

Code: Select all

$cart =array();

worked on spot in my OC v.1.5.6.5_rc Version, just to mention it!
Ernie