Quickbooks Import QBI

[adam5532]

Adam I posted a bug report some time back in post 476 where QBI does not match an item with one attribute in Zen with a group in Quick Books. Most of the items in my store are represented by groups in Quick Books. As such I have not been able to use QBI at all. Would it be possible for you to post the code change to match groups in Quick books so that I can begin using it until version 4 is released? I don't need multiple attributes, just one item with one attribute to match to a group in QB. Thanks.

Sorry, I did forget about this. I now have a formal bug report system to prevent things from falling through the cracks (this is now issue #21). I will try to look at it later this week.

Thanks,
Adam

[phb99z]

Hello Adam,
This may sound like a dumb question, but here goes... Do the part numbers (and/or descriptions) in zencart have to match exactly with the item numbers in quickbooks?
PHB

[adam5532]

Hello Adam,
This may sound like a dumb question, but here goes... Do the part numbers (and/or descriptions) in zencart have to match exactly with the item numbers in quickbooks?
PHB

Not a dumb question at all.

The easiest way to use QBI is for the Zen Cart Product Model to match the Quickbooks Item Name, and for Zen Cart Attribute Value to match the Quickbooks Subitem Name. But you can use the matching system in QBI to map together Products and Items that aren't the same.

Thanks,
Adam

[phb99z]

Thanks Adam, great stuff! and welcome to Oregon. (I am near Salem)
PHB

[renegade]

I'm sorry if this has been covered allready but I read through 5 pages & noticed that this thread is huge. this is a module for zen cart that will allow me to import all sales info directly from zen cart into QuickBooks Point of Sale 4.0 and also Quickbooks pro 2007???? Is there any way to import my Point of Sale items & inventory into zen cart???

[adam5532]

I'm sorry if this has been covered allready but I read through 5 pages & noticed that this thread is huge. this is a module for zen cart that will allow me to import all sales info directly from zen cart into QuickBooks Point of Sale 4.0 and also Quickbooks pro 2007???? Is there any way to import my Point of Sale items & inventory into zen cart???

Currently QBI only works with US versions of Quickbooks Pro, Premier, and Enterprise. It does not work with POS or non-US versions - that's planned for the future. QBI can export inventory lists into QB. It can not populate Zen Cart with inventory lists from QB (although the paid version can now synchronize inventory counts). This may be added in the future.

Thanks,
Adam

[renegade]

When there is seamless integration I will be glad to fork over some cas for this project.

I need a seemless integration between the 3 peices of software. Quickbooks Premier 2007, Quickbooks Point of Sale 4, and Zen Cart.
Does Zen Cart have any import capabilities for items and customers etc....

[adam5532]

When there is seamless integration I will be glad to fork over some cas for this project.

I need a seemless integration between the 3 peices of software. Quickbooks Premier 2007, Quickbooks Point of Sale 4, and Zen Cart.
Does Zen Cart have any import capabilities for items and customers etc....

Look at Easy Populate
- Adam

[JackQBTeK]

Everyone should know that Intuit is no longer supporting their own IIF Import facility.

See below.

Jack


From
http://developer.intuit.com/Support/...4#faq_qbsdk_q4


4. What happens to the Intuit Interchange Format (.iif) integration?
Importing incorrect IIF files can lead to corruption of QuickBooks company files. Therefore, Intuit strongly discourages relying on IIF files for application integration. Intuit cannot support customers who have used IIF files created by third-party applications.
Intuit expects to drop IIF from future versions of QuickBooks. Any such change will be announced in advance on this FAQ page.
Intuit recommends that all integration between QuickBooks and third-party software applications be implemented using the QuickBooks Software Development Kit (QBSDK). Intuit will support QuickBooks for customers who use applications which utilize the QuickBooks SDK.

[adam5532]

Everyone should know that Intuit is no longer supporting their own IIF Import facility.

Intuit has not supported iif for many years. They have also threatened to drop it for years, however every new version of Quickbooks, including 2008, has had it. There are just too many applications out there that use it.

If the iif files are properly formatted, which QBI does, there should be no problem. There are tens of thousands of people using QBI, and I've never heard of a corrupt company file occurring or any kind of data validity problem happening. QBI does have to be set up properly with the right company accounts and settings, but that's going to be the same regardless. So, users should have no reservations about importing iif files. However, that's not to say that there aren't advantages to using the SDK, and I plan to add XML file output capability to QBI 4.0.

Thanks,
Adam