Jump to content

jdfitch

Members
  • Content count

    67
  • Joined

  • Last visited

Everything posted by jdfitch

  1. The solution to my problem turned out to be a simple one. You can not escape and use a literal question mark in a match line in htaccess. So you have to use a query string and pick out what you need and throw out the rest. This is what I used. RewriteCond %{QUERY_STRING} ^(products_id=[0-9]+)/[a-zA-Z0-9-]+$ RewriteRule ^product_info\.php$ /product_info.php?%1 [R=301,L] Works like a charm.
  2. It has everything to do with this contrib This line in htaccess RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING} is picking up content in the URL after ...products_id=### in my case product_info.php?products_id=###/#### I am trying to work out how to change this rule so that everything is dropped from the new URL after the product ID# starting with that /
  3. Now I have an issue with very old links to my site that still exist out there in cyber space. I need an htaccess rewrite (301) to fix the issue before the url is passed to the SEO rewrite in the htaccess file. Links coming in look like this, product_info.php?products_id=168/Q####-##### (# sign of course are actually numbers) The URL works as far as landing on the right item in the catalog, but, wont work if you click the Add To Cart button. So I just need to drop everything after the / then let the SEO rewrite work and of course it would have to work for all product ID's and anything after the slash
  4. This has got me scratching my head. Using the old USPS module that went dark we did not have this error. After installling the module and emailing USPS, we get rates for Cont. U.S. But, we only offer postal service to Alaska, Hawaii, APO and FPO addresses. When running a test I get this error: <Package ID="1"> <Error> <Number>-2147219401</Number> <Source>;clsRateV4.CreateSinglePostage-CreateSinglePostage;RateEngineV4.ProcessRequest</Source> <Description> Error Information: The Destination ZIP Code you have entered is invalid.</Description> <HelpFile></HelpFile> <HelpContext>1000440</HelpContext> </Error> </Package> </RateV4Response> Address is: APO, AE 09391 This is a valid US Postal Service Zip Code. Any thoughts?
  5. I am scratching my head. Installed the module, emailed the postal folks to move us to to production server, All is well if I set the module to present rates for Cont. U.S. But. We only use the post office for Alaska, Hawaii and APO and FPO addresses. When I test a known APO, AE address I get: <Package ID="1"> <Error> <Number>-2147219401</Number> <Source>;clsRateV4.CreateSinglePostage-CreateSinglePostage;RateEngineV4.ProcessRequest</Source> <Description> Error Information: The Destination ZIP Code you have entered is invalid.</Description> <HelpFile></HelpFile> <HelpContext>1000440</HelpContext> </Error> </Package> </RateV4Response> Address is: APO, AE 09391 This is a valid US Postal Service zip code. This did not happen with the old USPS module that went dark on us. Any thoughts?
  6. jdfitch

    FedEx - Web Services v9

    Download and install my upload V9.3. It turns off International Ground to any foreign country. http://addons.oscommerce.com/info/7977 But does not have any effect on any other FedEx service quote, you still get international econ and priority to Canada rates. (it is easier and less hassle to use FedEx Express to cross a border anyway- Just MHO and my experience) There has always been an issue with FedEx returning $0.00 shipping cost for international when LIST rates are applied. Not sure why but that problem goes back way before this module.
  7. jdfitch

    FedEx - Web Services v9

    Are you using PayPal Express or any other PayPal module? You say the error occurs "where the call back to the shopping cart". If you are, run a search on the paypal module for function cmp() I have to wonder now if that was not used in that module. If so, that is the problem, two different modules using the same function call for two different functions. Just my guess at the moment, as I do not know what modules you have installed. As for useing FedEx Real Time Quotes. That will only work for a short time, FedEx will be phasing out all of the old API support next year.
  8. jdfitch

    FedEx - Web Services v9

    Just posted to the contribs section a V9.3. http://addons.oscommerce.com/info/7977 Includes all changes from V9.2 Added: My attempt at installation instructions. (they are crude but I tried) A Changelog (to try and keep track of changes) Stopped the module from quoting a ground rate to a foriegn country (international ground, if enabled, is unaffected). Stopped the module from quoting rates for a PO Box shipping address. The only changes are to /includes/modules/shipping/fedexwebservices.php at or about line 88 if (MODULE_SHIPPING_FEDEX_WEB_SERVICES_INTERNATIONAL_GROUND == 'true') { Changed to: if ((MODULE_SHIPPING_FEDEX_WEB_SERVICES_GROUND == 'true') && ($order->delivery['country']['iso_code_2'] == $this->country)) { at or about line 287 $this->quotes = array('module' => $this->title, 'error' => $message); } changed to: $this->quotes = array('module' => $this->title, 'error' => $message); } // po box hack by JD if (eregi("^P(.+)O(.+)BOX",$order->delivery['street_address']) ||eregi("^PO BOX",$order->delivery['street_address']) || eregi("^P(.+)O(.+)BOX",$order->delivery['suburb']) || eregi("^[A-Z]PO",$order->delivery['street_address']) || eregi("^[A-Z]PO",$order->delivery['suburb'])) { $this->quotes = array('module' => $this->title, 'error' => '<font size=+2 color=red><b>Federal Express cannot ship to Post Office Boxes.<b></font><br>Use the Change Address button above to use a FedEx accepted street address.'); } // end po box hack by JD Hope this helps someone else besides me.
  9. jdfitch

    FedEx - Web Services v9

    I have been using my FedEx automated labels all along, We updated the the webservices module about a month ago, all I did was turn off the FedEx Realtime Quotes shipping module in the admin>modules>shipping. I did not make any changes to it or unistall it. Just set enable to FALSE. Our Automated labels is working fine. I think the only reason you needed Realtime Quotes to begin with was to get a fedex meter ID
  10. jdfitch

    FedEx module with weight/dimensions

    This may not be much help, but, you can enter your weights as dimensional weights. In the item editor page set your weights there and forget about aggregate weight. We ship a lot of very bulky items and have found this to be to the only solution so far. L x W x H / 199 for domestic L x W x H / 164 for international The webservices fedex module appears to be just an adaptation of a module written for another cart system and has no oscommerce developer and thus no one supporting it. We are going to have to find ways to fix the module as it does not work in it’s present form. No support for: 2nd Address line special characters that show up in foreign addresses cause the module to crash no support for items that must ship separate no check to prevent customers from entering a PO box as the shipping address
  11. jdfitch

    FedEx - Web Services v9

    Another strange thing. After line 110: // customer details $street_address = $order->delivery['street_address']; $street_address2 = $order->delivery['suburb']; $city = $order->delivery['city']; This code is wrong. We added the second address line to OSCommerce a long time ago so it should be something like: // customer details $street_address = $order->delivery['street_address']; $street_address2 = $order->delivery['street_address_2']; $suburb = $order->delivery['suburb']; $city = $order->delivery['city']; and then after line 380 return array('MODULE_SHIPPING_FEDEX_WEB_SERVICES_STATUS', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_KEY', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_PWD', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_ACT_NUM', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_METER_NUM', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_WEIGHT', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_ADDRESS_1', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_ADDRESS_2', would become: return array('MODULE_SHIPPING_FEDEX_WEB_SERVICES_STATUS', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_KEY', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_PWD', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_ACT_NUM', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_METER_NUM', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_WEIGHT', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_ADDRESS_1', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_ADDRESS_2', 'MODULE_SHIPPING_FEDEX_WEB_SERVICES_SUBURB Again any thoughts? I am just becomeing familiar with this module so any help would be appreciated,
  12. jdfitch

    FedEx - Web Services v9

    Also something that came up today. In the original FedEx real time quotes there was a solution provided to stop the shippng address from including a PO Box. As FedEx does not deliver to PO boxes. the code was inserted just below the Country Just below line 32 $this->country = STORE_ORIGIN_COUNTRY; } became: $this->country = STORE_ORIGIN_COUNTRY; } if (eregi("^P(.+)O(.+)BOX",$order->delivery['street_address']) ||eregi("^PO BOX",$order->delivery['street_address']) || eregi("^P(.+)O(.+)BOX",$order->delivery['suburb']) || eregi("^[A-Z]PO",$order->delivery['street_address']) || eregi("^[A-Z]PO",$order->delivery['suburb'])) { $this->quotes = array('module' => $this->title, 'error' => '<font size=+2 color=red><b>Federal Express cannot ship to Post Office Boxes.<b></font>'); } I have tried just adding this code, but it does not show the error text, in fact it has no effect at all. Any thoughts?
  13. jdfitch

    FedEx - Web Services v9

    I just ran into the same issue with a customer from Brazil used an é in his shipping address and instead of a 500 error the shipping page just came up blank. We either need a fix for this, or a filter to replace accented characters. Also I have not had a chance to work on it, but I think we would also need to consider the Ship Seperatley addon from the original FedEx Real Time Quotes. http://addons.oscommerce.com/info/1462 update V2.06 26 Nov 2006. We ship a lot of bulky packages and this addon has really saved our butts with shipping calculations.
  14. jdfitch

    DHL XML Support

    We have been signed up and using DHL shipit for a while, all was fine well and good. We made the tragic mistake of asking DHL XML support for some aid in writing a label generation system not unlike the fedex automated lable system. O My What a mistake. If you are an up and comming ETailer with a growing operation, as much fun as FedEx and UPS can be, at least you can get a sales rep to help get you better rates. It took two years to get our DHL rep and he still wont answer emails. If you ever find yourself in an email exchange with XML requests at DHL beware of Brenda Murphy she didnt like that we wanted make her work so she cut off our DHL quotes. Nice People.
  15. jdfitch

    edgeoi feed error

    I am really not sure what you were trying to acomplish. A very simple solution to stop the script from listing every item as it is in every categorie, ie.. with store items are listed in more than one categorie so the script would put the items in the feed once for each category. was simply to change: $result=tep_db_query("select * from products p, products_description pd, products_to_categories ptc where p.products_id=pd.products_id and p.products_id=ptc.products_id and p.products_status=1 " . $limit); To: $result=tep_db_query("select * from products p, products_description pd where p.products_id=pd.products_id and p.products_status=1 " . $limit); What is missing are two components. 1. The Products_to_categories ptc both ends 2. we removed the and p.products_quantity>0 since we dont usually keep the quantity in the catalog.
  16. jdfitch

    edgeoi feed error

    I started gettting the same error. Also, I am not sure exactly where the loop occurs. I need to kill the Categories section of the Googlebase feed. We use the Multiple categories per item contrib and well this is the word from Google on the subject Duplicate items: Please be sure to post each item only once. So what I would need to know is how to make the Google end only list the products by Product ID and move on to the next, since most all of our products show up in at least two or more catagories.
  17. jdfitch

    Preauthorize with Authorize.net

    If I have what your asking right. You only want Authorize.net module to Authorize the card but not capture the funds, So that you can later (I do it after Fed Ex picks up packages everyday) and then capture the funds in the Authorize.net Virtual Terminal. If that is the case: Open up your oscommerce admin panel Modules>Payment Select the Authorize.net module then select Edit look for the Processing Mode (under Accepted Credit Cards check boxes) Select the Authorize Only Radio Button then click on Update at the bottom. If this is not what your looking for I am sorry.
  18. jdfitch

    CyberSource payment module

    I think we have a winner. Bank of America has been pushing clients towards the cybersource gateway as they are the tranistion partner for the Estores. Call them, ask to be moved to the Virtual Net Platform, Most BoA clients are using Vital as the processor, if you are, then you are not stuck with cybersource, Vital supports almost 650 gateways, Authorize.net being just one. Authorize.net also has implemented the Verified by Visa and MC secure code for use by shopping carts, although we are still investigating the implementation. Good Luck
  19. jdfitch

    CyberSource payment module

    We have been using the Link Point Modules for almost 3 years, granted we did some major rewrites to them to get everything out of them we needed. It seems odd that after all this time there is still not a working Cybersource module. Most ppl do not have root access to the server, alot of sites are hosted on windows boxes. Yet in all this time and after several ppl have stated that they have gotten it working on win32, not one contrib post. I agree with the poster from another forum about this, run clear of CyberSource it is a night mare. One of the things that we need to do is post a compiled win32 version, we also need to set up the admin email functions, most all CC modules return an email to the admin on processing with at least the AVS information. suggestions...
  20. jdfitch

    Automated FedEx Labels

    Here is the funny part, it will only round up the express packages. So I will have to assume that fed ex is doing that.
  21. jdfitch

    Automated FedEx Labels

    Followed this suggestion, for a couple of days it worked then all of a sudden no matter what it is rounding up to the nearest pound again.
  22. jdfitch

    OSC XML Feed - Help & Discussion

    This is a good contribution. Now we need to find a way to turn it into an RSS The current RSS contribs leave alot to be desired
  23. jdfitch

    Linkpoint MS1 and MS2 mod

    I changed the Customer Billing Country a while back. but since then it seems that the information is not being passed. My return from linkpoint only shows the Customer Billing country as ARRAY. That is what is displayed in the Gateway Email that LinkPoint sends back. Also, we worked out the curl issue a long time ago but it does not seem to get passed on very often. If your server is returning the Can not Execute Curl Error. Try this: in Catalog/Includes/Linkpoint/lpphp.php Find: $ch = curl_init (); curl_setopt ($ch, CURLOPT_URL,$host); curl_setopt ($ch, CURLOPT_POST, 1); curl_setopt ($ch, CURLOPT_POSTFIELDS, $xml); curl_setopt ($ch, CURLOPT_SSLCERT, $key); curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); $result = curl_exec ($ch); } Change to: $ch = curl_init (); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt ($ch, CURLOPT_URL,$host); curl_setopt ($ch, CURLOPT_POST, 1); curl_setopt ($ch, CURLOPT_POSTFIELDS, $xml); curl_setopt ($ch, CURLOPT_SSLCERT, $key); curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); $result = curl_exec ($ch); } This works anytime you get that error with a script.
  24. jdfitch

    Automated FedEx Labels

    That was the reason in my orginal post about the second address line I posted it to match the Second Address line Contrib. Overseas you will need the suburb field for some addresses.
  25. It would seem LinkPoint did not have all its ducks in a row when the Sever Migration happened this weekend. Since the migration we are recieving: error message'' CC-2501, unable to connect to SSL server, please try again later." On the phone with linkpoint two things were tried. Look for the port# in your LinkPointms1.php (sometimes other names) Catalog\includes\modules\payment If your port# is 1139 you should be able to use this legacy IP address as a temp fix to get processing again. IP - 63.146.126.8 This is a very ugly hard code hack but it works for the short run. I changed the Linkpointms1.php to : $myorder["host"]=MODULE_PAYMENT_LINKPOINTMS1_SERVER; $myorder["port"]="1139"; $myorder["storename"]=MODULE_PAYMENT_LINKPOINTMS1_LOGIN; // your store ID - supplied by linkpoint To This: /* $myorder["host"]=MODULE_PAYMENT_LINKPOINTMS1_SERVER; */ $myorder["host"]="63.146.126.8"; $myorder["port"]="1139"; $myorder["storename"]=MODULE_PAYMENT_LINKPOINTMS1_LOGIN; // your store ID - supplied by linkpoint THis way we are still processing while they resolve issues. The guy on the phone said he is not sure but this may also work for port 1129 Good luck,
×