Quickbooks Import QBI

Hi,

Quote:

---

Originally Posted by swingandmiss

Instead of dissabiling it, as I have a lot of customers that use it, should I just install QBI 3.76?

---

That would be the solution if you want the second address line with QBI (actually the current version is 3.78).

Thanks,
Adam

QBI version 3.76+ would be the commercial version, correct?

Quote:

---

Originally Posted by adam5532

Hi,

You don't say where you are getting these errors, but they aren't from QBI. None of these pages or functions are part of QBI.

I like to be helpful, but the amount of support that you seem to need is beyond what I am able or willing to give in this free forum - you must be over 20 posts now in a very short period. Out of respect for my time, this is where you get the paid version of QBI instead. Otherwise, you are on your own or maybe someone else in the forum will help you. I don't mean to sound rude at all, but I have limited time and want to make sure I have some left to help others here also.

Thanks,
Adam

---

I'd be in agreement with you were it not for the fact that this was the first question I asked, and for the fact that the only answers you've actually supplied up to now are "I'm not going to read that" and "you can't do that in QBI".

It is without a doubt very hard for you to find time to provide support, so of course paid members would take priority. All the same, thanks for your time.

In case anyone stumbles here with the same array issues, I found a solution. My web host upgraded to PHP5, making some of the code in catalog/admin/customers.php process incorrectly.

I originally thought this was due to implementing QBI, but I think it may have just been that I haven't needed to check out my customers page as of late. It likely starting showing errors as soon as my web host upgraded.


Find this:

$customer_info = array_merge($country->fields, $info->fields, $reviews->fields);

$cInfo_array = array_merge($customers->fields, $customer_info);


And change it to this:

$customer_info = array_merge((array)$country->fields, (array)$info->fields, (array)$reviews->fields);

$cInfo_array = array_merge((array)$customers->fields, (array)$customer_info);

Original info found here:

http://fstcs.net/blogs/ryansuzuki/ar...5-upgrade.aspx

Quote:

---

Originally Posted by tj1

QBI version 3.76+ would be the commercial version, correct?

---

Yes.
Currently, 3.50 and later is commercial. 3.76 is the first version that supports the second address line. 3.78 is the latest version.

Adam

i can save .iif files (from my admin website) of customer invoices and whatnot. When i save the file and try to import it with quickbooks, for every invoice is says error on line x (its many different numbers) if i keep clicking ok ok ok ok ok then finally is say import complete but it only imports the names and addresses of people and not their orders....can some one please help me

Hi,

Quote:

---

Originally Posted by thejollyroger9

i can save .iif files (from my admin website) of customer invoices and whatnot. When i save the file and try to import it with quickbooks, for every invoice is says error on line x (its many different numbers) if i keep clicking ok ok ok ok ok then finally is say import complete but it only imports the names and addresses of people and not their orders....can some one please help me

---

You have products in Zen Cart that are missing model numbers, discount items that aren't matched, and/or you have account fields that are not filled in on the QBI configure page. You MUST follow the manual and completely configure QBI before trying to import any orders.

Thanks,
Adam

ok thank you and none of the items import like i said just the customers and their addresses

Quote:

---

Originally Posted by thejollyroger9

ok thank you and none of the items import like i said just the customers and their addresses

---

Right. If you have any error in an order, the entire order will not import. The sum of the line items must equal the total. You need to read the manual and set everything up before trying to import orders.

Thanks,
Adam

I went ahead and created an all new store file in Quickbooks 2008 Pro.
I have opened up MySql and checked the products table, every single product has a product_model entry.
I have double and triple checked all of the configuration and matching settings.
I export the IIF file, and then go to import it into QB.
It imports the first 24 orders and then crashes on 25.
If I go into zen cart and look at order 25 I can not find any sort of info in the order that would be different from previous ones.

:frusty:

Quote:

---

Originally Posted by AlohaRover

I went ahead and created an all new store file in Quickbooks 2008 Pro.
I have opened up MySql and checked the products table, every single product has a product_model entry.
I have double and triple checked all of the configuration and matching settings.
I export the IIF file, and then go to import it into QB.
It imports the first 24 orders and then crashes on 25.
If I go into zen cart and look at order 25 I can not find any sort of info in the order that would be different from previous ones.

:frusty:

---

Try opening the file in Excel. Some errors I can see more easily in Excel and others I can see more easily in Zen Cart.

Quote:

---

Originally Posted by audradh

Try opening the file in Excel. Some errors I can see more easily in Excel and others I can see more easily in Zen Cart.

---

What sort of errors do you see when comparing ordersin Excel?

Thanks

Quote:

---

Originally Posted by AlohaRover

What sort of errors do you see when comparing ordersin Excel?

Thanks

---

I've gotta be honest, it has been a while since I have downloaded orders :ohmy:
From my memory full of cobwebs... I'm thinking most likely issues of the order not totalling properly.

Can you post the information from the excel entry? Maybe someone can pick out the trouble.

Hi,

Quote:

---

Originally Posted by AlohaRover

I went ahead and created an all new store file in Quickbooks 2008 Pro.
I have opened up MySql and checked the products table, every single product has a product_model entry.
I have double and triple checked all of the configuration and matching settings.
I export the IIF file, and then go to import it into QB.
It imports the first 24 orders and then crashes on 25.
If I go into zen cart and look at order 25 I can not find any sort of info in the order that would be different from previous ones.

:frusty:

---

Are you using QB Windows or Mac?

Open the iif in Excel. Your last order is at the end. The item section starts with TNRS, the total line, and then all the line items SPL. The line items must equal the negative of the total (AMOUNT column). Also, check that there are not any funny characters, quotes, apostrophes, etc that might confuse QB.

You may find an item missing, meaning you haven't matched discounts or some product. But this doesn't crash QB, so either it is probably some funny character, or you have QB Mac, which seems to crash on anything it doesn't like.

Thanks,
Adam

Win XP Pro SP2

Here is a bad record- I changed the name ;)

