Quickbooks Import QBI

[swingandmiss]

The USPS shipping methods do not match correctly due to inconsistencies in the that shipping module. Since so few people use USPS, I haven't resolved this, but I will look at it.

QBI finds and shows all the shipping methods that are available, even if they are not installed.

Thanks,
Adam

So what will happen if I continue to use QBI and I don't have a match for USPS First Class Package?

[adam5532]

So what will happen if I continue to use QBI and I don't have a match for USPS First Class Package?

The invoice or sales order will say "Method not found" under "Shipping Method."

Thanks,
Adam

[samad64]

you can also manually add in USPS First Class to the database in the format it appears on the receipt.. there was a post probably about 15 pages back talking about how to add FedEx or other carriers in.. you can follow the same steps and add in first class :)

[kevdoginca]

Dddaaaannnnggggg!!! This one Really, really long post!!!
I just can't make it through and I am not finding the answer I was looking for...

I am relatively new to ZenCart and I have a wine shop up and running for my sister and bro-in-law. They plan on opening a brick and mortar store in the very near future and has purchased Quickbooks POS software/hardware.

What we want to do is be able to download orders from ZenCart into Quickbooks, Upload products from Quickbooks to ZenCart and update inventory in both Quickbooks and ZenCart when orders are placed in either location.

Will the QBI do all this? We are looking at the T-Hub product, but would prefer not pay $200-$600 if we do not have to (but we will if it's a better interface between the two).

We realize that we may have to build a new site as so the products match up and we are not totally opposed to using a different cart if integration is easier for them.

I really appreciate all the posts on the ZenCart Forums. Thanks for all your help and keep up the good work Adam and everyone else contributing to this great product!

KevDoginCA

[djstern]

Unless Adam has made a change that I'm unaware of you can't sent inventory amounts from QB to Zen Cart. One option that may work, (I've played with it but not totally worked it out) is to export your inventory quantity from QB to an Excel spread sheet. Then change the headers as appropriate and upload the result to Zen with Easy Populate. After you do it a few times, it should only take you a few minutes to do the whole process. This could easily be a end of day operation. You'll need the paid version of Easy Populate to handle attributes though. It's not that expensive.

Of course any orders placed in the store and imported into QB would automatically update the inventory correctly in QB.

Adam has indicated some time back that he was working on changes to a future release of QBI that could update inventory quantities in Zen, but I have no idea when that will be available, or if it'll be in the next release. I do know that's a common request so I expect he'll get it as soon as he can. He's got a lot of request and can't possibly do them all at once. :)

Be careful of some of the after market options. Some of them are famous for selling you a $600.00 package with all kinds of bells and whistles, then telling you how much more it'll cost to integrate it or something like that. You end up with a lot of hidden costs you weren't prepared for.

The easy populate option I mentioned above should hold you over for a while.

good luck.

[adam5532]

Unless Adam has made a change ...

Thanks for the complete answer to the previous post.

I am busy adding features to the development version of QBI, and inventory updating from QB to Zen Cart hasn't yet been added but is definitely on the list for QBI 4. It will be ready in a few months -- I'll give a more accurate eta when I get closer.

Thanks,
Adam

[swingandmiss]

So I think I have everything set up correct. Setup is done, match is done, config is done. It creates the IIF file, and from not knowing much about how it should look, it looks fine. It imports without error, and all the orders and customer information is correct. However, when I look at the invoices, the product information is blank with zero charge. And following that, inventory isn't deducted, no sales tax, etc...

[swingandmiss]

Nevermind, I think I have it figured out. Assemblies...

[adam5532]

Nevermind, I think I have it figured out. Assemblies...

Assemblies should work correctly in version 3.21. Let me know if there is still a problem.

Thanks,
Adam

[cellomansings]

I am considering using Zen Cart and I am trying to learn in waht way it might be compatible for import or integration with Quickbooks Online Edition. Happy to hear anything about that.

Many thanks, Daniel