Quickbooks Import QBI

[adam5532]

It looks like there is already a contribution for Innovative Gateway Solutions in the archive.
- Adam

[adam5532]

I am happy to announce the release of QBI Quickbooks Import version 3.00 for Zen Cart!

QBI lets you import your Zen Cart orders, products, and customers directly into Quickbooks. Features include product mapping, automatic recognition of shipping methods, support for sales tax, discount coupons, and online payment gateways, and more. A wide range of configuration options let you customize it for your store. The comprehensive manual includes numerous screen shots.

Version 3.00 currently only supports US versions of Quickbooks. Support for international versions and multiple sales tax rates is designed into the software, but these capabilities will be added in a future release.

The Zen Cart team now approves contributions before they are posted, so it may be a day or two before QBI is available for download in the Contributions : Admin Tools section.

Thanks,
Adam

[adam5532]

QBI is now available for download. The link is:
http://www.zen-cart.com/index.php?ma...roducts_id=144

Thanks,
Adam

[LloydDobbler]

QBI is now available for download. The link is:
http://www.zen-cart.com/index.php?ma...roducts_id=144

Thanks,
Adam

I'll be the first to say it:

YEAH!!!!!!!!! Thanks, Adam!!!! You ROCK!!!!!!

(I'll also say you rock especially hard for including a manual. God love ya, man. It brings a tear to my eye. Once I finally figure out how the heck to use the template override system, I am SO installing your QBI, and sending you a donation.)

Woo-hoo!!!

[LloydDobbler]

BTW, since I know so many of us have been following this thread for a looooooong time - some of us waiting until this functionality was available to even decide whether or not we would use Zen Cart - I thought I should re-post a link to the info on how to send a donation to Adam's "cause"....

Here's the post.

It's obviously not a requirement of a community-based open source effort like Zen Cart (nor should it be)...but given the amount of time spent by Adam and the level of functionality of a contribution like this one, I think it's good for the rest of us to give something back when someone goes above and beyond the call and contributes something that benefits us.


Thanks again, Adam.

[landshark]

Holly Cow!!!

I almost thought this day would never come. I feel like a kid on Christmas Eve.

I will get it installed and tested and if it works out fomr me i will surely be sending a donation.

Thanks Adam!

[tronix]

I've followed the instructions (I believe)

When I click on the "Import Quickbooks QBI" button

I get this error :

Notice: Query failed: Table 'growtron_zc2.zen_qbi_config' doesn't exist SQL: SHOW COLUMNS FROM zen_qbi_config in /home/growtron/public_html/store/admin/includes/classes/qbi_mysql.php on line 119

I have the install database button but I'm nervous to click it with the above error. Is it normal?

The only part of the instructions that I wasn't sure on was instruction
"d) Copy the QBI language files to your server. You must copy at least one language set."

I figure that it is included in the admin folder.?

Also it would be nice if cut and paste was allowed from the insturctions PDF.

Thanks

[tronix]

: (

I got a little impatient and pushed the install database button I receive this:

Notice: Query failed: Table 'growtron_zc2.orders' doesn't exist SQL: ALTER TABLE `orders` ADD `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL; in /home/growtron/public_html/store/admin/includes/classes/qbi_mysql.php on line 119

Notice: Query failed: Table 'growtron_zc2.orders' doesn't exist SQL: ALTER TABLE `orders` CHANGE `qbi_imported` `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL; in /home/growtron/public_html/store/admin/includes/classes/qbi_mysql.php on line 119

Notice: Query failed: Table 'growtron_zc2.orders' doesn't exist SQL: ALTER TABLE `orders` ADD INDEX (`qbi_imported`); in /home/growtron/public_html/store/admin/includes/classes/qbi_mysql.php on line 119

Notice: Query failed: Table 'growtron_zc2.products' doesn't exist SQL: ALTER TABLE `products` ADD `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '2' NOT NULL; in /home/growtron/public_html/store/admin/includes/classes/qbi_mysql.php on line 119

Notice: Query failed: Table 'growtron_zc2.products' doesn't exist SQL: ALTER TABLE `products` CHANGE `qbi_imported` `qbi_imported` TINYINT(2) UNSIGNED DEFAULT '0' NOT NULL; in /home/growtron/public_html/store/admin/includes/classes/qbi_mysql.php on line 119

Notice: Query failed: Table 'growtron_zc2.products' doesn't exist SQL: ALTER TABLE `products` ADD INDEX (`qbi_imported`); in /home/growtron/public_html/store/admin/includes/classes/qbi_mysql.php on line 119

Database table installation successfull. Now you must go to the configuration page.
1) Check and fill in the configuration options.
2) Click "Update" at the bottom of the page to save your changes.
Note: You must click update to finish the installation, even if you did not change any settings!

Now you must go to the configuration page.

[tronix]

When you refer to line 16 and line 128 ect. When do you start line 1? after the php tag or after the commented sections?

[adam5532]

When you refer to line 16 and line 128 ect. When do you start line 1? after the php tag or after the commented sections?

The first error is not a functional problem -- it is checking to see if the config table has been installed -- but I will redo the check to avoid it throwing an SQL error.

The second problem is happening because you are using the database prefix "zen_" with your tables, and qbi isn't handling that correctly on the installation. I will try to look at and correct this tonight.

To correct your installation in the meantime, you can manually add zen_ to the name of all the qbi tables, and then go to the zen_orders and zen_products tables and:
Add a column called qbi_imported to each one, setting it to TINYINT, UNSIGNED, NOT NULL, DEFAULT 2. After creating those columns, go back to them and change the DEFAULT to 0.

I will fix the pdf so that you can copy the code, or supply it in another format.

Line number start from the very top of the page. You should be able to turn on line numbers in any html, php, or text editor.

Thanks,
Adam