Jump to content

aeroflight

Members
  • Content count

    13
  • Joined

  • Last visited

  • Days Won

    1

aeroflight last won the day on November 18 2011

aeroflight had the most liked content!

Profile Information

  • Real Name
    Wylie Coyote
  1. aeroflight

    [Contribution] - USPS Methods

    Although i have not seen your previous post, if you are upgrading, the first question is did you remove the old version before upgrading replace files and pushing the install key? Meaning uninstall from the admin windows/modules/shipping/usps edit remove. add new files/edit files and then run install. Since you are failing in PHP admin, it is more than likely you have the key already and when asked to update, it fails since the key/field already exists elsewhere. In OSC, disable/remove the module. In phpmyadmin search for each function in and more than likely you'll find a duplicate.in your database. Verify and delete duplicate or comment out in the install. Which is an easy work around but may cause you trouble later for upgrading and uninstall.
  2. aeroflight

    Checkout by Amazon for osCommerce Support Thread

    The plot thickens with Amazon. Under the new USPS xml data as in the previous post, the field reference is too long. Amazon appears to have no clue how to fix the issue. "In talking with the engineers they stated they do not have the ability to increase the number of characters accepted in the shipping console. However, they did provide me with a link here you can use a file to add additional characters. Please see the following link for more information: http://amazonpayments.s3.amazonaws.com/documents/Using_Custom_Data_Fields.pdf There is a few problems with their pdf and solution, One it doesn't work. Two it will never work. The field DisplayableShippingLabel is generated in Amazon's API and is not a customizable or an added field. That means if you customize that field per Amazons publication, it is no longer considered and therefore shipping is no longer considered. See a problem here? The call back feature is also affected and fails. For some reason Amazon cannot understand the shipping data from USPS is being passed directly to Amazon's API That means Amazons system either must accept the data in its entirety or *AMAZON* must determine which portion of the field they want. It is not up to us. Lastly, anyone using the old rate card is aware USPS is phasing it out by the end of first quarter 2012. That means if you upgrade you will have this problem and amazon payment will *NOT* work for any USPS service over 100 characters. Which in the all of the services.
  3. aeroflight

    [Contribution] - USPS Methods

    For those that are using Amazon checkout you are about to get a rude error. I've been in contact with amazon checkout support and there is no fix as of this writing. So far no other checkout service has been affected by the change, so please keep this in mind. I've upgraded from 5.2 to 6.1. 5.2-6.1 will generate the error at amazon checkout. It seems Amazon api is still operating under the old rate card and limited data. The problem is amazon shipping method only accepts 100 characters. The error you will receive is as follows: The order is not valid. Detail: Invalid Cart XML: The content of field DisplayableShippingLabel is longer than maximum allowed. For this field, the maximum allowed length is 100. DisplayableShippingLabel is only in their API, it is not in OSC. So here is where we need to limit. What is displayed by OSC usps method 6.1 is: First-Class Mail® Package ---Delivery Confirmation™ ---Approximate delivery time from mailing date 1 day $6.30 What Amazon sees is this: <DisplayableShippingLabel>United States Postal Service&nbsp;<br>0 lbs, 11.36 oz (First-Class Mail Package (---Approx. delivery time 2 Days))</DisplayableShippingLabel> As you can see this exceeds the 100 character limit and gives no real information. Amazon suggested I limit the data which can be done. I've posted a few ideas on their official support thread.. The problem is what do we limit it to? The first 100 characters? Could write a perl script to disassemble and reassemble the data on the fly. Does it matter which characters to us as long as we are providing the actual total to process? My other thought is maybe sanitize the xml code for amazon checkout only. Or amazon could fix their problem... Not likely to happen anytime soon.
  4. aeroflight

    Checkout by Amazon for osCommerce Support Thread

    Since upgrading to the new USPS method 5.2/6.1 it seems amazon checkout has a character limit for DisplayableShippingLabel which is only in Amazon's API code. The exact message response message from Amazon is: The order is not valid. Detail: Invalid Cart XML: The content of field DisplayableShippingLabel is longer than maximum allowed. For this field, the maximum allowed length is 100. With the new XML feature from USPS, amazon is not reading the code is including the ml characters, which looks like this. <DisplayableShippingLabel>United States Postal Service&nbsp;<br>0 lbs, 11.36 oz (First-Class Mail Package (---Approx. delivery time 2 Days))</DisplayableShippingLabel> Since it is very doubtful Amazon will increase their field limit or filter to deal with the additional information being returned by USPS, it looks like three files provided by amazon will need some code revision. ./checkout_by_amazon/checkout_by_amazon_cart.php ./checkout_by_amazon/CBAIOPNxml.php ./checkout_by_amazon/checkout_by_amazon_shipping_processor.php I propose setting a max limit in the three files to fix this issue. '#maxlength' => 100 The second option would be $DisplayableShippingLabel = substr($whateverthestringbeingcovertedis,0,100); The last option is to filter. Any suggestions?
  5. aeroflight

    Automatically send data feed to Froogle

    Hi Jack, Credit card is required to be posted but not charged. MS is trying to get you to buy ad time and as soon as the card is entered, the next screen takes you to start a campaign. Just click out of it. What I recommend for those that want to use bing but don't want the CC headache. Get a prepaid with a buck on it. Or use a credit card that allows for Shopsafe(safeshop). Shopsafe lets you create a card off your main card with a limited, time limit expire. Once you are validated it doesn't appear you need to update the card for ms ad for the feed to work. Great system! Oh one more thing. MS actually calls the company/ card holder before activation and verifies you created the account. Sometime in a far off galaxy as previous expressed, about 6 weeks, MS/Bing will let you know if your datafeed is validated or rejected by email. Until then, nothing goes on the site. MS is rather slow...
  6. aeroflight

    Automatically send data feed to Froogle

    Experimental feed to bing. Jack, there are several issues with this feed. First after change the code, I finally got it past their validation. Here is what ms/bing/microsoft ad center wants. Everything is in lb at ms period. So the produce weight field sending LB must be turned off. Or just remove the lb if you are not going to add other option product fields. Hey I kid you not. Here is their response. "All ShippingWeight values are invalid. Please use only numbers; all weights are expressed in pounds automatically." I have not tackled the conversion for metric as this was absolutely absured. the next issue is more interesting and I made a quick table to handle the change. MS does not wants product stock attrib (prodstatus) to send 0,1. They want In Stock, Out of Stock, Pre-Order, and Back-Order. Since in OS we oly have in stock and out of stock. I simply added before row>prodstatus statement a simple if it is a one, change to "In stock" , 0 "Out of stock". Fixed the problem For ftp_file changed the server to: feeds.adcenter.microsoft.com Then wait for about 6 weeks. MS apparently manually validates your data feed before giving approval for display. Then you play the game with support until they tell you you've validated. Hope this helps. Wylie
  7. aeroflight

    Shipping Estimator

    Jim: (2.2rc2) wanted to give you a quick update. There appears to be a few buttons missing in 2.2.3. In 2.2 there are alternative and more importantly the reset_button. :) Downloaded and added the gif. Now everything in shopping cart works great. Product info, since adding the button, crashes the entire page. Funny actually, no debug data generated. Went back to default, only two entries in the modified product_info file is for the shipping estimator per diff. Which means forest and trees and something stupid. So for tonight, customers will have to add it their cart. :) Thank you for your help. Rick
  8. aeroflight

    Shipping Estimator

    Jim, Using 2.2.3 (no overlay from an early version) and adding it to 2.2RC2a as well as an update of 2.3.1 A couple of questions if you have a moment. 2.2 two issues. I notice a lot of the MVS code is in the system, not an issue as far as I can tell. Never installed MVS. Just coupon codes, pwa and onecheckout. standard paypal express and standard as well as amazon. shipping USPS, per item shipping. In product info. shipping estimate is there. click and the page is blank. window pops up, but does not display anything. Cross check the code and found no errors. My first thought is to remove the product info code for pop up and button since nothing has been put in the cart yet. side note in your instructions, In catalog/shopping_cart.php, around line 308, look for... that should be line 208. In shopping card, after selecting the product, then shipping estimate, you get almost everything normal. java window pops up the box enter zip/country. brings up the box gives rates. at the the bottom says Click the "Change Address" button to enter a different shipping destination. Cool idea, except there is no change address button. Closing the window will not clear the address. Clearing the entire session does. There is no button that came along with shipping estimator that is change address.What am I missing? I've searched the file but cannot find where change address is actually called from. find -name does not yield anything rgrep is also no joy. Any idea where this change button is being generated from? Where is the session data being stored? ie zipcode/ country for the popup estimator. I assume a cookie? 2.3.1 is a who different matter. I'll watch the thread a little more there. Rick
  9. aeroflight

    One Page Checkout Support

    Steve: Thank you for the recommendation. No joy though. Still hanging on java after enter. Checked the database, onecheck creates the entry (ID) but fails to populate any fields. I am curious though checkout.sts.php is recommend below, is there an bug in firefox that I missed? I'll try and break this down later in the week. 2.3.1 is proving to be a slight challenge. Thank you.
  10. aeroflight

    One Page Checkout Support

    Hi Steve, Let me give an update and I'll post the changes so far if anyone is interested. What I did to get the the basic pages up and formatted is to change checkout.php Not only did I have to remove, header.php,footer.php, left_column, but First half of right_column.php as defined. There is still an issue with Java and processing. The extra box that I was having trouble with is make loader page pop up by onecheckout. Turned it off in config, but it is blank and no data when on, which was more confusing. Left oscommerce columns in config true and turned custom right column off. It should also be noted if you use the install.txt in the install.xml page for database entry, be-aware there is an error. The instructions call for 913 to be used twice as an identifier which causes a failure of the last insert table directive. Meaning you have to manually change the table id/seq number. There is no .sql table adjustment in 1.4 as defined. After all that... Everything propagates in the screen just fine. shipping pricing, etc. When you click continue, Java's wheel of forever time pops up and stays, until you break it. It attempts to place some data in to the DB but after this nothing gets processed. This is where I am really weak, Java is a long cry from assembler and C for me.. If you interrupt the process, you get blank fields. but an inserted was attempted. My is a new install. I've checked the code changes to all the files and they all seem to correct. < = Modified checkout.php in catalog added. > = removed 15d14 < require('includes/template_top.php'); 640a640 > <?php require(DIR_WS_INCLUDES . 'header.php'); ?> 642a643,656 > <!-- body //--> > <table border="0" width="100%" cellspacing="3" cellpadding="3"> > <tr> > <?php > if (ONEPAGE_SHOW_OSC_COLUMNS == 'true'){ > ?> > <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> > <!-- left_navigation //--> > <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> > <!-- left_navigation_eof //--> > </table></td> > <?php > } > ?> 949c963,971 < if (ONEPAGE_SHOW_CUSTOM_COLUMN == 'true'){ --- > if (ONEPAGE_SHOW_OSC_COLUMNS == 'true'){ > ?> > <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> > <!-- right_navigation //--> > <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> > <!-- right_navigation_eof //--> > </table></td> > <?php > }elseif (ONEPAGE_SHOW_CUSTOM_COLUMN == 'true'){ 990a1013 > <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> 996,997d1018 < <?php require(DIR_WS_INCLUDES . 'template_bottom.php'); ?> Can anyone walk me through the java process so I know what I'm looking at? I don't want to learn java per say. Stumbling through it is just fine. :) Or correct the issue for 2.3.1.
  11. aeroflight

    One Page Checkout Support

    Let me add onto what I'm seeing. I'm sure Steve is correct. If I turn off onepage, everything works normal, no issues. Turn on one page and of course the first thing I got was overlay of old 2.2 and mix of 2.31. template. but no page data boxes. Changed the header.php in checkout.php to template_top.php Changed footer.php template_bottom.php Removed column_left completely since it is contained in template. Left column_right in code, not sure exactly what it is doing and why we can turn it on and off in config. Nesting is fun to follow. Now I get a 2.31. template, no onepage and an additional box_heading (BOX_HEADING_SHOPPING_CART) from the original 2.2. Obviously I've missed something. My question, has anyone documented the necessary changes for 2.31? One other item, I noticed there is an email gathering for un-duplicated errors in 1.4 onepage for re-mailing? Can anyone elaborate how the error is processed? The code does not seem to gather any debug data? Just current table data for that transaction. Any help would be appreciated. W
  12. aeroflight

    One Page Checkout Support

    Mine crashes. I assume you meant within checkout.php for the above reference. Care to share your secret?
  13. aeroflight

    Purchase Without Account Problems

    I've noticed several issues with the PWA V2.2 It does not work on OS 2.31. Fine on 2.2XX There are so many changes in OS2.31 that is should have been a whole new rev level. It is not 2.X any longer. Obviously .XX revs are minor changes with little impact to code. In this case, it is not the case. Java script for boxes and images, tables changes, formatting, etc. Half the current lines of code are either missing or reformatted in 2.31. Don't get wrong it looks nice and is quicker. But a nightmare to traverse. I've been working through the code but several hooks are still not clear on diff changes. Lets face it, we are poor at documenting our changes for others to follow. I know what I am thinking and therefore so should you. There is no road map that I can find of system calls, which makes it time consuming. Has anyone had the time fix the PWA model to V2.3 for OS2.31? If not, does anyone have a road (system) map of all the calls. Even a flow chart would be handy. Maybe I'm missing it and making into something it isn't.
×