Quickbooks Import QBI

I am really interested int eh Paid version, but honestly with the 2 required software it cost more then QB itself.

I think a more reasonable price $50 to $100 for both software would actually get you more sales.

Not that I am spamming or not saying its good software or bad, but for 90% of the people running zen-cart its really overpriced:wacko:

Has anyone tried this mod with v1.50 yet?

letsmod:

I am really interested int eh Paid version, but honestly with the 2 required software it cost more then QB itself.

I think a more reasonable price $50 to $100 for both software would actually get you more sales.

Not that I am spamming or not saying its good software or bad, but for 90% of the people running zen-cart its really overpriced:wacko:
It's some 10,000 lines of code, and significant time to support.
Adam

Danielle:

Has anyone tried this mod with v1.50 yet? The free version is 5 years old and I have no plans to test it with ZC v1.50. I am in the process of testing the paid version with 1.50.
Adam

Since upgrading to 1.3.9h (from 1.3.6) in early December '11, my client cannot get Paypal transactions to import as receipts, only invoices. I have followed the earlier directions given (http://www.zen-cart.com/forum/showpost.php?p=402833&postcount=485) and it was to no avail as each of these changes had already been made to the files and db table. No settings have changed since the time (under 1.3.6) it was importing as receipts (as it was and is configured to do) and all files and database tables related to the add-on were copied over (this has been verified from backups).

Is it possible that the module name (column: qbi_paycart_mod in table: qbi_paycart) has changed since the last instructions were posted in 2007? I noticed that the paypal table now has a new field called "module_name" and refers to itself now as "paypal (ipn-handler)". Does this need to explicitly added to the above table in the above column?

Any suggestions to remedy this would be appreciated. Thanks!

Just to follow up, the problem seems to be resolved now. I found this link to be very helpful: https://www.qbisoftware.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=20&nav=0, particularly steps 2 and 3. I hadn't seen it described in that level of detail here. If you follow the steps in this thread, particularly the posts from 2007 describing a fix for this problem, and you change the database according to those steps, it won't work. That's because the name of the module has changed (assuming you're using 1.3.9 or later). You have to transpose the information in the orders table (see knowledgebase article link above) EXACTLY (case and all) to the qbi_paycart table.

Will this mod work with QuickBooks Mac 2012?

openvista:

Just to follow up, the problem seems to be resolved now. I found this link to be very helpful: https://www.qbisoftware.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=20&nav=0, particularly steps 2 and 3.
Glad you got it working. To clarify for others, you do need to comment out the two lines shown in the ZC forum post link given above. That's because the free version of QBI had a system that attempted to automatically update the tables, and you must disable it before you do manual changes so that they don't get overwritten.
Thanks,
Adam (creator of QBI)

Danielle:

Will this mod work with QuickBooks Mac 2012?
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

Hello Everyone,

I am having difficulty with my Quick Books QBI Verion 3.21. I am using Quick Books Pro 2010 and ZenCart 1.3.8a.

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.

This is the one thing that has been a problem for years, but I did not want to bother anyone. (duh).

Anyway, any assistance would be GREATLY appreciated.

Thanks all,
Danny Osko
Bubbas Pools:D

Danny,

danielosko:

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

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:

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.

Hello,

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

Thanks,
Dan Osko
Bubbas Pools:wacko:

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

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

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

danielosko:

Hello,

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

Thanks,
Dan Osko
Bubbas Pools:wacko:

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 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. :blink:

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

danielosko:

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. :blink:
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

adam5532:

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

Will this work on 1.3.9 for UK Quickbooks?

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

Thanks