Quickbooks Import QBI

M B Walker:

I'm having a problem with exporting orders to Quickbooks. Basically, all order information is exported properly EXCEPT that the detail of the actual items ordered is not included in the iif file. The items ordered do show up in emails generated by ZenCart, as well as in Admin/Customer/Orders -- they just don't come through in the QBI generated iif file.

The error is a Quickbooks Import Error ("transaction not in balance"). All customer data imports properly, just not the item information. I'm using QBI 3.21, ZenCart 1.3.8.

Thanks in advance for any suggestions.

i just had this same erorr, after using this mod forever with no problems. (although i did recently upgrade to 139e)

ok this is going to sound confusing, but for me, the problem was in the way the calculations were for an item i had on "special". (not sure if that is related) but something was happening with the calculations somewhere. the item was marked down 5% from 7.95 to 7.55. she bought 4 of them, and in the .iif file, it had the total as 30.2 - but she was charged 30.21 - and it was trying to import in quickbooks as 30.2 and that was causing the error because of it being .01 off. so i went into the.iff file and manually changed to 30.21 and then it imported fine. took awhile to figure that one out !

gorie:

i just had this same erorr, after using this mod forever with no problems. (although i did recently upgrade to 139e)

ok this is going to sound confusing, but for me, the problem was in the way the calculations were for an item i had on "special". (not sure if that is related) but something was happening with the calculations somewhere. the item was marked down 5% from 7.95 to 7.55. she bought 4 of them, and in the .iif file, it had the total as 30.2 - but she was charged 30.21 - and it was trying to import in quickbooks as 30.2 and that was causing the error because of it being .01 off. so i went into the.iff file and manually changed to 30.21 and then it imported fine. took awhile to figure that one out !
I'm not clear if your problem had to do with item descriptions, or just with rounding. The problem you describe with the discount amount is due to a bug in your discount module, not QBI. Your discount module is displaying a rounded price of 7.55, so 4 items should cost 30.20. It is, however, entering the unrounded price of 7.5525, which equals 30.21 for 4 items.

So, it is actually Zen Cart that has the wrong price. QBI calculates the 4 items itself, but uses the online store's calculation for the total price, hence the out-of-balance condition. The ultimate solution is to fix your discount module, so that the customer is charged the correct price when they check out.

Thanks,
Adam

adam5532:

I'm not clear if your problem had to do with item descriptions, or just with rounding. The problem you describe with the discount amount is due to a bug in your discount module, not QBI. Your discount module is displaying a rounded price of 7.55, so 4 items should cost 30.20. It is, however, entering the unrounded price of 7.5525, which equals 30.21 for 4 items.

So, it is actually Zen Cart that has the wrong price. QBI calculates the 4 items itself, but uses the online store's calculation for the total price, hence the out-of-balance condition. The ultimate solution is to fix your discount module, so that the customer is charged the correct price when they check out.

Thanks,
Adam

it definitely seems to be the pricing issue.
how do i do that? i think it is the one that came w/ the latest zencart upgrade, what is the file that does that so i can check?

oops - i meant it is the rounding issue, as a result of a "specials" discount percentage being applied.
not how the pricing is entered in the product description.

gorie:

oops - i meant it is the rounding issue, as a result of a "specials" discount percentage being applied.
not how the pricing is entered in the product description.

i actually just got this error again. this time due to how the tax was calculated and being .01 off again. i never had this error in the past. just since upgrading from 138 to 139e. i'm not sure of what other changes could have caused this.

gorie:

i actually just got this error again. this time due to how the tax was calculated and being .01 off again. i never had this error in the past. just since upgrading from 138 to 139e. i'm not sure of what other changes could have caused this.
Make sure that you are not using a Sales Tax Group in QB. There is a major bug in QB regarding Sales Tax Groups that they have never fixed. In QB, the individual taxes in the group get rounded to 2 placed before being added together, instead of after, as it should be. Therefore, in random cases the calculation in QB can be off by one cent. The solution is to use a Sales Tax Item, not a Group.