!CUST NAME BADDR1 BADDR2 BADDR3 BADDR4 BADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 PHONE1 PHONE2 FAXNUM EMAIL NOTE CONT1 CONT2 CTYPE TERMS TAXABLE TAXITEM LIMIT RESALENUM REP COMPANYNAME SALUTATION FIRSTNAME LASTNAME
CUST doe-31 john doe 123 main street Knoxville TN 37916 john doe 123 main street Knoxville TN 37916 615-504-4352 jd###################### John Doe Website Online N CO Sales Tax John Doe
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 NAMEISTAXABLE TERMS SHIPVIA REP FOB INVMEMO PAYMETH PONUM
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE PAYMETHOD EXTRA
!ENDTRNS
TRNS INVOICE 9/12/2008 Accounts Receivable Lindstrom-31 565 ebrs-34 N N john doe 123 main street Knoxville TN 37916 john doe 123 main street Knoxville TN 37916 N Online Federal Express MasterCard ebrs-34
SPL INVOICE 9/12/2008 Sales -550 CMMG Upper - 5.56 - 16' Lightweight MID - 1:7, ** This is a non-stock item**: Typically takes 2-4 weeks to ship N -1 550 CMMGU1605L7:Typically takes 2-4 weeks to ship N
SPL INVOICE 9/12/2008 N
SPL INVOICE 9/12/2008 Shipping and Delivery Income -15 Shipping N -1 15 Shipping N
SPL INVOICE 9/12/2008 Sales Tax Payable CO Sales Tax 0 N 7.40% CO Sales Tax N AUTOSTAX
ENDTRNS
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM PAYMETH MEMO
!SPL SPLID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM PAYMETH MEMO
!ENDTRNS
TRNS PAYMENT 9/12/2008 Undeposited Funds Smith-31 565 MasterCard Website
SPL PAYMENT 9/12/2008 Accounts Receivable Smith-31 -565 MasterCard Website
ENDTRNS

This is a good one :D

!CUST NAME BADDR1 BADDR2 BADDR3 BADDR4 BADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 PHONE1 PHONE2 FAXNUM EMAIL NOTE CONT1 CONT2 CTYPE TERMS TAXABLE TAXITEM LIMIT RESALENUM REP COMPANYNAME SALUTATION FIRSTNAME LASTNAME
CUST Smith-4 Mark Smith 123 main St Tucson AZ 85747 Mark Smith 123 main St Tucson AZ 85747 520-241-5620 mdw097########################## Mark Smith Website Online N CO Sales Tax Mark Smith
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 NAMEISTAXABLE TERMS SHIPVIA REP FOB INVMEMO PAYMETH PONUM
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE PAYMETHOD EXTRA
!ENDTRNS
TRNS INVOICE 8/25/2008 Accounts Receivable Smith-4 204.9 ebrs-2 N N Mark Smith 123 main St Tucson AZ 85747 Mark Smith 123 main St Tucson AZ 85747 N Online Federal Express MasterCard ebrs-2
SPL INVOICE 8/25/2008 Sales -189.95 ADM Scope Mount - RECON-X, Scope Ring Size: 1' N -1 189.95 AD-RECON-X:1' N
SPL INVOICE 8/25/2008 N
SPL INVOICE 8/25/2008 Shipping and Delivery Income -14.95 Shipping N -1 14.95 Shipping N
SPL INVOICE 8/25/2008 Sales Tax Payable CO Sales Tax 0 N 7.40% CO Sales Tax N AUTOSTAX
ENDTRNS
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM PAYMETH MEMO
!SPL SPLID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM PAYMETH MEMO
!ENDTRNS
TRNS PAYMENT 8/25/2008 Undeposited Funds Smith-4 204.9 MasterCard Website
SPL PAYMENT 8/25/2008 Accounts Receivable Smith-4 -204.9 MasterCard Website
ENDTRNS

Quote:

---

Originally Posted by adam5532

Hi,

Are you using QB Windows or Mac?

Open the iif in Excel. Your last order is at the end. The item section starts with TNRS, the total line, and then all the line items SPL. The line items must equal the negative of the total (AMOUNT column). Also, check that there are not any funny characters, quotes, apostrophes, etc that might confuse QB.

---

Adam,

I have an item attribute

Quote:

---

** This is a non-stock item**

---

For many of my items.

Looks like all of the orders that bomb have an item with this attribute in it.

I am going to get rid of that attribute, re down load and try again.

Keeping my fingers crossed :D

dbl post

Quote:

---

Originally Posted by AlohaRover

Adam,

I have an item attribute



For many of my items.

Looks like all of the orders that bomb have an item with this attribute in it.

I am going to get rid of that attribute, re down load and try again.

Keeping my fingers crossed :D

---

OK.

And please, upload iif files as attachments. As you can see, if you put them in the body of the message there are no columns and they are impossible to read.

Thanks,
- Adam

Adam,

Or anyone...

First off, thank you Adam I just started with both quickbooks and this mod today. My head is spinning, but i do truely appreciate this mod.

I was curious though, for us drop-shippers.. Is there away to import the orders to Quickbooks as Purchase orders? That would prove to be so much more efficient for me..

Thanks!

Quote:

---

Originally Posted by litepockets

Adam,

Or anyone...

First off, thank you Adam I just started with both quickbooks and this mod today. My head is spinning, but i do truely appreciate this mod.

I was curious though, for us drop-shippers.. Is there away to import the orders to Quickbooks as Purchase orders? That would prove to be so much more efficient for me..

Thanks!

---

Currently no, but yes I have future plans to do that. This will be added to the commercial but not the free version.

Thanks,
Adam

Thank you Adam. I have QBI working perfectly right now it seems. I might check out the differences between the commercial and free version to see if I could benefit any more from it. Overall I am happy with this module so far.

Adam,

Curious to hear your plans moving forward with QBI with the release of ZC2? Any plans for a free QBI for use with ZC2 with the same current features?

I proceeded to export the customer, products , and orders. When trying to import to QBs the customers and products seems to work fine, however there are some fields in Quick book not getting fill, like in products the QTY is zero even though when i open the file in excel there is a value in the QNTY column and problem i am having is when i import the orders Iff file i received error:

Error on Line 11 : Can't record invalid transaction

Hit ok and get

Transaction not in balance , make sure the amounts in the detail area on the form for this transaction equals the amount at the top of the form

I get this set of errors several times. however the orders only contain the customer information.

I am using Quick book premier 2009 and zencart 1.3.8

Quote:

---

Originally Posted by lextechs

I proceeded to export the customer, products , and orders. When trying to import to QBs the customers and products seems to work fine, however there are some fields in Quick book not getting fill, like in products the QTY is zero even though when i open the file in excel there is a value in the QNTY column

---

Currently QBI does not add inventory when you import products. Since QB is an accounting system, inventory can not be just added without a transaction taking place. Either a Purchase Order, or a stock adjustment going to some account. In order to do this, QB needs to know the cost of each item, not the selling price, and the cost is not something that Zen Cart keeps track of. In short, you are going to have to edit the descriptions and vendor information for each product anyway, so you can also add inventory at that point.

Quote:

---

and problem i am having is when i import the orders Iff file i received error:

Error on Line 11 : Can't record invalid transaction

Hit ok and get

Transaction not in balance , make sure the amounts in the detail area on the form for this transaction equals the amount at the top of the form

---

You have a product with no model number, tax rates not correctly entered into QBI, or discounts that you have not set up. If you look at the iif file, you'll see what it missing. Line 11 is the END of the affected transaction. Make sure you have completely set up QBI before trying to create iif files.

Thanks,
Adam

Hi,

Quote:

---

Originally Posted by litepockets

Adam,

Curious to hear your plans moving forward with QBI with the release of ZC2? Any plans for a free QBI for use with ZC2 with the same current features?

