Jump to content

baesic2

Members
  • Content count

    76
  • Joined

  • Last visited

1 Follower

About baesic2

  • Birthday 02/02/1959

Profile Information

  1. baesic2

    PayPal Prepopulate mod

    This would be the one you amend catalog\includes\modules\payment\paypal_ipn.php it's the only file with find statement of the readme. good luck it didn't work for me.
  2. baesic2

    Paypal IPN

    I have been dealing with problems with the offical oscommerce_payapl_ipn it is very easy to install. first make sure you installed a two file version of paypal ipn with ext folder as well and it will work flawlessly for you. Depending on your needs it may not do all of what you want it to do. That is where I am with the module. it works great if your shipping through your own site but if you ship through paypal like I currently do it's not wotj the time cause it will not pass variables to paypal or the shipping address. But I suggest giving it a try, it may work for you.
  3. baesic2

    Official PayPal IPN Support Thread

    I have posted this question elsewhere a few days ago with poor information coming back so I included this topic as well searching for the questions to be answered better. I am not trying to cross post however getting replies to some questions has been difficult, it may be my wording in the questions not being answered correctly, The answer may already be out there and I cannot find it?s location, Thanks to anyone trying to assist me in my quest for answers. I am having the same issue as another user here that has posted here.. No shipping information being sent to PayPal, I was looking for an answer to the last persons post and did not find the answer yet anyhow. I have a question about shipping, I want to still be able to ship using PayPal, currently our store does this now ship everything through PayPal using our PayPal account to handle shipping costs, as we include shipping in our prices? I think I must get the shipping information passing to through the PayPal IPN module first in order to continue moving forward with using PayPal IPN. I realize that the shipping information shows up in osCommerce. However I do not want to open another shipping account with USPS or UPS when PayPal handles that for us.
  4. Id would like to know where in the each to add the new lines of code for installation. I noticed in the readme.txt file it says to add for example OPEN AND MAKE CHANGES IN THIS FILE: /catalog/includes/application_top.php //Begin Checkout Without Account Modifications define('FILENAME_PWA_PWA_LOGIN', 'login_pwa.php'); //BMC new as of v0.57 define('FILENAME_PWA_ACC_LOGIN', 'login_acc.php'); //BMC new as of v0.57 define('FILENAME_CHECKOUT', 'Order_Info.php'); //End Checkout Without Account Modifications But where do we put these in that file do we just add it anywhere in the file just asking cause I am looking for this function and I do not fully understand how to install it properly. Thanks for the update though I am looking to get this function working soon.
  5. I have tried this for a while and I am stumped as to get it working correctly. It nice to see the checkboxes next to the product catagory selection and very handy for the customer, however after installing it. I discovered that when you click the add to cart button after making the selections you would like to purchase. It does not update the cart in any waynor does it take you to the shopping cart. has anyone dealt with this contribution? Or does anyone have and advise as to get this running, I am all ears and open for suggestion of other contributions that may help me out. If posting the code to this will just let me know. Thanks for all your help!
  6. I may be way out of line here I am just getting involved with osCommerce, I may have even crossposted a feww time I am trying not to do that any longer. But somtimes I feel a topic belongs in a couple different areas of the forum. For the mistakes I apologize to each forum member. However I have a store running now in html format, that I can change the options loaded into paypal, so when the information is passed to paypal. That information is viewable in the paypal where you can then ship from paypal account. My question here is? I have oscommerce 2.2 MS2 and the offical oscommerce_PayPal _IPN which up to this point just learned that you can only pass two variables through to the paypal account the rest of the variables do not show up I am loading the code in which I pass the information through to paypal, I am only trying to maybe assist in making more attributes show up in paypal and I also have no idea about implementing these changes. But it might help someone possibly and possibly not. Copy and paste into html document for full html instuctions. on how this works. I do not know if in could be incorporated into OSC PAYPAL IPN to pass on variable information. Thanks for your time and I hope I did not waste anyone time. But this works great in html format use it if you like it. Copy Below <script type="text/javascript"> <!-- function Dollar (val) { // force to valid dollar amount var str,pos,rnd=0; if (val < .995) rnd = 1; // for old Netscape browsers str = escape (val*1.0 + 0.005001 + rnd); // float, round, escape pos = str.indexOf ("."); if (pos > 0) str = str.substring (rnd, pos + 3); return str; } function ReadForm (obj1) { // process un-named selects var i,j,amt,des,obj,pos,fst,val,num=""; var ary = new Array (); amt = obj1.baseamt.value*1.0; // base amount des = obj1.basedes.value; // base description for (i=0; i<obj1.length; i++) { // run entire form obj = obj1.elements; // a form element if (obj.type == "select-one" && // just get selects obj.name == "") { // must be un-named pos = obj.selectedIndex; // which option selected val = obj.options[pos].value; // selected value ary = val.split (" "); // break apart for (j=0; j<ary.length; j++) { // look at all items // first we do single character tokens... if (ary[j].length < 2) continue; fst = ary[j].substring (0,1); // first character val = ary[j].substring (1); // get data if (fst == "@") amt = val * 1.0; if (fst == "+") amt = amt + val*1.0; if (fst == "%") amt = amt + (amt * val/100.0); if (fst == "#") { // record item number num = val; ary[j] = ""; // zap this array element } // Now we do 3-character tokens... if (ary[j].length < 4) continue; fst = ary[j].substring (0,3); // first 3 chars val = ary[j].substring (3); // get data if (fst == "s1=") { // value for shipping if (obj1.shipping) obj1.shipping.value = val; ary[j] = ""; // clear it out } if (fst == "s2=") { // value for shipping2 if (obj1.shipping2) obj1.shipping2.value = val; ary[j] = ""; // clear it out } } val = ary.join (" "); // rebuild val with what's left if (des.length == 0) des = val; // 1st storage? else des = des + ", " + val; // nope, accumulate value } } if (obj1.item_number && num.length > 0) obj1.item_number.value = num; obj1.item_name.value = des; obj1.amount.value = Dollar (amt); if (obj1.tot) obj1.tot.value = "$" + Dollar (amt); } //--> </script> </head> <body> <!-- This is the FORM to view the cart contents --> <form action="https://www.paypal.com/cgi-bin/webscr" method="post" id="viewcart" name="viewcart"> <p> <input type="hidden" name="cmd" value="_cart" /> <input type="hidden" name="display" value="1" /> <input type="hidden" name="business" value="jas22924@aol.com" /> </p> </form> <!-- End of view cart FORM --> <table width="100%"> <tr> <td> <h1>Concatenate unnamed selects</h1> </td> <td> <a href = "http://members.aol.com/paypalhelper/">home page</a><br /> <a href = "http://members.aol.com/paypalhelper/stdc.htm">std.css</a> </td> </tr> </table> <p>All this simple JavaScript (JS) plugin does is to accept the <i>value</i> fields from unnamed selects and concatenate them into the description field. These <i>value</i> fields may have price modifying information, item numbers or shipping costs in them. </p> <p>We start with the output of the PayPal button factory and make a few changes. Then the JS processes the FORM and adjusts the fields. <view source> on this page to see what was done. </p> <ul> <li>Copy the JS from this example and paste it into your page within the <b> <head></b> section, like is done on this page. Only one copy of the JS is needed for any page.</li> <li>If you want a view-cart button somewhere on the page you must copy the view FORM from my page and insert it into your page right after the <b> <body...</b> statement, like I have done here. You will need to change the <i> business</i> value, or course.</li> <li>Go into every FORM that can place an order and add these things... <ul> <li>A new named element called <i>baseamt</i> to hold the base amount of the item.</li> <li>A new named element called <i>basedes</i> to hold the base description of this item.</li> <li>An event handler to the to the FORM element, like I have done on this page.</li> <li><b>unnamed</b> selects so the user can pick his options.</li> <li>An optional text field named <i>tot</i> where the item cost is displayed if you include event handlers on the selects. In this case the base price must be the default settings of the selects. <view source> to see how I did it on this page.</li> </ul></li></ul> There are single token, and three-token flags that may be used in the <i>value</i> field of the options. <ul> <li>"<b>#</b>" to indicate that an item number follows.</li> <li>"<b>@</b>" to indicate that a price value follows.</li> <li>"<b>+</b>" to indicate that a price increment follows.</li> <li>"<b>%</b>" to indicate that a price percent change follows.</li> <li>"<b>s1=</b>" indicates a shipping value follows.</li> <li>"'<b>s2=</b>" indicates a shipping2 value follows.</li> <li>It is not obvious, but negative amounts are allowed. The first character is a flag character (has special significance to parsing), but after that you may input any valid nunmber. -1 is a valid number, so "+-1.50" is perfectly legal.</li> </ul> <p>Here is an example of what you may put into the value of an option field of a select... </p> <pre> &ltoption value="Description #A1234 s1=10 s2=8.50 @25.00">...</option> </pre> <p>Setting shipping is a little tricky, in that if you use it in any value field of a select, then you must use it in every value field, even if it is set to zero. </p> <hr /> <form action="https://www.paypal.com/cgi-bin/webscr" method="post" onsubmit="this.target = 'paypal'; ReadForm (this);"> <p> <input type="hidden" name="cmd" value="_cart" /> <input type="hidden" name="add" value="1" /> <input type="hidden" name="business" value="jas22924@aol.com" /> <input type="hidden" name="item_name" value="" /> <input type="hidden" name="item_number" value="" /> <input type="hidden" name="amount" value="" /> <input type="hidden" name="currency_code" value="USD" /> <input type="hidden" name="lc" value="US" /> <input type="hidden" name="shipping" value="10" /> <input type="hidden" name="shipping2" value="20" /> <input type="hidden" name="baseamt" value="10.00" /> <input type="hidden" name="basedes" value="Test Item" /> [picture] Blah, blah. <br /><br /> Color - <select onchange = "ReadForm (this.form);"> <option value="white #1212-w s1=2 s2=1 @9.00">white ($9.00)</option> <option value="red #1212-r s1=0 s2=0 @10.00">red ($10.00)</option> <option value="blue #1212-b s1=0 s2=0 @11.00">blue ($11.00)</option> </select> Fabric - <select onchange = "ReadForm (this.form);"> <option value="cotton">cotton</option> <option value="blend">blend</option> </select> Size - <select onchange = "ReadForm (this.form);"> <option value="Small">Small</option> <option value="Medium +0.50">Medium (+0.50)</option> <option value="Large +1.00">Large (+1.00)</option> </select> <br /><br />Input Quantity > <input type="text" name="quantity" size="3" value="1" /> Total item cost > <input class="nbor" type="text" name="tot" size="8" value="$9.00" /> <input type="image" src="images/x-click-but22.gif" name="submit" alt="cart add" /> <input type="image" src="images/view_cart.gif" alt="cart view" onclick="document.forms.viewcart.target = 'paypal'; document.forms.viewcart.submit (); return false;" /> </p> </form> <hr /> <p> <a href = "http://validator.w3.org/"> <img class = "w3c" src = "xhtml11.gif" alt = "Image: XHTML 1.1 certified!" /></a> <a href = "http://jigsaw.w3.org/css-validator/"> <img class = "w3c" src = "vcss.gif" alt = "Image: CSS2 certified!" /></a> <a href = "http://www.w3.org/wai/"> <img class = "w3c" src = "wcag1aa.png" alt = "Image: Multi-user accessibility!" /></a> <br /><br /> </p> </body> </html> End Copy HERE
  7. I may be way out of line here I am just getting involved with osCommerce, I may have even crossposted a feww time I am trying not to do that any longer. But somtimes I feel a topic belongs in a couple different areas of the forum. For the mistakes I apologize to each forum member. However I have a store running now in html format, that I can change the options loaded into paypal, so when the information is passed to paypal. That information is viewable in the paypal where you can then ship from paypal account. My question here is? I have oscommerce 2.2 MS2 and the offical oscommerce_PayPal _IPN which up to this point just learned that you can only pass two variables through to the paypal account the rest of the variables do not show up I am loading the code in which is how I pass the information through to paypal, I am only trying to maybe assist in making more attributes show up in paypal and I also have no idea about implementing these changes. But it might help someone possibly and possibly not. <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns = "http://www.w3.org/1999/xhtml" xml:lang = "en"> <head> <!-- Stylesheet for screen and printer --> <link type = "text/css" href = "std.css" rel = "stylesheet" media = "screen, print" /> <title>Concatenate unnamed selects.</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <meta http-equiv="Content-Language" content="en-US" /> <meta name="keywords" content="paypal, form, javascript, button, html, helper, select, concatenate, dropdown" /> <meta name="generator" content="Hand-typed in Wordpad" /> <meta name="description" content="Reading multiple selects with JavaScript, and concatenating those values into the PayPal description field to dynamically modify both the cart data and the price of the item." /> Copy and paste into html document for full html instuctions. on how this works. I do not know if in could be incorporated into OSC PAYPAL IPN to pass on variable information. Thanks for your time and I hope I did not waste anyone time. But this woeks great in jtml format use it if you like it. <script type="text/javascript"> <!-- function Dollar (val) { // force to valid dollar amount var str,pos,rnd=0; if (val < .995) rnd = 1; // for old Netscape browsers str = escape (val*1.0 + 0.005001 + rnd); // float, round, escape pos = str.indexOf ("."); if (pos > 0) str = str.substring (rnd, pos + 3); return str; } function ReadForm (obj1) { // process un-named selects var i,j,amt,des,obj,pos,fst,val,num=""; var ary = new Array (); amt = obj1.baseamt.value*1.0; // base amount des = obj1.basedes.value; // base description for (i=0; i<obj1.length; i++) { // run entire form obj = obj1.elements; // a form element if (obj.type == "select-one" && // just get selects obj.name == "") { // must be un-named pos = obj.selectedIndex; // which option selected val = obj.options[pos].value; // selected value ary = val.split (" "); // break apart for (j=0; j<ary.length; j++) { // look at all items // first we do single character tokens... if (ary[j].length < 2) continue; fst = ary[j].substring (0,1); // first character val = ary[j].substring (1); // get data if (fst == "@") amt = val * 1.0; if (fst == "+") amt = amt + val*1.0; if (fst == "%") amt = amt + (amt * val/100.0); if (fst == "#") { // record item number num = val; ary[j] = ""; // zap this array element } // Now we do 3-character tokens... if (ary[j].length < 4) continue; fst = ary[j].substring (0,3); // first 3 chars val = ary[j].substring (3); // get data if (fst == "s1=") { // value for shipping if (obj1.shipping) obj1.shipping.value = val; ary[j] = ""; // clear it out } if (fst == "s2=") { // value for shipping2 if (obj1.shipping2) obj1.shipping2.value = val; ary[j] = ""; // clear it out } } val = ary.join (" "); // rebuild val with what's left if (des.length == 0) des = val; // 1st storage? else des = des + ", " + val; // nope, accumulate value } } if (obj1.item_number && num.length > 0) obj1.item_number.value = num; obj1.item_name.value = des; obj1.amount.value = Dollar (amt); if (obj1.tot) obj1.tot.value = "$" + Dollar (amt); } //--> </script> </head> <body> <!-- This is the FORM to view the cart contents --> <form action="https://www.paypal.com/cgi-bin/webscr" method="post" id="viewcart" name="viewcart"> <p> <input type="hidden" name="cmd" value="_cart" /> <input type="hidden" name="display" value="1" /> <input type="hidden" name="business" value="jas22924@aol.com" /> </p> </form> <!-- End of view cart FORM --> <table width="100%"> <tr> <td> <h1>Concatenate unnamed selects</h1> </td> <td> <a href = "http://members.aol.com/paypalhelper/">home page</a><br /> <a href = "http://members.aol.com/paypalhelper/stdc.htm">std.css</a> </td> </tr> </table> <p>All this simple JavaScript (JS) plugin does is to accept the <i>value</i> fields from unnamed selects and concatenate them into the description field. These <i>value</i> fields may have price modifying information, item numbers or shipping costs in them. </p> <p>We start with the output of the PayPal button factory and make a few changes. Then the JS processes the FORM and adjusts the fields. <view source> on this page to see what was done. </p> <ul> <li>Copy the JS from this example and paste it into your page within the <b> <head></b> section, like is done on this page. Only one copy of the JS is needed for any page.</li> <li>If you want a view-cart button somewhere on the page you must copy the view FORM from my page and insert it into your page right after the <b> <body...</b> statement, like I have done here. You will need to change the <i> business</i> value, or course.</li> <li>Go into every FORM that can place an order and add these things... <ul> <li>A new named element called <i>baseamt</i> to hold the base amount of the item.</li> <li>A new named element called <i>basedes</i> to hold the base description of this item.</li> <li>An event handler to the to the FORM element, like I have done on this page.</li> <li><b>unnamed</b> selects so the user can pick his options.</li> <li>An optional text field named <i>tot</i> where the item cost is displayed if you include event handlers on the selects. In this case the base price must be the default settings of the selects. <view source> to see how I did it on this page.</li> </ul></li></ul> There are single token, and three-token flags that may be used in the <i>value</i> field of the options. <ul> <li>"<b>#</b>" to indicate that an item number follows.</li> <li>"<b>@</b>" to indicate that a price value follows.</li> <li>"<b>+</b>" to indicate that a price increment follows.</li> <li>"<b>%</b>" to indicate that a price percent change follows.</li> <li>"<b>s1=</b>" indicates a shipping value follows.</li> <li>"'<b>s2=</b>" indicates a shipping2 value follows.</li> <li>It is not obvious, but negative amounts are allowed. The first character is a flag character (has special significance to parsing), but after that you may input any valid nunmber. -1 is a valid number, so "+-1.50" is perfectly legal.</li> </ul> <p>Here is an example of what you may put into the value of an option field of a select... </p> <pre> &ltoption value="Description #A1234 s1=10 s2=8.50 @25.00">...</option> </pre> <p>Setting shipping is a little tricky, in that if you use it in any value field of a select, then you must use it in every value field, even if it is set to zero. </p> <hr /> <form action="https://www.paypal.com/cgi-bin/webscr" method="post" onsubmit="this.target = 'paypal'; ReadForm (this);"> <p> <input type="hidden" name="cmd" value="_cart" /> <input type="hidden" name="add" value="1" /> <input type="hidden" name="business" value="jas22924@aol.com" /> <input type="hidden" name="item_name" value="" /> <input type="hidden" name="item_number" value="" /> <input type="hidden" name="amount" value="" /> <input type="hidden" name="currency_code" value="USD" /> <input type="hidden" name="lc" value="US" /> <input type="hidden" name="shipping" value="10" /> <input type="hidden" name="shipping2" value="20" /> <input type="hidden" name="baseamt" value="10.00" /> <input type="hidden" name="basedes" value="Test Item" /> [picture] Blah, blah. <br /><br /> Color - <select onchange = "ReadForm (this.form);"> <option value="white #1212-w s1=2 s2=1 @9.00">white ($9.00)</option> <option value="red #1212-r s1=0 s2=0 @10.00">red ($10.00)</option> <option value="blue #1212-b s1=0 s2=0 @11.00">blue ($11.00)</option> </select> Fabric - <select onchange = "ReadForm (this.form);"> <option value="cotton">cotton</option> <option value="blend">blend</option> </select> Size - <select onchange = "ReadForm (this.form);"> <option value="Small">Small</option> <option value="Medium +0.50">Medium (+0.50)</option> <option value="Large +1.00">Large (+1.00)</option> </select> <br /><br />Input Quantity > <input type="text" name="quantity" size="3" value="1" /> Total item cost > <input class="nbor" type="text" name="tot" size="8" value="$9.00" /> <input type="image" src="images/x-click-but22.gif" name="submit" alt="cart add" /> <input type="image" src="images/view_cart.gif" alt="cart view" onclick="document.forms.viewcart.target = 'paypal'; document.forms.viewcart.submit (); return false;" /> </p> </form> <hr /> <p> <a href = "http://validator.w3.org/"> <img class = "w3c" src = "xhtml11.gif" alt = "Image: XHTML 1.1 certified!" /></a> <a href = "http://jigsaw.w3.org/css-validator/"> <img class = "w3c" src = "vcss.gif" alt = "Image: CSS2 certified!" /></a> <a href = "http://www.w3.org/wai/"> <img class = "w3c" src = "wcag1aa.png" alt = "Image: Multi-user accessibility!" /></a> <br /><br /> Contact me concerning this article at <a href="mailto:paypalhelper@aol.com"> paypalhelper@aol.com</a>. Mention "simple script" in your note. </p> <p> Individual help starting at $25.00 for simple JS solutions. </p> </body> </html>
  8. I know this qhuestion has been answered most likely a hundred times. I just can't seem to find a solid topic on it explaining well enough how to correct my problem. Everything works great with the two file installation. However; How do I get the checkout process to pass all the product attributes along and into paypal ipn? It appears that paypal excepts to fields for product options. Is there a way to increase these fields to be added to paypal? invoice number added also would be very handy too.
  9. I have half of the variables passing through to paypal but I miss two or thre variables, unfortuanely they are the critical attributes I need listed to paypal. Does anyone have an Idea how to make this happen.
  10. baesic2

    Option Not all showing in paypal?

    PayPal IPN ?? Not variables showing in the paypal details such as How to get all the Available Option to show in PayPal and get the PayPal transaction number into osc? Product Id size
  11. baesic2

    PayPal IPN [TEP STOP]

    Thanks so much I finally got it running without problems. All assistance and any cross posting was an error on my part thinking they were of the same nature of topic.
  12. baesic2

    PayPal IPN [TEP STOP]

    thank you for your assistance I did a complete drop all table and a complete re-install and put the oscommerce_paypal_ipn contribution in with 2 files and for noe in sandbox mode it's working fine now just to fine tune and get the invoice information to pass through to paypal, any ideas? Thank you I aooreciate you taking the time and pointing me in the right direction.
  13. baesic2

    PayPal IPN [TEP STOP]

    That copy doesn't seem to work when downloading it from the contribution page from that and I download 10 Feb 2005 I get a txt file Preloader text file. I do not think that is what I am looking for either. Thank you for your assistance. If you have any other suggestions please feel free to assist me.
  14. baesic2

    PayPal IPN [TEP STOP]

    When making a purchase through the check out process seems to wotk flawlessly however when trying to retrieve information on orders whether in admin or customer account area and attempt to look at "customer Acount"previous order information or ivoice thriough admin I get the following errors can anyone assist me in making the corrections to my palpal IPN Here is the error code 1054 - Unknown column 'products_options_id' in 'field list' select products_options_id, products_options_values_id, products_options, products_options_values, options_values_price, price_prefix from orders_products_attributes where orders_id = '8' and orders_products_id = '8' [TEP STOP]
  15. This is the complete error message i get when looking at account 1054 - Unknown column 'products_options_id' in 'field list' select products_options_id, products_options_values_id, products_options, products_options_values, options_values_price, price_prefix from orders_products_attributes where orders_id = '8' and orders_products_id = '8' [TEP STOP]
×