Jump to content

Chadduck

Members
  • Content count

    128
  • Joined

  • Last visited

Everything posted by Chadduck

  1. OSC2.2 RC2A conversion to OSC 2.3.4 These files I have assembled in this package assume that you, the reader, have access to the OSC configuration files, are somewhat knowledgable in the usage of PhpMyAdmin, a terminal program (like SecureCRT), and an FTP program. IF you are not I recommend that you stop now and go no further. WHAT THIS PACKAGE WILL DO: 1. INSERT the NEW tables as created by the OSC 2.3.4 a. Action Recorder b. Products Images c. SEC Directory Whitelist 2. MODIFY existing OSC tables to be as created by the OSC 2.3.4 sql file WHAT THIS PACKAGE WILL NOT DO: 1. Delete tables 2. Create tables required by user installed modifications 3. Modify fields inserted by user installed modifications These files do NOT ensure that user install modifications will work properly with OSC 2.3.4 - that is the end user's responsibility. FOLLOW THE READ_ME.pdf instructions The files are located here http://addons.oscommerce.com/info/9097
  2. Chadduck

    OSC2.2 RC2A conversion to OSC 2.3.4

    I misquoted the vsn number it is RC2a thank you for pointing that out. Also I corrected it in the updated files. THANK YOU RE: I NEVER found this in the add-ons ALSO the ones I did find did NOT do the UTF-8 unicode conversion.
  3. Chadduck

    New Certified PayPal Payment Modules

    Harald Please understand that I live by the adage - "If it ain't broke Don't fix it." BUT having said that I am now performing a massive upgrade from a multiple patched MS2A installation to a clean 2.3.4 install. The Payflow Pro module currently installed is the first (or very close to the first) version is payflow_pro_v0.3 written by Dynamo Effects WHAT is the current version I NEED to install? Obviously the correct vsn is important I DO NOT want to screw this vital installation up. Thank you for your time and reply in advance. BJ Chadduck
  4. Chadduck

    USPS Rate V4, Intl Rate V2 (official support thread)

    Whoops - clicked the wrong one - using USPS Methods
  5. Chadduck

    USPS Rate V4, Intl Rate V2 (official support thread)

    Not certain if everyone has realized it or not - USPS has "fixed" their garbage transmission. I was working on updating and installing when a customer called about his order.... I looked at his order and discovered that he had gotten a CORRECT response... further investigation showed it is now working without any changes on my part.
  6. Chadduck

    [Contribution] - USPS Methods

    Not certain if everyone has realized it or not - USPS has "fixed" their garbage transmission. I was working on updating and installing when a customer called about his order.... I looked at his order and discovered that he had gotten a CORRECT response... further investigation showed it is now working without any changes on my part.
  7. Chadduck

    [Contribution] - USPS Methods

    I am currently using 6.3 and like everyone things went to hell in a handbasket on Saturday. To temporarily over the difficulty I enabled the Flat rate with a package average shipping cost of $11.25 - hopefully with the fix identified above I can disable Flat Rate and get back to business with the USPS Method module.... however BEFORE I update to 7.1 (which I am willing to do) I started pulling the ALL 7.x modules looking for valid installation instructions. None of the modules seem to have a set. I even went over to github and Nope none there. ARE THEY THE SAME AS 6.3?
  8. I am haing difficulty with modifying an admin module to work within the 2.3.1 environment that works fine in a 2.2RC2a environment. The module creates a file, stores the file, and when user presses the DL FILE button the file displays on the screen instead of being sent to the user. I have spent close to 24 hours researching this, on php sites, OSC sites, and here. It makes no sense since if the file is called direct by URL the browser says "where you wanna put it?" The only modification done to the working 2.2RC2a mod was removal of the tab menu and making it into a "box" on the admin screen. EVERYTHING except the file download portion works. It writes to the db, reads the db, creates the necessary file in the correct format, the file imports to the user's final program correctly like I said it works CORRECTLY except the DL. Code environment is Apache, PHP 5.3.2, and MySQL 5.1.41 - also the "admin/output" directory is 777. HERE IS THE CODE BEING USED. I even inserted extra echo cmds to ensure that each step was seen. Each step was reached, at least the echo cmd was sent to the screen but still no DL only screen display. // Download file if (DL_FILE==1) { /* ORIG */ $filename="output/orders.iif"; $size=filesize($filename); header("Pragma: public"); header("Cache-Control: private"); header("Content-Type: Application/octet-stream"); header("Content-Disposition: attachment; filename=orders.iif"); header("Content-length: $size"); readfile($filename); I have been stuck on this for 5 days... I have tried countless variations of code for this found on many different sites. ANY and ALL suggestions would be helpful cause quite frankly I can not see WHY it is NOT working. (not to mention I am going bald from pulling out my hair LOL) Thank you in advance, BJ
  9. anyone have an idea? Is the code correct?
  10. Hello all; I utilize QB Enterprise v12 (2012) and unlike previous poster I CAN get the QBACCTS and the QBMISC iif files to import. However, like the previous poster i CAN NOT get the INVIMPORT to import. It contains 6149 items. Some are Groups most are not. Since the inventory file does not import this is of little value. It would be better if the IIF files were placed on the server prior to importation since the interface seems to time out before completion on large files such as my inventory. Just a thought. OH Well back to my modification of QBI 2.10c to work on OSC 2.3.1 BJ BTW I also pulled and installed hughesca's files AFTER the original files had an issue. His has the same issue.
  11. Chadduck

    QBI Quickbooks Import

    Has anyone modified the "free" version (2.10c) of Quickbooks Import available in contributions to work within OSC 2.3? At this point in time I have managed to get the files to display "properly" however the menuing does NOT work. The 2nd level menu does not display. Calling the files by their filenames they load and display correctly. Import of existing files works. Within the individual files the data is accessed and appears to be correct. Here is/are the primary problem(s) Since there is no submenu the functionality is disjointed. The DL of the IIF is not accomplished within the interface. Instead it is displayed on the screen. HOWEVER it is created and placed in qbi_output correctly. If pulled from there it does import correctly. I am at best a novice programmer. Give me an example and I can accomplish the rest. BJ
  12. Well, I am NOT "serverguy" BUT I accidently self induced the problem.... The problem was induced when I changed a setting the php.ini. The variable was short_open_tag. In php 5.3 these are the developer recommended settings ; Default Value: On ; Development Value: Off ; Production Value: Off ; http://php.net/short-open-tag When I moved it (what I thought was incorrect ) from "ON" as follows short_open_tag = On to the recommended "OFF" - that stupid problem presented itself... Since I had been working on the deprecated commands also I thought I had caused it with a typo. Have spent the last 4 and half hours copying ALL the files from a backup server. Copying the files DID NOT solve the issue. SO the deprecation fixes were not the problem. Realizing that the only other thing I had worked with was the php.ini I decided to verify from the back up server. Changing the variable above from "OFF" to "ON" in the php.ini solved the problem. Enjoy BJ
  13. Chadduck

    PayPal Payflow Pro [New Version]

    You may discover that this module allows credit cards that you do NOT accept to be approved To reolve this, what we did was as follows: BACK UP THE ORIGINAL FILES!!!!!!!!!! ##################### Things you probably need to look at How to implement Automated Clearinghouse (ACH) with Payflow Pro https://cms.paypal.com/cms_content/US/en_US...yment_Guide.pdf DID YOU BACK UP THE ORIGINAL FILES????? #################################### #################################### THIS WILL SET UP AN ERROR MESSAGE RETURNED IF THE CARD TYPE NOT ACCEPTED #################################### #################################### ############ OPEN ############ catalog/includes/languages/english/modules/payment/paypal_payflow_pro.php ############ FIND ############ ?> ############ BEFORE INSERT ############ define('MODULE_PAYMENT_PAYPAL_PAYFLOW_PRO_TEXT_ERROR_CC_TYPE', "We regret that we are unable to accept the type of Credit Card that you are tring to use."); ############ SAVE AND CLOSE ############ #################################### #################################### THIS NEXT PART INSERTS THE ERROR CHECKING FOR CARD TYPE NOT MAPPED TO YOUR ACH ACCOUNT ##################### AS IDENTIFIED IN ABOVE MANUAL from Table 8-5 ON PAGE 56 How to implement Automated Clearinghouse (ACH) with Payflow Pro WE ARE GOING TO ADD A CHECK FOR Code 25 - Invalid Host Mapping. You are trying to process a tender type such as Discover Card, but you are not set up with your merchant bank to accept this card type. DID YOU BACK UP THE ORIGINAL FILES????? #################################### #################################### ############ OPEN ############ catalog/includes/modules/payment/paypal_payflow_pro.php ############ FIND ############ } else if ($result_code == 12) { $RespMsg = MODULE_PAYMENT_PAYPAL_PAYFLOW_PRO_TEXT_ERROR_DECLINED; ############ BEFORE INSERT ############ } else if ($result_code == 25) { $RespMsg = MODULE_PAYMENT_PAYPAL_PAYFLOW_PRO_TEXT_ERROR_CC_TYPE; ############ SAVE AND CLOSE ############
  14. Chadduck

    PayPal Payflow Pro [New Version]

    Xtech - This may be a really dumb question but is the module set to TEST or LIVE? When I first installed it I overlooked that "minor" thing. BJ
  15. Chadduck

    PayPal Payflow Pro [New Version]

    <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=650,height=500,screenX=150,screenY=150,top=150,l eft=150') } //--></script> The previous code should be contigious line one line simply move the eft=150') up to read .... ,top=150,left=150') } //--></script> ALSO A WORKING VSN OF THE MODIFICATIONs IS AT http://www.militarywives.com/catalog
  16. Chadduck

    PayPal Payflow Pro [New Version]

    I myself am using this and after several separate conversations with Paypal - yes it is compatible. BJ
  17. Chadduck

    PayPal Payflow Pro [New Version]

    My hat is off to Brian for his efforts in creating this module and receiving recommendations from Paypal to use it as is shown here http://paypaldeveloper.com/pdn/board/messa...;thread.id=6309 . It was based on this recommendation that I began installing and using it. Before I begin I must state that I am NOT the original author of the module only a merchant with a few albeit limited skills with the php language and code tracing. Having stated that I also need to point out the issues I discovered with this module. 1. Many customers do NOT understand nor do they have a clue what CVV2 is. 2. The module will allow transactions to appear within the orders section showing them as APPROVED even though CVV2 portion failed. I am using osCommerce Online Merchant v2.2 RC2 NOT RC2a I am in the US and Paypal is my ACH (Automated Clearinghouse) We only accept VISA and MasterCard. I will now explain what I did to resolve those issues and the information I utilized to make my changes and why. BEFORE YOU GO ANY FURTHER - this works for me it should for you IF properly incorporated. BACK UP THE FILES REFERRED TO and if possible check on a test site first. REMEMBER TO BACK UP THE ORIGINAL FILES AND TEST BEFORE USING ON LIVE STORE!!!! ISSUE #1 above To resolve this you need to do a couple of things ##################### Things you will need PayPal Payflow Pro v1 http://addons.oscommerce.com/info/4805 You only need the csc.htm, amex.htm and the images (you may have to edit them to fit your specific site) Obviously Brian's Module PayPal Payflow Pro [New Version] http://addons.oscommerce.com/info/6244 DID YOU BACK UP THE ORIGINAL FILES????? ##################### FIRST WE ARE GOING TO CHANGE THE "CVV2" presentation text to "Card Security Code". FROM Brian's Module PayPal Payflow Pro [New Version] #### OPEN #### catalog/includes/languages/english/modules/payment/paypal_payflow_pro.php #### FIND #### define('MODULE_PAYMENT_PAYPAL_PAYFLOW_PRO_TEXT_CREDIT_CARD_CVV2', 'CVV2:'); #### CHANGE TO #### define('MODULE_PAYMENT_PAYPAL_PAYFLOW_PRO_TEXT_CREDIT_CARD_CVV2', 'Card Security Code:'); #### FIND #### define('MODULE_PAYMENT_PAYPAL_PAYFLOW_PRO_TEXT_ERROR_CVV2', "Your CVV2 security code does not match. Please re-enter."); #### CHANGE TO #### define('MODULE_PAYMENT_PAYPAL_PAYFLOW_PRO_TEXT_ERROR_CVV2', "Your Card Security Code did not match. Please re-enter."); ###### SAVE AND CLOSE ###### NOW WE ARE GOING TO CREATE A POP-UP WINDOW LINK TO EXPLAIN WHAT THE HECK "Card Security Code" is and how to locate it. #### OPEN #### catalog/checkout_payment.php #### FIND #### </head> #### BEFORE IT ADD #### <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=650,height=500,screenX=150,screenY=150,top=150,l eft=150') } //--></script> #### FIND THE SECTION #### <?php } elseif (isset($selection[$i]['fields']) && is_array($selection[$i]['fields'])) { ?> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td colspan="4"><table border="0" cellspacing="0" cellpadding="2"> <?php for ($j=0, $n2=sizeof($selection[$i]['fields']); $j<$n2; $j++) { ?> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo $selection[$i]['fields'][$j]['title']; ?></td> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo $selection[$i]['fields'][$j]['field']; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> <?php } ?> </table></td> #### CHANGE TO READ #### #### MAKE SURE YOU CHANGE <YOUR DOMAIN> to your url #### } elseif (isset($selection[$i]['fields']) && is_array($selection[$i]['fields'])) { ?> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td colspan="4" class="main"><img src="images/cclogos.gif" alt="Cards We Accept"><table border="0" cellspacing="0" cellpadding="2"> <?php for ($j=0, $n2=sizeof($selection[$i]['fields']); $j<$n2; $j++) { ?> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo $selection[$i]['fields'][$j]['title']; ?></td> <td><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo $selection[$i]['fields'][$j]['field']; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> <?php } ?> <tr> <td colspan="5" class="main"><a href="java script:popupWindow('http://<YOUR DOMAIN>/catalog/csc.htm')"><u><font color="0000FF">Card Security Code Explanation</font></u></a></td> <tr> </table></td> #### DID YOU CHANGE <YOUR DOMAIN> to your url #### #### SAVE and CLOSE #### #### FINAL TOUCHES #### From PayPal Payflow Pro v1 http://addons.oscommerce.com/info/4805 AS STATED PREVIOUSLY WE ACCEPT ONLY VISA AND MASTERCARD SO WE DO NOT USE THE amex.htm file. THIS INCORPORATES BOTH #### UPLOAD TO /catalog #### csc.htm, amex.htm ### UPLOAD TO /catalog/images ## the images (you may have to edit them to fit your specific site) #### IF YOU DO NOT ACCEPT AMEX YOU NEED TO REMOVE THE #### CONFUSION FACTOR LIKE THIS #### OPEN /catalog/csc.htm #### #### FIND #### <p> <font face="Verdana" size="2"><a href="csc_amex.htm">Using American Express?</a></font><span style="font-weight: 400"><font face="Verdana" size="2"><br> </font></span> <br> </p> #### DELETE IT #### ###################################### ###################################### ISSUE #2 above To resolve this you need to do a couple of things ##################### Things you probably need to look at How to implement Automated Clearinghouse (ACH) with Payflow Pro https://cms.paypal.com/cms_content/US/en_US...yment_Guide.pdf DID YOU BACK UP THE ORIGINAL FILES????? ##################### AS IDENTIFIED IN ABOVE MANUAL from Table 8-5 ON PAGE 57 How to implement Automated Clearinghouse (ACH) with Payflow Pro WE ARE GOING TO ADD A CHECK FOR Code 114 - CVV2 or CID Mismatch DID YOU BACK UP THE ORIGINAL FILES????? FROM PayPal Payflow Pro [New Version] #### OPEN #### catalog/includes/modules/payment/paypal_payflow_pro.php #### FIND #### } else if ($result_code == 12) { $RespMsg = MODULE_PAYMENT_PAYPAL_PAYFLOW_PRO_TEXT_ERROR_DECLINED; #### BEFORE IT INSERT #### } else if ($result_code == 114) { $RespMsg = MODULE_PAYMENT_PAYPAL_PAYFLOW_PRO_TEXT_ERROR_CVV2; #### THIS WILL SEND THE CUSTOMER BACK TO THE CREDIT CARD ENTRY PAGE FOR A CVV2 ERROR #### #### SAVE AND CLOSE #### That's it Folks and Good Luck. REMEMBER TO BACK UP THE ORIGINAL FILES AND TEST BEFORE USING ON LIVE STORE!!!! BJ
  18. Chadduck

    QBI Quickbooks Import

    Adam -- Wanted to let you know that we JUST installed Version 6 of Enterprise Solutions (aka QB2006) and QBI works with like it did with vsn 4. BJ Chadduck MilitaryWives.com
  19. Chadduck

    QBI Quickbooks Import

    Adam -- Since we do not have the Gift Voucher (or any other similar module for that matter) installed we can not quantify an answer regarding the error for the positive or negative value. We regret that we can not assist you with an answer. As to the discount (coming from the QB IIF) we are willing to be your tester on it since we have probably 20 or more different items set up like the one described above. Thanks for the heads up on the discount portion not working properly because truthfully I thought I had installed it incorrectly since the the QB items appeared but nothing appeared under the OSC column. Also, and this is a curiousity question - When an item is reduced by being placed on Special within the original OSC setup (Catalog => Specials) will the reduced pricing be reflected within the QB invoice or will a "Transaction out of balance error" be generated since the OSC price will be different from the QB price? What we had done in the past (since we were doing the entry manually) was simply enter the reduced price. QB never squawked about it HOWEVER since we anticipate using this outstanding management tool now we are really curious. In closing - is there a guess-timate on the next version's arrival? BJ Chadduck President MilitaryWives.com, Inc.
  20. Chadduck

    QBI Quickbooks Import

    Adam -- This contribution is absolutely FABULOUS. It was one reason we switched from the store software "Interchange" to OSC. Having said that - we are running into a slight problem that we can not figure out. Before I begin overall this contribution works without a hitch. Our setup - OSC 2.2 Milestone 2 QB Enterprise Some of our items are setup within QB to be groups with a discount amount associated with it. The export goes wonderfully. The import does also. From there it goes downhill with the discount. The discount appears where it should (Setup => Discounts/Fees) in the select bar. The situation is that we do not know how to define the "discount" within OSC so it appears under the OSC column. At present there is one item appearing (Low Order Fee) and nothing else. Since the customer never sees that the item(s) they are purchasing are actually produced from the individually available items the item price simply shows as $9.95. Here is an example of a one such item - QB Export IIF portion INVITEM SPAK-11 1286 1094933623 GRP "ScrapPack, Coast Guard #2" Y N 0 N INVITEM Scrapbook:K-Company:KC Papers:KC-638211 1281 1094929135 INVENTORY Y 1 N 0 N INVITEM Scrapbook:K-Company:KC Papers:KC-638228 121 1094929075 INVENTORY Y 1 N 1 N INVITEM Scrapbook:K-Company:KC Papers:KC-638235 118 1094929107 INVENTORY Y 1 N 1 N INVITEM Scrapbook:K-Company:KC Papers:KC-638242 307 1094928878 INVENTORY Y 1 N 1 N INVITEM Scrapbook:K-Company:KC Papers:KC-638273 200 1094928921 INVENTORY Y 1 N 1 N INVITEM Scrapbook:K-Company:KC Papers:KC-638327 321 1094928832 INVENTORY Y 1 N 1 N INVITEM Scrapbook:K-Company:KC-555044 1052 1083077928 INVENTORY Y 1 N 0 N INVITEM Scrapbook:K-Company:KC-552630 190 1094929034 INVENTORY Y 1 N 1 N INVITEM Scrapbook:K-Company:KC-557475 1282 1094929178 INVENTORY Y 1 N 0 N INVITEM SPAK-Z-820 1287 1094933845 DISC Y N 0 N ENDGRP OSC IIF Portion (of an order) N -1 SPAK-11 Y Sales:Scrapbook -0.55 Vintage Flag Blocks Paper N -1 0.55 Scrapbook:K-Company:KC Papers:KC-638235 Y Sales:Scrapbook -0.55 Vintage Flag Paper N -1 0.55 Scrapbook:K-Company:KC Papers:KC-638228 Y Sales:Scrapbook -4.95 American Flag Embossed Stickers N -1 4.95 Scrapbook:K-Company:KC-552630 Y Sales:Scrapbook -0.55 Camoflauge Paper N -1 0.55 Scrapbook:K-Company:KC Papers:KC-638273 Y Sales:Scrapbook -0.55 War Time Letters N -1 0.55 Scrapbook:K-Company:KC Papers:KC-638242 Y Sales:Scrapbook -0.55 12 x 12 Coast Guard Paper N -1 0.55 Scrapbook:K-Company:KC Papers:KC-638327 Y Sales:Scrapbook -4.95 Adhesion, Coast Guard Grand N -1 4.95 Scrapbook:K-Company:KC-555044 Y Sales:Scrapbook -0.55 Vintage Flag Border Paper N -1 0.55 Scrapbook:K-Company:KC Papers:KC-638211 Y Sales:Scrapbook -4.95 Patriotic Sayings N -1 4.95 Scrapbook:K-Company:KC-557475 Y -18.15 ScrapPack, Coast Guard #2 N Y ENDGRP The question is Since the discount from the QB IIF is read, placed where it should be (qbi_disc table) how do we get the item created within OSC for matching purposes so that it can be properly sent out with OSC IIF export? With the exception of this - this contribution is a lifesaver!!! (not to mention a TIME SAVER!!!) BJ Chadduck President MilitaryWives.com, Inc.
×