Quickbooks Import QBI

[adam5532]

Hi,

Sorry, Adam. It turns out I fixed most of my problems through trial and error, and was left with just one question: how to handle shipping in Quickbooks in an organized manner.

I'm not sure what your question was (I'm not going to read through 14 posts). Please explain again, concisely.

... and partially due to the 7 minute limit on editing posts. Were that limit not there, it would have been one post.

Write your post first in Word, then copy and paste it into the forum. Then you can take all day if you want.

... but might leave the less experienced Quickbooks user a bit baffled about things like adding shipping options.

I don't try to address setting up or using QB, except when it directly relates to QBI. There are numerous resources available elsewhere for learning QuickBooks.

Can I request you consider adding something to your manual about getting out of balance errors from orders that have products that are no longer available on your shop? I know this is probably an obvious one for some, but I spent a good amount of time trying to figure out that the issue wasn't discount coupons and low payment fees like you stated in multiple e-commerce forums located elsewhere.

Good suggestion. I also plan to do improvement on the error log system, so that QBI will indicate what went wrong.
Tip: Open the iif file in Excel. There you can easily see what's missing from an order by comparing it to the Zen Cart invoice.

Thanks,
Adam

[nonfinite]

I'm finding QuickBooks resources to be restrictively sparse, particularly in the area of shipping. I've asked the same question below in both the Intuit forums and Yahoo answers, but to no avail. So, my apologies if you view the question below as off topic, but it can't hurt to ask, I guess.

Is it possible to mark invoices/sales receipts as "shipped" somehow in QuickBooks and return that shipped status to zen cart? If so, how can I do this?

Even more ideally, it'd be nice if I could somehow automatically return this shipped status once I've printed a shipping label and postage through quickbooks.

[nonfinite]

I have tried absolutely everything I can to get payment method to work, but have had no success.

I want PayPal and GoogleCheckout to import as sales receipts, Check/Money Order to import as invoices.


My database shows:

Rows payment_method
50 Check/Money Order
5 Credit Card
2 Gift Certificate/Coupon
37 GoogleCheckout
179 PayPal

I have updated my php files as per the recommendation here:

http://www.qbisoftware.com/forum/vie....php?f=11&t=99

I have uploaded the correct IIF from QB, did a setup of payment methods, set Check/Money Order to not paid online, GoogleCheckout to paid online, and PayPal to paid w/ paypal.

I went to match, tried it with no matches, that failed. Tried it again by matching the following:

GoogleCheckout (googlecheckout) -> GoogleCheckout
PayPal (paypal) -> PayPal



Finally figured out the issue was in configuration. I had to create two more payment methods in QuickBooks: PaidOnline and NotPaidOnline, then enter the names in Invoice Terms Paid online and Invoice Terms Not Prepaid. I had named these something else from one of my earlier attempts to get payments methods to work, and had lost the similarly named QB list items when I restored from a backup.

(placing this here for any future QBI users who encounter the same issue.)

[adam5532]

Hi,

I'm finding QuickBooks resources to be restrictively sparse, particularly in the area of shipping. I've asked the same question below in both the Intuit forums and Yahoo answers, but to no avail. So, my apologies if you view the question below as off topic, but it can't hurt to ask, I guess.

Is it possible to mark invoices/sales receipts as "shipped" somehow in QuickBooks and return that shipped status to zen cart? If so, how can I do this?

QBI can't do that. It can though automatically change the status to Shipped when you download the orders. That's useful if you don't allow out-of-stock items to be purchased, and you plan to ship within 24 hours or so of charging the card.

Even more ideally, it'd be nice if I could somehow automatically return this shipped status once I've printed a shipping label and postage through quickbooks.

Not possible now. I'll look into these kinds of features in QBI 4. Using ShipRush in QB, you can have it send an email to your customer with the tracking number when you print the label. Combine that with QBI's ability to change status when downloaded, and that works well for many people.

- Adam

[adam5532]

Hi,

I have tried absolutely everything I can to get payment method to work, but have had no success.

It looks like you've tried everything. I could fix it for you, but this wouldn't be free support.

I want PayPal and GoogleCheckout to import as sales receipts, Check/Money Order to import as invoices.

Finally figured out the issue was in configuration. I had to create two more payment methods in QuickBooks: PaidOnline and NotPaidOnline

Actually, this has nothing to do with it. You can name them anything you like, as long as they are matched.

- Adam

[nonfinite]

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/.../catalog/admin/customers.php on line 1099

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home/.../catalog/admin/customers.php on line 1101

Warning: reset() [function.reset]: Passed variable is not an array or object in /home/.../catalog/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/.../catalog/admin/includes/classes/object_info.php on line 30

I forgot about this. Got wrapped up in getting everything else working and overlooked the fact that I still didn't figure out how to repair this.

Any ideas Adam?

[swingandmiss]

Hey Adam. When importing orders into QB, it never imports the second line of an address. Example:

John Doe
12345 Street
Apt A
City, CA 12345

The "Apt A" line always get's left off and I'm forced to enter it manually. Any ideas? QBI 3 and QB 2007 Premier.

[adam5532]

Hi,

Hey Adam. When importing orders into QB, it never imports the second line of an address. Example:

John Doe
12345 Street
Apt A
City, CA 12345

The "Apt A" line always get's left off and I'm forced to enter it manually. Any ideas? QBI 3 and QB 2007 Premier.

The second address line is not supported in QBI 3.21, so the best solution is to disable it in Zen Cart.

QBI 3.76 and later supports the 2nd line (suburb) and will include it in the address if it is not empty.

- Adam

[adam5532]

Hi,

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/.../catalog/admin/customers.php on line 1099
...

I forgot about this. Got wrapped up in getting everything else working and overlooked the fact that I still didn't figure out how to repair this.

Any ideas Adam?

You don't say where you are getting these errors, but they aren't from QBI. None of these pages or functions are part of QBI.

I like to be helpful, but the amount of support that you seem to need is beyond what I am able or willing to give in this free forum - you must be over 20 posts now in a very short period. Out of respect for my time, this is where you get the paid version of QBI instead. Otherwise, you are on your own or maybe someone else in the forum will help you. I don't mean to sound rude at all, but I have limited time and want to make sure I have some left to help others here also.

Thanks,
Adam

[swingandmiss]

Hi,

The second address line is not supported in QBI 3.21, so the best solution is to disable it in Zen Cart.

QBI 3.76 and later supports the 2nd line (suburb) and will include it in the address if it is not empty.

- Adam

Instead of dissabiling it, as I have a lot of customers that use it, should I just install QBI 3.76?