Quickbooks Import QBI

[motti]

Is any one ,ave any idea why on my quick book it imort the item as service and not as invetory,

It is set on my QBI as invetory item same as it is on my quick book

Thank you

[adam5532]

Is any one ,ave any idea why on my quick book it imort the item as service and not as invetory,

It is set on my QBI as invetory item same as it is on my quick book

Thank you

All products must already exist in Quickbooks before you import orders. You can do this by using the QBI matching feature, or by having identical products in both Zen Cart and in QB. If your products are not yet set up in Quickbooks, use the QBI Products export to add the products to QB. Doing this will result in a perfect set-up with all the attributes set up correctly as sub-items.

If you import an order into QB that contains an item that doesn't exist in QB. it will be created as a Service. QB can not properly create new items "on the fly."

Thanks,
Adam

[motti]

Hi Adam

My product already created in QuickBooks, as I explain before the are under category and not direct under item,
for example item number in Zen cart 6700051245 will be in my QuickBooks under Tools:6700051245
Is that mean i can't use QBI with my QuickBooks, or their is a way to make it work

Thank you

[adam5532]

Hi Adam

My product already created in QuickBooks, as I explain before the are under category and not direct under item,
for example item number in Zen cart 6700051245 will be in my QuickBooks under Tools:6700051245

Thank you

But, as far as QB knows, Tools:6700051245 and 6700051245 are two completely different items. They are not identical.

Is that mean i can't use QBI with my QuickBooks, or their is a way to make it work

Yes, there is no problem using QBI. You need to use the matching feature in QBI. Please read the QBI Configuration and User Manual for complete instructions on using this feature.

Thanks,
Adam

[motti]

Hello again
If I understand what you saying, you say it is possible.
So I will look in to it more and try making it work.

Thank You for your time

[motti]

It is amazing it works
I test few items and it all good
Wish I know it earlier I wouldn’t damage my quick book data

Sorry for driving you crazy i only need to be explain like to a child slow and few times still in early stage of learnnig.

Thank you Adam

[samad64]

this is a spectacular mod - thank you SO much!

the only issue i am having at this time is in regards to FedEx modules. For some reason I can't seem to get it working with FedEx.. the IIF file keeps saying "Discount and Fee matching not set up" on all orders that ship via FedEx. FedEx does not show up in the matching area.. so I took the advice adam had posted a while back regarding adding them to the database, but I guess I must have done something wrong while adding them which isn't allowing them to work. Any ideas?


quick update:

FedEx appears now on the match screen (since i put it into the database) -- however it appears different than it does in the shopping cart. It shows FedEx (2Day), when in fact it shows up as FedEx 2Day in the cart. Slight problem there.. I'm assuming thats why its not recognizing it in the iif generation process.

Also, which account do I link a coupon to? I'm very new to quickbooks (just installed yesterday) so I'm still getting my head around a lot of this accounting stuff.. any help would be greatly appreciated. Thanks!

[sndonline]

Hi,

any news when canadian zencart users can start using QBI?

Thank you in advance for answering me question!

Steve

[samad64]

this is a spectacular mod - thank you SO much!

the only issue i am having at this time is in regards to FedEx modules. For some reason I can't seem to get it working with FedEx.. the IIF file keeps saying "Discount and Fee matching not set up" on all orders that ship via FedEx. FedEx does not show up in the matching area.. so I took the advice adam had posted a while back regarding adding them to the database, but I guess I must have done something wrong while adding them which isn't allowing them to work. Any ideas?


quick update:

FedEx appears now on the match screen (since i put it into the database) -- however it appears different than it does in the shopping cart. It shows FedEx (2Day), when in fact it shows up as FedEx 2Day in the cart. Slight problem there.. I'm assuming thats why its not recognizing it in the iif generation process.

Also, which account do I link a coupon to? I'm very new to quickbooks (just installed yesterday) so I'm still getting my head around a lot of this accounting stuff.. any help would be greatly appreciated. Thanks!

I figured out the FedEx problem and added in a coupon as well going to the "Sales Discounts" account for right now.. sounds like the right place for it :). Everything is working great.. thanks again for a great contribution!

[adam5532]

Hi,

any news when canadian zencart users can start using QBI?

Thank you in advance for answering me question!

Steve

I am working on QBI 4 now and adding many requested features, including UK and Canadian support. It is probably still a couple of months away from being finished.

Thanks,
Adam