Also, there are some payment modules that have rounding errors. Due to the way computers handle floating point numbers, sometimes rounding can be done incorrectly. This is corrected using a PHP statement such as:
$order->info[’total’]+=0.000001;
You can calculate the amounts yourself to see if this is what happened. This issue is described further in section 14a of the QBI 3.21 User Manual.

Thanks,
Adam

gorie:

oops - i meant it is the rounding issue, as a result of a "specials" discount percentage being applied.
not how the pricing is entered in the product description.
You'd need to find the forum area that deals with problems in discount modules, unless someone else can help you here. I don't have time to help with issues that aren't with QBI. Sometimes QBI reveals calculation errors in other modules that would not have been noticed otherwise.

Thanks,
Adam

Just finished setting up everything, completed a test order and tried to import it. I got the unbalanced error message, looked at the .iif file and noticed the shipping charge was left out. What would cause this to happen?
Thanks

mikestaps:

Just finished setting up everything, completed a test order and tried to import it. I got the unbalanced error message, looked at the .iif file and noticed the shipping charge was left out. What would cause this to happen?
Thanks

Fixed it.... doh, somehow the shipping got turned off for the checkout process. :dontgetit

tj1:

Wow, thanks for taking the time to write that extra function, although I had already implemented that before my last post.

Thanks for the great support and great contribution. I've been able to find workarounds for some of the limitations by making very minor changes or commenting something out.
This has allowed me to import as estimates, which can then be used to create sales orders.
Also, attributes are now imported only as part of the product description, without creating endless subitems in Quickbooks.
If anyone needs this let me know and I'll post what I did.

Does anybody know how to do this? It would be very helpful for my setup.
TIA

mikestaps:

Does anybody know how to do this? It would be very helpful for my setup.
TIA
This (attributes handling) is a feature of the paid version of QBI.
Thanks -Adam
https://www.qbisoftware.com

Hello, I installed QBI about 2-3 months ago. I stopped using it and decided to start using it again. Although now I cannot export new orders, it just says quan: 0. The All Previous Exporter goes to 481 but there are many after that, and it ends at: Jul 1, 2010 7:41 am. I have tried reinstalling QBI according to the manual but it doesnt change any of the saved data on what has been exported and what hasn't. How do I export New Orders if the quantity is 0 and there is many new orders?

malarkey7:

How do I export New Orders if the quantity is 0 and there is many new orders?
New orders must meet two criteria:

1. Have never been downloaded before by QBI.
2. Status matches the Status you've selected on the QBI Configuration page for new orders.

If they are not showing as new orders, then one or both of the criteria above are not being met.

Thanks,
Adam

Got it to work, it was set to take "pending" orders when it should have been "processing". Thanks for the help its now working :D

I have another question for ya. I'm trying to make a small script that automatically downloads just the new orders. The script is in the admin folder. The problem I am having is that the script returns a blank file. Here is my script:

You can ignore my last post. I got it to work. :clap:

Does anybody know if it is possible to import the web order as an invoice so that the invoice # falls inline with your current numbering sequence? If so how?
thx

Hi,

mikestaps:

Does anybody know if it is possible to import the web order as an invoice so that the invoice # falls inline with your current numbering sequence? If so how?
thx

No, it is not possible with the iif import method. There is no way for QBI to know what the next Invoice number is, or if that number has been used "offline". This is a Quickbooks limitation. That's why QBI uses the PO number field. For Sales Orders, which is what you should be using if the customer has paid online, it will auto-number, but you still use the PO number field for the Zen Cart order number.

Thanks,
Adam

Hi! I'm new to the forum, but I have had my eye on Zen Cart since my sister-in-law has had tremendous success using it with her company. Starting out with Zen Cart, she now owns a 5k sqft store front.

I really need to know if there is a working Quickbooks module for the latest version of Zen Cart?

If so, where might I find it? Any and all help is greatly appreciated.

:bigups:

-Lee

newtozc32:

I really need to know if there is a working Quickbooks module for the latest version of Zen Cart?

If so, where might I find it? Any and all help is greatly appreciated.

:bigups:

-Lee
The existing free QBI 3.21 add-on should work fine with Zen Cart 1.39, although I have not tested it with PHP5.

The latest version of QBI, 3.85, is available for purchase at www. qbisoftware. com

Thanks,
Adam