Guest Posted February 16, 2004 Share Posted February 16, 2004 I think you have found a very elegant method there dimports; although the ability to do what recover carts does now is also important, because most people don't came back to your site. Quote Link to comment Share on other sites More sharing options...
cgchris99 Posted March 8, 2004 Share Posted March 8, 2004 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 Quote Link to comment Share on other sites More sharing options...
HIGH-FLYERS Posted March 10, 2004 Share Posted March 10, 2004 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 Quote Link to comment Share on other sites More sharing options...
mattwho Posted March 17, 2004 Share Posted March 17, 2004 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%' Quote Link to comment Share on other sites More sharing options...
mattwho Posted March 19, 2004 Share Posted March 19, 2004 Does this cotribution work? If so anyone know how to fix my problem? Quote Link to comment Share on other sites More sharing options...
Guest Posted March 25, 2004 Share Posted March 25, 2004 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 :( Quote Link to comment Share on other sites More sharing options...
zaps Posted March 27, 2004 Share Posted March 27, 2004 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, Quote Link to comment Share on other sites More sharing options...
Guest Posted March 27, 2004 Share Posted March 27, 2004 It showed you the cart after you logged out?? Wh?ch config did you have?? He show me not a single thing :( Quote Link to comment Share on other sites More sharing options...
paraxx Posted March 31, 2004 Share Posted March 31, 2004 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. Quote Link to comment Share on other sites More sharing options...
czar Posted April 1, 2004 Share Posted April 1, 2004 Hi! Could someone post a screenshot of the module so that I can see what it looks like and can see some features? Thanks. Quote Link to comment Share on other sites More sharing options...
akkinmore Posted April 1, 2004 Share Posted April 1, 2004 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: Quote Link to comment Share on other sites More sharing options...
bodyfeelings Posted April 1, 2004 Share Posted April 1, 2004 HiDid 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 Quote Thanks Matthias Link to comment Share on other sites More sharing options...
airolg Posted April 1, 2004 Share Posted April 1, 2004 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. Quote Link to comment Share on other sites More sharing options...
bodyfeelings Posted April 2, 2004 Share Posted April 2, 2004 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. Quote Thanks Matthias Link to comment Share on other sites More sharing options...
mattwho Posted April 6, 2004 Share Posted April 6, 2004 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted April 6, 2004 Share Posted April 6, 2004 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 Quote Link to comment Share on other sites More sharing options...
notset4life Posted April 7, 2004 Share Posted April 7, 2004 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted April 10, 2004 Share Posted April 10, 2004 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted April 10, 2004 Share Posted April 10, 2004 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. Quote Link to comment Share on other sites More sharing options...
duffythedog Posted April 19, 2004 Share Posted April 19, 2004 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. ;) Quote Link to comment Share on other sites More sharing options...
Aalst Posted April 19, 2004 Share Posted April 19, 2004 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... Quote Link to comment Share on other sites More sharing options...
duffythedog Posted April 19, 2004 Share Posted April 19, 2004 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 Quote Link to comment Share on other sites More sharing options...
Aalst Posted April 19, 2004 Share Posted April 19, 2004 (edited) 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 April 19, 2004 by Aalst Quote Link to comment Share on other sites More sharing options...
Guest Posted April 19, 2004 Share Posted April 19, 2004 (edited) Great Tool! Edited April 19, 2004 by bythevineyard Quote Link to comment Share on other sites More sharing options...
Aalst Posted April 19, 2004 Share Posted April 19, 2004 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 :)] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.