QuickBooks Merchant Service

mydanilo:

cptok: Would it be possible to get a transaction number back into Zen Cart? Or is this something that is beyond what the desktop model can do? Something like the paypal IPN transaction info. It would be great if one could see that a payment has been made and have a reverence # posted in the order.

Yes - I noticed this as well. What I will say at this point is, the Authorization Code and Transaction ID are indeed captured back into Zen as part of the order info. But... does not display in the email back to the admin or the customer nor in the order details in admin. I agree that it should, but that may not actually be a qbms thing - but more of a zen thing. I'll track it down at some point.

Order info, to be displayed on admin order pages, can be done. But will take me a while. I will add this to whatever comes up as a 1.7 release. I'm continuing to clean up code, and make it all properly GPL compliant.

I appreciate your effort for this module. Looking forward to a proper integration with some kind of payment record back in the order info of the customer. I hope this module will stay alive when 2.0 arrives. It will probably need again some work.

DrByte wrote:
Core gateway payment modules allow use of a store-identifier-prefix so multiple stores can be more easily identified when sharing a single merchant account.

I wonder if this could be done with QB merchant as well. I noticed it is a bit tricky to keep track of the payments from all stores.

Update for today - and it's good news. Add on now successfully captures the Auth Code and Transaction ID and displays as part of the order in admin screen. Now just need to elegantly display cc info (truncated cc number, name on card and expiry), then clean up GPL stuff, and we'll have a 1.7 available!

That IS good news. Wow.:clap:

Posted v1.7. Includes new capture of auth code and transaction ID. These are now posted to the admin orders screen, and included in the admin email at time of order. It is also available to the customer in their order history. Upon further reflection and consideration, it did not make sense to try to deal with other cc info - as I prefer not to tread to closely to credit card laws (capturing cc numbers etc.). And, for our purposes as QBMS users, we can do anything via the merchant account interface including voids, refunds, verifying address info etc.

Great. Any idea when it will be available for download?

Up to the mod gods now. But should be up shortly.

At this point, it seems that we have taken care of urgent fixes and nice enhancements (with new auth code and trans id capture). But if there is a bug, or something has been missed - post here!

I installed 1.7 and it works great. Posting of [QBMS PMT] AUTH: 0xxxP TransID: MAxxxxx1557 works fine. I like that it is visible to the admin and the customer in my account.

I noticed that the info is sent to the defined order email (admin) but not to the customers order confirmation. Did you do or not do this on purpose? Maybe the QBMS PMT] AUTH: 0xxxP TransID: MAxxxxx1557 should be sent in the order confirmation too? Maybe this would avoid some charge backs as customers can identify where the charge came from? What do you think?

Otherwise, thank you very very much. This 1.7 implementation will be a great helper.

The workflow for QB merchant orders starts to be more efficient for me. I want to share how I process the orders.

• Get email with new order

• Login Admin and print the order for my records

• Enter sales receipt in QB using only customer name (Sold to) and generic product for recording the sale. Enter method of payment and order #. (I leave the Customer Job blank so no account gets created for the customer. I only use Customer Job for my wholesale customers where I expect frequent reorders.)

• I deposit according to the batches that I can look up online in the Merchant Service.

Now that the transaction# is stored with the order, I do not need to check if the transaction actually posted in the Merchant Service.

One thing is missing for me: I wish I would see what type of credit card was used. At the moment it only shows "Pay by Credit Card". I still have to get that info from Merchant Service unfortunately. If there is a way of posting to the order what Credit Card was used, it would be greatly helpful.

Thanks mydanilo! I knew I could count on you for feedback. These changes actually took some effort - so the comments are very appreciated!

Re. adding info to customer email. The admin email already has core functionality to include that kind of information. I just had to correctly piggy-back on it. To change customer email templates might require changing core files or templates - and that is probably not a good idea. The addon has to work standalone with no code edits or core file changes (IMO).

Re. adding credit card type. I agree! I was actually trying to do that before just putting 1.7 out there. But it is, obviously, just a little easier said than done. It is doable, and will get done. Just depends on how much effort I can spend in the next week or so isolating that info, and putting it with the Auth data. But I will do it, and if I get it done sooner, I'll make it available to you via direct download as I'd like to wait on publishing new versions until there is more to do.

cptok, glad to give feedback and I understand if not everything on my "wish list" is going to happen. I kind of assumed that not everything is easy to accomplish. For sure I know it is over my head. Glad I can help somehow...

Capturing the credit card type might be tricky as the payment form is not asking the card type, but maybe one can capture or analyze the first 2 digits of the card #? This would give away what type of card it is. Just a thought.

mydanilo:

Capturing the credit card type might be tricky as the payment form is not asking the card type, but maybe one can capture or analyze the first 2 digits of the card #? This would give away what type of card it is. Just a thought.

Actually - it is much easier than that. It is already "solved" as part of verification prior to confirmation (note that the credit card type is shown on the confirmation screen). Problem is - carrying that value across to the other functions after the order is created. Like I said - it will get done, I'm just missing something about how the $order arrays are handled after processing. I'm pretty close... but without an Intuit "test" account - I don't run too many tests on the production gateway.

Success! I have 1.7a available with Credit Card Type captured and displayed in admin order page. I might just go ahead a post mini update, as this is pretty useful and I don't see any other bugs, issues etc. that need immediate attention. In any event - I can provide a download immediately for mydanilo if you like.

so, i had a huge mishap when moving my cart to a subdirectory, but ive fixed it and back on this one....i see lots of progress in the last few days nice work guys!

ok, so I've just kind of been assuming that everything works, because ive only used good CC #'s......

i misplaced 1 number on the same card and when i hit continue check out to move to step two...i get an error page that says IE cant read the page format???

when i use the correct cc # it goes through to the confirmation page!! Anyways, i need to get my cache fixed as the error logging isnt processing....still a left over fix from moving subdirectorys. I'll look deeper tomorrow...keep up the good work!

I use firefox at work, and it just gives me a blank page. IE said the page was not recognizable format....

Here is the URL that popped up in my browser

http s://securfocus.biz/products/index.php?main_page=checkout_payment&payment_error=qbms&error=The+credit+card+number+entered+is+invalid.+Please+check+the+number+and+try+again.&qbms_cc_owner=+&qbms_cc_expires_month=&qbms_cc_expires_year=

I put those asterisks in there, for month, year, and cc owner and i put the space between the http and s://.

once i get this error logging back up and running ill be able to give more details.

Securfocus - This part of the verification is a core class file which is called after user inputs cc data. If all is good, it displays the confirmation, if not, it displays the error. I tested this (in Firefox) and the red box comes up saying "invalid cc number". So something may still be amiss as a result of directory changes.

Ok, so I figured out my error logging, but this doesnt trip the mdDEBUG- unfortuntely, so i dont know where to start looking.

Can you point me in the spot to start looking, you said it was a core file...which one?

Thanks in advance.....again LOL!

Securfocus - the validation is a class in includes/classes (called cc_validation), but that is called from order.php which runs the payment modules which are active. If it were me, I would not be changing core files... it sounds more like config issues. But what do I know!

Mydanilo - see pvt msg. I now have final 1.7b and woud like to have you try it and verify. To me - it's just too cool!! But will await your feedback.