Quickbooks Import QBI

[Bart]

Hi all,

I'm new to this forum as well as QBI. So please go slow on me. My problem is when I click on the the QBI link under customer tab, it redirected me back to the admin login page. Could someone help me with this problem?

Thanks in advance.

[Dave_B]

I'm not able to get QBI to match any products with attributes to items in Quickbooks. On products without any attributes it's not a problem but products with attributes will "pass through" and create a new item instead of selecting the item:subitem that I have it matched to.

For example, I have a T-shirt with attributes of "Red" and "Blue" in Zen and in Quickbooks I have an inventory item called "T-shirt" with a subitem of "Red T-shirt" and a subitem called "Blue T-shirt." I have matched T-shirt:Red in Zen to the T-shirt:Red T-shirt item:subitem in Quickbooks but when I import the IIF file, Quickbooks will still pass this through and create a new item instead of using the T-shirt:Red T-shirt item:subitem.

Do the Quickbooks item:subitem names have to match exactly to Zen or am I missing something else here?

[Dave_B]

I should add that I can't match to a Quickbooks group even if there are no attributes in Zen.

[djstern]

I should add that I can't match to a Quickbooks group even if there are no attributes in Zen.

QBI will only match a single attribute. Adam tells us that the next version will handle multiple attributes though.

There is a bug in QBI that prevents it from matching to a QB group at all. Adam is aware of it and says it should be fixed in the next version. I am anxiously waiting for that because the majority of my product line is in groups in QB and currently, I can't use QBI because if that.

[Dave_B]

djstern - how did you get QBI to work with an attribute? I'm only using one attribute (color) and it's not on a group but I still can't get it to work.

[Dave_B]

Ok, I finally got QBI to match products with attributes to Items:Subitems in Quickbooks. I actually had the Quickbooks Items setup as Items:Subitems:Subitems. In other words, my Quickbooks Item was Clothes:T-Shirt:Red instead of just T-Shirt:Red. When I removed one "layer" of subitems, the QBI matched everything correctly.

Now for my next question: How do I get QBI to update the Zen order ID number into the Quickbooks Sales Receipt number? If I upload my orders from Zen to a Quickbooks Invoice, then the Invoice number matches the Zen order ID but if I upload to a Quickbooks Sales Receipt, the Sales Receipt number doesn't match the Zen order ID.

[adam5532]

Ok, I finally got QBI to match products with attributes to Items:Subitems in Quickbooks. I actually had the Quickbooks Items setup as Items:Subitems:Subitems. In other words, my Quickbooks Item was Clothes:T-Shirt:Red instead of just T-Shirt:Red. When I removed one "layer" of subitems, the QBI matched everything correctly.

Now for my next question: How do I get QBI to update the Zen order ID number into the Quickbooks Sales Receipt number? If I upload my orders from Zen to a Quickbooks Invoice, then the Invoice number matches the Zen order ID but if I upload to a Quickbooks Sales Receipt, the Sales Receipt number doesn't match the Zen order ID.

The iif file format does not allow QBI to use the Sale Receipt number. The Zen Cart order number is put into the PO Number field. In the QB template system, you can rename PO Number to Web Sale Number or whatever you wish, and make it visible on the screen and print-out.

Thanks,
Adam

[adam5532]

QBI will only match a single attribute. Adam tells us that the next version will handle multiple attributes though.

There is a bug in QBI that prevents it from matching to a QB group at all. Adam is aware of it and says it should be fixed in the next version. I am anxiously waiting for that because the majority of my product line is in groups in QB and currently, I can't use QBI because if that.

The developement version now works with multiple attributes. I've been in the caos of moving from California to Portland Oregon for the last few months, but I will have the office set back up this weekend and then will be able to concentrate more time working on version 4.x.

Thanks,
- Adam

[adam5532]

Hi all,

I'm new to this forum as well as QBI. So please go slow on me. My problem is when I click on the the QBI link under customer tab, it redirected me back to the admin login page. Could someone help me with this problem?

Thanks in advance.

Check that you are not using any mod for admin user permissions. If you are, you'll need to tell it about QBI. Try going directly to www.yourstore.com/admin/qbi_create.php.

Thanks,
Adam

[adam5532]

With QBI, can I upload inventory quantities from Quickbooks Point of Sale to ZenCart?

QBI does not yet work with POS. QBI can not yet update quantities in Zen Cart, but this is planned for the next version. When importing orders from Zen Cart into QB, inventory quantities will automatically be reduced.

Thanks,
Adam