Quickbooks Import QBI

[adam5532]

Danny,

The problem is: When I download new orders to Quick Books using the "QuickBooks Import QBI", the wrong transaction date is showing.

For Example, The actual date should be 03/01/2012 but the Invoice date that QBI reports is 12/03/2001.

QBI simply reads the date from your database. The problem is elsewhere -- check that your server time is set correctly, and that the invoice date in Zen Cart is correct.

Adam

[danielosko]

Thank You for your response.

However, the Server time is correct and the Zen Cart order date is correct. It seems to be the date format in one of the SQL files.

(they are the correct numerical values, but in the wrong place setting). Any further thoughts on how to change the Date format in what SQL file?

Thanks,
Danny

[caroldaley]

No. QB on Mac does have an iif file import feature, but when it doesn't like something in the file, it just crashes. So, don't waste your time trying. The file import capability on PC versions is much more reliable and robust.

Adam

I can not say how well it will work with QuickBooks Mac 2012, but I am able to use this plugin and import IIF using Quickbooks for Mac 2010 without issue.

[danielosko]

Hello,

Is there any way to use QBI with ZenCart ver 1.5.0.?

Thanks,
Dan Osko
Bubbas Pools

[adam5532]

Danny,

It obviously appears to be a date format issue, but I'm unable to help you further as I provide very limited support for the old free version of QBI. If you can't locate the problem yourself then I'd probably need to see your website to fix it for you.

Thanks,
Adam

Thank You for your response.

However, the Server time is correct and the Zen Cart order date is correct. It seems to be the date format in one of the SQL files.

(they are the correct numerical values, but in the wrong place setting). Any further thoughts on how to change the Date format in what SQL file?

Thanks,
Danny

[adam5532]

I don't give any guarantees about the old free version of QBI working. However, ZC 1.5.x uses essentially the same database structure as 1.3.9, so I don't expect there to be any problem related to the ZC version.

Thanks,
Adam

Hello,

Is there any way to use QBI with ZenCart ver 1.5.0.?

Thanks,
Dan Osko
Bubbas Pools

[danielosko]

I don't give any guarantees about the old free version of QBI working. However, ZC 1.5.x uses essentially the same database structure as 1.3.9, so I don't expect there to be any problem related to the ZC version.

Thanks,
Adam

Hello Adam,

I've installed this on 1.3.8 and 1.3.9 without any issues at all. Since I have upgraded to 1.5.0, I have installed twice and the program will not even show up under the stores admin panel. I am at a total loss.

Additionally, I have read numerous posts having the same or similar issues, without a solution.

I understand that this is basically open source, but I wish that the persons incharge of the 1.5.0 version had considered the use of ALL plugin compatibility before releasing this version of ZenCart or at least did the research to see what plugins would or would not work with 1.5.0. And stated such, so that a store owner would be able to make an INFORMED decission as to whether or not the 1.5.0 version was worth the effort, time or even compatible for their usage.

To me, an online shopping cart without the capability to download the sales information to an accounting program is basically useless. It is way to cumbersome to copy and paste all orders by hand into an accounting program.

So, in conclusion... Is there anyway to use QBI with 1.5.0?

If neccessary, I'll pay you!

Respectfully,
Dan Osko
Bubbas Pools
http://bubbaspools.com

[adam5532]

Hello Adam,

I've installed this on 1.3.8 and 1.3.9 without any issues at all. Since I have upgraded to 1.5.0, I have installed twice and the program will not even show up under the stores admin panel. I am at a total loss.

If it won't show up, then it really isn't an issue with the inner workings of QBI. It is simply a menu issue. The solution to that should be simple, and isn't specific to QBI. You can also just go directly to the QBI page by entering the URL in your browser instead of using the menus.

If neccessary, I'll pay you!

If you are willing to pay, then don't use the free version of QBI.

Thanks,
Adam

[danielosko]

If it won't show up, then it really isn't an issue with the inner workings of QBI. It is simply a menu issue. The solution to that should be simple, and isn't specific to QBI. You can also just go directly to the QBI page by entering the URL in your browser instead of using the menus.

If you are willing to pay, then don't use the free version of QBI.

Thanks,
Adam

Thanks for the info Adam,

Where do I get the "other" version?

Dan Osko
Bubbas Pools
http://bubbaspools.com

[Rizla]

Will this work on 1.3.9 for UK Quickbooks?

If not... Does anyone know of a solution?

Thanks