Quickbooks Import QBI

[Randolph Hoppe]

Thanks for suggesting that possible solution. I will try to get the text forms and send them to you. It would be awesome if this worked and I am sure there are other MYOB fans out there that would appreciate it.

Thanks again -

Doug

Another MYOB-interested user here. Any news?

- Rand

[hd28usa]

I can't seem to tell exactly what this error means from using the CRON script to process the export files:

PHP Warning: main(includes/languages/english/): failed to open stream: No such file or directory in /var/www/html/newzen/admin/includes/init_includes/init_languages.php on line 34
PHP Warning: main(): Failed opening 'includes/languages/english/' for inclusion (include_path='.:/usr/share/pear') in /var/www/html/newzen/admin/includes/init_includes/init_languages.php on line 34
Status: 302
X-Powered-By: PHP/4.3.9
Set-Cookie: zenAdminID=1bf0aa86aa5cd7375c39d0c96de798bc; path=/; domain=192.168.1.110
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
Content-Type: text/html; charset=iso-8859-1
Location: http://192.168.1.110/newzen/admin/lo...39d0c96de798bc



What file in the language folder is init_languages.php calling for? I added english.php manually in the init_languages.php file, but got the same error with the english.php file at the end of the path.

What am I missing here? Is this a QBI issue or Init Laguages (Zen) issue?
Adam, did the cron script work successfully for you?

[djstern]

I have a couple of diffrent stores running. Is there a practicle way that I can download orders etc from each store into the same Quick Books account and keep track of what orders come from what store? This is necessary because both stores are part of the same company and use the same bank account.

[BlessIsaacola]

I have a couple of diffrent stores running. Is there a practicle way that I can download orders etc from each store into the same Quick Books account and keep track of what orders come from what store? This is necessary because both stores are part of the same company and use the same bank account.

If you version of QB allow you to create "Class" do that and when you import the orders attach them to the appropriate class. That should fix the problem.

[adam5532]

I have a couple of diffrent stores running. Is there a practicle way that I can download orders etc from each store into the same Quick Books account and keep track of what orders come from what store? This is necessary because both stores are part of the same company and use the same bank account.

Since you'd have a different QBI config for each store, you could set the Invoices:Invoice Rep: field to be different for each store. You could also set the Invoices:Invoice/Sales Receipt 'PO Number': field to have a different letter prefix for each store.

Thanks,
- Adam

[adam5532]

I can't seem to tell exactly what this error means from using the CRON script to process the export files:

PHP Warning: main(includes/languages/english/): failed to open stream: No such file or directory in /var/www/html/newzen/admin/includes/init_includes/init_languages.php on line 34
PHP Warning: main(): Failed opening 'includes/languages/english/' for inclusion (include_path='.:/usr/share/pear') in /var/www/html/newzen/admin/includes/init_includes/init_languages.php on line 34
Status: 302
X-Powered-By: PHP/4.3.9
Set-Cookie: zenAdminID=1bf0aa86aa5cd7375c39d0c96de798bc; path=/; domain=192.168.1.110
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
Content-Type: text/html; charset=iso-8859-1
Location: http://192.168.1.110/newzen/admin/lo...39d0c96de798bc



What file in the language folder is init_languages.php calling for? I added english.php manually in the init_languages.php file, but got the same error with the english.php file at the end of the path.

What am I missing here? Is this a QBI issue or Init Laguages (Zen) issue?
Adam, did the cron script work successfully for you?

What happens when you try the regular qbi_create.php page? Do you not receive any errors?

Thanks,
Adam

[hd28usa]

When I use the qbi_create.php page, I get the same error.

[adam5532]

QBI 3.10 has finally been released and is available in the download section!
- Adam

New Features:
1. Added special handling for PayPal orders
2. Product match model and name width are now user settable
3. Maximum file size setting displayed on upload page
4. Added user registration system

Fixes and improvements:
1. Fixed a bad object reference in all the set-up pages (was $this) that prevented the delete function from working
2. Made iif file upload Mac compatible
3. Removed DEFAULT CURRENT_TIMESTAMP from SQL to make it compatible with MySQL prior to 4.1.
4. Made config form php5 compatible
5. Fixed various data format errors when uploading and parsing QB iif files (strip comma and percentage)
6. Fixed "Empty delimiter" error when creating iif file containing certain shipping methods
7. Product options and option values are now sorted properly
8. Added error log entry for missing product models in orders
9. Now converts all double quotes to single quotes in iif to avoid import errors
10. qbi_products.iif is now ordered by product model
11. Warning message is displayed on the create page if a model number is missing
12. Shipping lines not added if shipping cost is zero
13. "Update Payment Types" button is hidden if QB payment types have not been imported
14. Ship match made case-insensitive to correct problem with some shipping methods
15. Ship comparison is bypassed if carrier service is missing from shipping methods table
16. Code optimized to speed up cart module detection
17. Added file system constants to the log files
18. Suppresses log file link if log is not yet created
19. Changed the tab order in Setup and Match to prevent long products lists from delaying page load
20. Corrected various css problems affecting the menus in IE
21. Cart shipping text fields lengthened
22. Products list now includes all sub-items before sub-sub-items to prevent crash in QB for Mac
23. Semi-colons in option values filtered out to prevent mistaken sub-item creation by QB
24. Fixed initialization of database to active
25. Added back option to import orders with any status

[landshark]

Adam,

I just uploaded the files and upgraded the database. Wheni i go to configure i am seeing this warning at the top:

Warning: constant(): Couldn't find constant ORDERS_PAYPAL_STATUS_IMPORT_C in /home/diystore/public_html/catalog/admin/includes/classes/qbi_classes.php on line 1271

Warning: constant(): Couldn't find constant QBI_PAYPAL_STATUS_SELECT_C in /home/diystore/public_html/catalog/admin/includes/classes/qbi_classes.php on line 1271

I adjusted the new paypal settings and the warning is still there. Not sure how to fix this.

Thanks,

Mike

[adam5532]

Adam,

I just uploaded the files and upgraded the database. Wheni i go to configure i am seeing this warning at the top:

Warning: constant(): Couldn't find constant ORDERS_PAYPAL_STATUS_IMPORT_C in /home/diystore/public_html/catalog/admin/includes/classes/qbi_classes.php on line 1271

Warning: constant(): Couldn't find constant QBI_PAYPAL_STATUS_SELECT_C in /home/diystore/public_html/catalog/admin/includes/classes/qbi_classes.php on line 1271

I adjusted the new paypal settings and the warning is still there. Not sure how to fix this.

Thanks,

Mike

Woops! This error does not in any way affect the functioning of the program. To fix it, add these lines:

File: /catalog/admin/includes/languages/english/qbi_general.php
Where: anywhere inside the php tags
Add:

define ('ORDERS_PAYPAL_STATUS_IMPORT_C', '');
define ('QBI_PAYPAL_STATUS_SELECT_C', '');

Thanks,
Adam