Jump to content
Met00

Recover Cart Sales

Recommended Posts

Working pretty good DooD!

 

I have a suggestion...

Regarding stats_recover_cart_sales.php

 

Is there any way to add a reset button to this to clear the scart records and start over? Currently, you have to go into phpMyAdmin and delete the entries manually.


L8r,

PopTheTop

 

Published osC Contributions:

- eCheck Payment Module v3.1

- Reviews in Product Display v2.0

- Fancier Invoice & Packingslip v6.1

- Admin Notes / Customer Notes v2.2

- Customer Zip & State Validation v2.2

- Search Box with Dropdown Category Menu v1.0

 

Pop your camper's top today!

It's a popup thing...

You wouldn't understand

Share this post


Link to post
Share on other sites

It seems like this would not be that hard ... there would need to be a new button added, with a reset action and then something like this maybe:

// Reset Entry Begin
if ($HTTP_GET_VARS['action']=='reset_db') { 
  $reset_query_raw = "TRUNCATE TABLE  " . TABLE_SCART; 
  tep_db_query($reset_query_raw); 
}

 

Not an SQL expert here, so not sure if that's the best way or not. Is there a OSC tep_ method that should be used instead?

 

Also, for the delete there is a redirect back to the page for display purposes; would this be needed with reset as well?

 

Working pretty good DooD!

 

I have a suggestion...

Regarding stats_recover_cart_sales.php

 

Is there any way to add a reset button to this to clear the scart records and start over? Currently, you have to go into phpMyAdmin and delete the entries manually.

Share this post


Link to post
Share on other sites

Sorry for not replying quicker; for some reason I stopped getting emails on posts to this topic.

 

Anyway, I think it's just the "files to upload" that have changed; ie. if you changed the admin main page php to show this mod in the tables that will not have to be changed.

 

Should just be a copy files over existing and be done... but BACKUP FIRST! (please!)

 

Hi Lane,

 

I have just seen this update (I have installed v1.4c).  Is it just the 'files to upload' that have changed or the code changes to the other files?

Share this post


Link to post
Share on other sites

MET00,

 

This contribution is the BOMB!

 

Thank you dearly for your contribution! This contribution has already helped me recover sales that were forever lost and I am greatful for this!

 

Do you have a mailing address as I'd like to pay you something for this contribution!

 

With Regards,

 

MLHmptn

Share this post


Link to post
Share on other sites

Hi!

 

This is really a great contribution! CONGRATULATIONS! Fast and clean installation! I recommend it!

 

THANKS!

 

PS : in the mail sent to customers, is it possible to put the name of the products with their link to the site? It would be easier for the customer to visit the products he abandonned?


OSC2.2

Share this post


Link to post
Share on other sites
Hi!

 

This is really a great contribution! CONGRATULATIONS! Fast and clean installation! I recommend it!

 

THANKS!

 

PS : in the mail sent to customers, is it possible to put the name of the products with their link to the site? It would be easier for the customer to visit the products he abandonned?

 

The email does have a list of all products that were in the customer's cart(s). That cart should still exist when they come back, and they should be able to proceed right to the checkout stage.

 

There is also a link to the store in the email.

Share this post


Link to post
Share on other sites
The email does have a list of all products that were in the customer's cart(s). That cart should still exist when they come back, and they should be able to proceed right to the checkout stage.

 

There is also a link to the store in the email.

 

Hi Lane!

 

You're right but actually the customer can come back and purchase another product. He will then remove the first article from the cart it's why I thought that a link would be usefull. As a customer I will appreciate it as it offers me the possibility to just read its description without having to log in.

 

Thanks for your reply.

 

mujina


OSC2.2

Share this post


Link to post
Share on other sites

Hi folks,

 

Just installed this mod and it's very interesting to see the number of abandoned carts my store has!

 

I realise this was designed as a sales tool, and as such I daresay will remind my customers of where they were up to with an order and will be useful to them and me.

 

2 Quick Questions.

 

1) Has anyone got a fix for the multiple attributes showing in the report as mentioned earlier? I too have this problem. Attributes are required since this is a clothing store and we are using this as a way of recovering cart details for incomplete orders.

 

2) Anyone feel like working on a variation of this mod to allow Admins to complete the checkout process for interrupted or incomplete sales? The old favourite is Paypal payments - if the customer does not return to the site, the order is not completed although we take their money! We get no notification and neither does the customer, so the first we know is an angry email saying "You've had my money, now where's my stuff?"

 

I will have a look at this myself, but my knowledge of php and SQL is very limited and I probably won't get it to work!

 

Many thanks for a great contribution - I have v1.4e on MS1, btw.

Share this post


Link to post
Share on other sites

Hey -

 

I installed this and it worked great - I saw myself with an abandoned cart, and sent the email - but somehow, it's not picking up the variables, as the emaili only read as follows:

 

Subject: EMAIL_TEXT_SUBJECT

Date: January 5, 2005 5:18:20 AM EST

From: mystore's email address

To: my email address (customer)

 

 

EMAIL_TEXT_SALUTATIONFred,EMAIL_TEXT_CURCUST_INTROEMAIL_TEXT_COMMON_BODY

 

*****

 

Note: THE PS contents displayed fine, other than the ole' php apostrophe\backslash problem ... everwhere I'd put a "we'd like to thank" ... it became we\'d like to thank, etc ... I can just remember to not enter a quote or apostrophe.

 

At any case - what did I miss for the email to not pull the correct variables?

 

Thanks in advance,

Fred

Share this post


Link to post
Share on other sites

Doh ...

 

Never mind ... I was positive I'd uploaded the /admin/includes/english/ files ... that's what I get for installing this at 4:30 AM!

 

All is well!

FM

Share this post


Link to post
Share on other sites
Hi folks,

 

Just installed this mod and it's very interesting to see the number of abandoned carts my store has!

 

I realise this was designed as a sales tool, and as such I daresay will remind my customers of where they were up to with an order and will be useful to them and me.

 

2 Quick Questions.

 

1) Has anyone got a fix for the multiple attributes showing in the report as mentioned earlier? I too have this problem. Attributes are required since this is a clothing store and we are using this as a way of recovering cart details for incomplete orders.

 

2) Anyone feel like working on a variation of this mod to allow Admins to complete the checkout process for interrupted or incomplete sales? The old favourite is Paypal payments - if the customer does not return to the site, the order is not completed although we take their money! We get no notification and neither does the customer, so the first we know is an angry email saying "You've had my money, now where's my stuff?"

 

I will have a look at this myself, but my knowledge of php and SQL is very limited and I probably won't get it to work!

 

Many thanks for a great contribution - I have v1.4e on MS1, btw.

 

1) I don't use attributes on my store due to needing direct "buy now" links which I could not figure out how to do with attributes. Long way of saying, I have no experience with this mod and attributes :)

 

2) We use the "orders" list to update status of orders, works well. But, you do need to be using a PayPal IPN module! We are using the PayPal IPN 3.0 module ourselves, but it's a lot of work to integrate. The OSC team just released the official PayPal IPN module which looks extremely easy to implement. Either one should completely solve your non-return problem (it did for me).

Share this post


Link to post
Share on other sites
Hi Lane!

 

You're right but actually the customer can come back and purchase another product. He will then remove the first article from the cart it's why I thought that a link would be usefull. As a customer I will appreciate it as it offers me the possibility to just read its description without having to log in.

 

Good point about the cart; I've had a few times that has buggered me (every now and again paymenow will not return anything to the store, but approve the sale ... very very hard to figure out what they purchased if they messed with their cart afterwards!)

 

It shouldn't be that hard to create a link ... I'll look into it shortly.

Share this post


Link to post
Share on other sites
2) We use the "orders" list to update status of orders, works well. But, you do need to be using a PayPal IPN module! We are using the PayPal IPN 3.0 module ourselves, but it's a lot of work to integrate. The OSC team just released the official PayPal IPN module which looks extremely easy to implement. Either one should completely solve your non-return problem (it did for me).

 

 

Thanks for the reply Lane, hope you had a good Xmas and New Year!

 

What I'm after is a mod that will move the customers order from their shopping cart to the Orders table in OSC. Until then there is no order status to change! If the customer dosen't return to the site, the order is not completed at the OSC end although Paypal processes the payment.

 

It's the part that triggers the confirmation emails to ourselves and the customers that we need a manual way of applying to orders still in the cart table.

 

I'm hoping that someone can look at your code as a basis and add a "Complete" button or checkbox which will do this on a per customer basis, of course I don't want to do it for all customers at once. Then we can send out follow up emails using your system to try to encourage our remaining incomplete customers to return. Our site is quite specialised and I don't think there are that many who have abandoned their carts for no good reason, though the system should hopefully "jog their memories" to return & complete their order.

 

One thing I've implemented on an MS2 version of the site (which I'm having fun & games migrating, but thats another story) is a Wishlist, since I think many have left items in the cart intending to come back & purchase at a later date!

 

Once again, many thanks for the mod!

Share this post


Link to post
Share on other sites
What I'm after is a mod that will move the customers order from their shopping cart to the Orders table in OSC. Until then there is no order status to change! If the customer dosen't return to the site, the order is not completed at the OSC end although Paypal processes the payment.

I would doubly suggest fixing this problem instead of trying to work around it. Try out the official contribution, it looks very easy to install.

 

With the PayPal IPN in place, the customer no longer has to return to your site; you get an update no matter what! Works great :) (I'm not using this exact mod, I'm using this one, but it should work the same. The one I'm using requires a LOT of code edits due to various cool tools it provides, but it's probably overkill ... it has dozens and dozens of files, classes, folders, etc. whereas the official one has only a couple of files and edits.)

 

It's the part that triggers the confirmation emails to ourselves and the customers that we need a manual way of applying to orders still in the cart table.

 

I'm hoping that someone can look at your code as a basis and add a "Complete" button or checkbox which will do this on a per customer basis, of course I don't want to do it for all customers at once. Then we can send out follow up emails using your system to try to encourage our remaining incomplete customers to return. Our site is quite specialised and I don't think there are that many who have abandoned their carts for no good reason, though the system should hopefully "jog their memories" to return & complete their order.

I guess this could be done ... but if you fix the paypal problem via using IPN then you shouldn't need to worry about it anymore. Still... I guess this might be useful at some point ... ? Not sure.

 

One thing I've implemented on an MS2 version of the site (which I'm having fun & games migrating, but thats another story) is a Wishlist, since I think many have left items in the cart intending to come back & purchase at a later date!

Various Wishlist mods you might want to check out

 

Once again, many thanks for the mod!

Your welcome :D

Share this post


Link to post
Share on other sites

i was thinking ... RCS sends out an email in language that is selected in admin part of store, right?

 

well we have several customers from different countries .. but most of them are slovene .. so i select slovenian language for admin part and it sends out slovene email also to customers abroad .. german, italian .. they all receive slovenian email .. off course they don't know what to do with them.

 

is there a solution to put checkboxes under names to select in which language to notify customer?

 

i'ts hard to select one language and then search for german customers .. send .. then change to italian, search for italian customers .. send .. etc

 

thanx .. no need to mention that this contribution is a real bomb!

Share this post


Link to post
Share on other sites
i was thinking ... RCS sends out an email in language that is selected in admin part of store, right?

 

well we have several customers from different countries .. but most of them are slovene .. so i select slovenian language for admin part and it sends out slovene email also to customers abroad .. german, italian .. they all receive slovenian email .. off course they don't know what to do with them.

 

is there a solution to put checkboxes under names to select in which language to notify customer?

 

i'ts hard to select one language and then search for german customers .. send .. then change to italian, search for italian customers .. send .. etc

 

thanx .. no need to mention that this contribution is a real bomb!

 

Hmm.... how would you know which language the customer speaks? Is there a way in osC to lookup a language from the country a customer selects? Could do that and then have a popup menu with the looked-up language selected. (Not sure how to do that, but seems possible)

 

How do you envision checkboxes working?

Share this post


Link to post
Share on other sites
Hmm.... how would you know which language the customer speaks? Is there a way in osC to lookup a language from the country a customer selects? Could do that and then have a popup menu with the looked-up language selected. (Not sure how to do that, but seems possible)

 

How do you envision checkboxes working?

 

yes one way is to have OSC lookup customers country in database .. another way to have checkboxes with available language shown under the name of customer .. how would i know which country is he from .. well .. either add new column "Customers country, pulled out when retreiving other data for customer, or another way to see from email .. wel this one is not sure i guess :)

Share this post


Link to post
Share on other sites

Hey everyone - has anyone ever gotten this error when clicking on the recover cart sales link in the admin:

 

