QuickBooks Merchant Service

30 Dec 2007, 17:32

#1

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

QuickBooks Merchant Service

I have ported the osc contribution for QuickBooks Merchant Service over to ZenCart.

It installs but it is UNTESTED with quick books services because I am still waiting on config settings from my client,

If anyone wants to test it and give me feedback it would be greatly appreciated

Thanks

Download: http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=852

31 Dec 2007, 21:49

#2

blainehilton

New Zenner

Join Date:: Sep 2004
Posts:: 16
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

This is excellent news!

I have tried this and so far ran into a couple of issues off the bat. First it does not ask what type of credit card I'm entering if it is a Visa or Mastercard or whatnot, but I'm wondering if it figures that out by itself?

The second issue is that the CVV2 help link goes to https://www.fiveaspects.com/catalog/cvd.php instead of the default javascript popup as in the default credit card module.

I am going to upload this now and see if I can get a test transaction to work and I'll keep you update.

--
Thanks very much
Blaine

01 Jan 2008, 02:12

#3

the_ancient

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Re: QuickBooks Merchant Service

blainehilton:
This is excellent news!

I have tried this and so far ran into a couple of issues off the bat. First it does not ask what type of credit card I'm entering if it is a Visa or Mastercard or whatnot, but I'm wondering if it figures that out by itself?

The second issue is that the CVV2 help link goes to https://www.fiveaspects.com/catalog/cvd.php instead of the default javascript popup as in the default credit card module.

I am going to upload this now and see if I can get a test transaction to work and I'll keep you update.

--
Thanks very much
Blaine

I will fix the CVV2 Link, I don't think QB needs the user to select the card type,

02 Jan 2008, 00:37

#4

seltron

New Zenner

Join Date:: Nov 2007
Posts:: 11
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

I actually built a QBMS module myself for ZenCart. Was planning to post it once i got some more bugs out and could confirm it worked.

As for the CCV2 QBMS doesn't actually need the CCV at all. (Until now, looking at the source, i see where it can take it :-)

The next thing I need to know is how to Batch the transaction to QuickBooks itself. QBMS doesn't do it automatically that i can find.

Any suggestions on how to batch/confirm the transaction?
Also, possible import into QB?

02 Jan 2008, 03:02

#5

blainehilton

New Zenner

Join Date:: Sep 2004
Posts:: 16
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

The issue I am currently trying to figure out is how to register the application with Quickbooks Merchant Services and issue a well formed CSR for the quickbooks client certificate. I already have a SSL server certificate installed and working, however I'm trying to register at http://appreg.intuit.com/ with no luck. The initial CSR gave me an error: ARSC262: common name not in hostname:applogin format., because it had an email address as part of the CN, so I generated a new CSR, but this one is giving me another error. But I tried again and it seemed to of worked, so I'm going to try to load them in and see what happens.

How have the two of you been able to get the module to work?

When registering at http://appreg.intuit.com/ what did you enter for the callback URLs?

--
Thanks in advance
Blaine

02 Jan 2008, 19:05

#6

blainehilton

New Zenner

Join Date:: Sep 2004
Posts:: 16
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

I keep getting the error message:

The credit card number starting with was not entered correctly, or we do not accept that kind of card. Please try again or use another credit card.

I'm wondering if it is because the config isn't all the way setup because I'm still a bit confused about the ticket item. However it does not indicate either way what the error is.

Has anyone got this to work?

03 Jan 2008, 02:47

#7

the_ancient

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Re: QuickBooks Merchant Service

Seltron:

Any suggestions on how to batch/confirm the transaction?
Also, possible import into QB?

Yes it is possible but it is not easy...

I have a few other projects I have to finish but I plan on writing a 2 way module to go from QB to Zen and from Zen to QB, but it will be awhile before I have anything to release.

If you want to write your own, look up the QB SDK, and look at the web connector package

03 Jan 2008, 02:56

#8

the_ancient

Zen Follower

Join Date:: Mar 2007
Posts:: 120
Plugin Contributions:: 1

Re: QuickBooks Merchant Service

blainehilton:
The issue I am currently trying to figure out is how to register the application with Quickbooks Merchant Services and issue a well formed CSR for the quickbooks client certificate. I already have a SSL server certificate installed and working, however I'm trying to register at http://appreg.intuit.com/ with no luck. The initial CSR gave me an error: ARSC262: common name not in hostname:applogin format., because it had an email address as part of the CN, so I generated a new CSR, but this one is giving me another error. But I tried again and it seemed to of worked, so I'm going to try to load them in and see what happens.

How have the two of you been able to get the module to work?

When registering at http://appreg.intuit.com/ what did you enter for the callback URLs?

--
Thanks in advance
Blaine

I am out of town on business so I have limited time the rest of this week and next, but I will try and look in to this,

or maybe Seltron will release one that is better,

