Quickbooks Import QBI

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

audradh:

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

audradh:

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

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_date='',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_ponum='%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='',invoice_rep='',invoice_fob='',invoice_comments='1',invoice_message='',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='',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

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

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

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

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?

adam5532:

...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! :lamo:

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 :blush:

Audra

I cannot figure out why my matched items are being added as new "service" type items. Any ideas?

:( :(

For the record, I am having the same troubles that Landshark was having:

Paypal is not importing as Paid Online and items are being created during import despite matching.

I am guessing that the item creation is because most of my products have multiple attributes. What i attempted to do was to create a QB item for each manufacturer and then match each cart item to the correct manufacturer figuring that would at least give me some sales detail. I thought that if I used matching the attribute issue wouldn't interfere, but apparently for multiple attributes it does.

(BTW, is there any quick way to unmatch my 600+ products?)

As for Paypal:

I noticed that in QBI->Match->Payment the shopping cart payment methods include payment methods that are not installed in my cart, and Paypal is listed as "Paypal(paypal)". I do have it matched to "Paypal". In QBI->Setup->Payment "Paypal" is defined as "Paid online".

As an aside, given the impact of importing orders when things are not setup properly, it would be fabulous if QBI offered importing of just one order, or a date range, or order number range, or something other than just import new orders or the last batch.

Landshark, I have PM'd you to see whether you have gotten anywhere w/ this.

I apologize to those trying to skim this thread for my many posts.

Audra

adam

I have this error when trying to create / import an iif list file of product items file which I have exported from Quick books

Fatal error: Using $this when not in object context in ..\admin\qbi_products.php on line 51

any thoughts please.

Thanks

MG

MikeyG:

adam

I have this error when trying to create / import an iif list file of product items file which I have exported from Quick books

Fatal error: Using $this when not in object context in ..\admin\qbi_products.php on line 51

any thoughts please.

Thanks

MG
MG,
Look up this thread 12 posts. You will find the answer there.
Audra

Thanks audrah

Okay I am really having a battle with this.

If I don't have a model number I can seem to export the product and so a the moment I only have product withg any model info (not many as I have not really been using this field.)

I am also cconfused about how to get the product to list in the drop downs under the Match in order to do the mapping properly. I seem to be in a catch 22. Want to get the product into quick books (which is empty at moent) I have 6000+ combinations with attributes and don't want to retype but I can get them into quick books to then get them back out to map them for the purposes of stock control.

It has been a long day and I might be missing something. Sorry if I have missed the obvious.

Thanks

MG

MikeyG:

Okay I am really having a battle with this.

If I don't have a model number I can seem to export the product and so a the moment I only have product withg any model info (not many as I have not really been using this field.)

I am also cconfused about how to get the product to list in the drop downs under the Match in order to do the mapping properly. I seem to be in a catch 22. Want to get the product into quick books (which is empty at moent) I have 6000+ combinations with attributes and don't want to retype but I can get them into quick books to then get them back out to map them for the purposes of stock control.

It has been a long day and I might be missing something. Sorry if I have missed the obvious.

Thanks

MG
Hey MG,
Adam states in the QBI manual that model# is necessary in order for QBI to work.
The manual also says that products with multiple attributes cannot be matched. I don't know whether you are using single or multiple attributes. I'll have to do a little more testing to be sure what QBI does w/ single attributes.

It all comes back to that great shortcoming in the stock Zen Cart, no support for attribute stock:no:

Audra

MG,

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.
Run this statement in your MySQL interface:

UPDATE products SET products_model=products_id

• Adam

audradh:

I cannot figure out why my matched items are being added as new "service" type items. Any ideas?

:( :(
Are you sure they are matched, and you clicked the button to save each match page after matching them? Items that aren't matched or don't exist in QB will import as services.

Thanks,
Adam

audradh:

For the record, I am having the same troubles that Landshark was having:

Paypal is not importing as Paid Online and items are being created during import despite matching.
PayPal is not well supported at the moment. I am going to fix this in v3.10, so you won't have any problems. Version 3.10 will be out shortly -- it is taking a little longer as I add additional things to it.
(BTW, is there any quick way to unmatch my 600+ products?)
Just empty the qbi_products_itemsqb table.
As an aside, given the impact of importing orders when things are not setup properly, it would be fabulous if QBI offered importing of just one order, or a date range, or order number range, or something other than just import new orders or the last batch.
I don't quite follow. QBI should be set up properly! You can't skip setting it up and expect it to work well!

Thanks,
Adam