Quickbooks Import QBI

Hi All,

I am starting this new thread as the official support thread for QBI. Previous discussion is at the old archived thread (which can no longer be added to due to the new bulletin board system), http://www.zen-cart.com/forum/showthread.php?t=6152

I am working hard to complete it! I will post an update within a few days.

Thanks,
Adam

Hey Adam,

I'm launching a store in the coming month. Is there anything that could be done now to the cart (configuring order numbers, etc) to improve interaction with QB and your upcoming QBI? Thanks in anticipation.

Hi,

I am using old version of QBI in zencart.

actucally i have generated an iif filw.

when importing iif into Quickbooks it is generating an error like below..

'you cannot associate an item with Sales Tax Payble, Undeposited Funds, accounts recivable, accounts payble or non-posting accounts. Usually if u sell the item, use an income account; if you buy it, use an expense account.'

Can u please suggest what is the cause for this error.

Thanks,
Rosie..

magicpants:

Hey Adam,

I'm launching a store in the coming month. Is there anything that could be done now to the cart (configuring order numbers, etc) to improve interaction with QB and your upcoming QBI? Thanks in anticipation.
No, there is nothing you need to change.

Thanks,
Adam

Rosie_Nick:

Hi,

I am using old version of QBI in zencart.

actucally i have generated an iif filw.

when importing iif into Quickbooks it is generating an error like below..

'you cannot associate an item with Sales Tax Payble, Undeposited Funds, accounts recivable, accounts payble or non-posting accounts. Usually if u sell the item, use an income account; if you buy it, use an expense account.'

Can u please suggest what is the cause for this error.

Thanks,
Rosie..
This is a port that someone else did of an early version of QBI, so it may have some issues and is unsupported. The first official release of QBI for ZenCart will be ready soon, and I will provice full support.

Thanks,
Adam

Hi Adam--

I'm using QB2002. Will your new import work that old of a version?

Thanks
Mellany
https://www.mellmaxknits.com

knitlady:

Hi Adam--

I'm using QB2002. Will your new import work that old of a version?

Thanks
Mellany
https://www.mellmaxknits.com
Yes, QBI will work with Quickbooks 2002. If you don't have the Pro version though, make sure that under the File menu you have a comand to Import iif files.

Thanks,
Adam

adam5532:

Yes, QBI will work with Quickbooks 2002. If you don't have the Pro version though, make sure that under the File menu you have a comand to Import iif files.

Thanks,
Adam

Adam--

It is the pro version, forgot to mention that. I'm sooo excited to hear that it will work. Wasn't looking forward to just making journal entries and having half my data in 2 different places.

Thanks so much for all your efforts in the upgrade.
:thumbsup:

Hi All,

I'm happy to say that the basic rewrite of QBI (Quickbooks Import) 3.0 is done! Now, I need to work out a few small issues, do the SQL table files, update the documentation, and work on ZenCart compatability. So, it really is getting close!

Thanks,
Adam

Great! Can't wait to start using it :)

I hope your contrib has a link to send one-time donations to help you keep supportin it, I like the way timkroeger Image Handler 2 has a link within his contrib to send one-time donations. I always try to get my customer to make a one off donations to both Zen-cart and any contribs that they find they can't live without.

mrmarcus66:

