Jump to content



Photo
* * * * - 5 votes

Recover Cart Sales


  • Please log in to reply
1079 replies to this topic

#1   Met00

Met00
  • Members
  • 318 posts
  • Real Name:JM Ivler
  • Gender:Male
  • Location:Los Alamitos, CA

Posted 26 November 2003 - 00:37

This thread will be used to discuss the Recover Cart Sales Tool.

If you are using Unsold Carts and are ready to move up from a report to a sales tool, then this is the next generation.

Originally this code was released in a thread on abandoned carts as scart.php. Over time the report from that thread became Unsold Carts and made it to a stable release in version 1.7. At that time the Unsold Carts 1.7 code was tacken and scarts was rewritten on that code base. That created version 1.0 of the Recover Cart Sales.

A pointer to the location in Contribs will follow.

(I needed to create this thread for the readme).
The king of kluge...
¿ Do you really know what is and isn't working in your store? ≡ ¤

#2   Met00

Met00
  • Members
  • 318 posts
  • Real Name:JM Ivler
  • Gender:Male
  • Location:Los Alamitos, CA

Posted 26 November 2003 - 01:06

I abhore zip!

But to make it easy, I used zip.

http://www.oscommerc...tributions,1688

The code has been released.
The king of kluge...
¿ Do you really know what is and isn't working in your store? ≡ ¤

#3   azer

azer
  • Members
  • 842 posts
  • Real Name:azer
  • Location:Paris, france

Posted 26 November 2003 - 05:32

cool im gonna give you feedback with ms1 version
MS2

#4   valley

valley
  • Members
  • 259 posts
  • Real Name:Sreedharan Pillai
  • Location:Wombourne, U.K.

Posted 26 November 2003 - 07:25

Downloaded and Installed like a song !

One of the most useful contibutions ever !
I discovered 66 Abandoned carts which I didn't know
were there ! Could contact all of them by the press of a
Button . this is amazing.

It will be nice to know what the actual E mail says somewhere !
without digging to find out in the code.

#5   Met00

Met00
  • Members
  • 318 posts
  • Real Name:JM Ivler
  • Gender:Male
  • Location:Los Alamitos, CA

Posted 26 November 2003 - 07:56

Downloaded and Installed like a song !

One of the most useful contibutions ever !
I discovered 66 Abandoned carts which I didn't know
were there ! Could contact all of them by the press of a
Button . this is amazing.

It will be nice to know what the actual E mail says somewhere !
without digging to find out in the code.

Read the readme. /rolleyes.gif' class='bbc_emoticon' alt=':rolleyes:' />
New -> 
Thank you for stopping by STORE_NAME and considering us for your purchase. We noticed that in your visit to our store that you placed the following item(s) in your shopping cart, but did not complete the transaction with us.  "\n\n" Cart Contents: "\n\n".'%s' . "\n\n" . 'We are always interested in knowing what happened and if there was a reason that you decided to not purchase with STORE_NAME at this time. If you could be so kind as to let us know if you had any issues or concerns, we would like to address them as getting this feedback from you and others is how we can help make your experience at STORE_NAME  better. "\n\n" Again, thank you for your time and consideration in helping us make STORE_NAME "\n\n" STORE_OWNER ."\n".STORE_NAME . "\n". HTTP_SERVER .DIR_WS_CATALOG 

Customer ->
Firstoff, we would like to thank you for having purchased from STORE_NAME in the past.  Secondly, We noticed that in your visit to our store that you placed the following item(s) in your shopping cart, but did not complete the transaction with us. "\n\n" 'Cart Contents:'. "\n\n".'%s' . "\n\n" . 'We are always interested in knowing what happened and if there was a reason that you decided to not purchase with STORE_NAME at this time. If you could be so kind as to let us know if you had any issues or concerns, we would like to address them as getting this feedback from you and others is how we can help make your experience at STORE_NAME better. "\n\n". 'Again, thank you for your time and consideration in helping us make STORE_NAME ."\n\n". STORE_OWNER ."\n".STORE_NAME . "\n". HTTP_SERVER  DIR_WS_CATALOG

The uppercase items are picked up from the defines (or the store configuration) The %s is the cart contents. All this is in the /languages/english php files... like I said, read the readme. /tongue.gif' class='bbc_emoticon' alt=':P' />
The king of kluge...
¿ Do you really know what is and isn't working in your store? ≡ ¤

#6   bodyfeelings

bodyfeelings
  • Members
  • 71 posts
  • Real Name:Matthias F.
  • Location:Germany

Posted 26 November 2003 - 08:43

First of all: Thank You !!!

Now I want to help the german users with the german translation:

<?php
/*
  $Id: recover_cart_sales.php,v 1.0 2003/11/23 21:01:31 $

  Recover Cart Sales contrib: JM Ivler (c)
  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Released under the GNU General Public License
  
*/

