Quickbooks Import QBI

[audradh]

Think I got it. I forgot that products have to have a model# in Zen Cart, guessing that is my problem...

[adam5532]

Thanks Adam!

I am receiving an error when I try to import iif file at Setup->Products:

Sorry about that. Yes, this is a known bug and was posted previously in this thread. In the meantime:

A bug has been found in the following files:
qbi_products.php
qbi_ship.php
qbi_pay.php
qbi_disc.php

Symptom:
Error messages on screen, and items that are no longer used are not deleted like they should be.

Please replace
Code:

$this

with
Code:

$infile

There are two occurences in products, and one each in ship, pay, and disc. This will be corrected in the next release.

Thanks,
Adam

[adam5532]

Think I got it. I forgot that products have to have a model# in Zen Cart, guessing that is my problem...

No, that's not this problem, but yes that would cause a different problem. V3.10 will give a warning if any products don't have model numbers.

Thanks,
Adam

[MikeyG]

Adam,

Wanted to help you get this working for UK versions. I have hit the first hurdle though - getting the QBI to work in the first place.

I have the folloing error:

Notice: Query failed: Incorrect integer value: '' for column 'qbi_qb_addr' at row 1 SQL: UPDATE qbi_config SET qbi_qb_iso2='GB',qbi_qb_subver='1',qbi_qb_addr='',qbi_output_fmt='1',qbi_file_da te='',qbi_dl_file='1',qbi_prod_rows='5',prods_sort='0',prods_width='48',qbi_log= '',orders_status_import='1',qbi_status_update='',qbi_cc_status_select='3',qbi_mo _status_select='2',qbi_email_send='',qbi_cc_clear='',orders_docnum='%I',orders_p onum='%I',cust_nameb='%C10W-%I',cust_namer='%L10W-%I',cust_limit='0',cust_type='',cust_state='1',cust_country='',cust_compcon='1', cust_phone='',invoice_acct='Accounts Receivable',invoice_salesacct='Undeposited Funds',invoice_toprint='1',invoice_pmt='0',invoice_termscc='',invoice_terms='',i nvoice_rep='',invoice_fob='',invoice_comments='1',invoice_message='',invoice_mem o='',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='',item_match_serv ='',item_match_assy='',item_match_disc='',item_match_oth in ...\admin\includes\classes\qbi_mysql.php on line 119


using PHP 5 and mysql 5 on 1.3.5

thanks

[MikeyG]

Okay I have tried it now with version 1.27d and sql4 and seem to be getting closer but I am now getting:

Fatal error: Maximum execution time of 60 seconds exceeded in ...\admin\includes\classes\qbi_mysql.php on line 117


can this be extended or avoided. Probably an obvious answer to do with my server set up but I could do with a pointer please.

Thanks.

p.s. could still do with understanding my previous post as I would like to get working with the new version of ZenCart

[adam5532]

Adam,

Wanted to help you get this working for UK versions. I have hit the first hurdle though - getting the QBI to work in the first place.

I have the folloing error:

Notice: Query failed: Incorrect integer value: '' for column 'qbi_qb_addr' at row 1 SQL: UPDATE qbi_config SET ...
using PHP 5 and mysql 5 on 1.3.5

thanks

This is due to differences between PHP 4 and PHP 5. The variable '0' for the checkboxes on the config form that are unchecked do not get passed at all, resulting in missing values instead of zero. This has been fixed in QBI v3.1, which will be released very soon -- maybe this weekend if I find enough time to work on it.

Thanks,
Adam

[adam5532]

Okay I have tried it now with version 1.27d and sql4 and seem to be getting closer but I am now getting:

Fatal error: Maximum execution time of 60 seconds exceeded in ...\admin\includes\classes\qbi_mysql.php on line 117


can this be extended or avoided. Probably an obvious answer to do with my server set up but I could do with a pointer please.

Thanks.

p.s. could still do with understanding my previous post as I would like to get working with the new version of ZenCart

You don't say what you were trying to do -- import customers, products, or orders, and how many you have. If you are trying to import a huge number of past customers or orders, you could hit a PHP timeout, or it could be stuck for some reason.

Also, adding UK support involves changes in the taxation system as well as the iif fields. I know people are anxious for this to get done, but I am working on it, so please be patient.

Thanks,
Adam

[MikeyG]

Adam,

thanks again for your reply.

If I do not use model field how can I populate the model field with the product id from the data base.

The product file generated is missing product if the model field is blank

thanks

MG

p.s. can I help with the mapping of the iif fields in any way for the UK . What info would you need?

[audradh]

...QBI v3.1, which will be released very soon -- maybe this weekend if I find enough time to work on it.

Thanks,
Adam

Hey Adam,
Just curious: will v3.1 include the ability to create a iif of discount coupons from Zen Cart to download for importing into QB?

Thanks!
Audra

[audradh]

Hey Adam,
Just curious: will v3.1 include the ability to create a iif of discount coupons from Zen Cart to download for importing into QB?

Thanks!
Audra

Sorry, I spoke too soon before I truly understood how this works!

I was under the impression that each and every coupon code was going to need to be entered into QB, uploaded to Zen, and matched. I suppose the feature could still be added, but certainly is not as big a deal as I thought

Audra