Quickbooks Import QBI

djstern:

I ordered a bunch of new products to replace items that I've sold and adjusted the inventory quanity in Quickbooks, and changed the sale price on a few things as well. Is there a way that I can upload the adjusted inventory quanity and prices from Quickbooks to Zen Cart or do I have to do that manually? I'm not adding new items to the store. Just adjusting inventory quanity and prices on existing items.

QBI currently can not upload QB inventory counts into Zen-Cart. However, this feature is planned for the future.

Thanks,
Adam

So, what files would I have to alter in order to have ONE header line and change the extension from IIF to XLS? I'm kind of reverse engineering here.

I'd think you'd have to have about 3 headers. v_product_id, v_products_price, and v_products_quantity if I remember the headers correctly. Not sure about that though.

hd28usa:

So, what files would I have to alter in order to have ONE header line and change the extension from IIF to XLS? I'm kind of reverse engineering here.
I'm not sure what your intent is in doing this, but the only file that you'd need to alter would be qbi_output_iif.php In fact, you could make a new output class qbi_output_xls.php based on the iif output file, and add it to the output file types. QBI is completely modular and the code that formats the output is completely separated from the code that does everything else.

Thanks,
Adam

adam5532:

I'm not sure what your intent is in doing this, but the only file that you'd need to alter would be qbi_output_iif.php In fact, you could make a new output class qbi_output_xls.php based on the iif output file, and add it to the output file types. QBI is completely modular and the code that formats the output is completely separated from the code that does everything else.

Thanks,
Adam

Nice Adam. Actually, do mean qbi_classes_iif.php instead of qbi_output.php? The latter doesn't exist in the release I have. I was trying to modify the classes files. I'm customizing the output to work with AdvancePro from AdvanceWare. They require specific headers in correct order and import TXT, CSV, and XLS filetypes. After I import the orders to this software, the orders are passed to the accountant on her Quickbooks computer.

I basically have a "middle-man". Thanks for the quick reply!

hd28usa:

Nice Adam. Actually, do mean qbi_classes_iif.php instead of qbi_output.php? The latter doesn't exist in the release I have. I was trying to modify the classes files. I'm customizing the output to work with AdvancePro from AdvanceWare. They require specific headers in correct order and import TXT, CSV, and XLS filetypes. After I import the orders to this software, the orders are passed to the accountant on her Quickbooks computer.

I basically have a "middle-man". Thanks for the quick reply!
Sorry, yes I meant qbi_classes_iif.php When you create the new xls class and add it to the dropdown list of output types, QBI will automatically use the xls file extension on the file name.

Thanks,
Adam

adam5532:

Sorry, yes I meant qbi_classes_iif.php When you create the new xls class and add it to the dropdown list of output types, QBI will automatically use the xls file extension on the file name.

Thanks,
Adam

Ok, so you pull the file extension from the class's file name? No need to reply. I get where you are going. I was in the right direction and tried copying the info from the IIF class file to the XML class file. I ran into a server error. I will try this again with the new XLS filetype.

Thanks..

hd28usa:

Ok, so you pull the file extension from the class's file name? No need to reply. I get where you are going. I was in the right direction and tried copying the info from the IIF class file to the XML class file. I ran into a server error. I will try this again with the new XLS filetype.

Thanks..
You'll actually need to make a small change at the beginning of the create_files_orders class in the qbi_classes_output.php file for the output extension. Also, note that you need to modify both the output_file_iif and output_file_iif_us classes to be what you want. I'd suggest copying them to output_file_xml and output_file_xml_us since those are already set up, and then worry about the file extension later. You'll also need to include any new class files in qbi_app_top.php

• Adam

adam5532:

You'll actually need to make a small change at the beginning of the create_files_orders class in the qbi_classes_output.php file for the output extension. Also, note that you need to modify both the output_file_iif and output_file_iif_us classes to be what you want. I'd suggest copying them to output_file_xml and output_file_xml_us since those are already set up, and then worry about the file extension later. You'll also need to include any new class files in qbi_app_top.php

• Adam

Thanks. Got the app to pull from qbi_classes_xml.php. But, the file extension change does not let me download a file when I change:

$format='xml'

to

$format='xls'

in the qbi_classes_output.php file. There are two places this comes up in this file.

I can, however, download an XML file now.

EDIT

I can download a file, but it is an IIF file (contents to be edited) with the correct file extension (XLS). I may actually end up doing a CSV file in the end BTW.

adam5532:

QBI currently can not upload QB inventory counts into Zen-Cart. However, this feature is planned for the future.

Thanks,
Adam

Any idea when we might expect to see this feature? It would save a lot of time updating inventory count and prices in the store. I'm sure a lot of us would really appreciate that feature.

drc2100:

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

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/login.php?zenAdminID=1bf0aa86aa5cd7375c39d0c96de798bc

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?

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.

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.

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.

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.
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

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/login.php?zenAdminID=1bf0aa86aa5cd7375c39d0c96de798bc

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

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

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

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

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
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