Quickbooks Import QBI

[Merlinpa1969]

thanx adam,

[adam5532]

Zen Cart versions that QBI works with:

QBI works with all versions of Zen Cart (to my knowledge)

Just to clear up a little confusion, when one uploads a contribution, you are only able to choose one version of Zen Cart from a drop-down list. I always choose the latest one, to indicate that QBI works with the latest version of Zen Cart. But in general it works with any version. If you do discover any issues, especially with any payment or shipping modules, just let me know.

Thanks,
Adam

[MikeyG]

Hi, I have just tried a brand new install on 1.3.7 gone through and set my config settings and hit submit and got this error :

Notice: Query failed: Incorrect integer value: '' for column 'tax_lookup' at row 1 SQL: UPDATE qbi_config SET qbi_qb_iso2='US',qbi_qb_subver='1',qbi_qb_addr='0',qbi_output_fmt='iif',qbi_file _date='0',qbi_dl_file='1',qbi_prod_rows='5',prods_sort='0',item_width='48',qbi_l og='0',orders_status_import='1',qbi_status_update='0',qbi_cc_status_select='3',q bi_mo_status_select='2',qbi_email_send='0',qbi_cc_clear='0',orders_docnum='%I',o rders_ponum='%I',cust_nameb='%C10W-%I',cust_namer='%L10W-%I',cust_limit='0',cust_type='',cust_state='1',cust_country='0',cust_compcon='1' ,cust_phone='0',cust_default='0',cust_default_name='',invoice_acct='Accounts Receivable',invoice_salesacct='Undeposited Funds',invoice_toprint='1',invoice_pmt='0',invoice_termscc='',invoice_terms='',i nvoice_rep='',invoice_fob='',invoice_class='',invoice_comments='1',invoice_messa ge='',invoice_memo='',item_acct='',item_asset_acct='Inventory Asset',item_class='',item_cog_acct='Cost of Goods Sold',item_cart_lang='0',item_match_inv='1',item_match_noninv='0',item_ma in ...\admin\includes\classes\qbi_mysql.php on line 119

What have I missed or done wrong?

Thanks

MG

[adam5532]

Hi, I have just tried a brand new install on 1.3.7 gone through and set my config settings and hit submit and got this error :

Notice: Query failed: Incorrect integer value: '' for column 'tax_lookup' at row 1 SQL: ...
What have I missed or done wrong?

Thanks

MG

You are not doing anything wrong. This is a bug -- the tax_lookup column is not currently used and should have been removed from the code. This problem only affects some people due to your php settings. I will post simple instructions to fix it this evening.

Thanks,
Adam

[MikeyG]

Adam, Thanks look forward to it.

I have also had this error when trying to down load the product.iif. Is it linked?

Warning: create_output::require_once(..../admin/includes/classes/qbi_classes_out_1.php) [function.create-output-require-once]: failed to open stream: No such file or directory in ...\admin\includes\classes\qbi_classes_output.php on line 316

Fatal error: create_output::require_once() [function.require]: Failed opening required '.../admin/includes/classes/qbi_classes_out_1.php' (include_path='.;C:\php5\pear') in ...\admin\includes\classes\qbi_classes_output.php on line 316

[adam5532]

Adam, Thanks look forward to it.

I have also had this error when trying to down load the product.iif. Is it linked?

Warning: create_output::require_once(..../admin/includes/classes/qbi_classes_out_1.php) [function.create-output-require-once]: failed to open stream: No such file or directory in ...\admin\includes\classes\qbi_classes_output.php on line 316

Fatal error: create_output::require_once() [function.require]: Failed opening required '.../admin/includes/classes/qbi_classes_out_1.php' (include_path='.;C:\php5\pear') in ...\admin\includes\classes\qbi_classes_output.php on line 316

That shouldn't happen when the first problem is solved and you have the output settings set as they should be.
Thanks,
Adam

[adam5532]

In the file: qbi_classes.php
Line: 2648
Remove: 'tax_lookup',

Make sure to delete just the characters above, so that the commas and quotes remain correct. Just to be sure:
This section: 'tax_rate','tax_lookup','pmts_memo',
Now looks like: 'tax_rate','pmts_memo',

The tax_lookup field is not currently being used, so it can be removed from the field list.

This error only affects some users, depending on your php configuration.

- Adam

[audradh]

I'm have been configuring and performing setup. All is well except Payment setup. I receive:

Fatal error: Call to undefined function: check_payqb() in /home/natuscom/public_html/greenhouse/qbi_pay.php on line 52

Here is that portion of the referenced file:

// Display update payment types button only if pay types have been imported
if ($infile->check_payqb()>0) {
	$infile->form_footer(PAY_TYPE_BUTTON);
} else {
	$infile->form_footer_sans_submit();
}
$infile->form_display();

A search for check_payqb in my database using phpMyAdmin finds no matches.
A search for check_payqb in the developers tool kit finds only the file referenced in the error.

I guess I can export my qbi tables and compare them to the original mod sql.

Anybody have any other thoughts?

Thanks!
Audra

[adam5532]

I'm have been configuring and performing setup. All is well except Payment setup. I receive:

Fatal error: Call to undefined function: check_payqb() in /home/natuscom/public_html/greenhouse/qbi_pay.php on line 52

Here is that portion of the referenced file:

// Display update payment types button only if pay types have been imported
if ($infile->check_payqb()>0) {
	$infile->form_footer(PAY_TYPE_BUTTON);
} else {
	$infile->form_footer_sans_submit();
}
$infile->form_display();

A search for check_payqb in my database using phpMyAdmin finds no matches.
A search for check_payqb in the developers tool kit finds only the file referenced in the error.

I guess I can export my qbi tables and compare them to the original mod sql.

Anybody have any other thoughts?

Thanks!
Audra

Audra,
This doesn't concern your tables. The function check_payqb exists at line 1423 in qbi_classes.php. Is everything else working? You were able to update and save the Configuration? Check this first -- change something, and make sure it sticks, to verify that the database connection is ok. If this checks out OK, try downloading QBI again, and reupload the qbi_classes.php file to your server. The file may have gotten corrupted. Also, check your server error log for any other errors, if you don't have warnings print to your screen.

Thanks,
Adam

[audradh]

Thank you Adam! That helped. My cart came pre-loaded w/ QBI. The file you mentioned was not the current version. I just reloaded all of the files and it looks good so far.


Audra