---

QBI commercial and free versions will definitely be made compatible with ZC2. I'm not sure yet of the feature set for the free version. It will of course be reduced from the commercial version. The code will likely be based on the commercial version, and like the commercial version it would be installed in its own directory. Until the beta of ZC2 is available, I won't know what adjustments will be needed. Since QBI 3.50+ resides in its own directory, it is only affected by the database structure and is completely unaffected by Zen Cart code.
- Adam

Quote:

---

Originally Posted by adam5532

Currently QBI does not add inventory when you import products. Since QB is an accounting system, inventory can not be just added without a transaction taking place. Either a Purchase Order, or a stock adjustment going to some account. In order to do this, QB needs to know the cost of each item, not the selling price, and the cost is not something that Zen Cart keeps track of. In short, you are going to have to edit the descriptions and vendor information for each product anyway, so you can also add inventory at that point.

---

There is a cost profit mod for zencart where you can enter your cost and % of markup and it calculates the selling price is there a way to incorparted that mod into OBI so it can get the cost as you mention above?

Quote:

---

Originally Posted by adam5532

You have a product with no model number, tax rates not correctly entered into QBI, or discounts that you have not set up. If you look at the iif file, you'll see what it missing. Line 11 is the END of the affected transaction. Make sure you have completely set up QBI before trying to create iif files.

Thanks,
Adam

---

I will have to look into how quick books is set up i am fairly new at using it.

Thanks for you help

Adam, thank you very much for providing support on this wonderful mod. I am a new user to this mod and currently using ZC1.3.6 and QB2009 Pro.

Since i have been manually typing in all the orders previously, I don't want to re-import everything. How do I just import the orders that happened in the last 30 days? I did get the iif file when I create a file for all past orders. I am wondering which program I can use to truncate out the previous orders that I don't want to import. Thanks

I got another question. My item was set up to use accessories as the attribute (only one attribute). There are few values associated with the "accessory" attribute. When I tried to match the items in the QBI with quickbook import, only accessories attached with main item is showing up. Then, when I tried to export the iif file, there is no replacement of product evem though they have been set in the match. As result, those imported items are showing up in my QB pro as new service. How do I get around to fix this? Any help is greatly appreciated.

Is it possible to include the customer email address as part of the 'Customer Name' in quickbooks?

I would like to pass the name as 'Last, First - email'

Thanks

Sorry, I have another question.

Where else does QBI store settings?

I had installed QBI a long time when one of the very early version was released.
I never really used it more than a couple of times, but never removed the tables, all the files were deleted though.

Now I just downloaded the latest version, I dropped all the existing tables prefixed qbi_ in the database and then installed the new version. After installing and configuring, I go the Create IFF page and I see the following and was wondering where it got those records if I dropped all the tables:
-----------
New Orders
Quan: 20
No.: 2698 to 3863
Date: Jul 8, 2008 9:59 pm to Mar 5, 2009 1:34 am

Previous Batch of Orders
Quan: 2
No.: 1270 to 1271
Date: Jul 8, 2006 2:54 pm to Jul 10, 2006 12:39 am
----


Thanks

Quote:

---

Originally Posted by tj1

Is it possible to include the customer email address as part of the 'Customer Name' in quickbooks?

I would like to pass the name as 'Last, First - email'

Thanks

---

No, it is not one of the template options. Never been asked for, and I don't think it would be advisable.

Adam

Quote:

---

Originally Posted by tj1

Sorry, I have another question.

Where else does QBI store settings?

I had installed QBI a long time when one of the very early version was released.
I never really used it more than a couple of times, but never removed the tables, all the files were deleted though.

Now I just downloaded the latest version, I dropped all the existing tables prefixed qbi_ in the database and then installed the new version. After installing and configuring, I go the Create IFF page and I see the following and was wondering where it got those records if I dropped all the tables:
-----------
New Orders
Quan: 20
No.: 2698 to 3863
Date: Jul 8, 2008 9:59 pm to Mar 5, 2009 1:34 am

Previous Batch of Orders
Quan: 2
No.: 1270 to 1271
Date: Jul 8, 2006 2:54 pm to Jul 10, 2006 12:39 am
----


Thanks

---

One field is added to the Orders and Products tables to keep track of what has been imported. Those fields still remained.

Adam

Thanks for the previous replies.


One more question, where do you configure the non-taxable item name?

In quickbooks I have 'CA sales tax' as the taxable sales tax item and 'Out of state' as the non-taxable one.

When QBI imports out of state customers, the customer tax code is imported as non-taxable, but the tax item is still set to 'CA sales tax'.

Quote:

---

Originally Posted by tj1

Thanks for the previous replies.


One more question, where do you configure the non-taxable item name?

In quickbooks I have 'CA sales tax' as the taxable sales tax item and 'Out of state' as the non-taxable one.

When QBI imports out of state customers, the customer tax code is imported as non-taxable, but the tax item is still set to 'CA sales tax'.

---

Currently QBI only handles one QB tax item. Your out-of-state orders will show CA Sales Tax as the tax item, but the amount will be zero. This is inconsequential as far as accounting goes - actually some people prefer it this way. It is on the feature to-do-list to add multiple tax item capability and a no-tax tax item.

Thanks,
Adam

Thanks again for all your help answering my questions.
No big deal about one tax item limitation. I only get 10 - 20 orders per day so I have no problem changing the correct tax item manually (I also have many customers with resale tax item)


One more question, regarding importing orders paid with GoogleCheckout. I thought I had this figured out and configured correctly, but it doesn't seem to be working.
I read in another post by you that the 'Import PayPal orders with status:' setting could be used to import orders for other payment methods with different status.
The GoogleCheckout status for new orders is 'Google New'
I've set the 'Import PayPal orders with status:' setting to 'Google New'; however, QBI is still not importing GoogleCheckout orders.

Is there some other setting I need to change?

Hi,

Quote:

---

Originally Posted by tj1

The GoogleCheckout status for new orders is 'Google New'
I've set the 'Import PayPal orders with status:' setting to 'Google New'; however, QBI is still not importing GoogleCheckout orders.

Is there some other setting I need to change?

---

Yes. In Setup Payments, you need to set your Google payment method in QB to "Paid with PayPal", and then make sure that in Match Payments, your GoogleCheckout method is matched to the QB Google payment method.

- Adam

I have another question :)

This is regarding importing descriptions with quotation marks ( " ).
When the QBI file is imported into quickbooks quotation marks are imported as apostrophes.

Is this due to QBI or just how quickbooks imports things?
This creates a small issue for me because I use quotation marks to denote inches and I sell some products by the inch. So the imported description has the apostrophe which denotes feet and I have to change that manually.

Quote:

---

Originally Posted by tj1

I have another question :)

