Quickbooks Import QBI

[kallyloo]

Hi I'm from the UK and really need some form of integration with accounts software and thought this might be good as a friend uses QB but not with zen cart for his business.

Will this work with QB UK software and what QB, simplestart, Pro,or Premier?
Thank you.

[adam5532]

Hi I'm from the UK and really need some form of integration with accounts software and thought this might be good as a friend uses QB but not with zen cart for his business.

Will this work with QB UK software and what QB, simplestart, Pro,or Premier?
Thank you.

It will not work with QB UK. The taxation and import field names are different from the US version.

Thanks,
Adam

[DrByte]

The existing free QBI 3.21 add-on should work fine with Zen Cart 1.39, although I have not tested it with PHP5.

The latest version of QBI, 3.85, is available for purchase at www. qbisoftware. com

Thanks,
Adam

Adam,
Will there continue to be updates to the free version?
Or is it strictly a commercial addon nowadays?

[adam5532]

Adam,
Will there continue to be updates to the free version?
Or is it strictly a commercial addon nowadays?

I have been thinking of making an updated free version when QBI 4 is released, as 3.21 is quite old now. But I can't make any promises.

Thanks,
Adam

[DrByte]

Okay.

This is just a friendly reminder that commercial products are not allowed to be advertised here on the forum.
Please do not post links to commercial addons/services.

[letsmod]

I think the price they are charging for the commercial app is TOO MUCH, I would rahter sit here and type each order in then pay somone $180 after paying over $200 for quickbooks pro,

[ExotacInc]

Zencart V1.3.8a with QBI 3.2.1

Have a few issues and I'm not sure if they're setup problems or bugs:

1. Only a fraction of my orders are importing. When I look at the iif file, it goes from 976 to 1325 for no apparent reason. In QBI, here is what I see:

All Previous Orders
Quan: 68
No.: 901 to 1554
Date: Dec 8, 2009 5:39 pm to Nov 9, 2010 1:38 pm

2. I have Matched every shipping method and I still see "Ship Via" in the iif file says "Method not set". It looks like these orders are the ones that are "Free shipping" but I have that matched to
"USPS Priority". The option "Method not set" doesn't even exist in the matched list.

3. Paypal Payment method is coming across as "Check / MO". I've checked this and double checked it. Under payment setup, I've set "Paypal" to "Paid online" and under match I've set "Purchase (paypal)" to "Paypal". Under configure I have "Invoice terms paid online:" set to "Credit Card" and "Invoice terms not prepaid:" set to "Check / MO"

So it looks like I'm missing something but where?

Thanks in advance!

[adam5532]

Hi,

Zencart V1.3.8a with QBI 3.2.1

Have a few issues and I'm not sure if they're setup problems or bugs:

1. Only a fraction of my orders are importing. When I look at the iif file, it goes from 976 to 1325 for no apparent reason. In QBI, here is what I see:

All Previous Orders
Quan: 68
No.: 901 to 1554
Date: Dec 8, 2009 5:39 pm to Nov 9, 2010 1:38 pm

QBI only exports orders that 1) have not been exported before by QBI, and 2) meet the status criteria you've set on the QBI configuration page (download orders with status: pending, for example). Of the 600+ orders between 901 and 1554, you have 68 that meet both criteria.

2. I have Matched every shipping method and I still see "Ship Via" in the iif file says "Method not set". It looks like these orders are the ones that are "Free shipping" but I have that matched to
"USPS Priority". The option "Method not set" doesn't even exist in the matched list.

You may need to manually update QBI's shipping methods table to properly list the free shipping option. "Method not set" appears when no match is found.

3. Paypal Payment method is coming across as "Check / MO". I've checked this and double checked it. Under payment setup, I've set "Paypal" to "Paid online" and under match I've set "Purchase (paypal)" to "Paypal". Under configure I have "Invoice terms paid online:" set to "Credit Card" and "Invoice terms not prepaid:" set to "Check / MO"

Again, you may have to manually update QBI's payment methods table to properly match PayPal. However, walking you through how to do that is beyond the scope of the support I offer for the free version of QBI.

Thanks,
Adam
(QBI developer)

[ExotacInc]

Adam,

Thanks for the support you DO provide on the free version. It is definitely above and beyond what's expected.

After posting I looked into another post you had made in this thread that describes generally what needs to be done to add the shipping/payment methods to the tables. I'll try this today.

Your paid version doesn't list anything about doing this better. Maybe you've already thought of something however it would be nice to have two text boxes and a submit button to manually enter them. This way I don't have to go into mysql admin. It's only a one time thing so it's probably fine.

Your answer to #1 helped very much. I remembered that I have two identical status for "shipped". One has 42 orders, the other has the remainder. I guess I'll finally have to figure out how to fix this or just export in two rounds and not fix it at all :).

If I can get this working, i'll save me a lot of time and I'll send over some lunch money ;).

thanks!

[adam5532]

Hi,

Adam,

After posting I looked into another post you had made in this thread that describes generally what needs to be done to add the shipping/payment methods to the tables. I'll try this today.

Your paid version doesn't list anything about doing this better. Maybe you've already thought of something however it would be nice to have two text boxes and a submit button to manually enter them. This way I don't have to go into mysql admin. It's only a one time thing so it's probably fine.

The free version automatically detects and adds the shipping and payment methods. Unfortunately, because the modules are not implemented in a consistent manner, QBI can't always detect them all correctly. I believe (it's been a while since I wrote version 3.21) that you'll need to disable the automatic system by commenting out a line, so that it doesn't revert your manual changes -- this should be somewhere in earlier posts.

For the paid version, I gave up on the automatic system and just pre-populated the tables with the most common entries.

Manual boxes is an idea, but the problem is that you'd have to go into the database anyway to know what to put in them, as the values stored in the db with an order are not necessarily what's shown on the screen.

I'm hoping to revisit this and re-implement the automatic system with improvements in the future.

Good luck!

Thanks,
Adam