Jump to content

joyces

Members
  • Content count

    48
  • Joined

  • Last visited

1 Follower

About joyces

  • Birthday 08/27/1961

Profile Information

  1. joyces

    Support thread for Storing Shipped Orders

    Hey Rob worked like a dream. Thanks for your help Andrea (joyces)
  2. joyces

    Support thread for Storing Shipped Orders

    Rob you are a star!!! look forward to hearing from you, your help is much appreciated! Cheers Andrea (Joyces)
  3. how do you get answers to topics posted ages ago

  4. joyces

    Support thread for Storing Shipped Orders

    Ok I know this is as old as the hills and maybe there is no one out there who will ever look at this but I'm going to post anyway just in case. As previously asked I too would like to add another orders page orders3.php where I can store my cancelled orders away from the main orders page. I have successfully installed the contribution for shipped orders and reckon I can probably work out the rest but I don't know how to include the code in orders.php in addition to the code already installed for the contribution. The clean orders.php code has been amended to $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status != 5 and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC"; } else { $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status != 5 and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total'" . (!is_null($search_query)?$search_query:''). " order by o.orders_id DESC"; } The bit changed is: "where o.orders_status != 5 and o.orders_status = s.orders_status_id" from: "where o.orders_status = s.orders_status_id" This change has been made twice I now want the $orders_query_raw to also include the same information for order status 9 which will be sent to order3.php. In short I will have 3 pages in Admin: Orders (orders.php) Shipped orders (orders2.php - created from the contribution) Cancelled orders.(orders3.php - if someone can help me work out how to do it!!) I have tried a few trial and error ways but i'm afraid the ended up as errors!! Any help would be appreciated thanks a lot Andrea
  5. joyces

    Estimated Shipping Costs

    Hi everyone have installed this excellent cont but I have two issues both which have been raised before but never answered. 1) in my shopping_cart.php the continue shopping button disappears from the page after a while. (Originnally noted by Kina post 255) Why does it do it and how can I stop it going AWOL. 2) I have free shipping over £100, but the shipping estimator shows both what the cost would be and that it is also free. So two entries for the order. Is there anyway I can just show the free shipping? (Originally raised by Leveera post 332) Any help would be really appreciated Andrea
  6. Hi Still struggling with parts of PWA. I have been reading threads for 2 days and I'm sure the answer is out there but I can't solve what appear to be my final few problems any help would be gratefully received. I have installed Lildog version 2.0g My PWA customers records aren't deleted from my "Customers" in admin when they have completed the order. I think, and I could be wrong, this is because they each recieve a unique customers number. In addition any PWA getting part way through an order then deciding not to proceed also ends up showing as a customer. All this I can live with The one thing I really want to solve though is getting rid of the "My Account" link for PWA on the checkout_success.php page. All the threads I read about this refer to earlier versions of PWA and files that don't appear to exist in the later version eg. order_info_process.php. Would be very grateful if anyone can supply any answers. I don't know a lot about php, desperately trying to learn, but mind has turned to jelly over this. The code in header.php is as follows (I have also added a "log in" link at the end but that doesn't seem to be a problem) <!-- PWA BOF --> <td align="right" class="headerNavigation"><?php if (tep_session_is_registered('customer_id')) { ?><a href="<?php echo tep_href_link(FILENAME_LOGOFF, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_LOGOFF; ?></a> | <?php } ?><?php if (tep_session_is_registered('customer_id') && (!isset($HTTP_GET_VARS['guest']) && !isset ($HTTP_POST_VARS['guest'])) && !$order->customer['is_dummy_account']) { ?><a href="<?php echo tep_href_link (FILENAME_ACCOUNT, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_MY_ACCOUNT; ?></a> | <?php } ?><a href="<?php echo tep_href_link(FILENAME_SHOPPING_CART); ?>" class="headerNavigation"><?php echo HEADER_TITLE_CART_CONTENTS; ?></a> | <a href="<?php echo tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_CHECKOUT; ?></a> | <a href="<?php echo tep_href_link(FILENAME_LOGIN, '', 'SSL'); ?>" class="headerNavigation"><?php echo HEADER_TITLE_LOGIN; ?></a> </td> <!-- PWA EOF --> Andrea
  7. Hi Still struggling with parts of PWA. I have been reading threads for 2 days and I'm sure the answer is out there but I can't solve what appear to be my final few problems any help would be gratefully received. I have installed Lildog version 2.0g 1) When a customer purchases using PWA he gets a unique customer_id. His details appear on the customers list in admin. I know this isn't meant to happen as he is meant to be deleted when he reached checkout_success.php. I don't think the delete happens because of the unique customer_id. I don't mind him being there but is there anyway in admin to show that a customer is PWA. - I found a thread about this but it refered to files and sql which are different to the PWA I've installed (The threads were from 2005 Quite a few mention altering the order_info_process.php which I can't find and didn't seem to be included in the version 2.0g) 2) If a customer starts to use PWA but gives up the transaction half way through he is still shown in the customers list - is there anyway to stop this too? 3) Try as I might I still can't get rid of the "Logoff" and "My Account" links that appear in the breadcrumbs for a PEA customer. Logg Off pops up from checkout_shipping.php onwards and "My Account" is there once you arive at checkout_success.php. I keep thinking I've found a thread for this but it refers to order_info_process.php Should I have this installed? I can see it was included in the contributions previously and if I should have that what else should I have? Am I using contributions wrong? I thought you went to the most recent that said full package and then checked out any bug fixes for that version. If i'm doing this wrong I'm going to feel a right fool!! Would be very grateful if anyone can supply any answers. I don't know a lot about php, desperately trying to learn, but mind has turned to jelly over this. Andrea
  8. Hi I am trying to give my customers the option to pay by Paypal. Unfortunately when directed to the Paypal page the amout to pay is shown is 0. I have waded through the forum and found the fix for this ie alter English.php to / if USE_DEFAULT_LANGUAGE_CURRENCY is true, use the following currency, instead of the applications default currency (used when changing language) define('LANGUAGE_CURRENCY', 'GBP'); and alter admin config to "Switch to Default Language Currency" to TRUE" Unfortunately when I do this all prices disappear from my site. Its altering the "Switch to Default Language Currency" to TRUE thats the problem. I have the contribution "Display MSRP & Savings" (http://www.oscommerce.com/community/contributions,3574) and I have a feeling that this is causing the problem. Has anyone any idea how I should amend things so that the "Display MSRP & Savings" cont will work with Paypal. Of course I could be completely wrong and this contribution may not be the problem so if anyone has any ideas at all about what is going wrong I would be Sooooooooooo grateful!! Thanks Joyces
  9. Hi I have installed PWA and although the last contribution by lildog 'Purchase Without Account v2.0f' says it is to stop the "my account" appearing in the breadcrumbs it refuses to disappear for me. On checkout_shipping.php 'Log Off' appears in breadcrumbs and remains there for the rest of the checkout process and once you get to 'checkout_success.php' 'My Account' joins it in the breadcrumbs. ideally if a customer is not creating an account I don't want either 'Log Off' or 'My Account' to appear at all. I have now reinstalled 3 times incase i was missing something - has anyone got any idea what I'm doing wrong? Thanks Joyces
  10. Hi Lildog Yipeeeeeeeeeeeeeeeeeeee. Changing the link to checkout_shipping worked YOU ARE AWESOME!!! One last thing I want to do is add another box to the column_right.php which is a login box. I'm off to read all the postings to see if this is possible. Thanks again, really appreciate the time you have taken helping me. Cheers Joyces
  11. Hi Lildog I'm really sorry this is all my fault. I added a new box to column_right.php which was for a direct link to login.php for customers who didn't want to go into shopping_cart.php first. I now realise that it is this link that is causing all the problems as everything works great if you use either the checkout link in the shopping cart or the checkout link in the header.php. I realise I need to add code to account for PWA to the checkout link in column_right and I have been playing about with it all day but i can't seem to get it to work. I have been trying to add code from the changes to shopping_cart.php and header.php as they appear in your contribution to see if I could get the right bit but I think I'm going to admit defeat. The easiest thing would be to remove the link from column_right.php. I checked the code and it does appear checkout shipping as it should. cheers joyces
  12. Hi Lildog Been back to the beginning and re-installed contribution but still have the problem of not being able to log in as I keep getting sent back to the index page. My code is as above in login.php do you know how I can stop the modification that is happening to send me back to the index.php page? Thanks Joyces
  13. Sorry Lildog thats a bit above me. I have checked my code in login and it reads as above. I have also checked all my backup files and create_account.php and login.php haven't been altered by any other mods or conts. Is this something i've done in error? and any ideas what I need to do to sort it out? I wonder if anyone else is having the same problem. Cheers Joyces
  14. No I dont think so the only major cont that I have added is easy populate. I've been playing about with it and it seems there is loop now where you can't log in as you keep going back to index.php either as a new customer or returning customer. I will go through all my old back up files to check that I haven't made any other alterations to login.php in the past and will let you know but i'm fairly sure that it was untouched. joyces
  15. have just tried putting items into the shopping cart going to login.php and being a returning customer when I clicked sign in I was sent back to index.php. (It did acknowledge I was logged in with the appropriate welcome message) Thought I would let you know as it's the same as the create_account problem Cheers Joyces.
×