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?
XForm - Opencart Form Builder
Xshippingpro - An advanced Shipping Module
Need Professional support? Skype: opencartmart
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:
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)");
Code: Select all
$this->db->query("DELETE FROM " . DB_PREFIX . "cart WHERE date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)");
XForm - Opencart Form Builder
Xshippingpro - An advanced Shipping Module
Need Professional support? Skype: opencartmart
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!
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.
XForm - Opencart Form Builder
Xshippingpro - An advanced Shipping Module
Need Professional support? Skype: opencartmart
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)");
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?
XForm - Opencart Form Builder
Xshippingpro - An advanced Shipping Module
Need Professional support? Skype: opencartmart
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
in the file system/library/customer.php, You can replace following line
Code: Select all
$cart = unserialize($customer_query->row['cart']);
Code: Select all
$cart =array();
XForm - Opencart Form Builder
Xshippingpro - An advanced Shipping Module
Need Professional support? Skype: opencartmart
It will clear customer old cart whenever he/she login
XForm - Opencart Form Builder
Xshippingpro - An advanced Shipping Module
Need Professional support? Skype: opencartmart
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 = ''");
$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?
XForm - Opencart Form Builder
Xshippingpro - An advanced Shipping Module
Need Professional support? Skype: opencartmart
Thank you! This worked for me!opencartmart wrote: ↑Thu Dec 29, 2016 1:18 pmYou 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: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)");
Code: Select all
$this->db->query("DELETE FROM " . DB_PREFIX . "cart WHERE date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)");
Glad to hear. Thanks
XForm - Opencart Form Builder
Xshippingpro - An advanced Shipping Module
Need Professional support? Skype: opencartmart
worked on spot in my OC v.1.5.6.5_rc Version, just to mention it!opencartmart wrote:in the file system/library/customer.php, You can replace following linebyCode: Select all
$cart = unserialize($customer_query->row['cart']);Code: Select all
$cart =array();
Ernie
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Who is online
Users browsing this forum: No registered users and 57 guests
