Quickbooks Import QBI

**letsmod** · 10 Jan 2012, 11:25 PM

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

**Danielle** · 17 Jan 2012, 09:55 PM

Has anyone tried this mod with v1.50 yet?

**adam5532** · 18 Jan 2012, 09:35 AM

Originally Posted by 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

It's some 10,000 lines of code, and significant time to support.
Adam

**adam5532** · 18 Jan 2012, 09:41 AM

Originally Posted by 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

**openvista** · 27 Jan 2012, 03:04 AM

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/showpo...&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!

**openvista** · 1 Feb 2012, 07:42 PM

Just to follow up, the problem seems to be resolved now. I found this link to be very helpful: https://www.qbisoftware.com/support/...cleid=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.

**Danielle** · 2 Feb 2012, 08:02 PM

Will this mod work with QuickBooks Mac 2012?

**adam5532** · 3 Feb 2012, 06:51 AM

Originally Posted by 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/...cleid=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)

**adam5532** · 3 Feb 2012, 07:06 AM

Originally Posted by 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

**danielosko** · 1 Mar 2012, 09:15 PM

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