I did not write most of it so I will have to go and anyalze the module and read the support thread for the OSC module (that this is based on) and see if there is a known fix, or fix it myself,

I will try to get back to you as soon as I can

03 Jan 2008, 15:05

#9

blainehilton

New Zenner

Join Date:: Sep 2004
Posts:: 16
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

I've been reading through the osC forum for the other mod for that platform at http://www.oscommerce.com/community/contributions,5383 and there appears to be a page called intuit.php that you put at the level above shop, but I believe it could be placed at the shop level too as that makes more sense, and perhaps the poster had the domain going straight to the shop. But this intuit.php is what you would use for the callback URLs, and it seems that the callback is how a connection ticket number is established.

However I can not get past the error that says the credit card number is invalid to see exactly where my next stopping point would be.

03 Jan 2008, 15:08

#10

blainehilton

New Zenner

Join Date:: Sep 2004
Posts:: 16
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

I thought I would add that I found a post at http://idnforums.intuit.com/messageview.aspx?catid=3&threadid=7743&STARTPAGE=1&FTVAR_FORUMVIEWTMP=Linear that talks about connecting to QBMS with PHP and they talk about how to make the intuit.pem file and how you need to go to https://login.ptc.quickbooks.com/j/qbn/sdkapp/confirm?appid=YOURAPPIDHERE&serviceid=1002&appdata=10001 to register the connection between your application and your QBMS merchant account.

Before doing that though you must have at least a developers account and you can sign up for one instantly and at no cost by going to
https:/merchantaccount.ptc.quickbooks.com/j/mas/signup?nonQBmerchant=true

04 Jan 2008, 01:01

#11

seltron

New Zenner

Join Date:: Nov 2007
Posts:: 11
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

blainehilton, Yes.

There are several steps to get QuickBooks Merchant Services to work (aka QBMS).

Note: QBMS is a separate system from QuickBooks itself.

Create AppId
Create Application Login
Create Connection Ticket

First registering as a Developer.
http://appreg.intuit.com/

Create "Add" a registered App.
This is where you create AppName.yourdomain.com
The Domain/AppName is not real, just what you want to call it.

If you are using SSL like this module set Application Type: hosted

Now you will have an AppId and Application Login.

Goto:
https://login.quickbooks.com/j/qbn/sdkapp/confirm?appid=YOURAPPID&serviceid=1002

Login with your QuickBooks account (in my case, my Client's QB account).

This will create a Connection Ticket.

The Connection Ticket is your connector for linking the QBMS to QB.
Why register your Application, I have no clue. It makes things much more difficult for developers.

That should get you working for some part.
My module used Desktop Mode instead of Hosted (web app).
So I don't know how to setup the SSL stuff.

Hope that helps :-)

04 Jan 2008, 01:03

#12

seltron

New Zenner

Join Date:: Nov 2007
Posts:: 11
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

the_ancient.

Stupid question, but i don't know.
In order for the QBMS transaction to be batched, it requires QB API? and not QBMS?

04 Jan 2008, 23:06

#13

blainehilton

New Zenner

Join Date:: Sep 2004
Posts:: 16
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

Seltron, thank you for your response. I have done all of that though, but I'm not sure what my connection ticket is. In the web site it says QBMS Connection is the name of the connection, but there is no ID number for it. I do have an application ID though.

I have done the SSL signing correctly I believe and created the intuit.pem file in a secure non web accessible location.

However I am still getting the error that the credit card number is not valid, not any other type of QBMS connection error, and that is why I am perplexed. I'm going to try over the weekend to go through the code and see where that error is generated and what the conditions are that cause it to be generated.

As far as your question about batching the data with quick books I would suggest you talk with Adam with http://www.qbisoftware.com/. His profile name here in this forum is adam5532 too. I was able to talk to him on the phone and he said that the QBI works with any payment module, but is not the module itself, so it can't process the payment with QBMS, but it will sync the data with the actual quickbooks software for you.

08 Jan 2008, 16:45

#14

seltron

New Zenner

Join Date:: Nov 2007
Posts:: 11
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

blainehilton,

Ok, now I feel silly in thinking you maybe ok all along.
First,
Did you get a connection ticket that starts off looking like this: TGT-XX-XXXXXXXXXXXXX ?

That's your connection ticket.
If you didn't, then you need to Goto:

