Quickbooks Import QBI

[audradh]

I went ahead and created an all new store file in Quickbooks 2008 Pro.
I have opened up MySql and checked the products table, every single product has a product_model entry.
I have double and triple checked all of the configuration and matching settings.
I export the IIF file, and then go to import it into QB.
It imports the first 24 orders and then crashes on 25.
If I go into zen cart and look at order 25 I can not find any sort of info in the order that would be different from previous ones.

Try opening the file in Excel. Some errors I can see more easily in Excel and others I can see more easily in Zen Cart.

[AlohaRover]

Try opening the file in Excel. Some errors I can see more easily in Excel and others I can see more easily in Zen Cart.

What sort of errors do you see when comparing ordersin Excel?

Thanks

[audradh]

What sort of errors do you see when comparing ordersin Excel?

Thanks

I've gotta be honest, it has been a while since I have downloaded orders
From my memory full of cobwebs... I'm thinking most likely issues of the order not totalling properly.

Can you post the information from the excel entry? Maybe someone can pick out the trouble.

[adam5532]

Hi,

I went ahead and created an all new store file in Quickbooks 2008 Pro.
I have opened up MySql and checked the products table, every single product has a product_model entry.
I have double and triple checked all of the configuration and matching settings.
I export the IIF file, and then go to import it into QB.
It imports the first 24 orders and then crashes on 25.
If I go into zen cart and look at order 25 I can not find any sort of info in the order that would be different from previous ones.

Are you using QB Windows or Mac?

Open the iif in Excel. Your last order is at the end. The item section starts with TNRS, the total line, and then all the line items SPL. The line items must equal the negative of the total (AMOUNT column). Also, check that there are not any funny characters, quotes, apostrophes, etc that might confuse QB.

You may find an item missing, meaning you haven't matched discounts or some product. But this doesn't crash QB, so either it is probably some funny character, or you have QB Mac, which seems to crash on anything it doesn't like.

Thanks,
Adam

[AlohaRover]

Win XP Pro SP2

Here is a bad record- I changed the name ;)

!CUST NAME BADDR1 BADDR2 BADDR3 BADDR4 BADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 PHONE1 PHONE2 FAXNUM EMAIL NOTE CONT1 CONT2 CTYPE TERMS TAXABLE TAXITEM LIMIT RESALENUM REP COMPANYNAME SALUTATION FIRSTNAME LASTNAME
CUST doe-31 john doe 123 main street Knoxville TN 37916 john doe 123 main street Knoxville TN 37916 615-504-4352 jd###################### John Doe Website Online N CO Sales Tax John Doe
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 NAMEISTAXABLE TERMS SHIPVIA REP FOB INVMEMO PAYMETH PONUM
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE PAYMETHOD EXTRA
!ENDTRNS
TRNS INVOICE 9/12/2008 Accounts Receivable Lindstrom-31 565 ebrs-34 N N john doe 123 main street Knoxville TN 37916 john doe 123 main street Knoxville TN 37916 N Online Federal Express MasterCard ebrs-34
SPL INVOICE 9/12/2008 Sales -550 CMMG Upper - 5.56 - 16' Lightweight MID - 1:7, ** This is a non-stock item**: Typically takes 2-4 weeks to ship N -1 550 CMMGU1605L7:Typically takes 2-4 weeks to ship N
SPL INVOICE 9/12/2008 N
SPL INVOICE 9/12/2008 Shipping and Delivery Income -15 Shipping N -1 15 Shipping N
SPL INVOICE 9/12/2008 Sales Tax Payable CO Sales Tax 0 N 7.40% CO Sales Tax N AUTOSTAX
ENDTRNS
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM PAYMETH MEMO
!SPL SPLID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM PAYMETH MEMO
!ENDTRNS
TRNS PAYMENT 9/12/2008 Undeposited Funds Smith-31 565 MasterCard Website
SPL PAYMENT 9/12/2008 Accounts Receivable Smith-31 -565 MasterCard Website
ENDTRNS

[AlohaRover]

This is a good one

!CUST NAME BADDR1 BADDR2 BADDR3 BADDR4 BADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 PHONE1 PHONE2 FAXNUM EMAIL NOTE CONT1 CONT2 CTYPE TERMS TAXABLE TAXITEM LIMIT RESALENUM REP COMPANYNAME SALUTATION FIRSTNAME LASTNAME
CUST Smith-4 Mark Smith 123 main St Tucson AZ 85747 Mark Smith 123 main St Tucson AZ 85747 520-241-5620 mdw097########################## Mark Smith Website Online N CO Sales Tax Mark Smith
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR1 ADDR2 ADDR3 ADDR4 ADDR5 SADDR1 SADDR2 SADDR3 SADDR4 SADDR5 NAMEISTAXABLE TERMS SHIPVIA REP FOB INVMEMO PAYMETH PONUM
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY PRICE INVITEM TAXABLE PAYMETHOD EXTRA
!ENDTRNS
TRNS INVOICE 8/25/2008 Accounts Receivable Smith-4 204.9 ebrs-2 N N Mark Smith 123 main St Tucson AZ 85747 Mark Smith 123 main St Tucson AZ 85747 N Online Federal Express MasterCard ebrs-2
SPL INVOICE 8/25/2008 Sales -189.95 ADM Scope Mount - RECON-X, Scope Ring Size: 1' N -1 189.95 AD-RECON-X:1' N
SPL INVOICE 8/25/2008 N
SPL INVOICE 8/25/2008 Shipping and Delivery Income -14.95 Shipping N -1 14.95 Shipping N
SPL INVOICE 8/25/2008 Sales Tax Payable CO Sales Tax 0 N 7.40% CO Sales Tax N AUTOSTAX
ENDTRNS
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM PAYMETH MEMO
!SPL SPLID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM PAYMETH MEMO
!ENDTRNS
TRNS PAYMENT 8/25/2008 Undeposited Funds Smith-4 204.9 MasterCard Website
SPL PAYMENT 8/25/2008 Accounts Receivable Smith-4 -204.9 MasterCard Website
ENDTRNS

[AlohaRover]

Hi,

Are you using QB Windows or Mac?

Open the iif in Excel. Your last order is at the end. The item section starts with TNRS, the total line, and then all the line items SPL. The line items must equal the negative of the total (AMOUNT column). Also, check that there are not any funny characters, quotes, apostrophes, etc that might confuse QB.

Adam,

I have an item attribute

** This is a non-stock item**

For many of my items.

Looks like all of the orders that bomb have an item with this attribute in it.

I am going to get rid of that attribute, re down load and try again.

Keeping my fingers crossed

[AlohaRover]

dbl post

[adam5532]

Adam,

I have an item attribute



For many of my items.

Looks like all of the orders that bomb have an item with this attribute in it.

I am going to get rid of that attribute, re down load and try again.

Keeping my fingers crossed

OK.

And please, upload iif files as attachments. As you can see, if you put them in the body of the message there are no columns and they are impossible to read.

Thanks,
- Adam

[litepockets]

Adam,

Or anyone...

First off, thank you Adam I just started with both quickbooks and this mod today. My head is spinning, but i do truely appreciate this mod.

I was curious though, for us drop-shippers.. Is there away to import the orders to Quickbooks as Purchase orders? That would prove to be so much more efficient for me..

Thanks!