previously i installed qbi 3.10 but have not configured it. i have read about 3.21b. what is the best way to upgrade to 3.21b? will the files in the current directories just be overwritten?
thanks,
di
Printable View
previously i installed qbi 3.10 but have not configured it. i have read about 3.21b. what is the best way to upgrade to 3.21b? will the files in the current directories just be overwritten?
thanks,
di
NEVER MIND... sorry about that. i just now saw the upgrade instructions.
thanks,
di
:blink:
Adam,Quote:
Originally Posted by adam5532
I have made this change but still getting all these query errors when trying to get products downloaded and set the config settings as per my earlier posting.
Regards
MG
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='0',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
Adam this is the error I am getting despite removing the tax look_up as pre your post above.
have a failed to read something correctly.
It looks like tax_lookup is still there. Make sure that you made the change and then uploaded it to your site. Do a search on all your Zen Cart admin directory for tax_lookup to check that you or I didn't make a mistake and it has truly been removed.Quote:
Originally Posted by MikeyG
Thanks,
Adam
Hi Adam,
I have gone back one version and removed the tax_lookup and it has got me past the previous sticking point so thank you for that.
I have now got my product and the attributes into quickbooks and I havegot my customer list into quickbooks which is great. I even managed to suss out the column for getting the tax/VAT exempt or standard to import correctly(as it had not done so on the first attempt - the column was not exported by qbi in quite the right way)
So at this stage I should say I am breaking your rules slightly as I am using the UK version of Quickbooks and I know the current version is US only. So my next question may be caused by this fact.
So I have now tried to upload the list.iff file back to QBI/Zencart to be able to match the product. Payment methods and shipping fine - the following error has occurred with products though. Notice: Query failed: Incorrect integer value: '' for column 'qbi_itemsqb_taxable' at row 1 SQL: INSERT INTO qbi_itemsqb SET qbi_itemsqb_name='Gift Wrapping',qbi_itemsqb_refnum='1',qbi_itemsqb_hidden='0',qbi_itemsqb_desc='Gift Wrapping',qbi_itemsqb_accnt='Sales',qbi_itemsqb_price='3.3617',qbi_itemsqb_invit emtype='SERV',qbi_itemsqb_taxable='', added=NULL in ...\admin\includes\classes\qbi_mysql.php on line 119
Notice: Query failed: Incorrect integer value: '' for column 'qbi_itemsqb_taxable' at row 1 SQL: INSERT INTO qbi_itemsqb SET qbi_itemsqb_name='Next Day Delivery',qbi_itemsqb_refnum='3',qbi_itemsqb_hidden='0',qbi_itemsqb_desc='Next day delivery Charge',qbi_itemsqb_accnt='Freight Income',qbi_itemsqb_price='6.95',qbi_itemsqb_invitemtype='OTHC',qbi_itemsqb_taxa ble='', added=NULL in ...\admin\includes\classes\qbi_mysql.php on line 119
Notice: Query failed: Incorrect integer value: '' for column 'qbi_itemsqb_taxable' at row 1 SQL: INSERT INTO qbi_itemsqb SET qbi_itemsqb_name='Standard Carriage Charge',qbi_itemsqb_refnum='2',qbi_itemsqb_hidden='0',qbi_itemsqb_desc='Standard Carriage Charge',qbi_itemsqb_accnt='Freight Income',qbi_itemsqb_price='4.95',qbi_itemsqb_invitemtype='OTHC',qbi_itemsqb_taxa ble='', added=NULL in ...\admin\includes\classes\qbi_mysql.php on line 119
Could you just through some light on this for me. I am not to sure if it is related to the UK bit the tax bit or something else.
Many thanks. Once this is sorted I will start to look at the transaction so any guidence there would be great.
As always - Many thanks in advance:
MG
Hi, Newbie here. Integration with Quickbooks is extremely important to me, but I seem to have the reverse problem that most of the people on here are having (Yes, I just read all 336 posts on these 34 pages before asking my stupid questions ;-)
My issue is I am new to shopping carts in general, and already have my data in Quickbooks (specifically products, sans large descriptions like I am putting up on products on my Zen-Cart). Once I get all of my products into the cart, this is going to be awesome for me to be able to work with Quickbooks, as I have to maintain that as accurately as possible.
This is likely not the right place to ask this, but after inputting several product lines into my Zen to learn the features and functions, is there a relatively easy way to import products FROM my Quickbooks data (csv, excel, etc) into my products database of the shopping cart?
Again, I am learning the ins & outs of the cart software, but was gleefully hoping there would be a reasonably simple way to import blocks of inventory items without having to know several programming languages.
If anyone can point me in the right direction, I'd be much obliged!
-James
nomadRip
Try the Mod called Easypopulate
Regards
MG
Quote:
Originally Posted by MikeyG
Found it...hadn't thought to look for that term. Can't wait to try the Quickbooks contribution!:clap:
Thanks!
-James
I am a new non-programmer user of ZenCart which installed without problems using Fantastico. When I attempted to install QBI Quickbooks Import, however, I get the following message when I click on Quickbooks Import QBI in the Customer menu:
Warning: main(includes/qbi_app_top.php) [function.main]: failed to open stream: No such file or directory in /home/onenessw/public_html/store/admin/qbi_create.php on line 23
Fatal error: main() [function.require]: Failed opening required 'includes/qbi_app_top.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/onenessw/public_html/store/admin/qbi_create.php on line 23
I have checked that the file /store/admin/qbi_create.php is there but I don't know the directory reference /home/onenessw/public_html/ is correct. My store is installed in the www directory of my website I am trying to build at www.onenessweddingcandle.com.
What do I do now? If this question has been asked before please refer me to it. I have searched the thread for several of the strings in the error but have not found it. I admit that I have NOT read all 34 pages of posts - will do if that is necessary to fix this problem.
Harold:blink: