Quickbooks Import QBI

[adam5532]

I might of missed in earlier posts it but If we have part #'s with different colors, Will this import into quickbooks as an attribute?

Thanks,

Ben

Yes, attributes will become sub-items in Quickbooks.
- Adam

[ncmx1]

Thanks!

I am looking forward to using this.

[helpme]

I am bad need of an accounting program and it looks as if QB is the best solution.
My question for all of you that use this, what verision do I need to get? I am running Vista if that makes a difference.
Thanks for any help or ideas!

[adam5532]

I am bad need of an accounting program and it looks as if QB is the best solution.
My question for all of you that use this, what verision do I need to get? I am running Vista if that makes a difference.
Thanks for any help or ideas!

To use it with QBI, you need US versions of Quickbooks Pro, Premier, or Enterprise. QBI works with all years, including 2008.

Thanks,
Adam

[chris parker]

Hi there,

I am using the quickbooks import and am very impressed. Well done.

I have a slight problem though with the way the addresses are formatted in Excel.

I have the box unticked in the configuration for the "Limit addr to 3 lines", but in the excel sheet, most of the address (the city, county, and postal code) is contained within one cell labelled "BADDR4".

It is taking ages to seperate them in Excel. I wonder if it is possible to have these fields seperated into 3 fields automatically?

Many thanks.

[adam5532]

Hi,

Hi there,

I am using the quickbooks import and am very impressed. Well done.

I have a slight problem though with the way the addresses are formatted in Excel.

I have the box unticked in the configuration for the "Limit addr to 3 lines", but in the excel sheet, most of the address (the city, county, and postal code) is contained within one cell labelled "BADDR4".

It is taking ages to seperate them in Excel. I wonder if it is possible to have these fields seperated into 3 fields automatically?

Many thanks.

From your use of "unticked" instead of "unchecked," I suspect you are in the UK? QBI 3.21 only works with US versions of Quickbooks. For US addresses, City, State, and Postal Code all go on one line -- this is as it should be, to conform with address format standards in the US. QBI will put it on the 3rd or 4th line, depending on whether the address includes a company name or just a personal name.

The checkbox is for very old versions of Quickbooks, which only support a maximum of 3 address lines instead of 5. In this case, QBI will put everything on 3 lines, combining the company and personal names on one line if necessary. Since no-one should be using a version of QB that is that old, this feature has little usefulness any more and will likely be dropped in the future.

Unfortunately, the iif format only supports address lines. There are no separate fields for Company, Name, Address, City, State, Postal Code, and Country (actually, there are fields for Company and Name, but these are used elsewhere and not for the address block). The fields that it has are for the 5 billing and shipping address lines, so QBI has to construct the address, using US addressing conventions. Quickbooks parses these back out again in the background after the customer and order are imported.

QBI 4.x is planned to include support for Canadian and UK Quickbooks, with the appropriate address formatting.

Thanks,
Adam

[jazzah]

Hi Adam, Any word on a version for Australia yet? desperately needed?
What did other Aussies do in the interim?

[adam5532]

Hi Adam, Any word on a version for Australia yet? desperately needed?
What did other Aussies do in the interim?

I can't give a time for completion yet. My current priorities are supporting current users, rewriting the manuals, eliminating any bugs, and completely automating the installation procedure. Following that, continuing on adding support for multiple tax zones, xml output, and UK and Canadian support, which will result in the release of 4.0. After that, I will look at other nationality versions of QB.

Thanks,
Adam

[Stamper]

I just did an install of QBI Quickbooks Import V3.21b. When I go to admin and click on Quickbooks Import QBI I get the following server error:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


I have renamed my admin folder for security reasons, but I'm pretty sure I placed the QBI Quickbooks Import files from admin into the correct places. I'm wondering if one of the QBI files has a hard reference to the admin folder which is causing this. I tried searching through the files without any luck. Does anyone have any possible solutions? I have not experienced any similar errors from my server prior to the install, which makes me think its QBI related rather than a server configuration issue.

Thanks! Clive

[Stamper]

To add to my previous post -
I'm getting a "Premature end of script headers:" error in my server log.

Also, I have another test cart on the same server without renamed admin and QBI seems to work OK. 404 Not Found error is just due to a missing 500 error shtml file.