define('EMAIL_TTL', '90');
define('BASE_DAYS', '10');

define('EMAIL_SEPARATOR', '------------------------------------------------------');
define('EMAIL_TEXT_SUBJECT', 'Anfrage von '.  STORE_NAME );
define('EMAIL_TEXT_NEWCUST', "\n\n".'Vielen Dank für Ihren Besuch bei ' . STORE_NAME . ' und Ihr uns entgegengebrachtes Vertrauen. Wir haben gesehen, daß Sie bei Ihrem Besuch in unserem Onlineshop den Warenkorb mit folgenden Artikeln gefüllt haben aber den Einkauf nicht vollständig durchgeführt haben. ' . "\n\n" . 'Inhalt Ihres Warenkorbes:'."\n\n".'%s' . "\n\n" . 'Wir sind immer bemüht unseren Service im Interesse unserer Kunden zu verbessern. Aus diesem Grund interessiert es uns natürlich, was die Ursachen dafür waren, Ihren Einkauf dieses Mal nicht bei '. STORE_NAME . ' zu tätigen. Wir wären Ihnen daher sehr dankbar, wenn Sie uns mitteilen würden, ob Sie bei Ihrem Besuch in unsererm Onlineshop Probleme oder Bedenken hatten den Einkauf erfolgreich abzuschließen. Uns Ziel ist es Ihnen und anderen Kunden den Einkauf bei '. STORE_NAME . ' leichter und besser zu gestalten. '."\n\n". 'Nochmals, vielen Dank für Ihre Zeit und Ihre Hilfe den Onlineshop von '. STORE_NAME . ' zu verbessern.' . "\n\n". 'Mit freundlichen Grüßen' . "\n". 'Ihr Team von ' . STORE_NAME . "\n". HTTP_SERVER . DIR_WS_CATALOG . "\n");
define('EMAIL_TEXT_CUST', "\n\n".'Vielen Dank für Ihren erneuten Besuch bei ' . STORE_NAME . ' und Ihr wiederholtes uns entgegengebrachtes Vertrauen. Wir haben gesehen, daß Sie bei Ihrem Besuch in unserem Onlineshop den Warenkorb mit folgenden Artikeln gefüllt haben aber den Einkauf nicht vollständig durchgeführt haben. ' . "\n\n" . 'Inhalt Ihres Warenkorbes:'."\n\n".'%s' . "\n\n" . 'Wir sind immer bemüht unseren Service im Interesse unserer Kunden zu verbessern. Aus diesem Grund interessiert es uns natürlich, was die Ursachen dafür waren, Ihren Einkauf dieses Mal nicht bei '. STORE_NAME . ' zu tätigen. Wir wären Ihnen daher sehr dankbar, wenn Sie uns mitteilen würden, ob Sie bei Ihrem Besuch in unsererm Onlineshop Probleme oder Bedenken hatten den Einkauf erfolgreich abzuschließen. Uns Ziel ist es Ihnen und anderen Kunden den Einkauf bei '. STORE_NAME . ' leichter und besser zu gestalten. '."\n\n". 'Nochmals, vielen Dank für Ihre Zeit und Ihre Hilfe den Onlineshop von '. STORE_NAME . ' zu verbessern.' . "\n\n". 'Mit freundlichen Grüßen' . "\n". 'Ihr Team von ' . STORE_NAME . "\n". HTTP_SERVER . DIR_WS_CATALOG . "\n");

define('HEADING_TITLE', 'Recover Cart Sales v1.0');
define('DAYS_FIELD_PREFIX', 'Zeige letzen ');
define('DAYS_FIELD_POSTFIX', ' Tage ');
define('DAYS_FIELD_BUTTON', 'Anzeigen');
define('TABLE_HEADING_DATE', 'Datum');
define('TABLE_HEADING_CONTACT', 'kontaktieren?');
define('TABLE_HEADING_CUSTOMER', 'Kunden Name');
define('TABLE_HEADING_EMAIL', 'E-Mail');
define('TABLE_HEADING_PHONE', 'Telefon');
define('TABLE_HEADING_MODEL', 'Artikel');
define('TABLE_HEADING_DESCRIPTION', 'Beschreibung');
define('TABLE_HEADING_QUANTY', 'Menge');
define('TABLE_HEADING_PRICE', 'Preis');
define('TABLE_HEADING_TOTAL', 'Summe');
define('TABLE_GRAND_TOTAL', 'Summe netto Gesamt: ');
define('TABLE_CART_TOTAL', 'Summe netto: ');
define('PSMSG', 'Zusätzliche Nachricht (PS) am Ende der Mail: ');
?>

<?php
/*
  $Id: report_recover_cart_sales.php,v 2.0 2003/10/24 21:01:31 $

  report_recover_cart_sales contrib: JM Ivler 11/23/03
  (c) Ivler/ osCommerce
  http://www.oscommerce.com

  Released under the GNU General Public License
  
*/

define('BASE_DAYS', '3');
define('HEADING_TITLE', 'Recover Cart Sales Report v1.0');
define('DAYS_FIELD_PREFIX', 'Zeige die letzen ');
define('DAYS_FIELD_POSTFIX', ' Tage ');
define('DAYS_FIELD_BUTTON', 'OK');
define('TABLE_HEADING_CUSTOMER', 'KUNDEN NAME');
define('RECORDS', 'In Überprüfung befindliche Datensätze:');
define('SALES', 'Verkäufe:');
?>

Gruß Matthias
Thanks Matthias

#7   ahearn

ahearn
  • Validating
  • 43 posts
  • Real Name:Andrew Hearn

Posted 26 November 2003 - 20:11

This works really well! (using MS2) I did a reply to one of my test accounts, and the PS text came just after the Cart Contents, and before the "We are always interested in knowing what..." text.

The Readme file said the PS mesage would be after the signature...

(This was tested on a customer acount that had previosly made a purchase from the store)

#8   Met00

Met00
  • Members
  • 318 posts
  • Real Name:JM Ivler
  • Gender:Male
  • Location:Los Alamitos, CA

Posted 26 November 2003 - 20:19

This works really well! (using MS2) I did a reply to one of my test accounts, and the PS text came just after the Cart Contents, and before the "We are always interested in knowing what..." text.

I'll take a look at that.
The king of kluge...
¿ Do you really know what is and isn't working in your store? ≡ ¤

#9   urbach

urbach
  • Members
  • 105 posts
  • Real Name:Steven
  • Location:Zürich

Posted 27 November 2003 - 19:36

this contribution is awsome. I already have customer coming back after sending them the email reminder. Great job Met00 and thanks to bodyfeelings for the geman translation.

PS I was wondering if this is allowed, looking up what customer havent puchased and sending them a reminder. E-Commerce Laws??

Steven

/biggrin.gif' class='bbc_emoticon' alt=':D' /> /smile.gif' class='bbc_emoticon' alt=':)' /> /rolleyes.gif' class='bbc_emoticon' alt=':rolleyes:' />

#10   p-r

p-r
  • Members
  • 14 posts
  • Real Name:Paweł Robaczewski
  • Location:Poland

Posted 27 November 2003 - 20:53

Hi!

Great job, Met00!
I have just posted on the contributions site un updated package that contains polish and german (by bodyfeelings) translations. I also have moved some things to the language files, namely the "Send e-mail" button description and the "Back to report" text.

By the way, on my site the contrib DOES put the PS message after the signature, contrary to what ahearn suggested.

#11   raul

raul
  • Members
  • 43 posts
  • Real Name:Andrzej Sawiniec

Posted 27 November 2003 - 21:57

I think I've installed this contribution as it should have been installed but when I search for "abadoned carts" I have:

Examined Records: 0
Sales: 0

And it doesn't matter how much days I check.
I know there is my test abadoned cart and it's not showing.

The scart database is empty. (Just as it was when it was added).

Could anyone help me?

Thanks in advance.

Kind regards,
Raul

#12   Met00

Met00
  • Members
  • 318 posts
  • Real Name:JM Ivler
  • Gender:Male
  • Location:Los Alamitos, CA

Posted 28 November 2003 - 00:31

By the way, on my site the contrib DOES put the PS message after the signature, contrary to what ahearn suggested.

That's good, because I have yet to be able to duplicate the issue.
The king of kluge...
¿ Do you really know what is and isn't working in your store? ≡ ¤

#13   Met00

Met00
  • Members
  • 318 posts
  • Real Name:JM Ivler
  • Gender:Male
  • Location:Los Alamitos, CA

Posted 28 November 2003 - 00:32

I think I've installed this contribution as it should have been installed but when I search for "abadoned carts" I have:

Examined Records: 0
Sales: 0

And it doesn't matter how much days I check.
I know there is my test abadoned cart and it's not showing.

The scart database is empty. (Just as it was when it was added).

Could anyone help me?

Thanks in advance.

Kind regards,
Raul

If you have a cart that you have sent e-mail to, and the scart table is empty, then it did not write to the table. Did you add the table name to application_top.php?
The king of kluge...
¿ Do you really know what is and isn't working in your store? ≡ ¤

#14   raul

raul
  • Members
  • 43 posts
  • Real Name:Andrzej Sawiniec

Posted 28 November 2003 - 00:57

If you have a cart that you have sent e-mail to, and the scart table is empty, then it did not write to the table. Did you add the table name to application_top.php?

