QuickBooks Merchant Service

All set up done and tried to make a transaction. Like others, I do not see a charge in Merchant Account. Check out went successful. How would I see in Zencart if the transaction worked? Or do I just see it if I log in the merchant account? What if I need to refund?

I got no errors and no transaction posted to my merchant account. I will re-check everything as advised to others anyway.

Securfocus:

2)I already had QBMS - not the web store portion
3)Once it works you CAN see your transactions through Merchant Service Deposits on the QB Accounting Software home page.

Where exactly do you see this? I still can't find my transaction. No errors.

Ok, maybe I posted a bit fast, the transaction did show up if I just go to my merchantcenter and go to Search and reporting - search for transactions. Now I see my test transactions but how would I refund?

I posted again too fast, sorry.

Now I see my test transactions and I see that there is a refund option. So far so good. Now just the question remains how to get the transactions downloaded to QB. I am not taking about the QBI features of importing the orders from Zen, just getting the financial transaction data into QB. How are you guys handling this? Let's say you have 10 transactions for the day from web sales. How do you track them in QB?

Mod works but validation of cvv BEFORE it gets sent to QB merchant service gateway does not work. I can check out without giving CVV. All settings are done so CVV should get checked. Offline CC mod java popup works fine. In this mod not.
I looked at the code that should make it work, did anybody modify so it works?

   // function javascript_validation: Validates the submitted payment details.
   function javascript_validation() {
      $js = '  if (payment_value == "' . $this->code . '") {' . "\n" .
            '    var cc_owner = document.checkout_payment.qbms_cc_owner.value;' . "\n" .
            '    var cc_number = document.checkout_payment.qbms_cc_number.value;' . "\n" .
            '    if (cc_owner == "" || cc_owner.length < ' . CC_OWNER_MIN_LENGTH . ') {' . "\n" .
            '      error_message = error_message + "' . MODULE_PAYMENT_QBMS_TEXT_JS_CC_OWNER . '";' . "\n" .
            '      error = 1;' . "\n" .
            '    }' . "\n" .
            '    if (cc_number == "" || cc_number.length < ' . CC_NUMBER_MIN_LENGTH . ') {' . "\n" .
            '      error_message = error_message + "' . MODULE_PAYMENT_QBMS_TEXT_JS_CC_NUMBER . '";' . "\n" .
            '      error = 1;' . "\n" .
			'    if (' . MODULE_PAYMENT_QBMS_VERIFY_WITH_CVV2 . ' == "True") {' . "\n" .
			'      var cc_cvv2 = document.checkout_payment.qbms_cc_cvv2.value;' . "\n" .
			'      if (cc_cvv2 == "" || cc_number.length < ' . 3 . ') {' . "\n" .
            '        error_message = error_message + "' . MODULE_PAYMENT_QBMS_TEXT_JS_CC_CVV2 . '";' . "\n" .
            '        error = 1;' . "}\n" .
            '      }' . "\n" .  
            '    }' . "\n" .
            '  }' . "\n";

      return $js;

Follow up on previous post. I tested other payment modules like Authorize.net and the ccv java pop up works there too. It seems something is wrong with the code in the qbms.php

I want the error to pop up if no cvv is given: (see attached picture)

Any help would be greatly appreciated.

Are you sure you have "Verify Credit Card with CVV2" set to TRUE in the admin Payment Modules settings for qbms?

Confirmed. I'm going to work with this - and will let you know if I find the "bug". But this validation code is not running at all.

Found the issue with the js not validating. The code is correct, the alert is not called. Will fix and post solution.

OK - Here is the fix. Thanks for picking that up. I reformatted a little to match up with the standard cc module. But the key was correct opening/closing of tags. Also - the test for CVV2 length was incorrect - so please note that change as well.

    function javascript_validation() {
      $js = '  if (payment_value == "' . $this->code . '") {' . "\n" .
            '    var cc_owner = document.checkout_payment.qbms_cc_owner.value;' . "\n" .
            '    var cc_number = document.checkout_payment.qbms_cc_number.value;' . "\n" .
            '    if (cc_owner == "" || cc_owner.length < ' . CC_OWNER_MIN_LENGTH . ') {' . "\n" .
            '      error_message = error_message + "' . MODULE_PAYMENT_QBMS_TEXT_JS_CC_OWNER . '";' . "\n" .
            '      error = 1;' . "\n" .
            '    }' . "\n" .
            '    if (cc_number == "" || cc_number.length < ' . CC_NUMBER_MIN_LENGTH . ') {' . "\n" .
            '      error_message = error_message + "' . MODULE_PAYMENT_QBMS_TEXT_JS_CC_NUMBER . '";' . "\n" .
            '      error = 1;' . "\n" .
            '    }' . "\n";
                 if (MODULE_PAYMENT_QBMS_VERIFY_WITH_CVV2 == 'True') {
     $js .= '    var cc_cvv2 = document.checkout_payment.qbms_cc_cvv2.value;' . "\n" .
            '    if (cc_cvv2 == "" || cc_cvv2.length < ' . 3 . ') {' . "\n" .
            '      error_message = error_message + "' . MODULE_PAYMENT_QBMS_TEXT_JS_CC_CVV2 . '";' . "\n" .
            '      error = 1;' . "\n" .
            '    }' . "\n";
           }
     $js .= '  }' . "\n";
      return $js;
    }

Now that I have gotten into the code a bit - additional enhancements have been added which improve security (such as limiting input lengths on the form) and correct other errors such as the link to the gateway. This is not my addon - but I may "fork" it and maintain that fork from there.

Ancient - are you still maintaining this? If so - I'm happy to provide the various updates, edits and improvements I have made for you to update in the addon section. The validation piece is actually quite important.

You should post the code up for the fix, and where to put that code in our files.

I am thinking that if there is a security factor that is being over looked it would be more then helpful to the original mod maker to have it posted so he could fix it if he wants to, but at least its out there for us to use.

And for the person asking how to get the transactions into quickbooks.

Here is my scenario -

1)Im using QB Enterprise:contractors edition v9.0
2)on the quickbooks software "homepage" there is a button in the banking area of the homepage that says - Merchant Service Deposits.
3)if you click it you should see transactions that are "processing" and another tab that has transactions that have been "processed" and deposited to your bank account.
4)on that same tab where transactions are listed as "processed" there is another button that says "record all transactions"
5)that button well a)automatically record the deposits in your bank register and b)record the merchant fees in your bank register as well.

