Quickbooks Import QBI

This seems like a fantastic mod and sure beats the way we do it now. I installed the mod as per the instructions (at least I think I did :cool: )but I got the follwing error messages

This is a brand new cart that has just a couple test products in it, as I am trying to get everything modified and working before loading all the products in, not sure if that is what is casuing the issue or not, but thought I would point it out.

**Notice: **Query failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-config' at line 1 SQL: SELECT * FROM qbi-config in /home/scroll/public_html/cart/admin/includes/classes/qbi_mysql.php on line 119

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

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/scroll/public_html/cart/admin/includes/classes/qbi_mysql.php on line 176

Warning: array_walk(): The argument should be an array in /home/scroll/public_html/cart/admin/includes/classes/qbi_classes.php on line 958

Warning: Invalid argument supplied for foreach() in /home/scroll/public_html/cart/admin/includes/classes/qbi_classes.php on line

Here is my server info
**Database Host: **localhost (127.0.0.1)
**Server OS: **Linux 2.4.25-HRGRP4smp
**Database: **MySQL 4.0.22-standard
**PHP Version: **4.3.11 (Zend: 1.3.0
**HTTP Server: **Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.11 FrontPage/5.0.2.2634a mod_ssl/2.8.22 OpenSSL/0.9.6

I did try to delete from the server the two pages qbi_classes.php and qbi_mysql.php and re upload them, however that didn't help. I also checked the original zip files and compared them to the ones I uploaded and couldn't find a difference however I might aw well have been comparing ancient egyptian hieroglphics LOL

Any guidance as to what I should be looking for or a fix would be fantastic

Looking forward to hearing how I messed it up this time LOL

Thanks in advance
Shadez

shadez2270:

This seems like a fantastic mod and sure beats the way we do it now. I installed the mod as per the instructions (at least I think I did :cool: )but I got the follwing error messages

**Notice: **Query failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-config' at line 1 SQL: SELECT * FROM qbi-config in /home/scroll/public_html/cart/admin/includes/classes/qbi_mysql.php on line 119
The table name is qbi_config, not qbi-config.

You wrote in the table definitions wrong in the installation. I suggest you use the word document copy of the installation instructions and do copy and paste instead of recopying, to avoid any typing mistakes.

Thanks,
Adam

DOUHHHH (in my best homer Simpson voice) This always happens when I type code--->:lamo:

I corrected the typo and it worked like a charm... See I knew I had screwed it up.

I will be sure to make a contribution... thanks for helping me get it running

Also thank you Adam for a great mod!

shadez2270:

Also thank you Adam for a great mod!
Thanks!

• Adam

I use both inventory items (things that I actually keep in stock) as well as non inventory items (things that I manufacture or drop ship). I also occasionally charge a service fee for consulting and such. QBI has a setting under Items called export type. Choices are Inventory, Noninventory, and Service. What one should I choose? I have all 3 in QB. How does this affect my book keeping and inventory?

Thanks.

djstern:

I use both inventory items (things that I actually keep in stock) as well as non inventory items (things that I manufacture or drop ship). I also occasionally charge a service fee for consulting and such. QBI has a setting under Items called export type. Choices are Inventory, Noninventory, and Service. What one should I choose? I have all 3 in QB. How does this affect my book keeping and inventory?

Thanks.
The type setting in the QBI configuration only affects items in ZC that are directly imported by QBI, since ZC has no such designations.

If you use the Matching feature in QBI, and match those items to your items in QB, then the type of each QB item will be preserved.

Thanks,
Adam

Under match | Shipping I have nearly 3000 entrys under the shopping cart colum. Flat Rate (Best Way) for example is showing up dozens of times and I don't even have it installed. A bunch of other shipping methods like free is also showing up dozens of times even though they are not even installed in ZC under Modules | Shipping. Everytime I click on something, anything in that window the number of entrys increases. I can't even set up shipping until this is corrected. any ideas?

Thanks in advance.

Problem is that the same thing is showing up dozens of times. Flat Rate (Best Way) fills the entire page even if I have it configured to show 25 rows. If I attempt to go to the next page the number of Shipping Methods increases and I can never manage to get to the next shipping method.

Just for grins I dropped all of the database entries for QBI and recopied the files to my server. Verified the file changes and went through the configure process again. All went well until I entered match | shipping. When I first entered the page I had 32 entries. Making no changes of any kind I hit the "Update Matches On This Page" button and ended up with 64 shipping methods. Hit the button again and I have 96 entries. One more time and I have 128 entries. Same thing happens if I click next or a page number. The number of Shipping Method increases by more than is displayed on the page.

HELP!!!

Basically, I can't set up shipping with this problem.

djstern:

Under match | Shipping I have nearly 3000 entrys under the shopping cart colum. Flat Rate (Best Way) for example is showing up dozens of times and I don't even have it installed. A bunch of other shipping methods like free is also showing up dozens of times even though they are not even installed in ZC under Modules | Shipping. Everytime I click on something, anything in that window the number of entrys increases. I can't even set up shipping until this is corrected. any ideas?

Thanks in advance.
This is a bug in 3.10 and will be corrected in 3.11. Please see the Bug Reports section of the QBI forum at http://www.libermansound.com/qbi for a simple solution.

All known bugs are listed in the QBI forum. It is a good idea to check there first if you have any problems.

Thanks,
Adam

QBI 3.20 has been released!

• Adam

New Features:

1. Invoice class can be set in config
2. Default customer name option added
3. Automatic detection of available output formats
4. Customer, order, and products header and footer output lines added for additional flexibility
5. Shipping methods are now manually loaded from cart (by clicking a button)

Fixes:

1. Missing PayPal constants added
2. Shipping match was multiplying shipping methods every time Match:Ship was selected
3. Clarified difference between iif file uploading and processing
4. QB group tables entries are now deleted properly
5. Assembly subitem descriptions no longer get deleted
6. QB groups now alphabetically sorted in match dropdown box
7. Chron misspelling changed to cron in files and docs

adam great news, can you provide a link?

thanks

MG

Adam glad to hear it especially since i am upgrading to ZC 1.3.7 tonight.

I'll secong where can we download it and also for those of us who have donated are we able to register our version? how does that work?

Thanks again,

Mike

MikeyG:

adam great news, can you provide a link?

thanks

MG
I have uploaded it to the Zen Cart contribution area (it is under Admin Tools). However, all contributions have to be approved by Zen Cart before they are made available, so it may be 24 - 48 hours before it appears. It was actually only a few hours last time, but it is New Year's Eve so it may not be as quick!

• Adam

landshark:

Adam glad to hear it especially since i am upgrading to ZC 1.3.7 tonight.

I'll secong where can we download it and also for those of us who have donated are we able to register our version? how does that work?

Thanks again,

Mike
All users with or without donations are strongly encouraged to register at http://www.libermansound.com/qbi

This helps me keep track of you for support, and I can let you know when new versions are available. Simply registering a free version of QBI however does not change your support level.

Donations that you have made are part of the equation for support and upgrades. However, in respect of the forum rules I will respond to you privately about that.

Thanks,
Adam

Could anybody here explain the diferences between US and UK versions of Quickbooks.

I have US version on trial, but i operate from the UK. I am interested in trying the contribution and getting Quickbooks intergrated with Zencart.

salt3y:

Could anybody here explain the diferences between US and UK versions of Quickbooks.

I have US version on trial, but i operate from the UK. I am interested in trying the contribution and getting Quickbooks intergrated with Zencart.
The taxation systems are different, and the iif file format is different. QBI will not work with UK Quickbooks yet. That is being worked on now -- when I am closer I will let everyone know.

Thanks,
Adam

Adam, Thanks just for clarification where on the website do i register. I don't see a link, maybe i am just blind.

Now for technical problems. I installed the new files into a new install of ZC 1.3.7
but an upgraded database if that makes sense to you. So my olde QBI Tables were still there. After the install i ran the upgrade database for QBI.

My problem: When i try to download the new orders i get the following error:

Warning: create_file_orders(/home/diystore/public_html/catalog/admin/includes/classes/qbi_classes_out_1.php): failed to open stream: No such file or directory in /home/diystore/public_html/catalog/admin/includes/classes/qbi_classes_output.php on line 132

Fatal error: create_file_orders(): Failed opening required '/home/diystore/public_html/catalog/admin/includes/classes/qbi_classes_out_1.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/diystore/public_html/catalog/admin/includes/classes/qbi_classes_output.php on line 132

any insight into what might be causing this?

Ok fixed the problem i had to delete all the QBI stuff from the database. Working now.

I am still running into the problem with paypal orders being imported into QB as an invoice and listed under Accounts receivable.

I want everything to be imported as a sales reciept. I just can't seem to find where i might be going wrong with the settings.

landshark:

Adam, Thanks just for clarification where on the website do i register. I don't see a link, maybe i am just blind.
Click on the menu link at the top of the page that says Registration, or go directly to:
http://www.libermansound.com/qbi/register.php
Now for technical problems. I installed the new files into a new install of ZC 1.3.7
but an upgraded database if that makes sense to you. So my olde QBI Tables were still there. After the install i ran the upgrade database for QBI.

My problem: When i try to download the new orders i get the following error:
...
any insight into what might be causing this?
Whoops, I guess my hope for zero bugs has been squashed! This one is minor though, and database reinstallation actually isn't necessary.

When you upgrade QBI to version 3.20, you will be prompted to update the database tables. After that, please go to the Config page and in the General section select iif as the Output Format and then click Save at the bottom of the page.

Thanks,
Adam

landshark:

Ok fixed the problem i had to delete all the QBI stuff from the database. Working now.

I am still running into the problem with paypal orders being imported into QB as an invoice and listed under Accounts receivable.

I want everything to be imported as a sales reciept. I just can't seem to find where i might be going wrong with the settings.
In Set up|Payment you've got PayPal (from your QB payment methods) set to "Paid with PayPal?" And in Match|Payment you've got the the cart's PayPal method matched to this QB method? That should work. But I will look at this in QBI and see if I missed something and get back to you.

Thanks,
Adam