Quickbooks Import QBI

Printable View

Show 100 post(s) from this thread on one page

29 May 2007, 09:22 PM
adam5532

Re: Quickbooks Import QBI

Quote:

Originally Posted by reza

hi adam
I know my question seems to be very simple, BUT for me is still working with QBI foggy .
wel, I installed QBI 3.21 on a fresh zen1.3.7, in admin I could configure quickbooks import and I see all menus of the QBI.
then I went to creat iif, and above the page I see:
Warning: Some products are missing the model name! Correct this issue before creating iif files!
anyway, when I try do download for exp.
All Previous Products
Quan: 141
No.: 2 to 208
Date: Nov 3, 2003 12:32 pm to Apr 27, 2007 12:08 pm
or
All Customers
Quan: 1
No.: 1

i get this message:
Fatal error: Class 'output_file_iif_gb' not found in ...www\catalog\admin\includes\classes\qbi_classes_output.php on line 46

now two question:
1- do I have to donload or buy another software in order to work with QBI, if yes, any idea or some links ? is there any program ?
2- why do I get this message, even if I have this file in the class directory?

thanks

You have selected the country as UK on the QBI Configuration page. That file does not exists -- currently, you can only set it to US. Just correct this and click Save to update the configuration, and all should work! I had anticipated adding a UK module to version 3.x, but haven't. Quickbooks UK compatibility will be in QBI 4, which I hope to have ready in a couple of months.

You need to make sure to fill in the Model field on all your products. Open each product in your Zen Cart admin and add model numbers where they are missing.

Thanks,
Adam
29 May 2007, 09:26 PM
adam5532

Re: Quickbooks Import QBI

Quote:

Originally Posted by athena

Adam,
Please advise - back in August 2006 we installed this mod and it placed all our shipped orders with a status of processing in the Zencart Admin control panel. We have not been able to get them out of processing even though we used the QBI configure to reset in this manner:

Control Panel > Customers > QBI > Configure >

Orders:
Import orders with status: Processing

Update status:
Change CC order status to: Shipped
Change check/mo status to: Updated

Update

What is to be done?

Hi,

The setting in QBI will affect all future orders that you import with QBI. It will not change the status of orders that you have previously imported. You'll probably have to change each one manually.

Thanks,
Adam
30 May 2007, 10:41 PM
athena

Re: Quickbooks Import QBI

Thanks for being so quick adam,
I don't really get it, however.

These were all the orders in zencart previous to installing QBI. It happened on installation. It has not happened to any orders since. Would the zen team know how to fix it?
3 Jun 2007, 09:04 PM
adam5532

Re: Quickbooks Import QBI

Quote:

Originally Posted by athena

Thanks for being so quick adam,
I don't really get it, however.

These were all the orders in zencart previous to installing QBI. It happened on installation. It has not happened to any orders since. Would the zen team know how to fix it?

QBI does not change the status of any existing orders - it has no way to do this. It only changes the status of orders that you import, according to the setting in the QBI configuration. There must be something else that caused this.

If you need to change the status of a large number of previous orders to Delivered, you can run the following SQL command from PHPMyAdmin in you website control panel, where xx is the lowest order id and yy is the highest order id. Make sure to backup your MySQL database beforehand, and get someone to help you or do it for you if you need to.

UPDATE orders SET orders_status=3 WHERE orders_id >= xx AND orders_id<=yy

Thanks,
Adam
4 Jun 2007, 10:26 PM
dootch

Re: Quickbooks Import QBI

After installing the database per instructions go to configure and get the following errors:
Warning: opendir(DIR_QBI_CLASSES) [function.opendir]: failed to open dir: No such file or directory in admin/includes/classes/qbi_classes.php on line 937

Warning: readdir(): supplied argument is not a valid Directory resource in admin/includes/classes/qbi_classes.php on line 938

Warning: sort() expects parameter 1 to be array, null given in admin/includes/classes/qbi_classes.php on line 945
QBI version 3.02

and a bunch more related to paypal etc. Tried reinstalling db by dropping config but no luck??
4 Jun 2007, 11:46 PM
adam5532

Re: Quickbooks Import QBI

Quote:

Originally Posted by dootch

After installing the database per instructions go to configure and get the following errors:
Warning: opendir(DIR_QBI_CLASSES) [function.opendir]: failed to open dir: No such file or directory in admin/includes/classes/qbi_classes.php on line 937

Warning: readdir(): supplied argument is not a valid Directory resource in admin/includes/classes/qbi_classes.php on line 938

Warning: sort() expects parameter 1 to be array, null given in admin/includes/classes/qbi_classes.php on line 945
QBI version 3.02

and a bunch more related to paypal etc. Tried reinstalling db by dropping config but no luck??

It looks like you didn't copy the QBI file admin/includes/qbi_app_top.php to your server, or it got corrupted in the transfer.

Thanks,
Adam
8 Jun 2007, 11:31 PM
numinix

Re: Quickbooks Import QBI

I'm just wondering when this contribution will support the Canadian version of QuickBooks?
9 Jun 2007, 02:58 AM
adam5532

Re: Quickbooks Import QBI

Quote:

Originally Posted by numinix

I'm just wondering when this contribution will support the Canadian version of QuickBooks?

I'm working every day on QBI 4, which will support UK and Canadian. But it may still be a few months till it is ready, as there will be a lot of new features.

Thanks,
Adam
10 Jun 2007, 04:38 AM
swingandmiss

Re: Quickbooks Import QBI

I've got almost everything setup with QBI and Quickbooks, but am having a problem matching with shipping. I've read the entire manual, and haven't found my solution. Very nice manual by the way.

I use the USPS shipping module and allow First Class Package and Priority. In Quickbooks, I only have one shipping method and that is US Mail.

1) I see USPS Priority mail in the shopping cart methods and can match that with US Mail. However, I don't see a USPS First Class Package method. So when people select USPS First Class Package, what will that match up with?

2) Why are all the Shopping Cart methods showing up (UPS, walk-in, table, etc...) in the list when the only one I have installed is the USPS module?

I really appreciate all the time and effort that you've put into this. When I get everything working, I'd gladly donate to keep your efforts going.
11 Jun 2007, 06:49 AM
adam5532

Re: Quickbooks Import QBI

Quote:

Originally Posted by swingandmiss

I've got almost everything setup with QBI and Quickbooks, but am having a problem matching with shipping. I've read the entire manual, and haven't found my solution. Very nice manual by the way.

I use the USPS shipping module and allow First Class Package and Priority. In Quickbooks, I only have one shipping method and that is US Mail.

1) I see USPS Priority mail in the shopping cart methods and can match that with US Mail. However, I don't see a USPS First Class Package method. So when people select USPS First Class Package, what will that match up with?

2) Why are all the Shopping Cart methods showing up (UPS, walk-in, table, etc...) in the list when the only one I have installed is the USPS module?

I really appreciate all the time and effort that you've put into this. When I get everything working, I'd gladly donate to keep your efforts going.

The USPS shipping methods do not match correctly due to inconsistencies in the that shipping module. Since so few people use USPS, I haven't resolved this, but I will look at it.

QBI finds and shows all the shipping methods that are available, even if they are not installed.

Thanks,
Adam

Show 100 post(s) from this thread on one page