I have only used enterprise edition with the merchant service so I cant provide support via any other piece.

OK - Here is the fix. Thanks for picking that up. I reformatted a little to match up with the standard cc module. But the key was correct opening/closing of tags. Also - the test for CVV2 length was incorrect - so please note that change as well.

is this for a different add on mod? i dont remember seeing any java in the QBMS mod that this post is for.

Securfocus:

is this for a different add on mod? i dont remember seeing any java in the QBMS mod that this post is for.

This is from the qbms.php file. It is from this mod.

Thank you for the updated js code. I will apply this very soon and give feed back.

between the three of us I think we will finally have a full walk through of setting this up. This Mod seemed like it wasn't getting much attention or support lately. I do thank the mod maker for this add on, it is a very good tool if you have QBMS.

CPTook, do you think there is a way to make this mod report specific errors on the credit card processing? I know there is only one error message that pops up if the transaction fails, but I dont think it tells you why it failed. So for the customer it would be hard to know whats going on.

The cc processing can only report those errors which the gateway gives back. There are not too many errors that I can tell. If you miss-enter the number, and it fails the algorithm for a "real" number, it fails before the gateway. If the card is "declined", it does report that specific error. What other errors need to be reported?

Regarding the other updates to the addon - it is not as easy as the js modification (which was all in one snipet). For that, I may just publish the new files altogether, but wanted to give Ancient the chance to just update the mod in the addon section.

Mydanilo - looking forward to successful feedback. I think this will do it.

Perfect, i guess i never got a declined error yet.

Greatly appreciate the updates you are doing.

Merchant Service Deposits seems to be a new feature for 2009 versions. I have QB Pro 2008. Seems like I have to manually enter. Bummer! If anybody has a good way of getting the transactions into QB 2008 or older, pls let me know. As far as I know you can only download fees or connect to the merchant account and see the activity but not automatically download.

Even in 2009 - they are "unmatched", and so are problematic. I have looked at including code to post the transaction into QBXML - which would then post in. But lots of new questions arise. Is it a payment or a sales receipt? If a receipt, then what product? What customer should it post to? Including all of that as "options" in the addon would be a significant effort.

Having said that - I'm thinking of posting everything to a generic "Online Customer" and posting as payments received. Then the credit balances can be applied to sales receipts for products purchased. The sales entries are still manual, but there is no other way for QB to know what has been sold. Anything more specific gets ugly quickly, and at that point, the two other QB products which export/import transactions are probably better approaches (one using IIF export and the other using web connector).

For the moment - I'm more focused on making sure the qbms addon does what it should correctly, and as securely as possible.

cptok:
The js for the CVV validation is now creating a nice pop up! Working. Now I tested if the credit card entered was not long enough. This results in a message on top of the page (old zen way) and no pop up. Could you modify it that this would be done in the pop up as well?

Here is the message that comes up on top of the page instead of the pop up:

The credit card number entered is invalid. Please check the number and try again.

What I like about the pop up version is, that the customer only needs to correct the problem and does not have to start with a blank form again. Re-entering the whole card info is a drag...

Thanks for working on the js. :smile:

Define "not long enough". The cc test is that it needs to be min 10 numbers. Although from my research, the shortest VISA cards are 13 digits, and longest cc numbers are 16. You can (and should?) change the minimum on your admin-configuration-minimum values page. On my newest version, there is also a maximum entry size on cc number and cvv number forms. Because anything from 13 to 16 is potentially valid - it must go to the next set of tests to validate.

I think if you put in a number less than 10 - the popup will work as expected.