-
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?ma...roducts_id=852
-
Re: [BETA] 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
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
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,
-
Re: [BETA] 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?
-
Re: [BETA] 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
-
Re: [BETA] 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?
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
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
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
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
-
Re: [BETA] 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.
-
Re: [BETA] QuickBooks Merchant Service
I thought I would add that I found a post at http://idnforums.intuit.com/messagev...VIEWTMP=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/q...&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
-
Re: [BETA] 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/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.
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 :-)
-
Re: [BETA] 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?
-
Re: [BETA] 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.
-
Re: [BETA] 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/q...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!
-
Re: [BETA] 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
-
Re: [BETA] 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?ma...roducts_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...
-
Re: [BETA] 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
-
Re: [BETA] 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.
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
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
-
Re: [BETA] 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-cu...erver.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!
-
Re: [BETA] QuickBooks Merchant Service
I haven't been able to get a connection ticket. I've registered the application though no problem. From reading through the forums at osCommerce it seems like I need a file called intuit.php that will connect with QBMS and get the connection ticket.
I'm pretty good with this type of stuff, but I'm just not seeing this here. I appreciate all of your help tough, I'm just becoming ever more frustrated and confused by the whole thing.
Were you able to get a connection ticket?
-
Re: [BETA] QuickBooks Merchant Service
What are the appropriate https: call backs?
On the osCommerce forum is says use yourdomain.com/intuit.php
IS that what to use? or a different /xxxxxxxx.php (like qbms.php)?
Thats, Roland
-
Re: [BETA] QuickBooks Merchant Service
Sorry for the Extended dealy guys, I have 5 web projects I am trying to get done and this QBMS module kinda got pushed to the back burner,
However have had a chance to work on it, I will be packing up a ver 1.5 that will be fully working and tested, as well as have better documentation as to how to get everything set up.
I need to run a few more tests but so far everything is coming out perfectly, I should be able to release it by the end of business tomorrow (5pm EST)
I will then start working ver 2 because there are some features that are SERIOUSLY lacking in this that I need to put in for my client, that ver should be out by the end of next week,
so bear with me, but you will have a working QBMS module soon:yes::clap:
-
Re: [BETA] QuickBooks Merchant Service
That's great news!
Thanks, Roland
-
1 Attachment(s)
Re: [BETA] QuickBooks Merchant Service
ok here is 1.5, PDF included walks you through the set up process
Please report all bugs and feature requests
-
Re: [BETA] QuickBooks Merchant Service
Thank you.
One question... if I set this up as a desktop (as you show) will this integrate with an online ZneCart store?
~Roland
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
vwebworld
Thank you.
One question... if I set this up as a desktop (as you show) will this integrate with an online ZneCart store?
~Roland
"Destktop" and "hosted" names are just names, "Desktop" secrutiy mode will work in all applications
-
Re: [BETA] QuickBooks Merchant Service
Thanks, I hope to have it up and running this weekend.
~Roland
-
Re: [BETA] QuickBooks Merchant Service
Visa Note:
I just went through a trouble shooting period where a cart that has my QB module installed could not process visa cards, apparently this is a re-occuring problems across all carts that process via QBMS, apparently somehow when the QBMS turns on your ability to process via the web, sometimes that also turn off the Visa Flags which will prohibit you from processing visa transactions,
So if possible it is recommended you live test your cart with a visa card, if you get a error call QBMS help line and make sure your visa flags are turned on.
-
Re: [BETA] QuickBooks Merchant Service
Okay I have downloaded the 1.5 zip and walked through everything. I was able to get a connection ticket now that I'm using the desktop model no problem.
However the admin page in zencart does not look right. I do not have the question for Hosted or Desktop, there are 2 text boxes that do not have any display text by them.
I'm a bit confused as to the actual source files in the folder. In the documentation it says to copy the folder includes into your catalog folder, so I assume that means into the root level shop folder, and not the admin folder. However it seems like you need it in the admin area as well.
I feel that I'm so close, what am I missing?
Thanks for your help thus far though.
-
Re: [BETA] QuickBooks Merchant Service
I have a question before I attempt to mess with this. Will this module update the inventory count in Zen with that in the QBMS system as well?
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
blainehilton
Okay I have downloaded the 1.5 zip and walked through everything. I was able to get a connection ticket now that I'm using the desktop model no problem.
However the admin page in zencart does not look right. I do not have the question for Hosted or Desktop, there are 2 text boxes that do not have any display text by them.
I'm a bit confused as to the actual source files in the folder. In the documentation it says to copy the folder includes into your catalog folder, so I assume that means into the root level shop folder, and not the admin folder. However it seems like you need it in the admin area as well.
I feel that I'm so close, what am I missing?
Thanks for your help thus far though.
Did you uninstall the v1 module before uploading the v1.5?
If you did not, Write down all of your Settings, Uninstall qmbs (via the uninstall button in the admin panel) and then Reinstall it (via the install button in the admin panel)
Let me know if this works
Thanks
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
S3v3n
I have a question before I attempt to mess with this. Will this module update the inventory count in Zen with that in the QBMS system as well?
QBMS has no inventory, Quick book Merchant Service (QBMS) is merely a Credit Card processing Gateway. Like Paypal or Authorize.net or countless others
Quick Books carries the inventory, and no it does not do any sync with Quick Books, I am planing a Separate Quick Books Integration in the future but I have not even started on it yet
-
Re: [BETA] QuickBooks Merchant Service
Thanks, I think that did it! It all looks good now.
I'm doing the testing in the ptc environment with one of the free QBMS accounts. Is there a way to login to there and see if they received it properly, or do I just need to make a new application logon, number, and connection ticket using my client's existing account and try a transaction that way?
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
blainehilton
Thanks, I think that did it! It all looks good now.
I'm doing the testing in the ptc environment with one of the free QBMS accounts. Is there a way to login to there and see if they received it properly, or do I just need to make a new application logon, number, and connection ticket using my client's existing account and try a transaction that way?
This is my Biggest Complaint with Quick Books MS, I have not been able to detrime if they have a web based adimn section to see all of the orders recieved, My Client is suppose to be calling to find out but I have not heard back from them,
Right now I made some Modifications to the code that outputs the Authorization code and Transaction ID in to the "cc_owner" and "cc_number" fields of the order database, to allow for back end tracking, these were not put in the 1.5 release because they are "hacked" in right now.
The module only records the orders after getting a "OK" response back from QBMS so that is how you know they received it ok, if it does not get a response back or "Not OK" response it out puts an error message (there are 2 in the lang file, one for system and one for declined)
The Hardest thing right now is the reconciliation between Quick Books and the web site, which I plan on solving at some point but it will be awhile.
-
Re: [BETA] QuickBooks Merchant Service
I installed the module. When I go to the ADMIN Payment module page I get this ERROR:
Fatal error: Class qbms: Cannot inherit from undefined class base in /home/*****/public_html/shop/includes/modules/payment/qbms.php on line 12
-
Re: [BETA] QuickBooks Merchant Service
I installed the module and tested it using the Quickbooks MS test server. Ran test transactions and that seemed to go OK.
When I transferred everything over to the production server with a production server connection ticket, etc. the credit card order seemed to go through according to the checkout pages. However, there was no sign of the transaction in the Manage Merchant Service pages form Quickbooks, or by going directly to the web URL for the QBMS account. Where do I go from here?
Clive. :frusty:
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
blainehilton
I thought I would add that I found a post at
http://idnforums.intuit.com/messagev...VIEWTMP=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/q...&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
There will be none, QBMS does not record Transactions to be viable like that, this is a major issues I have with quick books merchant services
it is not like other Gateways... QBMS is made for use INSIDE quickbooks, doing anything outside of quickbooks make it a pain in the ######...
You have to use the QB SDK to create a sales reciept it you want to record the transaction...
Your Transactions are being processed, you will see the money deposited in 2-4 days
-
Re: [BETA] QuickBooks Merchant Service
It seems that the charge is authorized and captured as soon as the customer places the order with this module. Is there any chance that this could be modified to authorize only on placing the order and then captured on shipping?
I was looking at the thread for the original OSCommerce version to see if this was in the latest version (which I think was released after the port to Zen Cart) to see if its been added there, but documentation is sparse.
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
Stamper
It seems that the charge is authorized and captured as soon as the customer places the order with this module. Is there any chance that this could be modified to authorize only on placing the order and then captured on shipping?
I was looking at the thread for the original OSCommerce version to see if this was in the latest version (which I think was released after the port to Zen Cart) to see if its been added there, but documentation is sparse.
yes it could be modified, but would require not only editing the Module but the admin side
neither OSC nor Zen Cart is step for AUTH transactions, almost every module is set to Capture for this reason...
-
Re: [BETA] QuickBooks Merchant Service
the_ancient:
Thanks for your contribution.
I just want to add that I have got the Quickbooks Merchant Service module working and have successfully charged and received funds. Its not entirely clear when browsing the threads as a prospective user that the module actually works in the real world, so here is my confirmation that it does! :clap:
-
Re: [BETA] QuickBooks Merchant Service
I am working on Version 2 of this module, It has more or less be completely rewritten by me,
It will however require PHP5 because I am making use of the SimpleXML class that comes with PHP5...
Some of the Enchantments will be Full Transactional Logging, This will allow for full integration with Quickbooks, and allow users to see all failed transactions, and possible add refund capability's
Anyway I am looking for Feedback on the Quickbooks Web Connector project...
http://www.zen-cart.com/forum/showthread.php?t=94974
-
Re: [BETA] QuickBooks Merchant Service
I installed the mod and get an error during page 3 of checkout...
"An error has occurred within our system while trying to process your credit card. Please try this transaction again. If the problem persists, please email "
Are there any settings within merchant services that are not covered in the install instructions?
Any clues what is causing the error?
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
gonewild
I installed the mod and get an error during page 3 of checkout...
"An error has occurred within our system while trying to process your credit card. Please try this transaction again. If the problem persists, please email "
Are there any settings within merchant services that are not covered in the install instructions?
Any clues what is causing the error?
that is telling you
1> Curl was unable to connect to the QBMS Server
2> QMBS Refused to authenticate you,
a> you entered the wrong Ticket Number or the Wrong App Id, or the wrong app user, or the app was not mapped to themerchant account
Are you using the hosted or Desktop security model?
Are you tring a Live or Demo Account. and did you select the proper setting in the module for live or demo...
-
Re: [BETA] QuickBooks Merchant Service
I loaded the two files into my catalog, but under admin->modules->payment, it's not showing up. Is there anything else I have to do?
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
dejavu
I loaded the two files into my catalog, but under admin->modules->payment, it's not showing up. Is there anything else I have to do?
Did you copy the files to the same dir's as they are in the zip?
-
Re: [BETA] QuickBooks Merchant Service
I downloaded this app.
When I go onto the payment page and the QBMS module loads, I get a syntax error } expected on line 293.
Has anyone else had this problem?
-
Re: [BETA] QuickBooks Merchant Service
The function javascript_validation() needed another "}" in modules/qbms.php. This makes me uncomfortable. I hope this app. works.
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
gonewild
I installed the mod and get an error during page 3 of checkout...
"An error has occurred within our system while trying to process your credit card. Please try this transaction again. If the problem persists, please email "
Are there any settings within merchant services that are not covered in the install instructions?
Any clues what is causing the error?
I am having identical problem. Any further information on this error?
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
hwy419
I am having identical problem. Any further information on this error?
It is not a error in the Module,
As I stated before this error means
1> Curl was unable to connect to the QBMS Server
2> QMBS Refused to authenticate you,
a> you entered the wrong Ticket Number or the Wrong App Id, or the wrong app user, or the app was not mapped to themerchant account
Are you using the hosted or Desktop security model?
Are you tring a Live or Demo Account. and did you select the proper setting in the module for live or demo...
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
dejavu
I downloaded this app.
When I go onto the payment page and the QBMS module loads, I get a syntax error } expected on line 293.
Has anyone else had this problem?
Yes Dejavu!
I didn't get the error in my install, but looking at the qbms.php file I see its missing too. I checked the version for OSCommerce from which this was ported and see that it was carried over from there. The latest revision of the qbms.php for OSCommerce corrects this.
Old code was
Code:
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";
The correct version should be:
Code:
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";
Clive.
-
Re: [BETA] QuickBooks Merchant Service
Also folks,
I'm using a godaddy hosted account. I haven't tested the curl section out, but I think the modifications go something like this:
Code:
$clientURL = curl_init();
curl_setopt($clientURL, CURLOPT_POST, 1);
curl_setopt($clientURL, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($clientURL, CURLOPT_CUSTOMREQUEST, 'POST');
curl_setopt($clientURL, CURLOPT_URL, $qbmsURL);
curl_setopt($clientURL, CURLOPT_TIMEOUT, 60);
curl_setopt($clientURL, CURLOPT_HTTPHEADER, $PHP_Header);
curl_setopt($clientURL, CURLOPT_POSTFIELDS, $qbmsRequest);
curl_setopt($clientURL, CURLOPT_VERBOSE, 1);
curl_setopt($clientURL, CURLOPT_SSL_VERIFYPEER, 1);
// if (MODULE_PAYMENT_QBMS_HOSTEDORDESKTOP == 'Hosted') {
// curl_setopt($clientURL, CURLOPT_SSLCERT, $qbmsCert);
// }
curl_setopt($clientURL, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']); //??
curl_setopt ($clientURL, CURLOPT_PROXYTYPE, CURLPROXY_HTTP);
curl_setopt ($clientURL, CURLOPT_PROXY,"http://proxy.shr.secureserver.net:3128");
// if (MODULE_PAYMENT_QBMS_IP_ADDRESS != '') {
// curl_setopt($clientURL, CURLOPT_INTERFACE, MODULE_PAYMENT_QBMS_IP_ADDRESS);
// }
Notice I added the proxy stuff.
I hope it works. They don't have an emoticon for crossing your fingers.
$qbmsResponse = curl_exec($clientURL);
-
Re: [BETA] QuickBooks Merchant Service
I'm getting no errors. I get the success page and an order number.
However, there have been no charges to my credit card and no transactions posted to the merchant account.
I'm not sure why it's all seems to go smoothly, yet nothing is happening.
-
Re: [BETA] QuickBooks Merchant Service
My appid and login were wrong. I was using the merchant account login, not the app login.
Transactions posting well to merchant's accounts!
Thank you.
It took me a while to figure out you can use desktop security on a hosted account. Those terminologies are confusing.
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
dejavu
My appid and login were wrong. I was using the merchant account login, not the app login.
Transactions posting well to merchant's accounts!
Thank you.
It took me a while to figure out you can use desktop security on a hosted account. Those terminologies are confusing.
If you do anything in Inuit you will learn everything they do is confusing and ###### backwards...
Personally I hate QBMS, and my client is wanting to Redo their site soon, and I am tring very very very hard to get them to drop QBMS like a bad habit and move to a REAL gate way like Authorize.net
-
Re: [BETA] QuickBooks Merchant Service
Just wanted to throw this out there:
In my experience, IF AT ALL POSSIBLE, use the "Desktop" version of the Quickbooks Merchant Service module instead of the "Hosted" version. The Desktop version is far easier to install and get set up. Just make sure you're on an SSL connection, and your transactions will be just as secure as if you're using any other credit card processor.
-
Re: [BETA] QuickBooks Merchant Service
Also, but in validate: Add quotes:
Code:
if ("' . MODULE_PAYMENT_QBMS_VERIFY_WITH_CVV2 . '" == "True") {' . "\n" .
-
Re: [BETA] QuickBooks Merchant Service
Is this module similar to the T-Hub software for Quickbooks?
http://www.atandra.com/Prod_THub.htm
-
Re: [BETA] QuickBooks Merchant Service
This one worked fine with a few adjustments.
By the way author of QuickBooks Merchant Service, do you have a donation location?
I won't make a donation yet, but I'll put you on my list.
-
Re: [BETA] QuickBooks Merchant Service
Hello, I have a customer that already has an appID and App Login. can I use their information to get a connection ticket?
-
Re: [BETA] QuickBooks Merchant Service
Did they register the app with the merchant account? If you have the id that is generated with the desktop version when you register the app with the account, then you should be good to go.
-
Re: [BETA] QuickBooks Merchant Service
they registered as hosted. I do not have access to their QB login. I tried to use their info at the link given here...
https://login.quickbooks.com/j/qbn/s...serviceid=1002
Can I send this link to my customer and have him get the connection ticket?
-
Re: [BETA] QuickBooks Merchant Service
Looking back at the threads, my client may have the merchant info in the QBMS module and not the app info. If I go back and create the app portion will it still point to their acct in QB?
-
Re: [BETA] QuickBooks Merchant Service
I found the desktop model easier to implement. When you set up the app, it will not point at their account, until they go to the link specifying the app id, they log in and create the connection ticket. An id will only be generated with the desktop model.
-
Re: [BETA] QuickBooks Merchant Service
If you have the client do it with the desktop model, I don't know a way to get the id, if they do not cut and paste it immediately. If they don't cut and paste it, right away and click the button, I'm pretty sure it's gone.
-
Re: [BETA] QuickBooks Merchant Service
I have set up a PTC acount
I have a problem in test mode. I am getting the error message credit card starting with error. I have all setup in the admin panel with the connection ticket, and I am trying this in a beta environment. One thing I notice is that the application status shows gateway error. I read back on a previous page about getting a test account from QBMS. How do I go about getting this?
Also I signed up my company today for a production merchant account but now I am wondering if I signed up for the correct one. They referred to the choices as a web store or pc based. I took the pc based because the web based looked to be the one that their approved and recommended providers use of course they wanted me to switch over . I said I would use my zencart with the developed module. that was not a problem and they gave me three free months and no setup fee.
Thanks for any help.
RJ
-
Re: [BETA] QuickBooks Merchant Service
I now have setup as production live. I have received the connection ticket and every thing is in place in the admin.
I am still getting "The credit card number starting with 4607 was not entered correctly, or we do not accept that kind of card. Please try again or use another credit card."
What have I done wrong?
thank again RJ :frusty:
-
Re: [BETA] QuickBooks Merchant Service
I went back through this thread another time and see where it could be the visa flags. I called and they are turned on.
RJ
-
Re: [BETA] QuickBooks Merchant Service
I feel like a real idiot I did not have the credit card configured in the admin. I have been using Paypal and this was never an issue.
The cart shows successful transaction but when checking with QBMS it did not show a transaction. I was told that I had the wrong merchant service solution. I need their web store service. They switched it over.
Is this the problem?
Help!! :frusty:
RJ
-
Re: [BETA] QuickBooks Merchant Service
Is there anyone able to help me on this?
I show a successful transaction using a valid CC. I have talked to merchant services and have opened QBMS transaction display. Nothing is being recorded. Where are these transactions going?
How does this tie into the account that I have setup at QBMS?
What in the#@##@ I'm I missing here? :censored:
If I don't get any help I guess I will go back to using Paypal only.
Thanks
RJ
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
rjspomer
Is there anyone able to help me on this?
I show a successful transaction using a valid CC. I have talked to merchant services and have opened QBMS transaction display. Nothing is being recorded. Where are these transactions going?
How does this tie into the account that I have setup at QBMS?
Go into Quickbooks, from the mennu select "Customers", "Credit Card Processing Activities", "Manage Merchant Service".
What do you see?
-
Re: [BETA] QuickBooks Merchant Service
No transactions reported. The QBMS tech says there is not a connection between my website and the MS.
-
Re: [BETA] QuickBooks Merchant Service
Something just doesn't seem right.
I went through the steps in the readme text without a hitch, other than forgetting to turn on the credit cards in config.
I called QBMS and opened an account, but here is my question how do you tie the connection ticket to my new opened account?
I think this must be where I went wrong.
-
Re: [BETA] QuickBooks Merchant Service
This does not work and I am done with it.
I have generated conection tickets setup production went live. I get a succesufful page but Quickbooks still doesnot have a recorded transaction. I talked to their Level two support who clims that it wasnot setup as eccomerce. He changed it over but stil does not work.
As you can see from my post above there has not been any support or interest in this.
DO NOT TRY THIS UNLESS YOU HAVE NOTHING ELSE TO DO!!!
:censored:
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
rjspomer
As you can see from my post above there has not been any support or interest in this.
DO NOT TRY THIS UNLESS YOU HAVE NOTHING ELSE TO DO!!!
:censored:
Wait a minute. I just tried to help you.
I gave you a very specific question, but the answer you gave shows you did not follow what I asked. It would help if you cooled down and really tried to focus on the help that is being offered.
I don't have any stake in this mod, other than using it myself. It works for me. Yes, its very complex to set up, but it does work if all the steps are carefully followed. I'm willing to try to help, but I need some help from your end too!!
-
Re: [BETA] QuickBooks Merchant Service
Hello, Sorry for my absence I am working on a very big project that is taking all of my time..
Let gets some things out however
This is not a commerical Module, it comes with ZERO support, I will help other when I can but I am not "required" to do so, so emails demanded such help will be ignored. I devedloped this module based on one from OSC, an corrected some bugs, I did so because my employer needed QBMS support for a project we have going..
Quick Book Merchant Services have been and continue to be a pain in my ######, and I will never recommend them to ANYONE, infact my company is moving to authorize.net in the near future.
With that let me solve this problem
QBMS and QB do not communicate with each other, the ONLY transactions record directly in QB are the ones processed INSIDE of QB, any transactions processed by the shopping cart module WILL NOT appear in QB by default, blame QBMS for this, not me..
You can use the qbSDK and develop your own web connector interface to record the transactions, I was working on one but development has been suspended because of this new project.
If you get a success message using the live server the transaction should have been processed and the money will appear in your bank account 2-5 days after the transaction, I am bet it will in this case as well..
I have found the QBMS support people to be worthless and inept.
-
Re: [BETA] QuickBooks Merchant Service
Hello Stamper,
I should of thank you for your reply. You asked:
"Go into Quickbooks, from the mennu select "Customers", "Credit Card Processing Activities", "Manage Merchant Service".
What do you see?
My answer "No transactions reported"
As far as this Module even if it did somehow work I would dump it. QBMS help is miserable. Their profit and motivation is to get you to one of their web providers.
It' has been a learning experience.
RJ
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
rjspomer
"Go into Quickbooks, from the mennu select "Customers", "Credit Card Processing Activities", "Manage Merchant Service".
What do you see?
My answer "No transactions reported"
I wasn't asking about the transactions window. If you click on the "Manage merchant account" link when in the Quickbooks Merchant Services window it should give a page allowing you to edit processing information with radio buttons showing the status of your account features.
Anyhow - do you still want help or not?
-
Re: [BETA] QuickBooks Merchant Service
Stamper
I'm sorry I miss understood you.
Both of the radio buttons are on I did this the other day when I went into check to see the transactions.
Thanks for your Help
RJ
-
Re: [BETA] QuickBooks Merchant Service
In Admin under Payment Modules, I would make sure you have the :Credit Card - Offline Processing" and "The Zen Cart FREE CHARGE CARD" modules set to off so you don't inadvertantly use one by mistake. Ensure the "Pay by Credit Card" (qbms) module is green.
Do you have a valid SSL certificate set up on your server?
Double-check that you have really entered the App ID, Connection Ticket and Application Login that you used or were provided when you set yourself up for the PRODUCTION SERVER and not the test server at QBMS.
You have Desktop mode set and Testing set to false - right?
Clive.
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
the_ancient
QBMS and QB do not communicate with each other, the ONLY transactions record directly in QB are the ones processed INSIDE of QB, any transactions processed by the shopping cart module WILL NOT appear in QB by default, blame QBMS for this, not me..
Hi the_ancient:
Right, credit card transactions will not show within Quickbooks itself as if they were run through the program. However, they still show when you search for transactions through "Manage Merchant Service". That's just a HTTPS browser window that Quickbooks calls to the https://merchantcenter.intuit.com/ portal. My transactions from Zen show up there.
I think that's what he means about not showing up.
Clive.
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
Stamper
In Admin under Payment Modules, I would make sure you have the :Credit Card - Offline Processing" and "The Zen Cart FREE CHARGE CARD" modules set to off so you don't inadvertantly use one by mistake. Ensure the "Pay by Credit Card" (qbms) module is green.
Do you have a valid SSL certificate set up on your server?
Double-check that you have really entered the App ID, Connection Ticket and Application Login that you used or were provided when you set yourself up for the PRODUCTION SERVER and not the test server at QBMS.
You have Desktop mode set and Testing set to false - right?
Clive.
I have double checked all the settings and I do have a SSL certificate. What baffels me is I get the successful purchase page so it must be connecting somewhere.
Clive I thank you for all your time but I'm calling QBMS and cancelling my account. The Ancient had it right.
Thanks again
RJ
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
the_ancient
Hello, Sorry for my absence I am working on a very big project that is taking all of my time..
Let gets some things out however
This is not a commerical Module, it comes with ZERO support, I will help other when I can but I am not "required" to do so, so emails demanded such help will be ignored. I devedloped this module based on one from OSC, an corrected some bugs, I did so because my employer needed QBMS support for a project we have going..
Quick Book Merchant Services have been and continue to be a pain in my ######, and I will never recommend them to ANYONE, in fact my company is moving to authorize.net in the near future.
With that let me solve this problem
QBMS and QB do not communicate with each other, the ONLY transactions record directly in QB are the ones processed INSIDE of QB, any transactions processed by the shopping cart module WILL NOT appear in QB by default, blame QBMS for this, not me..
You can use the qbSDK and develop your own web connector interface to record the transactions, I was working on one but development has been suspended because of this new project.
If you get a success message using the live server the transaction should have been processed and the money will appear in your bank account 2-5 days after the transaction, I am bet it will in this case as well..
I have found the QBMS support people to be worthless and inept.
I have to respond to this reply.
First of all I did not email you demanding help. Since you were the ONE that started this thread with your contribution to the download I thought I could PM you and ask for some help. It looked like you had offered help to others.
It is very clear now that others should not expect any help from the contributer of this module and that could have been posted at the point you decided not to help.
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
rjspomer
I have to respond to this reply.
First of all I did not email you demanding help. Since you were the ONE that started this thread with your contribution to the download I thought I could PM you and ask for some help. It looked like you had offered help to others.
It is very clear now that others should not expect any help from the contributer of this module and that could have been posted at the point you decided not to help.
never said you did, your not the only person with access to the email form....
my post was not directed at you, personally, sorry if you took it that way...
I am happy to help, but the problem IMO is not with the module, as it has been installed a number of time with no problem, personally I think it is related to a configuration problem on QBMS's end which I cant help with,
if I had to guess, the connection ticket is not associated properly to your merchant account...
ohh, and every caught me on a bad time anyway. I have far too much work, and no time, Yesterday I was in airports or airplanes for 12+ hrs, and today was more of the same, so I have kind of a short fuse I guess..
Sorry if I offended anyone....
-
Re: [BETA] QuickBooks Merchant Service
The PDF that is distributed with this module is outdated and doesn't show how to get an app ID, has anyone successfully used this with QBMS and gotten it to work? If so, is there a relatively simple way to do it?
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
volarete
The PDF that is distributed with this module is outdated and doesn't show how to get an app ID, has anyone successfully used this with QBMS and gotten it to work? If so, is there a relatively simple way to do it?
I set up this module and have it working successfully. There is no simple way to do it. You have to double-check every detail - its pretty complex. I found it helpful to go to the QBMS tech forum and do some reading there to supplement the instructions.
http://idnforums.intuit.com/categori...lcache=2461853
-
Re: [BETA] QuickBooks Merchant Service
I'm trying to setup my app at intuit as a "hosted" server and it wants URLs for subscribe, change, cancel, login and marketing. I think I've got the login URL correct: http://appreg.intuit.com/AppReg.aspx but that's it... Anyone know how to do the rest?
-
Re: [BETA] QuickBooks Merchant Service
Belay that, the actual login URL (I think) is http://volaretees.com/cart/index.php?main_page=login, not http://appreg.intuit.com/AppReg.aspx...
Still, the question remains, how to create the other URLS (see the post above).
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
volarete
I'm trying to setup my app at intuit as a "hosted" server and it wants URLs for subscribe, change, cancel, login and marketing. I think I've got the login URL correct:
http://appreg.intuit.com/AppReg.aspx but that's it... Anyone know how to do the rest?
Why are you using the "Hosted" mode rather than "Desktop". The Ancient's instructions stress that "Desktop" is much simpler?
-
Re: [BETA] QuickBooks Merchant Service
Ok, using desktop mode, the PDF says once you've got an appID you go to https://merchantaccount.ptc.quickboo...Bmerchant=true and follow the prompts... Only problem is, it says, "page not found." So... I'm stuck.
-
Re: [BETA] QuickBooks Merchant Service
and when I try to go to "
https://login.quickbooks.com/j/qbn/s...confirm?appid=YOURAPPID&serviceid=1002" (and yes, I put my appID where YOUAPPID is) a page comes up saying "Unknown page /j/qbn/s...confirm" ... ?
-
Re: [BETA] QuickBooks Merchant Service
-
Re: [BETA] QuickBooks Merchant Service
Will this work with 1.3.8??
-
Re: [BETA] QuickBooks Merchant Service
Neve mind. I got it working.
Looks to me like I'll need a security certificate.
-
Re: [BETA] QuickBooks Merchant Service
One more question, honestly. Is the credit card being entered on QBMS's site or on my page?
I purchased a dedicated IP address and SSL cert. How do I apply the "https" to my cart?
-
Re: [BETA] QuickBooks Merchant Service
Quote:
Originally Posted by
Schanz
One more question, honestly. Is the credit card being entered on QBMS's site or on my page?
I purchased a dedicated IP address and SSL cert. How do I apply the "https" to my cart?
The credit card information is entered through pages on your Zen-cart then the QBMS module transfers the data to Merchant Services for processing.
For secure access with SSL see this thread:
http://www.zen-cart.com/forum/showth...sl+certificate
Make certain you have installed your certificate properly first.
Clive.
-
Re: [BETA] QuickBooks Merchant Service
Thank you. I did some more digging and found some tutorials. I got a dedicated IP and cert and I now have the pages protected. Almost ready to rock n roll.
-
Re: [BETA] QuickBooks Merchant Service
I've been on the phone with quickbooks my hosting company, paypal and a slew of others all day, and i'm probably more confused than ever. Ok i have my website with hostmonster which uses zen-cart as one of their shopping cart applets I'm currently adding a shopping cart to the site via someone else i'm not smart enough to code that. But i'd like to process my credit cards via quickbooks merchant services, is there a way to do that using zen-cart without having to use a gateway that sends it to them and makes money in the middle? or does anyone know of another shopping cart applet that will send directly to quickbooks merchant services? any help on the best way for all this to work together is greatly appreciated
-
Re: [BETA] QuickBooks Merchant Service
Follow the instructions with this module step by step. I didn't have too much trouble and i'm not a programmer. I use Quickbooks pro on my desktop and process CC transactions through it so I used the desktop installation as recommended. I didn't think it was that hard. You will need an SSL certificate to protect your site since customers will be keying their CC into your cart. I had more trouble with that than the payment module.
-
Re: [BETA] QuickBooks Merchant Service
so are people using this with quickbooks merchant services without flaws? or is it still too buggy to use? if so can anyone recomend a good shopping cart that will work with quickbooks merchant services?