Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
This free add-on report for BV Commerce 5 will be included in SP3 but is available now for anyone running SP2. The report lists all current shopping carts in your store and allow you to view the details (if any) about the cart. INSTALLATION: =================== 1) Unzip the folder/files attached to this post into your /BVModules/Reports/ folder in your store. 2) The report will automatically show up on the reports menu in the admin side as "Shopping Carts" Edited by user Friday, June 3, 2016 12:54:26 PM(UTC)
| Reason: Not specified File Attachment(s):  BVC5_Reports_ShoppingCarts.zip (3kb) downloaded 323 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
|
|
Rank: Member
Joined: 2/18/2006(UTC)
Posts: 172
|
[3]This is the good report for those who don't have a one page checkout. In my case, I don't see customer email or any other info. Thank you anyway![/3]
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
When I first saw this post, I thought, "Oh, that's cool" -- but after implementing it, I can't tell you how useful it is! To be able to see cart contents and to match those up with visitors in my Live Help window helps identify if customers are having a problem. I have also been able to identify a problem a customer was having, she left the site, and I email and asked if I could complete her order manually, which she thought was great customer service, and I closed a sale!
Question: Is the timestamp when a cart is first created or at the last addition of an item? |
|
|
|
|
|
|
Rank: Member
Joined: 1/30/2008(UTC)
Posts: 215
|
What would be nice - an easy way to filter the $0 carts. Even storing for a week with sometimes 500 carts triggering a day (bots seem to trigger them too) you end up with 3500 entries making it tough/impossible to find those with items.
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
Well, it is a free add-on after-all. So, any way to turn it off or get it working? Carts with $0.00 is a waste of database space - any way to empty the report as we can with searched terms?
If bots create an entry... how can a bot shop and fill a cart? |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 1/30/2008(UTC)
Posts: 215
|
Mitch I'm not sure but I know we have far more carts than visitors. I think the cart is created with any new session but we're not sure.
It would be much more useful to see just a number of total carts and then just have the carts with stuff in them listed, JOOH. This kills both birds with the same stone - we can all run conversion data roughly speaking and not have to spend so much time scanning through.
We manually clear out the carts every few days/weeks as it does seem to effect performance a bit too. You do that in the orders tab, set it to zero, save, run report, then set it back to xx days.
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
I would love to see the IP address added to the cart info -- that way I can associate a cart with a given customer that I see in my Live Help application. |
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
Joe, you seem to find a whole lot more value in this than I do. I'm getting a long list of 0.00. Clicking on them gets me to see an empty cart, 1 in 10 will have a product in it and a town, zip... I guess for a shipping quote, but the cart shows 0.00. How do you use the following? Maybe I'm completely missing it. Note that the "order" is marked Paid. MitchA attached the following image(s): Shoppingcart-1.jpg (109kb) downloaded 223 time(s).You cannot view/download attachments. Try to login or register. |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
yes, a $0.00 will be Paid because there is nothing yet to pay. I would say that probably 30 percent of my carts are $0.00 at the most. 60 percent are for the cost of a particularly popular brand of bird food -- I'm not sure what folks are doing -- they haven't entered a zip so they havent' checked shipping rates yet. I guess they are just "thinking" about it, or wondering what happens wh they add to cart -- many of my competition stores don't maintain inventory, don't stock the items, and so customers many times are "surprised" the next day when they are told it's out of stock. It's where I have a big advantage.
So about 10 percent of the carts show a significant number of products and many times will even show the customers full address info -- sometimes even an Order number, but for some reason the order didn't go through -- these I follow up on and usually close the sale. |
|
|
|
|
|
|
Rank: Member
Joined: 1/30/2008(UTC)
Posts: 215
|
Sorry I missed the responses.
Mitch your suggestion is great. We'd love to be able to delete 0 value carts. Something else we notice is carts are created when someone tries to enter something below the minimums for the amount they attempt. IE one item at $5 we'll see a $5 cart even though the error checks toss it back for validation. Dumping zero value carts would allow us to keep 14+ days of data. We swear beyond 5-6 days the system really bogs down. We know it cost sales but what can we do?
Interestingly all of our carts show a default shipping state/country.
We almost never get the same quality data Joe is getting. Not sure why other than maybe most of our visitors are unregistered/new. We know via logs many are competitors price shopping.
|
|
|
|
|
|
Rank: Member
Joined: 4/22/2004(UTC)
Posts: 280
|
This report is VERY useful. Thank you, Marcus!
We don't get the tons of $0 carts, but we find that it isn't updated continuously for some reason. Anyone have any ideas how to get it working in real-time?
Thanks,
Linette
|
|
|
|
|
|
Rank: Member
Joined: 1/30/2008(UTC)
Posts: 215
|
The $0 cart issue is related to thefind bot. I don't believe we signed up for it, it just kind of found us. It and one other similar bot generate session id's as we make no submission to them, they come and find what they want and list us. Again, don't think we've had a single click yet and we end up with 100s of carts a day. Loads of fun :( Just wanted to clarify, it is nothing wrong with the report... As far as delay goes that must have something to do with your DB I'd presume. PromoManagers promo items
|
|
|
|
|
|
Rank: Member
Joined: 4/22/2004(UTC)
Posts: 280
|
The db?
If I put something in the cart (customer view), then go away, then login as admin to view the Shopping Carts report, I don't see my cart.
If I go away again, come back to the store (customer view), my cart is there with the items I put in it, but it's not still not in the Shopping Carts report.
If I come back hours later, my cart might be in the report and it might not.
Any ideas?
Thanks,
Linette
|
|
|
|
|
|
Rank: Member
Joined: 3/3/2006(UTC)
Posts: 1,737
|
A work in progress.
A third party improvement is in the works. |
Optimists invent airplanes,
Pessimists buy parachutes. |
|
|
|
|
|
Rank: Member
Joined: 5/14/2005(UTC)
Posts: 398
|
|
|
|
|
|
|
|
Rank: Member
Joined: 4/10/2006(UTC)
Posts: 462
|
|
Netriplex Corporation<br /> |
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.