|
Group: Forum Members
Last Active: Wed 22 Jul 2020
Posts: 153,
Visits: 874
|
A backend useful feature, requested to me by a customer, would be a view of saved carts from all customers... this would give to a shop administrator an important "marketing tool" (i.e. knowing what customer saved in cart, he could send an email to customer with a coupon to encourage the conversion of the purchase).
The list should show the customer name (with a link to customer's details), last cart update date and the items in cart (could be even a list of accordions with customer and date in header and items inside the expandible panel)
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
Hi,
I was thinking about this today and I thought that you could actually use the admin database function to achieve what you wanted.
If you go to the backend and select [Configuration] > [Database Admin] > [Run Query] you could just run a select query from there.
The following SELECT Command will show you all of the saved baskets and what versions are in there, you would simple need to make some extra JOINs to get the product description etc. and the customer email address to allow you to chase them up.
Do you think that would do what you wanted as a quick fix?
SELECT * FROM
tblKartrisSavedBaskets sb INNER JOIN tblKartrisBasketValues bv on bv.BV_ParentID= sb.SBSKT_ID and bv.BV_ParentType='s'
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|