Jump to content

Aalst

Members
  • Content count

    197
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Rodney S. Foley
  • Location
    Phoenix, AZ
  • Website
  1. Aalst

    Recover Cart Sales

    I believe it still displays the full price in the tool as a reference, it was a much more simple approach. However, when the e-mail is sent no pricing is sent since it is a customer service (soft sell) message. As for the triplicate issue I do not really understand. Can you provide a link to a screen shot of the issue?
  2. Aalst

    Recover Cart Sales

    There is a date stamp for the cart, I always wait at least 1 day before sending them a message. This prevents me from contacting soming in the process of shopping, and if someone maybe coming back that same day. The chances of someone saving the cart for a future purchase is very very low. However as the message is worded they would not be offended by it and would most likely just let you know they are planning on returning. That is because it doesn't take up hardly any space in the DB and there is no REAL need to delete or "flush" the information that RCS adds. The carts being saved in the DB is a function of the CORE OSC and is not something that RCS added. The scart Table only containts two int(11)'s and a varchar(8) and I have been running this for over 6 months and I only have 4k of data in that table. I think if you look back a few pages of this topic you will see where JM posted how much space his scart table holds and he created this tool and the previous report and has more data in there than anyone and it actual space was used was nothing. If you want to flush it, which I don't recommend, you can use what ever tool your host provides most likely phpMyAdmin and then just "Empty" the scart table. -Aalst
  3. Aalst

    Recover Cart Sales

    JM... that is the link I was looking for... I couldn't find it, so I just reposted the info here... >shurg<
  4. Aalst

    Recover Cart Sales

    Again I don't recommend running a RCS version with delete features. This is off topic but here is how you do it: First you need to add a new line to the language file stats_customers.php in at least the language(s) you use. (admin/includes/languages/english/) Find the line: define('TABLE_HEADING_CUSTOMERS', 'Customers'); Then add this line below it: define('TABLE_HEADING_ORDERS', 'Orders'); Next you need to edit the file /admin/stats_customers.php and find the line (around line 55): <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMERS; ?></td> Then add this line below it: <td class="dataTableHeadingContent" align=center><?php echo TABLE_HEADING_ORDERS; ?></td> Then find this next line (around line 60): $customers_query_raw = "select c.customers_firstname, c.customers_lastname, sum(op.products_quantity * op.final_price) as ordersum from " . TABLE_CUSTOMERS . " c, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS . " o where c.customers_id = o.customers_id and o.orders_id = op.orders_id group by c.customers_firstname, c.customers_lastname order by ordersum DESC"; Replace that line with this one: $customers_query_raw = "select c.customers_firstname, c.customers_lastname, sum(op.products_quantity * op.final_price) as ordersum, c.customers_id as cid from " . TABLE_CUSTOMERS . " c, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS . " o where c.customers_id = o.customers_id and o.orders_id = op.orders_id group by c.customers_firstname, c.customers_lastname order by ordersum DESC"; Next find the following line (around line 69): while ($customers = tep_db_fetch_array($customers_query)) { Right after this line add the following lines: $customers_query_numords = tep_db_query("select orders_id from " . TABLE_ORDERS . " where customers_id ='".$customers['cid']."' "); $orders = tep_db_num_rows($customers_query_numords); Finally find this line (around line 80): <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CUSTOMERS, 'search=' . $customers['customers_lastname'], 'NONSSL') . '">' . $customers['customers_firstname'] . ' ' . $customers['customers_lastname'] . '</a>'; ?></td> And add the following line after it: <td class="dataTableContent" align=center><?php echo $orders; ?></td> Presto... you know have a new column on your Customer Orders-Total report showing who your best customers are by dollar amount, and also showing the number of orders they have made to get that dollar amount. I hope that helps you...
  5. Aalst

    Recover Cart Sales

    It has No Hyperlinks and No Prices since I been involved in with RCS. It is just a simple plain text message. Feel free to add those features if you wish.
  6. Aalst

    Recover Cart Sales

    It is sent as PLAIN TEXT and has only new lines for formating. If when you get the message it should have empty lines seperating information so that it is easier to read. This is normal and the safest way to send the message so that everyone can read it. If it is coming in some other way, check to see what method your server is using to send messages and see if can possibly be changing the message, or check your e-mail software you use to view it to see if it is removing lines or something.
  7. Aalst

    Recover Cart Sales

    This gives more info that the one I previous replied to. However RCS just gives it's customer request to: /admin/customers.php The search is then being handled by that file. The RCS tool just provides a LAST name for the search. You would have to trouble shoot the customers.php file as to why it doing this. I have tried and cannot replicate this issue.
  8. Aalst

    Recover Cart Sales

    JM -- apparently Willross released a 1.4 version of RCS on March 31st 2004 and he says in the comments that he "Added 'delete' feature in two places" He doesn't say where those two places are and I am not using 1.4. Saletco -- You may want to see if you can contact Willross some how, see if he put contact info in the readme of 1.4. Anything realted to changes in 1.4 I do not know anything about and it sounds like JM has it used it either.
  9. Aalst

    Recover Cart Sales

    where NAME = the name searched for. That error shouldn't be related to RCS, because you can't search for a customer in it. Sounds like you are getting this error in another part of OSC like the Customer Admin. If so this can't be related to RCS unless during the install you mistakely changed something dealing with the customer admin.
  10. Aalst

    Recover Cart Sales

    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 :)]
  11. Aalst

    Recover Cart Sales

    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 :)]
  12. Aalst

    Recover Cart Sales

    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...
  13. Aalst

    Recover Cart Sales

    There is nothing wrong with deleting customers. You have to clean house and do customer maintenance from time to time, as a matter of fact Met00 is working on a customer tool, that will be RCS aware, it may be easier for it to handle this feature when a customer is deleted using this new tool. What do you think Met00?
  14. Aalst

    Recover Cart Sales

    Try reading this topic before posting, you may find answers to questions before having to post. You will find the answer to your question posted at least once. OOoh was that snippy?
  15. Aalst

    Recover Cart Sales

    Okay this is posted in the forums already, this is an error in the 1.3.6 README. you need to change: define('FILENAME_STATS_RECOVER_CART_SALES', 'stats_recover_cart_sales.php'); to: define('FILENAME_REPORT_RECOVER_CART_SALES', 'stats_recover_cart_sales.php'); This is step 4a for MS2. I guess I will up date a 1.3.6a version to update the readme. It should be posted in moments... :)
×