Quickbooks Import QBI

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

• Adam

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

QBI is now available for download. The link is:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=144

Thanks,
Adam

adam5532:

QBI is now available for download. The link is:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_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!!!

:thumbsup:

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".... :smile:

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.

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!

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

: (

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.

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?

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?
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

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 do this using PhpMyAdmin? Or somewhere in the code?

should it be qbi_imported or zen_qbi_imported ?

I'm using myphpadmin

Got it working! Now to the configure :>

Sorry to keep posting in your forum. I made the changes you suggested and I didn't get those errors. I completed the configuration page and successfully uploaded an iif file. When I goto setup I get:

Found iif import file lists.iif. Import now?

Notice: Query failed: Unknown column 'zen_qbi_itemsqb_hidden' in 'where clause' SQL: SELECT * FROM zen_qbi_itemsqb WHERE zen_qbi_itemsqb_hidden=0 ORDER BY zen_qbi_itemsqb_name in /home/growtron/public_html/store/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/growtron/public_html/store/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/growtron/public_html/store/admin/includes/classes/qbi_mysql.php on line 176
Quickbooks Items
Name Description

Any ideas? I just got quickbooks and have only slightly set it up could that be the problem?

Ok I'm going to go back and read through the documentation some more but a few problems have poped up.

On is with Payments.

I have 3 payment types set up. PayPal which i set as Paid Onlin. Authorize.net payments which i am using "Credit Card" which i set-up as Paid Online and chack which is setup as not prepaid. They have been matched to their respective mates.

When I imported all previous orders to get populate quickbooks for the first time, I have noticed that the PayPal purchases are showing up under accounts receivable and the authorize.net payments are showing up under undeposited funds. How can i fix this?

Second problem when i imported the orders i checked the Items list in Quickbooks and noticed that all of my products that have been sold were imported and show no associated account and a negative number on hand that represents how much i have sold.

Finally I imported customers and it seems like not all of my customers have come into quickbooks there are several people missing. Everyone that has placed an order is there and the math adds up to all orders that have been placed but still missing some customers.

Most of the other glithces i have worked out myself and were my fault in configuring and i assume this is too, just not sure where yet. I also have notices i get a whole list of warnings when i import the iif file under setup although the import seems to be working fine.

Hope you can help.

tronix:

Sorry to keep posting in your forum.

---

Any ideas? I just got quickbooks and have only slightly set it up could that be the problem?
I have corrected these issues in QBI. Please delete all the qbi database tables and files, and then install all the files again using the new version 3.01 that I just uploaded.

Thanks,
Adam

landshark:

Ok I'm going to go back and read through the documentation some more but a few problems have poped up.

On is with Payments.

I have 3 payment types set up. PayPal which i set as Paid Onlin. Authorize.net payments which i am using "Credit Card" which i set-up as Paid Online and chack which is setup as not prepaid. They have been matched to their respective mates.

When I imported all previous orders to get populate quickbooks for the first time, I have noticed that the PayPal purchases are showing up under accounts receivable and the authorize.net payments are showing up under undeposited funds. How can i fix this?
I'll look at this and get back to you shortly.
Second problem when i imported the orders i checked the Items list in Quickbooks and noticed that all of my products that have been sold were imported and show no associated account and a negative number on hand that represents how much i have sold.
Make sure that you have entered the account in the QBI configuration.

Unless you increase your inventory in QB to cover all your past sales, the inventory is going to go negative when you import all those orders, because each one is subtracting from inventory. QBI does let you import all past orders, but really unless you have a compelling reason to do so, it is probably best to just start importing with the new orders.

Finally I imported customers and it seems like not all of my customers have come into quickbooks there are several people missing. Everyone that has placed an order is there and the math adds up to all orders that have been placed but still missing some customers.
Currently, QBI only imports customers who have placed at least one order, because it uses the orders table to determine the correct billing and shipping addresses (this information is not stored in the customers table). But I will modify this in a future release, so that the default address is used for customers who have not placed orders.
Most of the other glithces i have worked out myself and were my fault in configuring and i assume this is too, just not sure where yet. I also have notices i get a whole list of warnings when i import the iif file under setup although the import seems to be working fine.
The warnings were due to an error in one of the functions and that has been fixed in 3.01. It would not have caused any errors in the data.

Thanks,
Adam

Hi everyone,

Thanks for all the words of support and appreciation, and all the downloads in QBI for ZenCart's first day!

I have corrected the errors that have been discovered so far in the initial release. This includes installation problems when using a table prefix, and sql errors that were appearing during the Set up procedures when importing an iif file.

If you have installed 3.00, please upgrade your version to 3.01, which I have just posted.

To upgrade, copy all the new files to your server. Also, please redo step 2i in the installation instructions (altering the database_tables.php file), using the new instructions, as the code you need to copy has been changed. I have included this as a Word document so that you can easily copy and paste the code.

Thanks,
Adam

adam5532:

I have corrected these issues in QBI. Please delete all the qbi database tables and files, and then install all the files again using the new version 3.01 that I just uploaded.

Thanks,
Adam
Also, please redo section 2i in the installation instructions, using the new instructions with 3.01.

Thanks,
Adam

Originally Posted by landshark
I have 3 payment types set up. PayPal which i set as Paid Onlin. Authorize.net payments which i am using "Credit Card" which i set-up as Paid Online and chack which is setup as not prepaid. They have been matched to their respective mates.

When I imported all previous orders to get populate quickbooks for the first time, I have noticed that the PayPal purchases are showing up under accounts receivable and the authorize.net payments are showing up under undeposited funds. How can i fix this?
It sounds like Authorize.net is working correctly. I'll need to test PayPal to see why it is not going to undeposited funds.

Thanks,
Adam