I hope your contrib has a link to send one-time donations to help you keep supportin it, I like the way timkroeger Image Handler 2 has a link within his contrib to send one-time donations. I always try to get my customer to make a one off donations to both Zen-cart and any contribs that they find they can't live without.
I appreciate the thought! I do have a link and a PayPal button on 2.10, but frankly there are a lot of people that talk about donating but don't come through -- it is of course up to the individual, but I suspect that a lot of people are benefiting and forget to give something back. I'm trying to decide before releasing 3.0 how to deal with that problem, without seeming heavy handed. Encouraging registration, offering store links and banners on the new QBI support site for those that contribute at certain levels, automatic registration and donation reminders (some people don't want to donate until they have used it for a while, and then they never do). Currently, I'm up to about 475 hours on the project!

Thanks,
Adam

Just to let you know Adam that I did donate a long time ago under a different name for your osc contrib.
I would definately NOT include something like Tim does (mentioned above) as it was the first thing I removed from his contribution and didnt exactly make me want to donate, especially as his screen shots differ from what you actually use.

Reesy:

Just to let you know Adam that I did donate a long time ago under a different name for your osc contrib.
I would definately NOT include something like Tim does (mentioned above) as it was the first thing I removed from his contribution and didnt exactly make me want to donate, especially as his screen shots differ from what you actually use.
I greatly appreciate that you donated, especially before the software was released! I just did a bunch of screen shots, and they will match exactly! However, it is very time consuming, so I can understand if he has gotten behind on updating them.

• Adam

adam5532:

Hi All,

I'm happy to say that the basic rewrite of QBI (Quickbooks Import) 3.0 is done! Now, I need to work out a few small issues, do the SQL table files, update the documentation, and work on ZenCart compatability. So, it really is getting close!

Thanks,
Adam

no adam, thank you...

will there be a payment module for quickbooksmerchantservice?

http://www.quickbooksmerchantservice.com/services/pricing.php

i think what you're doing is possibly one of the most important zc projects.

you're talking about millions of QB users out there possibly looking for a better solution than homestead, godaddy or the other QB ecom hosts that have no flexibility.

there's almost no mention of zc at http://www.quickbooksgroup.com/forums/

this should change, no?

neuzen:

no adam, thank you...

will there be a payment module for quickbooksmerchantservice?

http://www.quickbooksmerchantservice.com/services/pricing.php
I took a look at the GoDaddy QB integration. It looks far more limited than what QBI can do. You can't even import customer information with your orders -- they all import as one customer! From what I can tell from looking at the GoDaddy Quick Shopping Cart, the QB merchant service gateway is not integrated into the shopping cart. The integration just imports your receipts into QB, and then you have to charge each order using the merchant account features from within QB.

So, you'd have to get the API from Intuit, and I don't know if it even has the ability to communicate directly with a shopping cart. QBI will work with any payment module that you use with ZenCart, because the payment actually happens in the shopping cart, and QBI only needs to determine if the order has been paid for or not. Besides, iif files don't have fields for credit card numbers (a future release of QBI will be able to make XML files, which can hold that information and then you will be able to process credit cards within QB using their merchant service if you wish).

I think the best solution is to use Authorize.net with Zen-Cart and QBI. It is a real online gateway, which means that you don't have to spend any time charging cards or going back to customers if the charge is declined. And QBI imports all the billing and shipping contact information, as well as the customer's chosen shipping method and comments.

i think what you're doing is possibly one of the most important zc projects.

you're talking about millions of QB users out there possibly looking for a better solution than homestead, godaddy or the other QB ecom hosts that have no flexibility.
If those millions would only send me $1 each, I'd be happy!

I know everyone is anxiously awaiting QBI for ZenCart's release. I'm up now at 4am working on it! I'm currently testing it in ZenCart and making tweaks as needed (so far it is working nicely). And the documentation rewrite is partially done.

Thanks,
Adam

Actually the Quickbooks Merchant services payment gateway is Innovative Gateway Solutions and I believe there is a contrib for it for ZC. Do a search for the above in the forums. I hope I am not mistaken.

um, no zen :: https://www.innovativegateway.com/compatiblecarts.htm

probably has something to do with the fact that qbms doesnt use a gateway.

would be cool if qbms payment mod swam by.

The previous contributions were removed when the ZenCart contribution site was redone recently, so if it was there maybe it will come back. The Innovative Merchant Systems (which I believe was recently purchased by Intuit) website has almost no information, but does have a contact form, so I don't know if they make the API available. I'm not interested in working on that now, but if there is already a contribution or someone else writes one, it will work with QBI.

Thanks,
Adam

Old contributions:

http://www.zen-cart.com/archived_contributions