joyces

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

Rob you are a star!!! look forward to hearing from you, your help is much appreciated! Cheers Andrea (Joyces)

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

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

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

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

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

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

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

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

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

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

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

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.

Hi Lildog Have added on the 2 updates for login.php and create_account.php and all seems good. Thanks for making the database settings for customer_password clear that's now great. With reference to above all is as it should be until step 7 when the continue button after create_account_sucess.php takes you to index.php so the customer would have to return to the checkout and log in. Well thats what happens for me anyway. Just wanted to thank you for all your hard work it is much appreciated Joyces

Sorry lildog if I gave the wrong impression, I think the contribution is brilliant and I'm in awe of you, and all the others that contribute and like everyone else, very grateful. Thanks for all you are doing Joyces

I know you're not meant to reply to your own posts but I think I have sorted it customer_password cannot be null is sorted if you amend the database for customer_password to 'Null' I'm not sure if thats going to cause problems so going to try putting in test orders to see. If anyone knows that this is going to cause problems would be really grateful if you could let me know - cheers. Then had the problem with customer_account cannot be null and customer_block but "deivid I am also getting this errors, I don't know ve... Jul 25 2008, 08:32 AM" post sorts those out. Now need to sort out how to get customers setting up a new account in 'Check Out' to stay in check out once the account has been set up so they can continue with the check out proceedure without having to log in. Think I've seen a post on this so it looks like a bit more reading to do!! Is this stuff really hard or am I just thick?

Hi all posts on this problem refer to 'customer_account" cannot be null. My error message is 'customer_password' cannot be null. I have checked the settings above but still the same error. I'm sure I have read all the posts here as well as going through the install guide 3 times now - what am i doing wrong? Cheers Andrea

Hi What a way to spend a weekend - pulling my hair out!! I have added the PAW contribution osCommerce v2.2rc2a - Purchase Without Account v2.0e When I try to add the common.sql to the database I get this error Error SQL-query : ALTER TABLE `customers` MODIFY COLUMN `customers_password` VARCHAR( 40 ) CHARACTER SET utf8 COLLATE utf8_general_ci MySQL said: You have an error in your SQL syntax near 'CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1 When I then try to do a test order I get the following message 1048 - Column 'customers_password' cannot be null insert into customers (customers_firstname, customers_lastname, customers_email_address, customers_telephone, customers_fax, customers_newsletter, customers_password, guest_account, customers_gender, customers_dob) values ('Andrea', 'Joyce', '[email protected]', '0111111111', '', '', null, '1', 'f', '19610827') The only post I can find which seems to refer to this, but not exactly, says 1048 - Column 'guest_account' cannot be null NOT 'customer_password' cannot be null I tried making the amendments suggested to create_account.php (http://www.oscommerce.com/forums/index.php?showtopic=309382&pid=1282724&mode=threaded&start=0#entry1282724) but still the same problem. Please can anyone help me out - would be eternally grateful cheers Andrea