Jump to content
Met00

Recover Cart Sales

Recommended Posts

Ok, I just installed this contribution and did a test email.

 

The text sent has no formatting to it. Is this normal?

 

Thanks for any advice

Share this post


Link to post
Share on other sites

Hi,

 

I have also installed this contribution (1.3.6a), but it won`t work. On the recover carts page, i always get "No input file specified" if I press the button to send the email, or if I want to display a shorter or longer time period.

 

Has anybody an idee, what I made wrong? (I have checked the install steps 3 times)

 

Thanks and best regards

 

Tom

Share this post


Link to post
Share on other sites

I just installed this contribution but it seems to be displaying sold carts as well as unsold carts. Is this normal?

Also when I click on the customer's name under the tool i get an error:

1064 - You have an error in your SQL syntax near 'where c.customers_lastname like '%Noland%' or c.customers_firstname like '%Nolan' at line 3

 

select count(*) as total from customers c, address_book a, sources s, customers_info i where s.sources_id = c.entry_source_id and i.customers_info_id = c.customers_id and c.customers_id = a.customers_id and c.customers_default_address_id = a. address_book_id where c.customers_lastname like '%Noland%' or c.customers_firstname like '%Noland%' or c.customers_email_address like '%Noland%'

Share this post


Link to post
Share on other sites
Hi,

 

I have also installed this contribution (1.3.6a), but it won`t work. On the recover carts page, i always get "No input file specified" if I press the button to send the email, or if I want to display a shorter or longer time period.

 

Has anybody an idee, what I made wrong? (I have checked the install steps 3 times)

 

Thanks and best regards

 

Tom

Hi i got the same Problem.

 

I made a testaccount put something in my cart and then closed the window.

 

But the tool show me no items in the status window what i maked wrong??

 

2nd Questin for what is this code?

 

 

// E-mail Time to Live :: Default=90
 $EMAIL_TTL = 90;

 