https://login.quickbooks.com/j/qbn/s...confirm?appid=YOURAPPID&serviceid=1002
Login with your QuickBooks account (in my case, my Client's QB account).
This will create a Connection Ticket.

If you have done that, then here is the 'silly' part.
Are you using a test CC number? i.e. 41111111111111111
But you are running this against a real processor. So of course it's not a real number.
If you are in Test mode. Then you will also need a test App-Login and test Connection Ticket. You will need to manually switch out the ones in your shopping cart. This module doesn't give you the option to store both.

In order to get a test Application Login, it's the same method only you select IDNBeta (ptc) for Environment.
To get the test Connection Ticket goto:
https://login.ptc.quickbooks.com/j/qbn/sdkapp/confirm?appid=YOURAPPID&serviceid=1002

You'll notice the login.PTC.quickbooks.com as the difference. This is for their testing server.

Give that a go! Good Luck!

13 Jan 2008, 04:11

#15

mcfly

New Zenner

Join Date:: Jan 2008
Posts:: 1
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

I read through this entire thread, and it appears to be exactly what I am looking for, but I am not so sharp on the QB terminology.

What I would like to achieve is allowing my client to download his Zen-Cart orders (the db structure has not been modified) in QB 2008.

Is this a very extensive process for setting up, and what is the simplest most realistic way to make this happen?

I appreciate any tips.

Thank you,
Richie

14 Jan 2008, 19:14

#16

seltron

New Zenner

Join Date:: Nov 2007
Posts:: 11
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

Followups:

blainehilton - How are things with you?

the_ancient - Thanks for your help. QuickBooks Merchant Services batchs automatically. So you should be able to see it via QB once configured.

With further information, my customer now wants to utilize QuickBooks POS instead of QB and sync that with the cart. This requires something like T-HUB from Atandra. But it's 600 bucks and requires use of osCommerce instead of Zen-Cart. I could write the module but I'm trying to remind myself it will take to long.

----
Terminology:
QB - QuickBooks
The accounting program.
QB POS - QuickBooks POS (Point of Sale)
Software for the Point of Sale registers.

QBMS - QuickBooks Merchant Services
The interface to allow for Credit Card transactions to occur via QuickBooks Merchant Services for QuickBooks.

QB POS MS - QuickBooks POS with Merchant Services.
The interface to allow for Credit Card transactions to occur via QuickBooks POS Merchant Services for QuickBooks POS.

To sync sales information with QB you need to use QB SDK.
To process CC via QBMS you need to use the QBMS SDK.
To process CC and sales information for QB POS you need to use the QBPOS SDK.

They are all separate pieces.
Alright, not all of these are exactly right. But it should help.

McFly - I think you might be looking for something closer to Adam Liberman's " Quickbooks Import QBI" http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=144
He has is own website with newer versions on it.
This will sync orders with QB. But not with QB POS.

Good luck everyone! You'll probably need it...

14 Jan 2008, 20:03

#17

vwebworld

New Zenner

Join Date:: Mar 2005
Posts:: 72
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

I've been looking for a way to process CC thru QBMS...

I also found T-HUB, which looks like it may work and their site says it is compatible with ZenCart.

Anyone elso using T-HUB?

~Roland

15 Jan 2008, 19:35

#18

seltron

New Zenner

Join Date:: Nov 2007
Posts:: 11
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

This really isn't the thread to talk about T-HUB.

If you want QBMS connection, use this Add-on module that this form is about.

If you want QB POS interfacing use T-HUB
If you want QB importing use QBI

Read my last posting if you are confused on the differences.

15 Jan 2008, 20:37

#19

vwebworld

New Zenner

Join Date:: Mar 2005
Posts:: 72
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

Seltron:
This really isn't the thread to talk about T-HUB.

If you want QBMS connection, use this Add-on module that this form is about.

If you want QB POS interfacing use T-HUB
If you want QB importing use QBI

Read my last posting if you are confused on the differences.

Sorry. about the T-hub question.

So... the Add-on module is ready to use? I was holding off because of potential problems with it (in BETA).

~Roladnd

17 Jan 2008, 04:10

#20

aaronjworld

New Zenner

Join Date:: Jan 2008
Posts:: 1
Plugin Contributions:: 0

Re: QuickBooks Merchant Service

Hello, I have went through the process to get the "Application Login" and cannot find a way to get the "Connection Ticket". I have read many posts about how to get find it, but I just cannot figure it out...

Every site says to go here and fill in the blanks in the URL with my custom data:
https://login.quickbooks.com/j/qbn/sdkapp/confirm?appid=<myAppid>&serviceid=2004&appdata=<myAppData>

I found this located here:
http://developer.intuit.com/qbSDK-current/doc/html/QBSDK%20Programmers%20Guide/wwhelp/wwhimpl/common/html/wwhelp.htm?context=QBSDKProGuide&file=06_1_Accessing_QBO_Server.9.7.html

I do not know how to find "myAppData" parameter even though it gives instructions I am confused.

BESIDES THAT:

I went ahead and left the field blank for the connection ticket, and when I went through the process to test to see if I ordered an item what it will do. And I got this error message:

PHP Fatal error: Call to a member function on a non-object in C:\MyDomainName.com\includes\modules\payment\qbms.php on line 43

ANY SUGGESTIONS FOR ANY OF THIS WOULD REALLY BE APPRECIATED

THANK YOU FOR YOUR TIME!