I haven't send any e-mail yet because I don't see any cart.

I did write the name of the table in the application_top.php.

I checked the customer cart table and there are carts (but no final price) and date.

My shop is MS2. Only polish languge and the date format is changed to d m Y. Maybe that's the problem?

Kind regards,
Raul

Edited by raul, 28 November 2003 - 01:01.


#15   JanetMor

JanetMor
  • Members
  • 4 posts
  • Real Name:Janet Morningstar

Posted 28 November 2003 - 06:01

This might sound pretty stupid but I am new to these contributions and some of it can be pretty daunting. I have followed the instructions included in the read me file for this contribution but I am unsure of one thing. It says
the new SQL table

CREATE TABLE `scart` (
`scartid` INT( 11 ) NOT NULL AUTO_INCREMENT,
`customers_id` INT( 11 ) NOT NULL ,
`dateadded` VARCHAR( 8 ) NOT NULL ,
PRIMARY KEY ( `scartid` )
);

and then later says

Create the database table scart

I have no idea where or how to create this database. After hours of searching and reading, I am hoping that someone here can lend a hand. I think that this is all that is left for me to do to get this contribution up and running. Thanks.

#16   LeeH

LeeH
  • Members
  • 121 posts
  • Real Name:Lee Harrison

Posted 28 November 2003 - 07:16

Met00,


This is a fantastic contribution! Thanks for you hard work!

Do you use VJ's Link Manager, by chance? If so, have you considered adding the email and color coding to his admin reports? I've managed to hack together several canned emails to use with the Links Mgr mod, along with a modified report, but I don't have the ability to color code in any meaningful way or select multiple contacts to send a "personalized" form letter in bulk.

Thanks again for a great mod!
Lee

#17   Met00

Met00
  • Members
  • 318 posts
  • Real Name:JM Ivler
  • Gender:Male
  • Location:Los Alamitos, CA

Posted 28 November 2003 - 09:03

This might sound pretty stupid but I am new to these contributions and some of it can be pretty daunting. I have followed the instructions included in the read me file for this contribution but I am unsure of one thing. It says
the new SQL table

CREATE TABLE `scart` (
`scartid` INT( 11 ) NOT NULL AUTO_INCREMENT,
`customers_id` INT( 11 ) NOT NULL ,
`dateadded` VARCHAR( 8 ) NOT NULL ,
PRIMARY KEY ( `scartid` )
);

and then later says

Create the database table scart

I have no idea where or how to create this database. After hours of searching and reading, I am hoping that someone here can lend a hand. I think that this is all that is left for me to do to get this contribution up and running. Thanks.

you have to create a new table. This is generally done using a tool like MyPHPAdmin which interfaces to the database. Then you runn the SQL (create table code) in the SQL box of the tool.
The king of kluge...
¿ Do you really know what is and isn't working in your store? ≡ ¤

#18   p-r

p-r
  • Members
  • 14 posts
  • Real Name:Paweł Robaczewski
  • Location:Poland

Posted 28 November 2003 - 09:05

I haven't send any e-mail yet because I don't see any cart.

I did write the name of the table in the application_top.php.

I checked the customer cart table and there are carts (but no final price) and date.

My shop is MS2. Only polish languge and the date format is changed to d m Y. Maybe that's the problem?

Kind regards,
Raul

Hi,

I'm using polish translation (exactly the one posted in the contribution section), have d-m-y date format and everything works fine for me. Maybe you don't see any carts in recover_cart_sales.php simply because there was nobody who put items in the cart and didn't finished the checkout procedure?
My hint: set up a account by yourself, put something in the cart and then check the recover carts in the admin section once again.

#19   p-r

p-r
  • Members
  • 14 posts
  • Real Name:Paweł Robaczewski
  • Location:Poland

Posted 28 November 2003 - 09:06

By the way, I'm using MS1 and it seems for me you don't have to make any adjustments to get it working both in MS1 and MS2.

Edited by p-r, 28 November 2003 - 09:07.


#20   Met00

Met00
  • Members
  • 318 posts
  • Real Name:JM Ivler
  • Gender:Male
  • Location:Los Alamitos, CA

Posted 28 November 2003 - 09:07

Met00,


This is a fantastic contribution! Thanks for you hard work!

Do you use VJ's Link Manager, by chance? If so, have you considered adding the email and color coding to his admin reports? I've managed to hack together several canned emails to use with the Links Mgr mod, along with a modified report, but I don't have the ability to color code in any meaningful way or select multiple contacts to send a "personalized" form letter in bulk.

Thanks again for a great mod!
Lee

No, I don't use the links controller. Feel free to steal from my code to make the changes you want to make in VJ's.
The king of kluge...
¿ Do you really know what is and isn't working in your store? ≡ ¤