This is regarding importing descriptions with quotation marks ( " ).
When the QBI file is imported into quickbooks quotation marks are imported as apostrophes.

Is this due to QBI or just how quickbooks imports things?
This creates a small issue for me because I use quotation marks to denote inches and I sell some products by the inch. So the imported description has the apostrophe which denotes feet and I have to change that manually.

---

Unfortunately quotation marks in the iif file can cause problems for QB. QBI changes them for this reason. Hopefully you will be able to use ft and in.

Adam

Adam, regarding importing GoogleCheckout orders, this is still not working for me.
This are the settings I have:

Configure>Import PayPal orders with status:
Google New

Setup>Payment>GoogleCheckout:
Paid w PayPal

Am I missing some other setting?

Thanks.

Hi,

Quote:

---

Originally Posted by tj1

Adam, regarding importing GoogleCheckout orders, this is still not working for me.
This are the settings I have:

Configure>Import PayPal orders with status:
Google New

Setup>Payment>GoogleCheckout:
Paid w PayPal

Am I missing some other setting?

Thanks.

---

You also need to do Match>Payments and match Google Checkout to Google New.

- Adam

For Match>Payments, I have:
GoogleCheckout (googlecheckout): GoogleCheckout

There's no 'Google New' here.

Hi Adam,

I'm using Zencart 1.3.8 and QBI.

I am receiving a message "error on line 12" when importing orders. I have verified that all my items have model #'s and I am pretty sure this is because I am using a low order fee.

I uploaded my iif files to QBI and I went to Match the low order fee to my Handling Charge which is used in Quickbooks, but it is not in the list. In our Quickbooks, the handling fee is listed under Sales:Services. How can I direct the low order fee to this account?

Thanks!

Quote:

---

Originally Posted by tj1

For Match>Payments, I have:
GoogleCheckout (googlecheckout): GoogleCheckout

There's no 'Google New' here.

---

Yes, that's what I meant. Google New was an error.

Adam

Quote:

---

Originally Posted by iscatech

Hi Adam,

I'm using Zencart 1.3.8 and QBI.

I am receiving a message "error on line 12" when importing orders. I have verified that all my items have model #'s and I am pretty sure this is because I am using a low order fee.

I uploaded my iif files to QBI and I went to Match the low order fee to my Handling Charge which is used in Quickbooks, but it is not in the list. In our Quickbooks, the handling fee is listed under Sales:Services. How can I direct the low order fee to this account?

Thanks!

---

Handling Charge must be item type "Other Charge" in QB to show up on the matching list. Or else create a new item in QB called Low Order Fee of type Other Charge, and upload your lists again into QBI.

Adam

I want to install QBI Quickbooks Import for a client who just upgraded to Quickbooks 2009. The module documentation states "Quickbooks Pro 2004 – 2007 (US Version) (versions back to 1998 should work also but are not supported)". Will it work with Quickbooks 2009?

~anne

I've been using the paid version of QBI for awhile now, and I love it, but I still have a few issues:

Is there any way to account for different tax rates? Our state requires one tax rate for the county you live in, but if you sell to a different county, you just need to pay the base tax rate for the state -- no county taxes included. So, my site uses a mod that checks by zip code to see if you are in LA County. If you are, we charge a higher tax rate. If you are in another county, we charge a lower tax rate. And, if you aren't in California, we don't charge any tax at all. The problem is that when it comes time to pay our sales taxes, the Board of Equalization wants us to break our taxes down into two categories -- in our county or not in our county. We can't seem to do this as QBI is setup now to assign all taxes, no matter what rate they are at or name they are, to one tax type in Quickbooks. Even if we could find some workaround where we could separate taxes by rate instead of name, that would solve our problem. Any ideas? Can QBI do this? If not, can Quickbooks somehow differentiate between two different tax rates that are assigned to the same tax type?

Lastly, and this isn't really a problem with QBI as it is an issue with credit card processing and quickbooks, has anyone figured out how to deal with batches of credit card transactions? It's been very time consuming to match up the batch deposits with transactions. If there were some way to automate this so that each batch gets deposited automatically, that would be so much easier. Authorize.net has a QBI export function, but as far as I can tell, all it does is what QBI does. I'd somehow need it to export batch information and then match that up with sales receipts to automatically make the batch credit card deposits for us. That would be SO much easier. Anyone ever figure out a way to do this?

Thanks for the help in advance!

Quote:

---

Originally Posted by seattleannie

I want to install QBI Quickbooks Import for a client who just upgraded to Quickbooks 2009. The module documentation states "Quickbooks Pro 2004 – 2007 (US Version) (versions back to 1998 should work also but are not supported)". Will it work with Quickbooks 2009?

~anne

---

Yes, it also works with QB Pro 2008 and 2009.

- Adam

Quote:

---

Originally Posted by srturner47

I've been using the paid version of QBI for awhile now, and I love it, but I still have a few issues:

---

Issues for the paid version of QBI need to be submitted as a support ticket at http://www.qbisoftware.com/support.

But I'll briefly answer, since this applies to both versions:

Quote:

---

Is there any way to account for different tax rates? ... Can QBI do this? If not, can Quickbooks somehow differentiate between two different tax rates that are assigned to the same tax type?

---

QBI currently only handles one tax rate (plus none for out-of-state). Multiple tax rates are planned for a future release. There is no work-around that I can think of. The tax rate in QBI must match the rate in QB or the orders won't import.

Quote:

---

Lastly, and this isn't really a problem with QBI as it is an issue with credit card processing and quickbooks, has anyone figured out how to deal with batches of credit card transactions?

---

There's nothing much you can do, as batching is up to the bank and out of your control. The best thing is to reconcile daily, so that it is evident what sales are grouped by the amount. If you get stuck, you can examine the records at authorize.net and at your merchant card services, which will break down the sales in each batch.

- Adam

Has anyone been able to successfully download orders for two different order status? If so, what settings do you have?


I need to download GoogleCheckout orders, which have the 'Google New' status in addition to regular orders with 'pending' status. I seem to have the correct settings, but QBI is not importing this orders.

Thanks for any info on this.

Is there an easy way to match and import attributes?

I only have one attribute, but I'm having a lot of trouble. Maybe I'm missing some important step that might make this easier.

The attribute is for engravable text.

I have about 15,000 items on my site and about 1000 of them have this attribute.
I can't do matching manually for this many items.

At the matching page, QBI lists items like
EngravableItem1:Text
EngravableItem2:Text
EngravableItem3:Text
...etc

In QuickBooks I just have one service item called EngraveService.

Is it possible to just import the Text attribute as a separate item matched to the EngraveService item in QB?

The way this is importing right now is QBI is automatically creating hundreds of sub-items in quickbooks, this is creating a big mess.

Or if not possible to import the attribute as a separate item, can QBI just match to the item number without creating a sub-item?
For example, currently QBI does something like this
Engravable1:Text
Is imported in QB as
Engravable1
- variable subitem with text input


More appropriate behavior would be to just match Engravable1:Text to Engravable1. No creating sub-items, just include the attribute as the item description.


Thanks.

Hi,

Quote:

---

Originally Posted by tj1

Is there an easy way to match and import attributes?

I only have one attribute, but I'm having a lot of trouble. Maybe I'm missing some important step that might make this easier.

The attribute is for engravable text. ...

---

All the features you mention for handling engraved or personalized items are available in the paid version of QBI, but not in the free version.

Thanks,
Adam

Hi all,
Sorry if this has been posted somewhere already, but I've spent most of the morning looking for an answer and cannot find anything specific to this issue.

I've followed the procedures on installing qbi_v3_21b_zen and I am now at the point of setting up the initial configuration options. After configuring all the option and clicking on "update" to submit the form, I get the following message:

Code:

---

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='1',qbi_dl_file='1',qbi_prod_rows='5',prods_sort='0',item_width='48',qbi_log='1',orders_status_import='2',qbi_status_update='1',qbi_cc_status_select='2',qbi_mo_status_select='1',qbi_email_send='1',qbi_cc_clear='0',orders_docnum='%I',orders_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='1',cust_default='0',cust_default_name='',invoice_acct='Accounts Receivable',invoice_salesacct='Undeposited Funds',invoice_toprint='1',invoice_pmt='1',invoice_termscc='PayPal',invoice_terms='Check',invoice_rep='',invoice_fob='',invoice_class='',invoice_comments='1',invoice_message='Thank you very much!',invoice_memo='',item_acct='Sales',item_asset_acct='Inventory Asset',item_class='',item_cog_acct='Cost of Goods Sold',item_cart_lang='0',item_match_i in C:\apache\htdocs\store\ADMIN_NAME_REMOVED\includes\classes\qbi_mysql.php on line 119

---

Additional Info:
* Apache/2.2.9 (Win32) PHP/5.2.6
* MySQL client version: 5.0.51a
* PHP extension: mysql

Does anyone have any pointers on where to start looking?

Thanks

Quote:

---

Originally Posted by jwitt98

Hi all,
Sorry if this has been posted somewhere already, but I've spent most of the morning looking for an answer and cannot find anything specific to this issue.

I've followed the procedures on installing qbi_v3_21b_zen and I am now at the point of setting up the initial configuration options. After configuring all the option and clicking on "update" to submit the form, I get the following message:

Code:

---

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='1',qbi_dl_file='1',qbi_prod_rows='5',prods_sort='0',item_width='48',qbi_log='1',orders_status_import='2',qbi_status_update='1',qbi_cc_status_select='2',qbi_mo_status_select='1',qbi_email_send='1',qbi_cc_clear='0',orders_docnum='%I',orders_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='1',cust_default='0',cust_default_name='',invoice_acct='Accounts Receivable',invoice_salesacct='Undeposited Funds',invoice_toprint='1',invoice_pmt='1',invoice_termscc='PayPal',invoice_terms='Check',invoice_rep='',invoice_fob='',invoice_class='',invoice_comments='1',invoice_message='Thank you very much!',invoice_memo='',item_acct='Sales',item_asset_acct='Inventory Asset',item_class='',item_cog_acct='Cost of Goods Sold',item_cart_lang='0',item_match_i in C:\apache\htdocs\store\ADMIN_NAME_REMOVED\includes\classes\qbi_mysql.php on line 119

---

Additional Info:
* Apache/2.2.9 (Win32) PHP/5.2.6
* MySQL client version: 5.0.51a
* PHP extension: mysql

Does anyone have any pointers on where to start looking?

Thanks

---

I finally found the solution to this problem in a post by Adam here:
http://www.qbisoftware.com/forum/vie...ax_lookup#p323

Once I remove the 'tax_lookup' column from the array, it worked fine.

Thanks for the helpful response adam5532! I did a little digging through the code and figured out how to charge different sales tax rates with qbi. It takes a little coding, but if you are at all handy with php, its really fairly straight forward. While I know nothing about the .iif format, you can easily tell what variables need to be changed due to adam5532's careful and deliberate coding! (Wish my coding was that organized!)

The function you'll want to edit is in admin/includes/classes/qbi_classes_out_iif.php. You'll want to find where the function tax_us($cust,$order) is. Everything is pretty straight forward once you've figured out that this is the function that does the tax magic! If you need to do any SQL queries to determine which tax rate to use, $order['orders_id'] is the order id you'll need to use after the "WHERE" part of the SQL query.

Thanks for your great work on this adam5532! I'm impressed with how you kept the main code very sparse and relied almost entirely on functions. You're a very neat and tidy coder! I'll definitely be purchasing the new version with the tax codes when you release it -- it will make changing tax codes a cinch in the future, so it will be well worth it. In the meantime, my little hack will suffice! :)

Is the function clean_iif_data applied to the product model?

The reason I ask is because I have many products that have an underscore in the model and I'm looking for a way to remove that when imported into quickbooks.
I figure if the clean_iif_data is being applied to the product model, I can simply add a line there to remove the underscores.

Thanks.

Quote:

---

Originally Posted by tj1

Is the function clean_iif_data applied to the product model?

The reason I ask is because I have many products that have an underscore in the model and I'm looking for a way to remove that when imported into quickbooks.
I figure if the clean_iif_data is being applied to the product model, I can simply add a line there to remove the underscores.

Thanks.

---

clean_iif_data is in the qbi_functions.php file, and calls the following other functions:
remove_returns_and_tabs_array
strip_tags_array
convert_quotes_array

Each of these processes all the data going to the iif file. So, you could add a new function to it (see the others as a model), but it would remove underscores from everything, not just the model.

Otherwise, you could modify the code in the guts, but I'm not going to step you through that.

Or, you could put your function in the qbi_classes_out_iif.php file, although design-wise that's just an output formatting file and code that manipulates the data shouldn't go there.

The last and best way of course would be for you to just run an SQL statement (REPLACE) on your database and remove all the underscores from your model numbers in Zen Cart, so they match QB.

Adam

Thanks for the clarification, adding the function to remove underscore will work just fine.
The only place I have underscore is at the end or beginning of some product models and nowhere else. These are duplicate products, limited quantity on sale, so I use the underscore to easily distinguish that.

Thanks again.

Quote:

---

Originally Posted by tj1

Thanks for the clarification, adding the function to remove underscore will work just fine.
The only place I have underscore is at the end or beginning of some product models and nowhere else. These are duplicate products, limited quantity on sale, so I use the underscore to easily distinguish that.

Thanks again.

---

Then this should work:

Add to function clean_iif_data:

Code:

---

$var=remove_underscore_array($var);

---

Add function:

Code:

---

function remove_underscore_array(&$var) {
        if (is_array($var)) {
                array_walk($var,'remove_underscore_array');
        } else {
                $var=str_replace('_','',$var);
        }
        return $var;
}

---

Thanks,
Adam

Wow, thanks for taking the time to write that extra function, although I had already implemented that before my last post.

Thanks for the great support and great contribution. I've been able to find workarounds for some of the limitations by making very minor changes or commenting something out.
This has allowed me to import as estimates, which can then be used to create sales orders.
Also, attributes are now imported only as part of the product description, without creating endless subitems in Quickbooks.
If anyone needs this let me know and I'll post what I did.


Now all I need is to figure out how to import orders paid with GoogleCheckout.

HI

Does anyone know how to solve this issue with the QBI import

Install QBI database tables for version 3.21?



Registered to: QBI_USER_NAME, QBI_USER_COMPANY #QBI_USER_REGNO
QBI 3 for Zen-Cart Copyright ©2004, 2005, 2006 by Adam Liberman
Distributed under the terms of version 2 or later of the GNU General Public License

As soon as I try to install the data tables i get the following

Error: SQL file not found

Can anyone please advise

Many thanks
Justin

ok, I looked and searched thru bunches of pages and cant find what I need help with...prob easy fix.

i installed this mod, everything seems working fine. but when i try to puch the links across the top: create iif, setup, match, config, and support...they all point to a nonexistant link. where do i change this to make it match my site?

Quote:

---

Originally Posted by jrev0

HI

Does anyone know how to solve this issue with the QBI import

Install QBI database tables for version 3.21?



Registered to: QBI_USER_NAME, QBI_USER_COMPANY #QBI_USER_REGNO
QBI 3 for Zen-Cart Copyright ©2004, 2005, 2006 by Adam Liberman
Distributed under the terms of version 2 or later of the GNU General Public License

As soon as I try to install the data tables i get the following

Error: SQL file not found

Can anyone please advise

Many thanks
Justin

---

Are the SQL files actually there where you installed QBI or not?

Thanks,
Adam

Quote:

---

Originally Posted by fusionsp

ok, I looked and searched thru bunches of pages and cant find what I need help with...prob easy fix.

i installed this mod, everything seems working fine. but when i try to puch the links across the top: create iif, setup, match, config, and support...they all point to a nonexistant link. where do i change this to make it match my site?

---

QBI gets the file paths from your Zen Cart set-up, so if the links are wrong you may have an incorrect path in your Zen Cart config file.

What are the links that the menus point to now?

Thanks,
Adam

Quote:

---

Originally Posted by adam5532

QBI gets the file paths from your Zen Cart set-up, so if the links are wrong you may have an incorrect path in your Zen Cart config file.

What are the links that the menus point to now?

Thanks,
Adam

---

Yea thats what i figured. i have looked in a bunch of places and am unable to find them yet.

right now they point to...http://admin/qbi_create.php for example

i understand that it needs to be elsewhere but i dont know how to change the link. Help please:blink:

Hi,

Quote:

---

Originally Posted by fusionsp

Yea thats what i figured. i have looked in a bunch of places and am unable to find them yet.

right now they point to...http://admin/qbi_create.php for example

i understand that it needs to be elsewhere but i dont know how to change the link. Help please:blink:

---

The web and file system constants are set in /catalog/admin/includes/qbi_app_top.php. There's a section near the top called "User Area".

The one that affects the menus is:

[FONT="Courier New"]define('DIR_QBI_WS', DIR_WS_ADMIN); // (full web path from www root)[/FONT]

so as you can see, if DIR_WS_ADMIN is wrong in Zen Cart, it will be wrong in QBI. If you must, you can replace DIR_WS_ADMIN with a hard-coded location.

Thanks,
Adam

hi

Im still unsure to what im meant to being filling into the qbi_app_top.php

Ive found the 2 areas in question

define('DIR_QBI_WS', DIR_WS_ADMIN); // (full web path from www root)
define('DIR_QBI_FS', DIR_FS_ADMIN); // (full virtual file path)

What do i insert here, ive installed all the database patches etc.

Hope you can help as this has really confused me.

Thanks

Justin

Quote:

---

Originally Posted by adam5532

Hi,

The web and file system constants are set in /catalog/admin/includes/qbi_app_top.php. There's a section near the top called "User Area".

The one that affects the menus is:

[FONT="Courier New"]define('DIR_QBI_WS', DIR_WS_ADMIN); // (full web path from www root)[/FONT]

so as you can see, if DIR_WS_ADMIN is wrong in Zen Cart, it will be wrong in QBI. If you must, you can replace DIR_WS_ADMIN with a hard-coded location.

Thanks,
Adam

---

ok forgive me but i still am unable to figure out the correct way to write this.

i have tried 10 different ways an im still lost. right now i have the following
define('DIR_QBI_WS', DIR_WS_ADMIN,'/admin/'); // (full web path from www root)
define('DIR_QBI_FS', DIR_FS_ADMIN,'/www/fusionspiritualemporium/admin/'); // (full virtual file path)

i must have not installed zencart correct from the beginning. someone please help. :frusty:

Quote:

---

Originally Posted by fusionsp

ok forgive me but i still am unable to figure out the correct way to write this.

i have tried 10 different ways an im still lost. right now i have the following
define('DIR_QBI_WS', DIR_WS_ADMIN,'/admin/'); // (full web path from www root)
define('DIR_QBI_FS', DIR_FS_ADMIN,'/www/fusionspiritualemporium/admin/'); // (full virtual file path)

i must have not installed zencart correct from the beginning. someone please help. :frusty:

---

Replace the existing constant -- don't add a third one. Try this:

define('DIR_QBI_WS', '/admin/'); // (full web path from www root)
define('DIR_QBI_FS', '/www/fusionspiritualemporium/admin/'); // (full virtual file path)

Again, this shouldn't be necessary if DIR_WS_ADMIN and DIR_FS_ADMIN are set correctly in the Zen Cart config file.

- Adam

Quote:

---

Originally Posted by adam5532

Replace the existing constant -- don't add a third one. Try this:

define('DIR_QBI_WS', '/admin/'); // (full web path from www root)
define('DIR_QBI_FS', '/www/fusionspiritualemporium/admin/'); // (full virtual file path)

Again, this shouldn't be necessary if DIR_WS_ADMIN and DIR_FS_ADMIN are set correctly in the Zen Cart config file.

- Adam

---

ok maybe I shoud be changing the zencart config file? I changed it to what you said and now i have an error. Where is the config file? Where do i set the DIR_WS_ADMIN and DIR_FS_ADMIN at?

here is the error i get now:
Warning: require_once(/www/fusionspiritualemporium/admin/includes/classes/qbi_mysql.php) [function.require-once]: failed to open stream: No such file or directory in /home2/fusionsp/public_html/admin/includes/qbi_app_top.php on line 54

Fatal error: require_once() [function.require]: Failed opening required '/www/fusionspiritualemporium/admin/includes/classes/qbi_mysql.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home2/fusionsp/public_html/admin/includes/qbi_app_top.php on line 54

Hi,

Quote:

---

Originally Posted by fusionsp

ok maybe I shoud be changing the zencart config file? I changed it to what you said and now i have an error. Where is the config file? Where do i set the DIR_WS_ADMIN and DIR_FS_ADMIN at?

---

Ok. Put QBI back the way it was before you changed it.

Go to:
/store/admin/includes/configure.php

Normally it should be as follows (replace mydomain with your own domain):
- Adam

Code:

---

define('HTTP_SERVER', 'http://www.mydomain.com');
  define('HTTPS_SERVER', 'https://www.mydomain.com');
  define('HTTP_CATALOG_SERVER', 'http://www.mydomain.com');
  define('HTTPS_CATALOG_SERVER', 'https://www.mydomain.com');

  // Use secure webserver for catalog module and/or admin areas?
  define('ENABLE_SSL_CATALOG', 'false');
  define('ENABLE_SSL_ADMIN', 'false');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
  // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
  define('DIR_WS_ADMIN', '/storezen/admin/');
  define('DIR_WS_CATALOG', '/storezen/');
  define('DIR_WS_HTTPS_ADMIN', '/storezen/admin/');
  define('DIR_WS_HTTPS_CATALOG', '/storezen/');

---

Wow that was alot of work for a simple fix. Thanks Adam for your help. Its all working now. But one last question, I went to your site and registered at the esupport link. Where does it spit out the registration number so i can get rid of the "this copy is not registered line"?

ok last question for a while, i promise. I am just getting ready to finally open my site for business. Currently I have 4 "customers" listed in zencart in QBI, but obviously none have bought anything yet. When i try to import them, it says import successful. But when I open quickbooks customer lists, it doesnt have any listed? Is the reason due to them not technically buying anything? Or shoudnt it import them anyways?

Hi,

Quote:

---

Originally Posted by fusionsp

Wow that was alot of work for a simple fix. Thanks Adam for your help. Its all working now. But one last question, I went to your site and registered at the esupport link. Where does it spit out the registration number so i can get rid of the "this copy is not registered line"?

---

I never got around to setting up the registration system for the free version of QBI. The support registration at www.qbisoftware.com is for users of the paid version. The message will not affect the operation of QBI. One of these days I will look back at my code for 3.21 and see what it wants as an acceptable registration number. The other thing you could do is do a search for that warning text in the QBI language files and then delete the text and just leave the opening and closing quotes.

- Adam

Hi,

Quote:

---

Originally Posted by fusionsp

ok last question for a while, i promise. I am just getting ready to finally open my site for business. Currently I have 4 "customers" listed in zencart in QBI, but obviously none have bought anything yet. When i try to import them, it says import successful. But when I open quickbooks customer lists, it doesnt have any listed? Is the reason due to them not technically buying anything? Or shoudnt it import them anyways?

---

This is a source of some confusion. The customers count displayed on the Create page is the total customers. However, the Customers download will only include customers who have placed orders.

This is being improved in paid version 3.80, which is about to be released. This version lets you choose customers with orders, customers without orders, and customers without accounts (who placed orders, for the PWA contribution), in any combination. Also, the count on the Create page will be correct, according to the options chosen.

Note that in normal operation, it is not necessary to use the Customers download feature, as customers are always added or updated along with their orders. One reason to use it is if you have a store that has operated for some time, but just started using Quickbooks, and you want to bring all your existing customers into Quickbooks (without importing all their past orders).

Thanks,
Adam

Quote:

---

Originally Posted by adam5532

Hi,

This is a source of some confusion. The customers count displayed on the Create page is the total customers. However, the Customers download will only include customers who have placed orders.

This is being improved in paid version 3.80, which is about to be released. This version lets you choose customers with orders, customers without orders, and customers without accounts (who placed orders, for the PWA contribution), in any combination. Also, the count on the Create page will be correct, according to the options chosen.

Note that in normal operation, it is not necessary to use the Customers download feature, as customers are always added or updated along with their orders. One reason to use it is if you have a store that has operated for some time, but just started using Quickbooks, and you want to bring all your existing customers into Quickbooks (without importing all their past orders).

Thanks,
Adam

---

ok thanks. So how much is the paid for version going for now? is there a list of updates that you have done vs the free one? Is it easily upgraded to a new version?

Thanks again for making this module and continuing to support it even though its free

Quote:

---

Originally Posted by fusionsp

ok thanks. So how much is the paid for version going for now? is there a list of updates that you have done vs the free one? Is it easily upgraded to a new version?

Thanks again for making this module and continuing to support it even though its free

---

I can't discuss that here, but you can get that information at the qbisoftware website.

Thanks,
Adam

hello everyone,

not sure if this is the right place to post this or not...

i am currently setting up a site using zen cart. i have used zen cart in the past and really like it. my only concern for this particular project is the ability to bring data from zen cart into quickbooks. it is my understanding that this add-on (QBI) is pretty complex to implement. so i am wondering how it is working for people? does it require tons of configuration? is it working reliably after it is installed?

if i am not certain of the add-on, i may have to switch to a different cart solution. booooo.

thank you so much for your feedback.

It's actually very easy to set up, configure and use; especially if you use the same product model in ZenCart as the item name in Quickbooks, you don't have to do any product matching.

It took me about 1 hour to set up, configure and learn how it works.

Can anyone give me some advise about making this work with paypal pro -- everything that I have tried all my orders are imported as Invoices and I need them to be sales receipts?

Second is there a way to import the paypal fees with each order?

Hi, I am in Australia and looking at accounting packages for my new business. I am nearly finished setting up my zencart store and was wondering if this add on is suitable for the Australian versions of quickbooks? Is anyone down under using it? Thanks........Hopeful

Quote:

---

Originally Posted by poolfiltersusa

Can anyone give me some advise about making this work with paypal pro -- everything that I have tried all my orders are imported as Invoices and I need them to be sales receipts?

---

Check if PayPal Pro has been added properly to the qbi_paycart db table. The payment module and the payment text in qbi_paycart must match the module and text in your orders table.

If you have to make any modifications to qbi_paycart, then coment out $matching=new match($dbqbi); in the file qbi_pay.php. This will disable the automatic detection which will over-write your changes.

Make sure that Set Up Payment and Match Payment are done properly, and that you have set the Configuration option "Import Orders As" to Sales Receipts.

Adam

Quote:

---

Originally Posted by poolfiltersusa

Second is there a way to import the paypal fees with each order?

---

No. They aren't part of the customer order, so they don't need to be imported. The fees are an expense that you can enter when you pay them.

Adam

Quote:

---

Originally Posted by christinefred

Hi, I am in Australia and looking at accounting packages for my new business. I am nearly finished setting up my zencart store and was wondering if this add on is suitable for the Australian versions of quickbooks? Is anyone down under using it? Thanks........Hopeful

---

QBI is untested on Australian QB, but I have been told that it might work. So, try it out.

Adam

Zen Cart Version 1.3.6
No add-ons other than QBMS
We have QBMS plugin set up on the site, got our AppID from the Intuit Developers Site, got the Connection Ticket from the merchant service site and set everything up for desktop hosting. The transactions process (customer received approval or denial), order goes through, but the funds do not show in QBMS nor depost to our bank account. QB said it was the cart setup. Can you help? THank you.

Lesa Seibert:wacko:

Quote:

---

Originally Posted by lseibert

Zen Cart Version 1.3.6
No add-ons other than QBMS
We have QBMS plugin set up on the site, got our AppID from the Intuit Developers Site, got the Connection Ticket from the merchant service site and set everything up for desktop hosting. The transactions process (customer received approval or denial), order goes through, but the funds do not show in QBMS nor depost to our bank account. QB said it was the cart setup. Can you help? THank you.

Lesa Seibert:wacko:

---

I think you have posted in the wrong forum. This does not have anything to do with QBI.

Thanks,
Adam

I apologize ahead of time if this topic has been discussed in the forum already. I did a specific search and nothing came up.

I am getting a QuickBooks import error ("Transaction not in balance etc.) with an order from a customer who is designated for group pricing. (At least I think this is where the error is steming from).

In QBI -> match -> discounts/fees section there is no option for group pricing.

Any thoughts?

Thank you,

Michelle

Quote:

---

Originally Posted by mcarbone

I apologize ahead of time if this topic has been discussed in the forum already. I did a specific search and nothing came up.

I am getting a QuickBooks import error ("Transaction not in balance etc.) with an order from a customer who is designated for group pricing. (At least I think this is where the error is steming from).

In QBI -> match -> discounts/fees section there is no option for group pricing.

Any thoughts?

Thank you,

Michelle

---

Group pricing will not cause any problem - it is something else. Usually:
An item is missing the Model.
A discount or added fee is not matched.
Taxes are not set up properly.
A payment module is used that rounds numbers incorrectly (rare, random errors).

Open the iif file in Excel. For each order, you'll see all its line items, and the total amount. The line items must add up to the total. It should be clear what is missing -- some item or discount will be missing. Then, fix the problem in QBI, download the iif file again, and check if it is fixed.

Thanks,
Adam

Adam,

You are definitely the guru!

I pulled from the excel file:

Quote:

---

Accounts Receivable - "Customer name" - $239.92
Web Sales - $350
(blank cell) (blank cell) - Discount and Fee matching not set up
Web Sales Shipping - $12
Sales Tax Payable - Tax Board - ST -$17.92

---

I can't help but still think that because the QBI - > Match -> Discounts/Fees under "shopping Cart" section it does not have a group pricing option that it is the reason why we are coming up with " Discount and Fee matching not set up.

Here's the customer's order total:

Quote:

---

Sub-Total: $350.00
United Parcel Service (20.60lbs) (Ground): $12.00
Group Discount: -$140.00
Tax (8.25%): $17.92
Total: $239.92

---

Maybe I can update a file that recognizes the zen cart group pricing function as a "discount/fee" in QBI. My PHP programming is primative.

Thanks again!!!

MC

Is there a way that I can make the correct credit card show up in Quickbooks? For now, I have cc matched to Visa, so they are all Visa no matter what the credit card really is. Thanks for the help!

Hi,

Quote:

---

Originally Posted by mcarbone

Adam,
I can't help but still think that because the QBI - > Match -> Discounts/Fees under "shopping Cart" section it does not have a group pricing option that it is the reason why we are coming up with " Discount and Fee matching not set up.

---

Go to the orders_total table in ZC and find the code for the group discount module. It will be ot_(something). That needs to go into the qbi_disccart table.

Thanks,
Adam

Quote:

---

Originally Posted by srturner47

Is there a way that I can make the correct credit card show up in Quickbooks? For now, I have cc matched to Visa, so they are all Visa no matter what the credit card really is. Thanks for the help!

---

It has been a while, so I don't remember if QBI 3.21 supports this - I think it does not. The commercial version of QBI does. It also has to be supported by the payment module in ZC for it to be converted to the correct card type.

In either case, you should match to "Credit Card" and the conversion will happen automatically if possible. I suggest you add a payment method of "Credit Card" in Quickbooks, since, as you say, Visa is not always correct.

Adam
(QBI Author)

Hi Adam,

Forgive me if I need a little hand holding on this one.

Quote:

---

Go to the orders_total table in ZC and find the code for the group discount module. It will be ot_(something). That needs to go into the qbi_disccart table.

---

What "code" am I looking for in the DB? Is this a distinct cell value? Will I need to create new fields in the qbi_disccart table? I got as far as locating the tables in question.
:blink:

Thanks for the help!

Michelle

Quote:

---

Originally Posted by mcarbone

Hi Adam,

Forgive me if I need a little hand holding on this one.



What "code" am I looking for in the DB? Is this a distinct cell value? Will I need to create new fields in the qbi_disccart table? I got as far as locating the tables in question.
:blink:

Thanks for the help!

Michelle

---

Browse the orders_total table, sorting by orders_total_id descending. You'll see codes such as ot_total, ot_disc, etc. Find the code that is used for the discount entry on those orders with the group discount. Maybe ot_discgroup? I don't know, but you should be able to see what it is. Then open the qbi_disccart table and you'll see where it goes when you add a new row.

Adam

I don't know if this has been covered but is there a script to remove the SQL databases this installs?

I'm not using QB anymore and would like to remove this module. I can hand delete the files but am not database friendly and could really use some help!!

THANKS!!
-Christopher

Quote:

---

Originally Posted by growlight

I don't know if this has been covered but is there a script to remove the SQL databases this installs?

I'm not using QB anymore and would like to remove this module. I can hand delete the files but am not database friendly and could really use some help!!

THANKS!!
-Christopher

---

Christopher,

You can delete any db tables that begin with qbi_

Thanks,
Adam

Hi Adam. I have a question: does there have to be a folder called "admin" in the directory in order for QBI to function? I suspect that is the case but I wanted to ask. Would I be able to name my admin folder something else and have QBI work? Thanks.

Quote:

---

Originally Posted by fabienne

Hi Adam. I have a question: does there have to be a folder called "admin" in the directory in order for QBI to function? I suspect that is the case but I wanted to ask. Would I be able to name my admin folder something else and have QBI work? Thanks.

---

It does not matter what the admin folder is called. Additionally, for the commercial version of QBI, it does not matter what the /qbi folder is called.

Thanks,
Adam

I'm having a problem with exporting orders to Quickbooks. Basically, all order information is exported properly EXCEPT that the detail of the actual items ordered is not included in the iif file. The items ordered do show up in emails generated by ZenCart, as well as in Admin/Customer/Orders -- they just don't come through in the QBI generated iif file.

The error is a Quickbooks Import Error ("transaction not in balance"). All customer data imports properly, just not the item information. I'm using QBI 3.21, ZenCart 1.3.8.

Thanks in advance for any suggestions.