Quickbooks Import QBI

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

[adam5532]

Hi,

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

[adam5532]

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)

[mcarbone]

Hi Adam,

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

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.


Thanks for the help!

Michelle

[adam5532]

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.


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

[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

[adam5532]

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

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

[adam5532]

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

[M B Walker]

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.