Quickbooks Import QBI

[adam5532]

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.

I don't initially see any problem with the code, so if your settings are correct as noted in the previous post, please contact me privately as I may need access to your site to find the problem.

Thanks,
Adam

[landshark]

Adam thanks,

I really must be blind then, i didn't notice the menu bar at the top. I am all set now and registered.

Wish i had been more ptient and waited for your solution o my first problem hopefully this will help out the next guy.

On the PayPal issue my setting seem to be as you described. I will PM you about this.

Thanks again for all your hard work.

Mike

[adam5532]

A bug has been discovered in v3.20 on the Match|Shipping page. It produces PHP warning messages, but does not affect functionality.

File: qbi_shipmatch.php
Line: 50
Replace: $ship_meth=new Ship_form();
With: $ship_meth=new Ship_form($dbqbi);

File: qbi_classes.php
Line: 2782
Replace:
function Ship_form() {
$this->Form_fields();
}

With:
function Ship_form($db) {
$this->db=$db;
return;
}

Thanks,
Adam

[adam5532]

A bug has been found in v3.20 where iif files that contain Invoice and Payment won't import. This is only an issue if you have the Configuration option "Import payments" set to "As Invoice and Payment."

File: qbi_classes_output.php
In Line: 264 (after the comment // Create Payment Data)

Replace:
$ofile->create_payment($cartorder->order,$cartcustomer->customer)

With:
$ofile->create_payment($cartcustomer->customer,$cartorder->order)

Thanks,
Adam

[adam5532]

QBI v3.21 has been posted to the contribution section (as usual, it will take a few hours to be available).

It fixes 3 bugs found in 3.20. If you have already applied the fixes in the previous posts, then you do not need to upgrade from 3.20 to 3.21.

1. Fixed output error upgrading from 3.0x or 3.1x if configuration wasn’t re-saved
2. PHP error message on Match|Shipping page fixed
3. Payments weren’t working

Thanks,
Adam

[djstern]

No such thing as a bug free program I guess. :) At least it's in PHP and we have a programmer that actually supports it and gives us quick fixes (unlike he who's name shall not be spoken.) :)

My hats off to Adam for his hard work and support of this Contribution.

[michelle_rvc]

My admin was renamed after I had installed QBI. I just reinstalled it but I am getting this error-

Warning: main(/home/rusty2/public_html/newcatalog/admin/includes/classes/qbi_mysql.php): failed to open stream: No such file or directory in /home/rusty2/public_html/newcatalog/mgsadmin/includes/qbi_app_top.php on line 54

Fatal error: main(): Failed opening required '/home/rusty2/public_html/newcatalog/admin/includes/classes/qbi_mysql.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/rusty2/public_html/newcatalog/mgsadmin/includes/qbi_app_top.php on line 54

If I change my admin back to admin I have no problems. Where in the QBI files should I go to change the name of my admin?

Thanks!
michelle

[adam5532]

My admin was renamed after I had installed QBI. I just reinstalled it but I am getting this error-

Warning: main(/home/rusty2/public_html/newcatalog/admin/includes/classes/qbi_mysql.php): failed to open stream: No such file or directory in /home/rusty2/public_html/newcatalog/mgsadmin/includes/qbi_app_top.php on line 54

Fatal error: main(): Failed opening required '/home/rusty2/public_html/newcatalog/admin/includes/classes/qbi_mysql.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/rusty2/public_html/newcatalog/mgsadmin/includes/qbi_app_top.php on line 54

If I change my admin back to admin I have no problems. Where in the QBI files should I go to change the name of my admin?

Thanks!
michelle

QBI gets the directory paths from your Zen Cart settings, so there is nothing in QBI that needs to be changed. It sounds like you haven't configured Zen Cart properly for your new admin directory.

In addition to changing the directory name, you'll need to go into catalog/admin/includes/configure.php and change the following constants to the correct directory:
DIR_WS_ADMIN (the web URL path)
DIR_FS_ADMIN (the server file system path)

BTW, I agree this is a good basic security measure for everyone -- rename your catalog and admin directories from the defaults to make it just a little harder for automated bots and hackers searching for Zen Cart security holes to find your directories.

Thanks,
Adam

[michelle_rvc]

Thanks so much that worked perfectly. I didn't rename the admin, I switched hosting services and the person that moved my store did it. I guess I am glad I switched hosts the 1st company to install Zencart for me never mentioned it.

Thanks again!
michelle

[djstern]

In Match | Shipping all of my UPS and USPS shipping options show up twice. I look in the database and under the qbi_shipcart_car_code colum I have each UPS shipping method listed as ups then again as usp.bak. I've tried deleting the .bak versions but they come back each time I enter QBI in ZC giving me the duplicate entries. Same thing applies with the USPS shipping methods. I looked in Catalogue | inclueds | modules | shipping thinking that I might have a old backup version of the files causing the problem but that's not the case.

Any idea why I'm getting the duplicate entrys and how to fix it?