Quickbooks Import QBI

[adam5532]

I did download 3.21b from zencart. After installation every page of it says that I need to register my copy. I click the link it takes me to a site that says the site has moved click the next link and it asks for money. Where am I going wrong? I would love to reinstall this mod and use it.

Thank you,
John

The registration system was planned but I never completed it. You do not have to register it. Not being registered in no way affects its operation.

Thanks,
Adam

[stevenlee]

I exported the customers and orders and that worked fine but then I tried to export the products and it said:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 457 bytes) in rollermangosport.com/admin/includes/classes/qbi_classes.php on line 535

any clues as to what is causing the error, we want to get this version running and upgrade to the new 3.75 if it does what I think it does, as I understand it the 3.75 version will export the Attributes of the order to quickbooks, like the price and description of the Attributes when someone orders something, so we can track the inventory of the attributes, that is what we really need and if 3.75 can do that then we are all for it

thanks very much for the great software

[adam5532]

Hi,

You have a lot of products or product/attribute combinations. You need to increase the max memory for PHP above 8 MEG. There is a php.ini setting to do that.

QBI 3.75 can do what you say below, although it may get complicated if you have a lot of product options. I believe there is also a contribution which can do that. You'll need to determine which route is best for your situation.

Thanks,
Adam

I exported the customers and orders and that worked fine but then I tried to export the products and it said:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 457 bytes) in rollermangosport.com/admin/includes/classes/qbi_classes.php on line 535

any clues as to what is causing the error, we want to get this version running and upgrade to the new 3.75 if it does what I think it does, as I understand it the 3.75 version will export the Attributes of the order to quickbooks, like the price and description of the Attributes when someone orders something, so we can track the inventory of the attributes, that is what we really need and if 3.75 can do that then we are all for it

thanks very much for the great software

[bumba000]

I have installed QBI 3.21b now and have a downloaded file of all orders. I have set up a test account in Quick Books. I tried to import the .iif file following the PDF instruction manual and this is what I get.

"Quick Books has detected that one of your items does not have an account associated with it."

I have tried to open this file with excel and with notepad so that I can see all the headers but it is severely broken when viewing that way. How can I see what I need to create in QB for this file to import?

Thanks in advance,
John

[adam5532]

Hi,

I have installed QBI 3.21b now and have a downloaded file of all orders. I have set up a test account in Quick Books. I tried to import the .iif file following the PDF instruction manual and this is what I get.

"Quick Books has detected that one of your items does not have an account associated with it."

You probably have not configured QBI properly. All items in Red on the Configuration page must be filled out. Specifically, you are likely missing one of these:

COGS account:
Item income account:
Item asset account:

I have tried to open this file with excel and with notepad so that I can see all the headers but it is severely broken when viewing that way. How can I see what I need to create in QB for this file to import?

Thanks in advance,
John

Associate .iif files with Excel. Then, double click on the file in Windows Explorer, instead of opening it inside of Excel. Then each field should line up in each column.

Thanks,
Adam

[bumba000]

When I tried importing the customers they all imported fine. When we try to import orders it just continuously gives the same error. We say okay and it goes to the next identical error. This will continue until the status indicator reaches 100% or until we cancel the import. Do we have to set up an account in quick books for each of these things? 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

I don't do much with quick books and don't know how to do this. If I have a super blank quick books install what steps do I need to take to get these imports to work?

Thank you,
John

[bumba000]

Okay. This imported my customers and my products. The orders file still gives me errors every couple of seconds. The error is: "Can't record invalid transaction". It gives me the row number that its having a problem with but that row in excel looks just like many other rows which seem to import just fine. In the end there are hundreds of errors. All the same error. I have added some name or generic text to every field in the configure. Things that I'm really not sure about I just typed in the title of that text box in the configure. Since I did this the errors now start at row 108 rather than 8.

I would greatly appreciate any advice you can give me here.

Thanks in advance,
John

[adam5532]

John,

I have added some name or generic text to every field in the configure. Things that I'm really not sure about I just typed in the title of that text box in the configure.

Well that tells me a lot! You CAN NOT do that and expect QBI to work. QBI MUST be configured completely before you try to use it. You can not just "test it out." It MUST be configured for your Quickbooks file, or you will get import errors. You can not just put random text in the configuration. Accounts MUST match what is in your Quickbooks company file. It may take you an hour or more to set up.

I suggest that first, you carefully set up your Quickbooks company the way you want it. Then, read the QBI manual from start to finish and set up each configuration option according to the instructions in the manual. Then, do Setup and Match in QBI, according to the instructions. Don't even try to use QBI until you have done this!

Thanks,
Adam

[andrewmp]

Hey, I'm new to the forum and QBI seems to be the solution to my objective. I want to be able to automatically import my sales into Endicia’s Dazzle Shipping Program to create the shipping labels. I know this has been discussed extensively on this forum, but the 70+ pages of replies are a bit daunting to wade through.

If it has been discussed on how to implement this, I would really appreciate a link to the correct page to save me the time of searching each page one by one.

I don't use Quick Books, so if there is a way to do this with out the use of quick books that would be preferable. If not I'm open to using it.

Like I said, all I want to do is easily import the correct data from zen cart sales to Endicia’s Dazzle Shipping Program to print off the shipping labels and postage. Any help?

[adam5532]

Hi,

Hey, I'm new to the forum and QBI seems to be the solution to my objective. I want to be able to automatically import my sales into Endicia’s Dazzle Shipping Program to create the shipping labels. I know this has been discussed extensively on this forum, but the 70+ pages of replies are a bit daunting to wade through.

QBI can not be used to import into Dazzle.

- Adam