Quickbooks Import QBI

[Merlinpa1969]

Kool thanks

I am using web connect on another project and its great

actually create invoices payments and all

love it

[tj1]

Kool thanks

I am using web connect on another project and its great

actually create invoices payments and all

love it

Merlin, is this other project you're using Quickbooks Sync ( http://www.zen-cart.com/forum/showthread.php?t=110998 )?

[Merlinpa1969]

no, its not for ZC at all,

and its a serious learning curve...

Now back to adams QB thread

[iraweissman]

Hi All. QBI is fantastic, but I can't figure out one little annoying problem. I use QBI with paypal payments pro (using paypal as a Credit card gateway in addition to classic paypal payments). Everything imports fine, except for the fact that payments that are marked in paypal's history as "Shopping Cart Payment Received" import fine as "sales receipts", while payments marked as "Express Checkout payment received" always import as invoices.

I've tried a number of different permutations of settings and can't get it to accept the latter type as sales receipts.

Any ideas?

Thanks for any help!

Widow's Mite Christian Jewelry

[adam5532]

Hi All. QBI is fantastic, but I can't figure out one little annoying problem. I use QBI with paypal payments pro (using paypal as a Credit card gateway in addition to classic paypal payments). Everything imports fine, except for the fact that payments that are marked in paypal's history as "Shopping Cart Payment Received" import fine as "sales receipts", while payments marked as "Express Checkout payment received" always import as invoices.

I've tried a number of different permutations of settings and can't get it to accept the latter type as sales receipts.

Any ideas?

Thanks for any help!

Widow's Mite Christian Jewelry

Make sure you have Setup Payments set so that the payment method it is matched to is either Paid Online or Paid w PayPal.

Then, match that PayPal method to the QB method you are using in Match Payments.

If you've done all that right, then sometimes the text for the payment method is spelled slightly differently than is expected in the database. I can tell you how to fix that if that's necessary.

Which PayPal method isn't working? Do you need to use two methods?

One other thing: There is actually no difference between Paid Online and Paid w PayPal, except that it uses alternate download selection criteria. So, if payments through one system return with one order status, and payments through the other return with something else, you can specify that on the Configuration page. The second method doesn't have to be PayPal -- it is just called that because there was a need for it when using PayPal payment methods that took the customer to the PayPal site for payment.

Thanks,
Adam

[tj1]

Adam, can QBI import orders as estimates?

I need to be able to import sales orders; however I realize this is not supported in neither the free nor the commercial version.
(BTW, I tried to contact about the commercial version using your website but I always kept getting an error message, could not post in the forum or use the contact form)

I think the reason for not supporting sales orders is the limitation of the IFF file, correct? Apparently there's no support for this type of transactions, although I read somewhere TRNS SALESORDER might work, but I'm not sure.

I know estimates can be imported with an IFF file, and this could be used as a workaround since an invoice or sales order can be created from an estimate.
I need sales orders for about 30% of my orders because I need to track backorders and orders shipped in parts from various locations.

[adam5532]

Adam, can QBI import orders as estimates?

I need to be able to import sales orders; however I realize this is not supported in neither the free nor the commercial version.
(BTW, I tried to contact about the commercial version using your website but I always kept getting an error message, could not post in the forum or use the contact form)

I may just remove the forum, since its purpose has essentially been replaced by the support ticket system, which is a much better way to solve users' issues.

There is a link to Contact Us and one to Purchase QBI on the QBI Software website.

I think the reason for not supporting sales orders is the limitation of the IFF file, correct? Apparently there's no support for this type of transactions, although I read somewhere TRNS SALESORDER might work, but I'm not sure.

Yes, it isn't documented, but someone suggested that. I haven't tested it yet.

I know estimates can be imported with an IFF file, and this could be used as a workaround since an invoice or sales order can be created from an estimate.
I need sales orders for about 30% of my orders because I need to track backorders and orders shipped in parts from various locations.

But that would add an extra step, yes? No-one has requested estimates before. I can look at doing that.

Thanks,
Adam

[Merlinpa1969]

just remember that according to the folks we talked to over at quickbooks the .iif import is being phased out,
the preffered method is web connect.

[borillion_star]

I would like to ask if you wouldn't mind taking a look at some errors I am getting when I try to run, I did look for a solution in the Zen-Cart
Forums where you tell others to upgrade to the newest version. I took the update off the Zen-Cart download site and it didn't solve the errors.


Notice: Query failed: Unknown column 'products_id' in 'where clause' SQL: SELECT * FROM qbi_products_itemsqb WHERE products_id='66' AND products_options_values_id='' in /home/bcxotlng/public_html/store/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/bcxotlng/public_html/store/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/bcxotlng/public_html/store/admin/includes/classes/qbi_mysql.php on line 176

Thanks

[adam5532]

just remember that according to the folks we talked to over at quickbooks the .iif import is being phased out,
the preffered method is web connect.

They've been saying that for the last 5 years or so, and it hasn't happened. I think there is still a lot of software out there that uses iif, which is probably why they haven't done so. It is still good with QB 2009.

iif works fine with properly designed software. In some 50,000+ sales or downloads of QBI (Zen, osC, CRE, etc), not one customer has complained of lost data.

Nevertheless, Web Connect is superior and more flexible, and at this point I will be focusing the majority of my development time on integrating it into QBI. I will also be adapting QBI to work with ZC2.0. I need to evaluate if a free version will be offered for 2.0.

Thanks,
Adam