1054 - Unknown column 'l' (ell) in 'where clause'

select p.products_price price, p.products_model model, pd.products_name name from products p, products_description pd, languages l where p.products_id='29{4}2' and pd.products_id=p.products_id and pd.language_id=1

[TEP STOP]

 

It only happens ocassionally - but when it happens, I can't get past it on the recover cart sales link. Also, if I get this error, I can't get anything to show under the "Orders" link... It shows the headings, but no data.

 

Thanks.

Share this post


Link to post
Share on other sites
Hey everyone - has anyone ever gotten this error when clicking on the recover cart sales link in the admin:

 

1054 - Unknown column 'l' (ell) in 'where clause'

select p.products_price price, p.products_model model, pd.products_name name from products p, products_description pd, languages l where p.products_id='29{4}2' and pd.products_id=p.products_id and pd.language_id=1

[TEP STOP]

 

It only happens ocassionally - but when it happens, I can't get past it on the recover cart sales link.  Also, if I get this error, I can't get anything to show under the "Orders" link... It shows the headings, but no data.

 

Have never gotten this myself, and I use it often. It seems to be complaining about the "languages l" portion of the sql query, but I'm a sql newbie so I don't know if that would be correct or not. It seems odd that it would be formed that way, but maybe that's not the full query.

 

Does it give a line #?

Share this post


Link to post
Share on other sites

I am trying to decide whether the Recover Cart Sales is a good match for my site:

 

Will it tell me if a customer tried to purchase the cart items but their credit card was declined? I am using the authorize.net consolidated module to instantly authorize payments, and I would like to know if customers are being declined and why.

 

I assume from reading this thread and the contribution log that the contribution tells you only that items were put in a cart but not sucessfully purchased?

 

Thank you.

Share this post


Link to post
Share on other sites
I am trying to decide whether the Recover Cart Sales is a good match for my site:

 

Will it tell me if a customer tried to purchase the cart items but their credit card was declined?  I am using the authorize.net consolidated module to instantly authorize payments, and I would like to know if customers are being declined and why.

 

I assume from reading this thread and the contribution log that the contribution tells you only that items were put in a cart but not sucessfully purchased?

 

That is correct. None of the payment modules report back why a purchased did not complete. For that information you have to use the vendor supplied tools; I used AuthorizeNet for a while and you can get a daily report on activity and it will tell you much information about each order in the detail; including the reason for any declines.

 

This module is more about getting customers back to complete purchases as well as requesting feedback on why they did not complete orders. (The second has often been very helpful to me in finding out things like AuthorizeNet changing a setting, PayPal not being available, etc.)

Share this post


Link to post
Share on other sites

Hi all,

I installed recover carts, but am having a problems getting it working.

I have put thgough a few test sales and then abandoned the process. When I go to recover carts, nothing shows up.

I was wondering if recover carts works off the status of the order and will only show orders with a status of pending or something like that. I have installed paypal IPN and NOCHEX APC. The paypal status for uncompleted sales is 'paypal pending' and NOCHEX is 'NOCHEX pending'.

The test orders are showing up fine in my customer/orders reports with these status', but as I say, nothing in recover carts.

Hope somebody here can help


OSC Image Magic

On-the-fly thumbnails, watermarks and image processing

Share this post


Link to post
Share on other sites
Hi all,

I installed recover carts, but am having a problems getting it working.

I have put thgough a few test sales and then abandoned the process. When I go to recover carts, nothing shows up.

I was wondering if recover carts works off the status of the order and will only show orders with a status of pending or something like that. I have installed paypal IPN and NOCHEX APC. The paypal status for uncompleted sales is 'paypal pending' and NOCHEX is 'NOCHEX pending'.

The test orders are showing up fine in my customer/orders reports with these status', but as I say, nothing in recover carts.

Hope somebody here can help

Have you tried logging in and placing a product in your cart then logging off without checking out?

Share this post


Link to post
Share on other sites
Have you tried logging in and placing a product in your cart then logging off without checking out?

 

Well I have now :D and it works perfectly.

 

But what about people who are unregistered, add an item, and go all the way through checkout - obviously having registered on the way? When they get to paypal, or nochex and then abandon the process, is there any way to pick those people up and get them into the recover carts process?


OSC Image Magic

On-the-fly thumbnails, watermarks and image processing

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×