Quote Originally Posted by MikeyG View Post
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
I'm not sure what you mean by going back one version. I suggest you use 3.21b.

Some earlier versions had the issue you are describing -- if the value is zero, the variable isn't passed from the form. Try setting the field qbi_itemsqb_taxable to NULL instead of NOT NULL in MySQL, and use the latest version 3.21b.

In the UK your prices include the VAT, whereas in the US the price for each item does not include tax, and tax is added at the end. So, I am working on UK compatibility for the next major release of QBI, however I can't really take the time to help you make this version work with UK QB, as it won't!

Thanks,
Adam