The time a server retry to send the mail to the customer?? Sorry but im a n00b in this :(

Share this post


Link to post
Share on other sites

I have just installed this awesome looking contribution.

After the install I have created a dummy account and added some items and abandoned the shopping cart.

 

It shoes everything OK. But when I tried to send an email. It looks as though it has been sent but I did not get the email.

 

Can anybody help me.

 

Regards,

Share this post


Link to post
Share on other sites

It showed you the cart after you logged out??

 

Wh?ch config did you have?? He show me not a single thing :(

Share this post


Link to post
Share on other sites

I've installed this contribution but I have a problem. Sometimes when I view the recovery carts in tools, I get an error like this:

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 9

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 = '55{8}17' and pd.products_id = p.products_id and pd.language_id = (Japanese character)

 

I'm not sure if it is a Japanese character at the end, but it looks like one. This does not always happen. I can close the browser window and reopen admin and it will work again. It usually happends after I have looked at the who's online screen.

Share this post


Link to post
Share on other sites

Hi!

 

Could someone post a screenshot of the module so that I can see what it looks like and can see some features? Thanks.

Share this post


Link to post
Share on other sites

Hi

Did anyone downloaded Recover Cart Sales v1.4? I downloaded the file and could not open it. I used winzip with error message. Can someone help me? Thanks. :rolleyes:

Share this post


Link to post
Share on other sites
Hi

Did anyone downloaded Recover Cart Sales v1.4? I downloaded the file and could not open it. I used winzip with error message. Can someone help me? Thanks. :rolleyes:

Sorry,

but I have the same problem.... Please can somebody upload a new file also in zip format.

 

Thanks


Thanks Matthias

Share this post


Link to post
Share on other sites

I had this problem once, I just removed the .gz from the file name and saved it, then unzipped it, not sure if it would work for this one, but you could try it.

Share this post


Link to post
Share on other sites

Thanks "airlog"

 

I had this problem once, I just removed the .gz from the file name and saved it, then unzipped it, not sure if it would work for this one, but you could try it.

 

 

It works fine for me.


Thanks Matthias

Share this post


Link to post
Share on other sites

since installing this contribution (which is great other than this problem) whenever i search for a customer name i get

1064 - You have an error in your SQL syntax near 'where c.customers_lastname like '%NAME%' or c.customers_firstname like '%NAME%' at line 3

 

select count(*) as total from customers c, address_book a, sources s, customers_info i where s.sources_id = c.entry_source_id and i.customers_info_id = c.customers_id and c.customers_id = a.customers_id and c.customers_default_address_id = a. address_book_id where c.customers_lastname like '%NAME%' or c.customers_firstname like '%NAME%' or c.customers_email_address like '%NAME%'

 

[TEP STOP]

where NAME = the name searched for.

Share this post


Link to post
Share on other sites

Hi

 

I have just installed the Recover Cart 1.4 and I wonder where I can delete what - because I do not have any delete buttons or so wheter in the reports area nor the tools area.

 

Please - maybe I am just to sleepy or stupid :rolleyes: - need help...

 

cu

kai

Share this post


Link to post
Share on other sites

Great contrib! Thanks.

 

2 silly questions...

 

where and how can I add "Dear" before the customer's first name in the email?

I assume it's in the english language file but I'm not sure where to put it in.

 

what do you mean by "flushing out the database"?

 

Sorry I'm new at this

 

V

Share this post


Link to post
Share on other sites
Hi

 

I have just installed the Recover Cart 1.4 and I wonder where I can delete what - because I do not have any delete buttons or so wheter in the reports area nor the tools area.

 

Please - maybe I am just to sleepy or stupid :rolleyes: - need help...

 

cu

kai

you don't delete with recover carts. It's a sales tool. If you feel a need to "delete" a customer record, just delete the customer.


The king of kluge...

? Do you really know what is and isn't working in your store? ≡ ?

Share this post


Link to post
Share on other sites
Great contrib! Thanks.

 

2 silly questions...

 

where and how can I add "Dear" before the customer's first name in the email?

I assume it's in the english language file but I'm not sure where to put it in.

 

what do you mean by "flushing out the database"?

 

Sorry I'm new at this

 

V

To include the customers name you will have to make changes to the php as well.

 

$email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . tep_catalog_href_link(FILENAME_CATALOG_LOGIN, '', 'SSL') . "\n" . sprintf(EMAIL_TEXT_NEWCUST, $mline) . "\
n". $_POST['message'];

 

Currently the sprintf takes in the $mline which is build to list the cart items. You would have to pass in both the $mline and the customers name. Then you would have to go to the english file and make the mods there to do the replacement.

 

Now a IMHO, which is never humble. I considered this when I was creating the initial code as I feel that personalization is generally a good thing, but I rejected this as a "good idea" as it didn't fit well with the fact that the message is "generated" as a form letter. If the goal is to get people to think that you care about customer service (remember, that's the goal of the form letter, to get feedback and see if there were problems) personalization comes off as a tad phoney and doesn't add a great deal of value. In fact, it looks almost spam-like. So, while it is possible to do, I would avoid it.

 

As for the database issue. There is one database created by the program, and even if you beat the bejesus out of your recover_carts it won't grow that large as there is not a great deal of data stored in it. If, on the other hand, you are talking about the customer data on what they have in their carts, that's not part of the recover_cart system, but part of standard OSC. All recover_carts does is peek into the standard tables.


The king of kluge...

? Do you really know what is and isn't working in your store? ≡ ?

Share this post


Link to post
Share on other sites

Can somebody write an ADMIN to edit the email subject, body, and include an option to have a stored default PS message? -these will be an option on the ADMIN side-

 

It is too difficult for newbies to edit the hard coded email and would make thing just simpler for the contri. ;)

Share this post


Link to post
Share on other sites
Can somebody write an ADMIN to edit the email subject, body, and include an option to have a stored default PS message? -these will be an option on the ADMIN side-

 

It is too difficult for newbies to edit the hard coded email and would make thing just simpler for the contri. ;)

Keep in mind that this is my personal opinion, BUT....

 

First they are not "hard coded", so if a "newbie" can't edit a text file they shouldn't be using OS Commerce. Most of the customizing of the core OSC requires the editing of text files that we like to call language files. By the way, how did you get RCS installed if you find editing a text file "too difficult" for you? I would think the install is more difficult that editing a text file with notepad, but that's me.

 

With that said, the file recover_cart_sales.php doesn't take a high level tech degree to comprehend. It is in plan English.

 

If you want to change the subject, then change the text for "EMAIL_TEXT_SUBJECT". If you want to change the message body change the "EMAIL_TEXT_CURCUST_INTRO" and/or EMAIL_TEXT_COMMON_BODY.

 

They are in a language file that is no more complicated than the old Windows INI files. They are separated from the main code, so that they would not be hard coded. That is one of the many things the language files are for.

 

To create an admin for these simple tasks would be a big task. It would require that these items be moved to the database, and it would have to be able to support all languages. Then they would require DB calls to get this information. One of the goals is to keep unneeded DB calls down. This admin you are asking for not only would complicate a the install of the product, it complicates the coding, and it risks slowing the display of information down.

 

Oh by the way... DB is short for DataBase.

 

Now I know I have not posted for a while, but I couldn't let any of you forget my sarcastic posts. I am sorry the one who said there is no stupid questions hasn't been to America in the last twenty years. :)

 

Adios...

Share this post


Link to post
Share on other sites

Aalst, sorry for being such a lamer, but i am fairly new to OSC and PHP and wiring DB.

 

Hmm, can you help me with the code so the PS Message box has a default INITIAL VALUE inside it? Maybe this will be easier than always typing in the same message all the time or maybe have something like "Admin Comments Toolbar"

 

http://www.oscommerce.com/community/contributions,869

 

Thanks

Share this post


Link to post
Share on other sites
Aalst, sorry for being such a lamer, but i am fairly new to OSC and PHP and wiring DB.

 

Hmm, can you help me with the code so the PS Message box has a default INITIAL VALUE inside it? Maybe this will be easier than always typing in the same message all the time or maybe have something like "Admin Comments Toolbar"

 

http://www.oscommerce.com/community/contributions,869

 

Thanks

Now that is a good suggestion. I will post the "hack" below, since I have not looked at RSC 1.4 yet, I am still running 1.3.6a, and I do not have the time to make a full fledge release. You will need to edit two php text files.

 

First you need to add a new line to the language file recover_cart_sales.php in at least the language(s) you use. (admin/includes/languages/english/) Find the line:

define('PSMSG', 'Additional PS Message: ');

Then add this line below it:

define('PSMSG_DEFAULT_TEXT', 'Default Text');

Change the "Default Text" to what ever you want, or even leave it blank.

 

Next you need to edit the file /admin/recover_cart_sales.php and search for the text:

tep_draw_textarea_field('message', 'soft', '80', '5')

It should be around 447 in version 1.3.6a.

 

Replace that text with this:

tep_draw_textarea_field('message', 'soft', '80', '5', PSMSG_DEFAULT_TEXT)

 

Presto... you know have a PS Message default text.

 

Good Luck...

 

-Aalst

 

[Hopefully who ever does the next release will include this in it, if I do not get around to it :)]

Edited by Aalst

Share this post


Link to post
Share on other sites
To include the customers name you will have to make changes to the php as well. 

 

$email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . tep_catalog_href_link(FILENAME_CATALOG_LOGIN, '', 'SSL') . "\n" . sprintf(EMAIL_TEXT_NEWCUST, $mline) . "\
n". $_POST['message'];

 

JM -- Tsk tsk.. it still a good idea as long as it is optional.

 

Here is a hack to add what ever greating you want in front of the name.

 

First you need to add a new line to the language file recover_cart_sales.php in at least the language(s) you use. (admin/includes/languages/english/) Find the line:

define('EMAIL_TEXT_SUBJECT', 'Inquiry from '.  STORE_NAME );

 

Then add this line below it:

define('EMAIL_TEXT_EMAIL_TEXT_SALUTATION', 'Dear ' );

 

You can change the greeting from "Dear" to what ever you want just make sure there is a space after it, or just leave it empty for no greeting if you change your mind in the future. I think if this is included in a future release it should be empty by default.

 

Next you need to edit the file /admin/recover_cart_sales.php and search for the text:

$email = $inrec['fname'] . ",";
[code]
It should be around 234 in version 1.3.6a.

Replace that text with this:
[code]
$email = EMAIL_TEXT_SALUTATION . $inrec['fname'] . ",";

Presto... you know have a Salutation of your choice before the users first name.

 

Now I agree with JM about not using this, however, the above hack will allow you to do it if you want, and easily remove it if you change your mind in the future.

 

AS for the DB Flushing that was a comment listed on the 1.4 release and I agree with JM that I do not see who the RCS data would need this unless some how you are using MySQL and hitting the 4gb limit on the Table size which would be hard to do. You would have to ask Willross who released 1.4 why he makes the claim that "YOU MUST FLUSH OUT THE 'scart' DB OCCASIONALLY!" because again I agree with JM on the scart specific data is minor and would be very difficult to hit the table size limitations with it. Because Willross says it will prevent uncontacted errors, well I have not had any uncontacted errors.

 

Anyway... good luck with the hack if you use it.

 

-Rodney

 

[Hopefully who ever does the next release will include this in it, if I do not get around to it :)]

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

×