Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

tigergirl

Pioneers
  • Posts

    423
  • Joined

  • Last visited

Everything posted by tigergirl

  1. Hi, I found this thread to explain the bug fix http://www.oscommerce.com/forums/index.php?showtopic=80361 and I have applied the fix although I don't think this affected me as I'm not using external ot modules. I was hoping to get the sage form module working to log the order before payment - can this please be worked on? For PCI reasons I want to use Form but the old module is ruining a few customer relationships and I am worried about this. I am actually considering moving to a different payment processor due to this :(. Still need to get the vendor email issue resolved and the transaction ids still seem odd - they change as some have an extra 5 digits. Thanks for all the suggestions.
  2. thanks - that works and displays (in admin and order email) the transaction number the customer received from the Sage payment notification email. The customer isn't given the VPS transaction ID from Sage so that's why it's pointless giving it to them in the osc order conf email. I think this should be noted for future version releases. Ross - does the Server module log the order in osc admin before the customer pays? Thanks for all your help - still not receiving sage emails though :(
  3. I do apologise - you are perfectly correct on both points. My point then should be - it would be better to include the Vendor Tx Code in osc admin and order confirmation email as that is the one in the sage email and on the sage admin pages. Sage admin is bad enough never mind adding another piece of data to confuse everyone. I just want an easy life...
  4. Hi, thanks for your responses. The sage reference is coming through like this in osc and order email although I changed a few digits here: Sage Pay Reference ID: {4F6GHH98-3ABC-63DR-12D8-3668OPU98E89} ....and that is not what shows in sage admin or sage email as the unique transaction reference, the above looks encrypted and it bears no relevance to me or my customer. If my customer quotes that to me it means nothing. So that refernce needs to be displayed correctly or stripped out of the module IMO. I beleive I am on osc V2.2 MS2 060817. I can not check Administration Tool -> Tools -> Server Info as I removed that link & file due to potential security risk. I do have the code you mention - I use Paypal IPN V1.4 and am confused as the link http://github.com/osCommerce/oscommerce2/c...7345cc91145862a mentions something like . Will I break paypal IPN if I apply the fix? I need to run both sage form and paypal ipn - don't want to break anything... John is looking into the email issue. Is there no way to log the order in admin before payment for sage form? I have problems with the old module not logging orders occassionally which creates a real mess sometimes and isn't good from a customer point of view = some pay twice. The main reason I was looking for an improved version of form. Thanks for your help.
  5. Hi, thanks for the new module. I'm testing but have a few issues: 1) no sage payment notification email arrives for vendor (customer receives though, order emails ok) 2) what is the Sage Pay Reference ID in admin and order confirmation email? It appears to have nothing to do with any info I can find on my sage test admin account = useless if a customer quotes it to me. It looks encrypted? 3) I see references to order id - but this doesn't appear anywhere in the sage system. 4) The sage pay ref id looks odd, all with -12- at the end, no vendor name - is that correct? 5) the readme pdf makes reference to: Please can you state specifically which osc versions this fix needs to be applied to? Look forward to your replies. Thanks
  6. well, now my sagepay vendor account is active, I do not have this problem. No idea why using the testvendor details causes the error. BTW version 1-20-1 isn't the most up to date version and although it says it has stripped out any reference to protx, protx is still there... and I think it's using the old protocol so you'll need to pick the module that works with the new billing fields for 3d secure. Cheers
  7. Forgot to say it's Protx/ Sage Pay Form 1-20-1 I'm using on 060817. Live & Test sites hosted on same server and should be pretty similar except the content. The debug came back with: 2.22 PAYMENT TestVendor VendorTxCode=TestVendor200907091510445&Amount=8.29&Currency=GBP&Description=Goods bought from mystore&SuccessURL=https://www.mystore/checkout_process.php&FailureURL=https://www.mystore/checkout_process.php&CustomerName=Test Customer&CustomerEmail=myemail@myemailuk&VendorEMail=myemail@myemailuk&DeliveryAddress=Test address&DeliveryPostCode=test postcode&BillingAddress=Test address&BillingPostCode=test postcode&Basket=3:Soap:1:0.89:0.00:0.89:0.89:Pads:1:4.99:0.00:4.99:4.99:Shipping:1:2. 41:----:2.41:2.41 There must be something going on - could it be a file difference or a sessions problem? I'm not aware of losing sessions. If it's a file, can anyone give me a some starting points for where to look so I can compare the files??? What files would be called after you are returned to the website form SagePay? I tried this thread protx form not redirecting but the crypt thing doesn't make a difference. Many thanks Tigergirl
  8. Hi, did you find a solution for this? I have the exact same problem on my live site. My test site works perfectly and I am confused. I don't know if the payment show on the sage account as I'm waiting for them to activate my account to "Test Mode". After payment you get redirected to https://www.mysite.co.uk/checkout_payment.php?error_message= Just got my merchant number so a little sad this has occured when I thought all was ok and I was fairly ready to go live :( Tigergirl
  9. From PayPal and and my missing ipns did catch up and the order confirmation email got sent. So there we have it. They never learn but at least it seems to be fixed, hope yours is too.
  10. ok, I found this thread: paypal forum so they have been messing around with IPN. In paypal account, I found the page in History / IPN history but it doesn't give me any option to resend the IPN - mine just say "retrying" which they aren't doing IMO. I suppose they're fixing the bugs they just made and creating more bugs as usual.
  11. My last few orders seem ok but I don't know if it's intermittent or not. I think it's been a while since I've seen this one happening. Everytime paypal co**s up the scripts I remember how annoying they can be. I reported the problem to paypal MTS but get the usual "we're looking into this and will get back to you next business day" HELLO, next business day? What about my customers? I've had more abandoned carts than usual so think there is something going on at paypals end. I know they have been updating because there were messages on my paypal account last week. Can't wait to get my real merchant account set up. Will be very sad if I'm not good enough for the banks. I am at the stage where I think paypal is hurting my business and I'm darn sure I'm not losing any more customers because of them. You know your customer can't make more than 10 purchases with you unless they open a paypal account? Can't find it written although I do remember reading it. Lost my customer, who knows if she wil come back as she's bought somewhere else now. enuff said, I can breathe now. Anyone know how to send out an order confirmation email manually? Might look better from the customers point of view.
  12. Same here, I get the paypal payment notification but paypal not communicating the successful payment to website and no order confirmation emails sent out. Anyone know what they've broken this time?
  13. Hi, sure, I use UK RM & oversees shipping module It works very well. I think I'm using the 18/02/07 version which had a few bugs - you'll need to read the support thread for the fixes . I see it's been updated recently so you'll need to choose which version you feel happiest using. Tiger
  14. I managed to find a contribution for a shipping module that seems like it mostly does the job (after trying many other things) One thing left to fix - can't get it to switch off if order total is less than £60. I'm trying to use this code: if ($order->info['total'] < 60) { // If total ship cart price is below £60 do not show this shipping method $this->enabled = false; } But I think I'm putting it in the wrong place - DOH! Here's the file inc/mod/shipping/eco.php: <?php /* $Id: eco.php,v 1.27 2003/02/05 22:41:52 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ class eco { var $code, $title, $description, $icon, $enabled; // class constructor function eco() { global $order; $this->code = 'eco'; $this->title = MODULE_SHIPPING_ECO_TEXT_TITLE; $this->description = MODULE_SHIPPING_ECO_TEXT_DESCRIPTION; $this->sort_order = MODULE_SHIPPING_ECO_SORT_ORDER; $this->icon = ''; $this->tax_class = MODULE_SHIPPING_ECO_TAX_CLASS; $this->enabled = ((MODULE_SHIPPING_ECO_STATUS == 'True') ? true : false); if ( ($this->enabled == true) && ((int)MODULE_SHIPPING_ECO_ZONE > 0) ) { $check_flag = false; $check_query = tep_db_query("select zone_id from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . MODULE_SHIPPING_ECO_ZONE . "' and zone_country_id = '" . $order->delivery['country']['id'] . "' order by zone_id"); while ($check = tep_db_fetch_array($check_query)) { if ($check['zone_id'] < 1) { $check_flag = true; break; } elseif ($check['zone_id'] == $order->delivery['zone_id']) { $check_flag = true; break; } } if ($check_flag == false) { $this->enabled = false; } } } // class methods function quote($method = '') { global $order, $cart, $shipping_weight, $shipping_num_boxes; if (MODULE_SHIPPING_ECO_MODE == 'price') { $order_total = $cart->show_total(); } else { $order_total = $shipping_weight; } $eco_cost = split("[:,]" , MODULE_SHIPPING_ECO_COST); $size = sizeof($eco_cost); for ($i=0, $n=$size; $i<$n; $i+=2) { if ($order_total <= $eco_cost[$i]) { $shipping = $eco_cost[$i+1]; break; } } if (MODULE_SHIPPING_ECO_MODE == 'weight') { $shipping = $shipping * $shipping_num_boxes; } $this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_ECO_TEXT_TITLE, 'methods' => array(array('id' => $this->code, 'title' => MODULE_SHIPPING_ECO_TEXT_WAY, 'cost' => $shipping + MODULE_SHIPPING_ECO_HANDLING))); if ($this->tax_class > 0) { $this->quotes['tax'] = tep_get_tax_rate($this->tax_class, $order->delivery['country']['id'], $order->delivery['zone_id']); } if (tep_not_null($this->icon)) $this->quotes['icon'] = tep_image($this->icon, $this->title); return $this->quotes; } function check() { if (!isset($this->_check)) { $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_ECO_STATUS'"); $this->_check = tep_db_num_rows($check_query); } return $this->_check; } function install() { tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Table Method', 'MODULE_SHIPPING_ECO_STATUS', 'True', 'Do you want to offer table rate shipping?', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Shipping Table', 'MODULE_SHIPPING_ECO_COST', '25:8.50,50:5.50,10000:0.00', 'The shipping cost is based on the total cost or weight of items. Example: 25:8.50,50:5.50,etc.. Up to 25 charge 8.50, from there to 50 charge 5.50, etc', '6', '0', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Table Method', 'MODULE_SHIPPING_ECO_MODE', 'weight', 'The shipping cost is based on the order total or the total weight of the items ordered.', '6', '0', 'tep_cfg_select_option(array(\'weight\', \'price\'), ', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Handling Fee', 'MODULE_SHIPPING_ECO_HANDLING', '0', 'Handling fee for this shipping method.', '6', '0', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Tax Class', 'MODULE_SHIPPING_ECO_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', '6', '0', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added) values ('Shipping Zone', 'MODULE_SHIPPING_ECO_ZONE', '0', 'If a zone is selected, only enable this shipping method for that zone.', '6', '0', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(', now())"); tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_SHIPPING_ECO_SORT_ORDER', '0', 'Sort order of display.', '6', '0', now())"); } function remove() { tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')"); } function keys() { return array('MODULE_SHIPPING_ECO_STATUS', 'MODULE_SHIPPING_ECO_COST', 'MODULE_SHIPPING_ECO_MODE', 'MODULE_SHIPPING_ECO_HANDLING', 'MODULE_SHIPPING_ECO_TAX_CLASS', 'MODULE_SHIPPING_ECO_ZONE', 'MODULE_SHIPPING_ECO_SORT_ORDER'); } } ?> Please can someone tell me where to insert my code? Or the correct way to code it? I'm sure that's easy peasy - just not for me :( The contrib is Shipping prices by order total if anyone else wants to use Thanks so much Tigergirl
  15. There are many reasons why someone may want to do extra tests - using different settings or adding different contributions might affect the way the paypal module works. Also, don't think Paypal likes you to pay yourself. Then of course if you have a paypal account and want to test if it works without using paypal account and with or without creating an account then you're going to run into problems. Of course, if you don't wish to fully test for broken bits or to see what your customers see then the 1p method is fine. Just offering another way for people who're interested and may not already know about Sandbox. I agree paypal is a pain in ar*e but that's not our fault !-) Anyone reading is free to take my advice or ignore it , just trying to help when I can.
  16. If you're using the paypal module that came with OSC you might want to look at some of the paypal contibutions which do update the stock levels etc.
  17. Hi, if the paypal module has an option for "test server" then you can use the PayPal Sandbox to test it all works. https://developer.paypal.com/ You'll need to register an account on the sandbox but its worthwhile and won't cost you a penny! You'll probably need to carry out lots of test purchases to get the set-up the way you want it so I wouldn't recommend the "live" way mentioned above as you can't test all eventualities that way. Tigergirl
  18. This is what I did to fix it in my shipping modules - [CONTRIB] UK Royal Mail & Overseas Shipping Methods - I'm not sure if you are using this but the file looks pretty similar - please back-up files first. The problem is something to do with tear weight and cart weight totalling around the amount of the max set weight in the module ie 2kg and the worked for me. I've taken this from the post I mentioned earlier. Find this line: if ($error == true) $this->quotes['error'] = MODULE_SHIPPING_AIRMAILSIGNEDFOR_INVALID_ZONE; and add this after it if ($shipping_method == MODULE_SHIPPING_AIRMAILSIGNEDFOR_UNDEFINED_RATE ) $this->quotes['error'] = $shipping_method; You will need to add this line to all the modules where the problem occurs (changing the module name to the module you are fixing ie AIRMAILSIGNEDFOR) (I added it to them all to be sure!) This should fix the cart weight exceeded issue but I don't know why you can't update your prices.
  19. Hi, RM modules do currently disappear when free shipping kicks in at >£100.00 Think it would be good to alter ot_shipping. Had a look at ot_shipping but not sure how to code this I found Contrib ot_shipping enhancement but it does not look right in admin and does not switch off RM modules which is disapointing. It has CCGV mods in the file which I do not have so it maybe hasn't been coded well. I removed it for now. I'll have a look at the clubosc page later if I get this up and running. Can you help? Thanks Tigergirl
  20. Hi Kellie, after you changed the php files, did you uninstall and reinstall the shipping module in admin? I'm using [CONTRIB] UK Royal Mail & Overseas Shipping Methods and there was a "Cart weight exceeded" problem with that - try the supprt thread for it to see if it's a similar issue. http://www.oscommerce.com/forums/index.php?sho...3681&st=160 Tigergirl
  21. Hi, I'd like to add a shipping option which will allow the customer to be charged a maximum shipping cost of say £5.00 if they spend over £60 on products. I'd like to keep the ot_shipping module for free shipping over £100. I'm using [CONTRIB] UK Royal Mail & Overseas Shipping Methods as well and want to keep that in place for lower value orders. I've seen sites with a message on the basket saying "spend £x.xx to qualify for free shipping" - not essential for now but would be nice to do! I have tried searching but can't find anything suitable. Anyone able to help or recommend a contrib? Many thanks Tigergirl
  22. Hi, Royal Mail are increasing the prices from Monday 6th April - changes below for the modules I use - these can be overwritten easily in your OSC Admin in modules, shipping. NOTE 1: I use a handling fee for the Recorded Delivery option (easier than redoing another two lines of prices). If you update the php files you'll need to add the £0.75 to the prices. NOTE 2: For Standard Parcels I use this to prevent the customer checking out with free shipping on high weight orders (100000:1000.00) - You will need to change or remove this to your specifications RM Second Class Rates 100:1.08,250:1.41,500:1.85,750:2.24,1000:2.70 ----- RM Second Class Recorded Rates 100:1.08,250:1.41,500:1.85,750:2.24,1000:2.70 Packaging / Handling Fee 0.75 ----- RM First Class Rates 100:1.28,250:1.62,500:2.14,750:2.65,1000:3.25,1250:4.45,1500:5.15,1750:5.85,2000 :6.55,4000:8.22,6000:11.02,8000:13.82,10000:16.62 ----- RM First Class Recorded Rates 100:1.28,250:1.62,500:2.14,750:2.65,1000:3.25,1250:4.45,1500:5.15,1750:5.85,2000 :6.55,4000:8.22,6000:11.02,8000:13.82,10000:16.62 Packaging / Handling Fee 0.75 ----- RM Standard Parcel Rates 2000:4.41,4000:7.06,6000:9.58,8000:11.74,10000:12.61,20000:14.69,100000:1000.00 Hope that saves someone some time...... Cheers Tiger
  23. I used this fix on every module to get rid of the £0.00 problem. It's not a 100% fix as the "cart weight exceeded" still shows occasionally but at least the customer cannot select £0.00 cost shipping. The other problem I notice will this module is that if your customer tries to order products that weigh more then you ship, no postage optoion will show and they can check out without selecting any postage! I just put a restrictive cost of £1000.00 on 20 - 100kg to stop people ordering stuff that heavy. Hope that helps someone.
  24. Just to let everyone know - my problem was not to do with Paypal IPN module. My mailbox was full and so my emails were not getting delivered. Once I deleted a bunch of emails, all my delayed emails arrived. With regards to the "web accept payment received" on the transaction details - seems like paypal had changed something at their end - although their explanations are the usual automated b***sh** that I'm accustomed to from ebay and paypal. All is fine now. Tiger
  25. Hi folks, is anyone else having problems with paypal email notifications & order confirmation emails? I've been using this paypal IPN module for ages and all was fine. But my last 4 orders have had no payment received notification email from paypal. The last order didn't even get an order confirmation email from my website. I've also noticed that the last paypal transaction says "web accept payment received" and is showing aggregate items, it used to be per item and say "Shopping Cart payment received". I haven't made any changes to the module or my paypal account settings. Have paypal altered some scripts which is affecting this module? I can't find out any info anywhere. Anyone know whats going on? thanks everyone Tigergirl
×
×
  • Create New...