Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
A cool feature of nopCommerce is to be able to see what registered customers have saved in their cart and not purchased yet. Is this possible which uCommerce?
If you have a customer - you could select the newest PurchaseOrder (with the customer assignet to it) with the basket status.
Just note that the customer could have more than one basket (on different browsers or devices, or even expired baskets)
Basically I want to run a query each week and return all customers that have outstanding products in their basket, and get a list of all the products?
Is all the customer login before they get a basket assigned (so no basket is anonymous)?
I think you would have to make changes to the way baskets are assigned - to limit the ammount of basket per customer to one for it to work properly.
http://www.publicvoid.dk/ChangingTheDefaultBasketBehaviorOfUCommerce.aspx
When that is done, you can fetch a list of all baskets and i think you have the information you are after.
You can search for order status in the backend including orders in "basket" state.
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
Find Out What Users Have In Their Carts?
A cool feature of nopCommerce is to be able to see what registered customers have saved in their cart and not purchased yet. Is this possible which uCommerce?
If you have a customer - you could select the newest PurchaseOrder (with the customer assignet to it) with the basket status.
Just note that the customer could have more than one basket (on different browsers or devices, or even expired baskets)
Basically I want to run a query each week and return all customers that have outstanding products in their basket, and get a list of all the products?
Is all the customer login before they get a basket assigned (so no basket is anonymous)?
I think you would have to make changes to the way baskets are assigned - to limit the ammount of basket per customer to one for it to work properly.
http://www.publicvoid.dk/ChangingTheDefaultBasketBehaviorOfUCommerce.aspx
When that is done, you can fetch a list of all baskets and i think you have the information you are after.
You can search for order status in the backend including orders in "basket" state.
is working on a reply...