Quickbooks Import QBI

Quote:

---

Originally Posted by MikeyG

Okay I am really having a battle with this.

If I don't have a model number I can seem to export the product and so a the moment I only have product withg any model info (not many as I have not really been using this field.)

---

I don't know why Zen-Cart doesn't enforce mandatory use of this field. It is pretty much universal in inventory systems for every item to have a stock number or UPC. QuickBooks requires it -- that's the item 'Name'. If I didn't enforce this, and used the products_id instead, the item Name in QB would import as a meaningless integer.

Quote:

---

I am also cconfused about how to get the product to list in the drop downs under the Match in order to do the mapping properly. I seem to be in a catch 22. Want to get the product into quick books (which is empty at moent) I have 6000+ combinations with attributes and don't want to retype but I can get them into quick books to then get them back out to map them for the purposes of stock control.

---

I think you are misunderstanding how QBI works. If you currently have no products in QB, then make an iif of all Products from the QBI Creat IIF page and import this into QB. Then no matching is required! And, all your attributes (up to 5 options and unlimited option values) will be imported as sub-items, with complete inventory control in QB.

Note that all items will import as zero stock, even though the iif contains stock quantities for products (not attributes, as this is a limitation of Zen-Cart). This is because QB can not create stock without knowing where the stock came from! In other words, you will need to do a stock adjustment in QB, or create PO's in QB to account for these items. Since it is an accounting system, if it imported stock but didn't know how it was purchased, that stock would have no value!

Once you set up the stock levels in QB, then even though Zen-Cart can not track attribute stock, you will have complete inventory control of each option value combination in QB!

Thanks,
Adam

Quote:

---

Originally Posted by audradh

I'll have to do a little more testing to be sure what QBI does w/ single attributes.

---

Note that while matching currently only works with a limited number of attributes, if you don't need to use matching, you can import products and orders with up to 5 levels of attributes using QBI! I doubt that more than 5 levels is needed -- with 3 values each, that would be 243 versions of one product -- with 5 values each, 3125 versions!

- Adam

Tried to search for references to this program working with MYOB accounting software but did not find anything discussed. We sell music downloads and product and accept credit cards and paypal and need to get sales data from Zen Cart to MYOB.

Thanks for any info and sorry if it has been discussed.

Quote:

---

Originally Posted by drc2100

Tried to search for references to this program working with MYOB accounting software but did not find anything discussed. We sell music downloads and product and accept credit cards and paypal and need to get sales data from Zen Cart to MYOB.

Thanks for any info and sorry if it has been discussed.

---

QBI only works with Quickbooks. Each accounting system has its own data format. I have a lot of features to add to QBI, including non-US support, so it is unlikely that I will add compatability with any other accounting system for quite some time, if at all. You might consider converting to Quickbooks!

Thanks,
Adam

Thanks for your prompt reply. We all work on Macs here and the accountants I work with prefer MYOB for many reasons and we are entrenched at this point. We were able to import easily form Pay Pal before we upgraded to our Zen Cart in April and added standard credit cards thru authorize.net. I am sure we wil eventually find a work around.

Given what we went through to make the music store sell individual track and album downloads this should be just a matter of time and effort.

Thanks again

Quote:

---

Originally Posted by drc2100

Thanks for your prompt reply. We all work on Macs here and the accountants I work with prefer MYOB for many reasons and we are entrenched at this point. We were able to import easily form Pay Pal before we upgraded to our Zen Cart in April and added standard credit cards thru authorize.net. I am sure we wil eventually find a work around.

Given what we went through to make the music store sell individual track and album downloads this should be just a matter of time and effort.

Thanks again

---

It does look like MYOB will accept tab delimited files, like QB. The format has some differences. I took a look at their support site, and it provided some information but it wasn't complete. It doesn't show how the headers are set up, and how totals are listed on the sales order. If you are able to get a sample text file of a sales order and a customer record in the proper format for import into MYOB, please send it to me and I'll take a look.
Thanks,
Adam

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

I am trying to export my shopping cart and I am getting this error:

Fatal error: Call to undefined function: create_product_header() in /home/scouting/public_html/admin/includes/classes/qbi_classes_output.php on line 322

What can I do to fix this?

Mike

I figured out the issue with the error code. Now what is happening is that my client is using QB 2006 with Merchant Services. The way I understood QBI, is that the order, including the credit card info, will be downloaded into Quickbooks using the orders.iif file and then that order could be processed using Quickbooks and Quickbooks Merchant Services.

Well, the credit card info is not downloading. Did I misunderstand QBI? If so, what do I need to fix the issue?


Mike

Quote:

---

Originally Posted by mikecrane

I figured out the issue with the error code. Now what is happening is that my client is using QB 2006 with Merchant Services. The way I understood QBI, is that the order, including the credit card info, will be downloaded into Quickbooks using the orders.iif file and then that order could be processed using Quickbooks and Quickbooks Merchant Services.

Well, the credit card info is not downloading. Did I misunderstand QBI? If so, what do I need to fix the issue?


Mike

---

Mike,
In the future, QBI will directly interface to QB in order to support additional features such as this, but right now using the iif file format it can not import credit card numbers. The iif format does not even have any fields for the credit card information. QBI works with merchant services that are integrated directly into the shopping cart, and for most people this is a much better solution anyway. When it is integrated into the cart in real time, you do not have to do any additional steps later to charge the card, and you do not have to waste time contacting the customer if it is declined, because the customer can make corrections or try another card immediately. Also, for customer security, it is best not to even store the numbers in QB, since they are not needed once the sale is completed.

I believe that there may be a contribution that allows you to link to the QB merchant services in real time from the cart. You may also consider using Authorize.net instead, which is quite popular and used by many people, and it works perfectly with QBI.

QBI does know that the card has been charged, and does import the payment as an invoice/payment, or as a sales receipt (preferrable configuration). Because the card has already been charged online, there is no need to import any credit card information.

Thanks,
Adam

Adam,

thanks for your advice so far. I have started again from scratch and taking your advice about creating an iif file for product. (and thanks for the my sql to get product id into model) However I get when trying to upload/creat the product iif:

Fatal error: Class 'output_file_iif_gb' not found in ...\admin\includes\classes\qbi_classes_output.php on line 299


have I missed something in the way of fixes earlier ion this thread.

many thanks

MG

Quote:

---

Originally Posted by MikeyG

Adam,

thanks for your advice so far. I have started again from scratch and taking your advice about creating an iif file for product. (and thanks for the my sql to get product id into model) However I get when trying to upload/creat the product iif:

Fatal error: Class 'output_file_iif_gb' not found in ...\admin\includes\classes\qbi_classes_output.php on line 299


have I missed something in the way of fixes earlier ion this thread.

many thanks

MG

---

You have chosen a country version other than United States on the configuration page. There is a note next to this option noting that other countries are not yet supported.

Thanks,
Adam

Adam, thanks for your reply I did work this out eventually.

I have trouble getting the iif uploaded at the moment in order to map product to it.

Originally I only had two products showing one which was gift wrap and one that was carriage but now Icannot get any thing to map to.

Have I missed a trick

thanks

MG

Quote:

---

Originally Posted by MikeyG

Adam, thanks for your reply I did work this out eventually.

I have trouble getting the iif uploaded at the moment in order to map product to it.

Originally I only had two products showing one which was gift wrap and one that was carriage but now Icannot get any thing to map to.

Have I missed a trick

thanks

MG

---

Check your configuration settings for Items | Match Types.

Thanks,
Adam

Quote:

---

Originally Posted by 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

---

Count me in :)

Hello! Just checking, this mod won't work for me as I'm in Canada and using a Canadian version of QB, is that right?

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.

Hello! I am very new to ZenCart and have a question. I live in Canada, and am wondering if the Quickbooks Import QBI will work successfully with my Quickbooks Premier 2005 (Canada version). I have found different comments on this forum and am unclear if I will be able to successfully import my orders into my Quickbooks.

Please let me know the real answer. Thanks!:smile:

Okay...so this newbie found her own answer...and for any other Canadians that want to know if this module works on Canadian Quickbooks Program..the answer is NO.

So now I need some feedback from other Canadian Businesses. What have you done to effectively use ZenCart and Quickbooks without creating too much work for yourself? Do I just need to input each order manually into Quickbooks? Or is there a better way of managing inventory and tracking income that I am not thinking about?

I would love to hear how other Canadian Businesses have gotten around this.

Thanks! :smile:


www.babysigns.ca

Hi! I personally input each order manually and it's surprisingly not that bad. However, I don't input the customer info. What I did was create a customer called All Customers and just used that for each invoice, saves a ton of time! I use multi-currency, so I made an All Customers-CAD and an All Customers-USD so that the orders are in the correct currency.

There is also a feature in Quickbooks called a Sales Summary where you enter all sales on one order, daily, weekly, monthly, whatever. Just look up Sales Summary in your QB help and it will tell you more about it!

HTH!

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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..

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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/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?

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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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?

---

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

Quote:

---

Originally Posted by 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:

Code:

---

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

---

Thanks,
Adam

Does anyone here know how to set up discounts, coupons and Low Order fees so that I can get my QBI working? I think this is the last thing I need to fix but I am sooooo confused:lamo:

Thanks in Advance
Emily

Quote:

---

Originally Posted by MommysTouch

Does anyone here know how to set up discounts, coupons and Low Order fees so that I can get my QBI working? I think this is the last thing I need to fix but I am sooooo confused:lamo:

Thanks in Advance
Emily

---

Emily,

I promise I will be available today for a phone consultation!

Thanks,
Adam

ME AGAIN!

Sorry to be such a pest but I had deleted some items that were on earlier invoices after they were sold out. This caused a problem in that QB could not import them from QBI since I did not have Models entered in for my items at that time.
Yesterday my techinal support added the module to Zen that allows you to go back and edit orders. So I went into the old orders and added models. However the orders still wil not import. Do you have any idea whay that would be?

Also I am having ordes that are not importing because they are not "in balance" What can cause that since I do not charge sales tax?

BTW I do have the newest version of QBI

Thanks in Advance

Quote:

---

Originally Posted by Emily-MommysTouch

ME AGAIN!

Sorry to be such a pest but I had deleted some items that were on earlier invoices after they were sold out. This caused a problem in that QB could not import them from QBI since I did not have Models entered in for my items at that time.
Yesterday my techinal support added the module to Zen that allows you to go back and edit orders. So I went into the old orders and added models. However the orders still wil not import. Do you have any idea whay that would be?

Also I am having ordes that are not importing because they are not "in balance" What can cause that since I do not charge sales tax?

BTW I do have the newest version of QBI

Thanks in Advance

---

Emily,

You added model numbers, but those items also need to exist in the Products list for your store, and those products need to exist in QB. Also, since you deleted those products in your products list, their products_id number is also invalid. What you would have to do is add those products back into Zen Cart, and then edit those orders to include the "new" products instead of the deleted ones.

Importing old orders can be a problem if you have deleted those products. QBI needs to refer back to the product list in order to properly construct products with attributes, and to change the language (if this option is selected) so that the invoice lists products in the store owner's language regardless of the customer's language. What I will likely do in a future version of QBI is allow QBI to create a generic product line for those items that it can't identify because they are missing. This will at least allow you to import old orders and help you to troubleshoot. Then at least you could modify that order in Quickbooks to replace the missing item.

In the meantime I suggest that you give up on importing old orders! It simply can't be done if you have deleted products (until I update QBI to accommodate this)! In the future, if you no longer wish to sell a product, you should set it to inactive in Zen Cart instead of deleting it. This is what you have to do in Quickbooks (set item to hidden) -- it doesn't allow you to delete items that have been used in transactions, because as you can see it can mess up all your record keeping and access to prior transactions. Unfortunately, Zen Cart doesn't prevent this (it should, in my opinion).

As for the out-of-balance transactions, it may be that you still don't have all the discount coupons set up and matched, or that you have deleted old discount coupons as well. If you look at the iif file in a text editor, you should be able to see what the issue is. If you need help with this, give me a call and we can do some additional consulting.

Thanks,
Adam

You are right it was deleted coupons!!! I swear I messed things up good with my deleting. Now I just put the products as inactive but it is too late for the past items.

I will be doing an import of new orders in about a week and will see if it works for all of them, if it does we are set for the future anyway.

Emily

I keep a inactive category in ZenCart called "Dead Items" and move things I no longer sell to that category and then set it to inactive. This helps me to keep things a little more organized and easier to work with. Would that mess up QBI or does QB not care where something is at in my store as long as it is there?

Also, I got a little carried away with attributes when I set up the store and am re-doing it with much fewer attributes. Will removing un needed attributes also mess up QBI as well? I don't think there is a way to set attributes as inactive and I hate to have to sort through a ton on attributes that I no longer use just to find the few that I'll still need.

Keeping my self out of trouble with dumb questions instead of dumb mistakes. :)

Thanks.

Quote:

---

Originally Posted by djstern

I keep a inactive category in ZenCart called "Dead Items" and move things I no longer sell to that category and then set it to inactive. This helps me to keep things a little more organized and easier to work with. Would that mess up QBI or does QB not care where something is at in my store as long as it is there?

---

As long as it is there it is fine.

Quote:

---

Also, I got a little carried away with attributes when I set up the store and am re-doing it with much fewer attributes. Will removing un needed attributes also mess up QBI as well? I don't think there is a way to set attributes as inactive and I hate to have to sort through a ton on attributes that I no longer use just to find the few that I'll still need.

---

If you remove unneeded attributes and then try to re-import old orders that contain them, then yes there would be problems. As long as you don't try to import old orders, it isn't an issue. Generally, there is no reason to import old orders, except for people who are setting up Quickbooks for the first time and want to get all their order history into it. But this creates other issues anyway, because then you have negative inventory in QB and have to adjust it or enter the corresponding vendor purchases! In a future version, QBI will be able handle missing items by inserting a generic item in its place.

Thanks,
Adam

ok so i had the QBI 3.02 installed but i didnt configure it . i updated to 3.1 today before i started to configure it and now i get these errors when i open qbi

QBI version 3.10

Warning: constant() [function.constant]: Couldn't find constant ORDERS_PAYPAL_STATUS_IMPORT_C in /home/snarkys/public_html/admin/includes/classes/qbi_classes.php on line 1271

Warning: constant() [function.constant]: Couldn't find constant QBI_PAYPAL_STATUS_SELECT_C in /home/snarkys/public_html/admin/includes/classes/qbi_classes.php on line 1271

Quote:

---

Originally Posted by snarkys

ok so i had the QBI 3.02 installed but i didnt configure it . i updated to 3.1 today before i started to configure it and now i get these errors when i open qbi

QBI version 3.10

Warning: constant() [function.constant]: Couldn't find constant ORDERS_PAYPAL_STATUS_IMPORT_C in /home/snarkys/public_html/admin/includes/classes/qbi_classes.php on line 1271

Warning: constant() [function.constant]: Couldn't find constant QBI_PAYPAL_STATUS_SELECT_C in /home/snarkys/public_html/admin/includes/classes/qbi_classes.php on line 1271

---

Please see post #240 to correct this. I will try to upload a 3.11 version to fix this shortly. It does not cause any functional problem.

Thanks,
Adam

Hi Adam,

I have been watching this thread for sometime and wondered if you have a time frame for releasing a version that will work in the UK?

Many thanks.

H

Quote:

---

Originally Posted by BigMacYin

Hi Adam,

I have been watching this thread for sometime and wondered if you have a time frame for releasing a version that will work in the UK?

Many thanks.

H

---

I can't promise a date. But, I just purchased the QB UK and Canada development versions, so I am committed to working on it. Hopefully it won't be too much longer!

Thanks,
Adam

Thats great Adam, thanks for letting me know. I look forward to the release.

Many thanks.

Kind regards,

H

Is there a version of this mod for 1.2.7d? Has anyone used it on this version?

Quote:

---

Originally Posted by ksoup

Is there a version of this mod for 1.2.7d? Has anyone used it on this version?

---

QBI should work with any version, as it is almost completely self contained. The contribution section doesn't let you specify a range of versions, so I set it to the latest version (I currently test it with 1.3.5) to indicate that it works with the latest versions of Zen Cart, but that doesn't mean it won't work with earlier versions.

Thanks,
Adam

Thank you for your quick response! :) We will try it out. Does it change any files? or just add to? :)

Quote:

---

Originally Posted by adam5532

QBI should work with any version, as it is almost completely self contained. The contribution section doesn't let you specify a range of versions, so I set it to the latest version (I currently test it with 1.3.5) to indicate that it works with the latest versions of Zen Cart, but that doesn't mean it won't work with earlier versions.

Thanks,
Adam

---

Quote:

---

Originally Posted by ksoup

Thank you for your quick response! :) We will try it out. Does it change any files? or just add to? :)

---

It has its own files. The only thing you need to do in the Zen Cart files is add the database table definitions and the menu item.

Thanks,
Adam

Adam, I was having trouble finding some files but its becuase I can read properly. I assumed something and thats why I am having trouble.



Thanks for the killer module

Hi Adam,

can you please give a quick overview of which Quickbooks versions are currently supported?

I run a business in Germany and was thinking of purchasing the German Version from Lexware (Quickbooks Plus 2007) but I guess this is totally incompatible with the current QBI version, right?

So is it possible to have the US version (Quickbooks Pro 2007) and set it up to use the German Tax system (19% sales tax in 2007) ?

I greatly appreciate your answers!

Quote:

---

Originally Posted by surfmueller

Hi Adam,

can you please give a quick overview of which Quickbooks versions are currently supported?

I run a business in Germany and was thinking of purchasing the German Version from Lexware (Quickbooks Plus 2007) but I guess this is totally incompatible with the current QBI version, right?

So is it possible to have the US version (Quickbooks Pro 2007) and set it up to use the German Tax system (19% sales tax in 2007) ?

I greatly appreciate your answers!

---

It is only tested to work with US versions of QB that have iif import. That includes Pro, Premier, and Enterprise. Because the column names and taxation lines differ in each version, it is unlikely to work at all with other country versions of QB. I am currently working on adding support for UK and Canadian versions. That is because these are the most requested, and Intuit has available developer's versions of these programs so I can test the integration. I will add other countries after that.

The US version can't display prices in Euros. Also, in the US tax is not included in the price of the product and is added as a separate item at the end. And currently, QBI can only support one tax rate, so if you have to charge different tax rates for different customers or products then it can't do that yet. It can support customers or products that are or are not taxed at that one rate.

Thanks,
Adam

Hi All,

Just a heads up that I am working on QBI 3.11, which fixes a few bugs found in 3.10 (the constants error message, and shipping methods multiplying each time you go to the Match:Shipping page) and has other minor improvements. It should be done this weekend. For more information, you can also visit the QBI support site at www.libermansound.com/qbi, where you can register your copy, view screen shots, and also visit the forum.

Thanks,
Adam

This seems like a fantastic mod and sure beats the way we do it now. I installed the mod as per the instructions (at least I think I did :cool: )but I got the follwing error messages

This is a brand new cart that has just a couple test products in it, as I am trying to get everything modified and working before loading all the products in, not sure if that is what is casuing the issue or not, but thought I would point it out.

Notice: Query failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-config' at line 1 SQL: SELECT * FROM qbi-config in /home/scroll/public_html/cart/admin/includes/classes/qbi_mysql.php on line 119

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/scroll/public_html/cart/admin/includes/classes/qbi_mysql.php on line 160

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/scroll/public_html/cart/admin/includes/classes/qbi_mysql.php on line 176

Warning: array_walk(): The argument should be an array in /home/scroll/public_html/cart/admin/includes/classes/qbi_classes.php on line 958

Warning: Invalid argument supplied for foreach() in /home/scroll/public_html/cart/admin/includes/classes/qbi_classes.php on line

Here is my server info
Database Host: localhost (127.0.0.1)
Server OS: Linux 2.4.25-HRGRP4smp
Database: MySQL 4.0.22-standard
PHP Version: 4.3.11 (Zend: 1.3.0
HTTP Server: Apache/1.3.33 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.11 FrontPage/5.0.2.2634a mod_ssl/2.8.22 OpenSSL/0.9.6

I did try to delete from the server the two pages qbi_classes.php and qbi_mysql.php and re upload them, however that didn't help. I also checked the original zip files and compared them to the ones I uploaded and couldn't find a difference however I might aw well have been comparing ancient egyptian hieroglphics LOL

Any guidance as to what I should be looking for or a fix would be fantastic

Looking forward to hearing how I messed it up this time LOL

Thanks in advance
Shadez

Quote:

---

Originally Posted by shadez2270

This seems like a fantastic mod and sure beats the way we do it now. I installed the mod as per the instructions (at least I think I did :cool: )but I got the follwing error messages

Notice: Query failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-config' at line 1 SQL: SELECT * FROM qbi-config in /home/scroll/public_html/cart/admin/includes/classes/qbi_mysql.php on line 119

---

The table name is qbi_config, not qbi-config.

You wrote in the table definitions wrong in the installation. I suggest you use the word document copy of the installation instructions and do copy and paste instead of recopying, to avoid any typing mistakes.

Thanks,
Adam

DOUHHHH (in my best homer Simpson voice) This always happens when I type code--->:lamo:

I corrected the typo and it worked like a charm... See I knew I had screwed it up.

I will be sure to make a contribution... thanks for helping me get it running

Also thank you Adam for a great mod!

Quote:

---

Originally Posted by shadez2270

Also thank you Adam for a great mod!

---

Thanks!
- Adam

I use both inventory items (things that I actually keep in stock) as well as non inventory items (things that I manufacture or drop ship). I also occasionally charge a service fee for consulting and such. QBI has a setting under Items called export type. Choices are Inventory, Noninventory, and Service. What one should I choose? I have all 3 in QB. How does this affect my book keeping and inventory?

Thanks.

Quote:

---

Originally Posted by djstern

I use both inventory items (things that I actually keep in stock) as well as non inventory items (things that I manufacture or drop ship). I also occasionally charge a service fee for consulting and such. QBI has a setting under Items called export type. Choices are Inventory, Noninventory, and Service. What one should I choose? I have all 3 in QB. How does this affect my book keeping and inventory?

Thanks.

---

The type setting in the QBI configuration only affects items in ZC that are directly imported by QBI, since ZC has no such designations.

If you use the Matching feature in QBI, and match those items to your items in QB, then the type of each QB item will be preserved.

Thanks,
Adam

Under match | Shipping I have nearly 3000 entrys under the shopping cart colum. Flat Rate (Best Way) for example is showing up dozens of times and I don't even have it installed. A bunch of other shipping methods like free is also showing up dozens of times even though they are not even installed in ZC under Modules | Shipping. Everytime I click on something, anything in that window the number of entrys increases. I can't even set up shipping until this is corrected. any ideas?

Thanks in advance.

Problem is that the same thing is showing up dozens of times. Flat Rate (Best Way) fills the entire page even if I have it configured to show 25 rows. If I attempt to go to the next page the number of Shipping Methods increases and I can never manage to get to the next shipping method.

Just for grins I dropped all of the database entries for QBI and recopied the files to my server. Verified the file changes and went through the configure process again. All went well until I entered match | shipping. When I first entered the page I had 32 entries. Making no changes of any kind I hit the "Update Matches On This Page" button and ended up with 64 shipping methods. Hit the button again and I have 96 entries. One more time and I have 128 entries. Same thing happens if I click next or a page number. The number of Shipping Method increases by more than is displayed on the page.

HELP!!!

Basically, I can't set up shipping with this problem.

Quote:

---

Originally Posted by djstern

Under match | Shipping I have nearly 3000 entrys under the shopping cart colum. Flat Rate (Best Way) for example is showing up dozens of times and I don't even have it installed. A bunch of other shipping methods like free is also showing up dozens of times even though they are not even installed in ZC under Modules | Shipping. Everytime I click on something, anything in that window the number of entrys increases. I can't even set up shipping until this is corrected. any ideas?

Thanks in advance.

---

This is a bug in 3.10 and will be corrected in 3.11. Please see the Bug Reports section of the QBI forum at http://www.libermansound.com/qbi for a simple solution.

All known bugs are listed in the QBI forum. It is a good idea to check there first if you have any problems.

Thanks,
Adam

QBI 3.20 has been released!
- Adam

New Features:
1. Invoice class can be set in config
2. Default customer name option added
3. Automatic detection of available output formats
4. Customer, order, and products header and footer output lines added for additional flexibility
5. Shipping methods are now manually loaded from cart (by clicking a button)

Fixes:
1. Missing PayPal constants added
2. Shipping match was multiplying shipping methods every time Match:Ship was selected
3. Clarified difference between iif file uploading and processing
4. QB group tables entries are now deleted properly
5. Assembly subitem descriptions no longer get deleted
6. QB groups now alphabetically sorted in match dropdown box
7. Chron misspelling changed to cron in files and docs

adam great news, can you provide a link?

thanks

MG

Adam glad to hear it especially since i am upgrading to ZC 1.3.7 tonight.

I'll secong where can we download it and also for those of us who have donated are we able to register our version? how does that work?

Thanks again,

Mike

Quote:

---

Originally Posted by MikeyG

adam great news, can you provide a link?

thanks

MG

---

I have uploaded it to the Zen Cart contribution area (it is under Admin Tools). However, all contributions have to be approved by Zen Cart before they are made available, so it may be 24 - 48 hours before it appears. It was actually only a few hours last time, but it is New Year's Eve so it may not be as quick!

- Adam

Quote:

---

Originally Posted by landshark

Adam glad to hear it especially since i am upgrading to ZC 1.3.7 tonight.

I'll secong where can we download it and also for those of us who have donated are we able to register our version? how does that work?

Thanks again,

Mike

---

All users with or without donations are strongly encouraged to register at http://www.libermansound.com/qbi

This helps me keep track of you for support, and I can let you know when new versions are available. Simply registering a free version of QBI however does not change your support level.

Donations that you have made are part of the equation for support and upgrades. However, in respect of the forum rules I will respond to you privately about that.

Thanks,
Adam

Could anybody here explain the diferences between US and UK versions of Quickbooks.

I have US version on trial, but i operate from the UK. I am interested in trying the contribution and getting Quickbooks intergrated with Zencart.

Quote:

---

Originally Posted by salt3y

Could anybody here explain the diferences between US and UK versions of Quickbooks.

I have US version on trial, but i operate from the UK. I am interested in trying the contribution and getting Quickbooks intergrated with Zencart.

---

The taxation systems are different, and the iif file format is different. QBI will not work with UK Quickbooks yet. That is being worked on now -- when I am closer I will let everyone know.

Thanks,
Adam

Adam, Thanks just for clarification where on the website do i register. I don't see a link, maybe i am just blind.

Now for technical problems. I installed the new files into a new install of ZC 1.3.7
but an upgraded database if that makes sense to you. So my olde QBI Tables were still there. After the install i ran the upgrade database for QBI.

My problem: When i try to download the new orders i get the following error:

Quote:

---

Warning: create_file_orders(/home/diystore/public_html/catalog/admin/includes/classes/qbi_classes_out_1.php): failed to open stream: No such file or directory in /home/diystore/public_html/catalog/admin/includes/classes/qbi_classes_output.php on line 132

Fatal error: create_file_orders(): Failed opening required '/home/diystore/public_html/catalog/admin/includes/classes/qbi_classes_out_1.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/diystore/public_html/catalog/admin/includes/classes/qbi_classes_output.php on line 132

---

any insight into what might be causing this?

Ok fixed the problem i had to delete all the QBI stuff from the database. Working now.

I am still running into the problem with paypal orders being imported into QB as an invoice and listed under Accounts receivable.

I want everything to be imported as a sales reciept. I just can't seem to find where i might be going wrong with the settings.

Quote:

---

Originally Posted by landshark

Adam, Thanks just for clarification where on the website do i register. I don't see a link, maybe i am just blind.

---

Click on the menu link at the top of the page that says Registration, or go directly to:
http://www.libermansound.com/qbi/register.php

Quote:

---

Now for technical problems. I installed the new files into a new install of ZC 1.3.7
but an upgraded database if that makes sense to you. So my olde QBI Tables were still there. After the install i ran the upgrade database for QBI.

My problem: When i try to download the new orders i get the following error:
...
any insight into what might be causing this?

---

Whoops, I guess my hope for zero bugs has been squashed! This one is minor though, and database reinstallation actually isn't necessary.

When you upgrade QBI to version 3.20, you will be prompted to update the database tables. After that, please go to the Config page and in the General section select iif as the Output Format and then click Save at the bottom of the page.

Thanks,
Adam

Quote:

---

Originally Posted by landshark

Ok fixed the problem i had to delete all the QBI stuff from the database. Working now.

I am still running into the problem with paypal orders being imported into QB as an invoice and listed under Accounts receivable.

I want everything to be imported as a sales reciept. I just can't seem to find where i might be going wrong with the settings.

---

In Set up|Payment you've got PayPal (from your QB payment methods) set to "Paid with PayPal?" And in Match|Payment you've got the the cart's PayPal method matched to this QB method? That should work. But I will look at this in QBI and see if I missed something and get back to you.

Thanks,
Adam

Quote:

---

Originally Posted by landshark

Ok fixed the problem i had to delete all the QBI stuff from the database. Working now.

I am still running into the problem with paypal orders being imported into QB as an invoice and listed under Accounts receivable.

I want everything to be imported as a sales reciept. I just can't seem to find where i might be going wrong with the settings.

---

I don't initially see any problem with the code, so if your settings are correct as noted in the previous post, please contact me privately as I may need access to your site to find the problem.

Thanks,
Adam

Adam thanks,

I really must be blind then, i didn't notice the menu bar at the top. I am all set now and registered.

Wish i had been more ptient and waited for your solution o my first problem hopefully this will help out the next guy.

On the PayPal issue my setting seem to be as you described. I will PM you about this.

Thanks again for all your hard work.

Mike

A bug has been discovered in v3.20 on the Match|Shipping page. It produces PHP warning messages, but does not affect functionality.

File: qbi_shipmatch.php
Line: 50
Replace: $ship_meth=new Ship_form();
With: $ship_meth=new Ship_form($dbqbi);

File: qbi_classes.php
Line: 2782
Replace:
function Ship_form() {
$this->Form_fields();
}

With:
function Ship_form($db) {
$this->db=$db;
return;
}

Thanks,
Adam

A bug has been found in v3.20 where iif files that contain Invoice and Payment won't import. This is only an issue if you have the Configuration option "Import payments" set to "As Invoice and Payment."

File: qbi_classes_output.php
In Line: 264 (after the comment // Create Payment Data)

Replace:
$ofile->create_payment($cartorder->order,$cartcustomer->customer)

With:
$ofile->create_payment($cartcustomer->customer,$cartorder->order)

Thanks,
Adam

QBI v3.21 has been posted to the contribution section (as usual, it will take a few hours to be available).

It fixes 3 bugs found in 3.20. If you have already applied the fixes in the previous posts, then you do not need to upgrade from 3.20 to 3.21.

1. Fixed output error upgrading from 3.0x or 3.1x if configuration wasn’t re-saved
2. PHP error message on Match|Shipping page fixed
3. Payments weren’t working

Thanks,
Adam

No such thing as a bug free program I guess. :) At least it's in PHP and we have a programmer that actually supports it and gives us quick fixes (unlike he who's name shall not be spoken.) :)

My hats off to Adam for his hard work and support of this Contribution.

My admin was renamed after I had installed QBI. I just reinstalled it but I am getting this error-

Warning: main(/home/rusty2/public_html/newcatalog/admin/includes/classes/qbi_mysql.php): failed to open stream: No such file or directory in /home/rusty2/public_html/newcatalog/mgsadmin/includes/qbi_app_top.php on line 54

Fatal error: main(): Failed opening required '/home/rusty2/public_html/newcatalog/admin/includes/classes/qbi_mysql.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/rusty2/public_html/newcatalog/mgsadmin/includes/qbi_app_top.php on line 54

If I change my admin back to admin I have no problems. Where in the QBI files should I go to change the name of my admin?

Thanks!
michelle

Quote:

---

Originally Posted by michelle_rvc

My admin was renamed after I had installed QBI. I just reinstalled it but I am getting this error-

Warning: main(/home/rusty2/public_html/newcatalog/admin/includes/classes/qbi_mysql.php): failed to open stream: No such file or directory in /home/rusty2/public_html/newcatalog/mgsadmin/includes/qbi_app_top.php on line 54

Fatal error: main(): Failed opening required '/home/rusty2/public_html/newcatalog/admin/includes/classes/qbi_mysql.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/rusty2/public_html/newcatalog/mgsadmin/includes/qbi_app_top.php on line 54

If I change my admin back to admin I have no problems. Where in the QBI files should I go to change the name of my admin?

Thanks!
michelle

---

QBI gets the directory paths from your Zen Cart settings, so there is nothing in QBI that needs to be changed. It sounds like you haven't configured Zen Cart properly for your new admin directory.

In addition to changing the directory name, you'll need to go into catalog/admin/includes/configure.php and change the following constants to the correct directory:
DIR_WS_ADMIN (the web URL path)
DIR_FS_ADMIN (the server file system path)

BTW, I agree this is a good basic security measure for everyone -- rename your catalog and admin directories from the defaults to make it just a little harder for automated bots and hackers searching for Zen Cart security holes to find your directories.

Thanks,
Adam

Thanks so much that worked perfectly. I didn't rename the admin, I switched hosting services and the person that moved my store did it. I guess I am glad I switched hosts the 1st company to install Zencart for me never mentioned it.

Thanks again!
michelle

In Match | Shipping all of my UPS and USPS shipping options show up twice. I look in the database and under the qbi_shipcart_car_code colum I have each UPS shipping method listed as ups then again as usp.bak. I've tried deleting the .bak versions but they come back each time I enter QBI in ZC giving me the duplicate entries. Same thing applies with the USPS shipping methods. I looked in Catalogue | inclueds | modules | shipping thinking that I might have a old backup version of the files causing the problem but that's not the case.

Any idea why I'm getting the duplicate entrys and how to fix it?

Quote:

---

Originally Posted by djstern

In Match | Shipping all of my UPS and USPS shipping options show up twice. I look in the database and under the qbi_shipcart_car_code colum I have each UPS shipping method listed as ups then again as usp.bak. I've tried deleting the .bak versions but they come back each time I enter QBI in ZC giving me the duplicate entries. Same thing applies with the USPS shipping methods. I looked in Catalogue | inclueds | modules | shipping thinking that I might have a old backup version of the files causing the problem but that's not the case.

Any idea why I'm getting the duplicate entrys and how to fix it?

---

Also look in:
catalog/includes/languages/english/modules/shipping/

It sure sounds like you have a backup file in there that QBI is finding. Also, make sure you are using QBI v3.21, as 3.10 had some issues with the shipping method detection, and 3.20 has a few bugs.

Thanks,
Adam

Tht was it. I'd renamed the old files to ups.php.bak and usps.php.bak but it still picked them up. Strange.

Thanks for the help.

Just an FYI.

This mod doesn't work on purchase orders used with the super orders mod on Macs. Not sure if this is intended or not.

Quote:

---

Originally Posted by sddreamweavers

Just an FYI.

This mod doesn't work on purchase orders used with the super orders mod on Macs. Not sure if this is intended or not.

---

Hi,

If you could please explain to me what the super orders mod does and you are trying to do, I may consider this for a future version of QBI.

Thanks,
Adam

There is a new version of this available,
The only changes are that there are no longer any core file edits,

Thanx for this contribution Adam,

I added the over rides for the
admin/includes/boxes/quickbooks_customers_dhtml.php( replaces core edit to admin/includes/boxes/customers_dhtml.php)
admin/includes/languages/english/extra_definitions/quickbooks.php ( replaces core edit to admin/includes/languages/english.php)
/includes/extra_datafiles/quickbooks_db_filenames.php( Replaces the edits to /includes/filenames.php and /includes/database_tables.php )

Quote:

---

Originally Posted by adam5532

Hi,

If you could please explain to me what the super orders mod does and you are trying to do, I may consider this for a future version of QBI.

Thanks,
Adam

---

I basically only use the mod for Purchase Orders. Nothing else. I've configured my Zen Cart so that purchase orders are the only method of payment (no shipping or credit cards). I'm looking to export all the purchase orders from Zen Cart to Quickbooks. Right now, I can export the file but Quickbooks does not recognize it.

The URL to the Cart I'm developing (this is just a test cart for proof of concept):

http://sandbox.sddreamweavers.com/zencart



From the Readme of the Super Orders Mod:

Super Orders is exactly what its name implies:
Zen Cart order management on steroids.

It's more in all the areas I always see Zen users asking for more:
more navigation options, more order control, more thorough data, and more
detailed reports.

But it's NOT more than you can handle. The system was designed for data
entry clerks in my office (some of the least-technically inclined people
on the planet). You're a Zen user. You can handle it. :-)

Ready to get started? Just follow the installation instructions below;
note that the system uses *no* overwrites and you only make small changes
to three pre-existing files!

Any questions, just hit the forums:
http://www.zen-cart.com/modules/ipb/...howtopic=18717

Quote:

---

Originally Posted by Merlinpa1969

There is a new version of this available,
The only changes are that there are no longer any core file edits,

Thanx for this contribution Adam,

I added the over rides for the
admin/includes/boxes/quickbooks_customers_dhtml.php( replaces core edit to admin/includes/boxes/customers_dhtml.php)
admin/includes/languages/english/extra_definitions/quickbooks.php ( replaces core edit to admin/includes/languages/english.php)

---

There are no edits in english.php

Quote:

---

/includes/extra_datafiles/quickbooks_db_filenames.php( Replaces the edits to /includes/filenames.php and /includes/database_tables.php )

---

PLEASE PLEASE PLEASE respect my request NOT to post changed versions of QBI. This has been made extremely clear here and in the user manual. Unofficial versions will be replaced and will receive ZERO support!

I have spent 600+ hours developing QBI. If unknown people post their own versions with varying code quality and varying documentation quality, I can no longer support the changes. In addition, as there are invariably errors, in my experience these people are not around to fix their mistakes, and I am left to clean it up or delete their changes. Also, QBI has versions released for Zen Cart and also osC and CRE -- if people make changes for one cart and not the other, I can not continue to develop the program, as I'm not interested in doubling my work!

These changes have been recommended already, and will probably be implemented very soon in a future version of QBI. If you have suggestions for QBI, the place to make them is in the QBI forum at http://www.libermansound.com/qbi and not by changing the code to your own liking and posting it. If you wish to alter the code for your own use, you may do so, but please do not post the altered version.

Again, if you truly appreciate my contribution, then please RESPECT and do not blatantly ignore my request that has been very very clearly explained in the user manual and DO NOT TO POST MODIFIED VERSIONS. I hope this is clear.

Thanks,
Adam

Then use the flippin over rides, I sent you the freakin code last year and your still changing CORE CODE THAT DOSNT AND SHOULDNT BE CHANGED

Adam also please if your going to correct me please read your own manual first

this is an excerpt from it

Add the QBI language definition to the Customers menu in the Zen Cart admin panel as follows:

File: catalog/admin/includes/languages/english.php
Where: After line 128 (not critical)
Add line: define('BOX_CUSTOMERS_QBI', 'Quickbooks Import QBI');

Also Adam if I didnt respect your wishes I sure as heck wouldnt have stated that I didnt change ANYTHING except put this

Code:

---

Add the QBI language definition to the Customers menu in the Zen Cart admin panel as follows:

        File: catalog/admin/includes/languages/english.php
        Where: After line 128 (not critical)
        Add line: define('BOX_CUSTOMERS_QBI', 'Quickbooks Import QBI');

        Make the same change in any other languages you are using, for example
        Español:
        Add line: define('BOX_CUSTOMERS_QBI', 'Importar Quickbooks QBI');

Add the QBI link to the Customers menu in Zen Cart admin panel as follows:

        File: catalog/admin/includes/boxes/customers_dhtml.php
        Where: After line 16 (not critical)
        Add line:  $za_contents[] = array('text' => BOX_CUSTOMERS_QBI, 'link' => zen_href_link(FILENAME_QBI, '', 'NONSSL'));

Add the QBI filename definition to the Customers menu in the Zen Cart admin panel as follows:

        File: catalog/includes/filenames.php
        Where: At the end before the php closing tag (not critical)
        Add line: define('FILENAME_QBI', 'qbi_create.php');

Add the QBI database tables to the table list

        File: catalog/includes/database_tables.php
        Where: At the end before the php closing tag (not critical)
        Add lines:
define('TABLE_QBI_CONFIG', 'qbi_config');
define('TABLE_QBI_DISCCART', 'qbi_disccart');
define('TABLE_QBI_DISCCART_DISCQB', 'qbi_disccart_discqb');
define('TABLE_QBI_DISCQB', 'qbi_discqb');
define('TABLE_QBI_GROUPS', 'qbi_groups');
define('TABLE_QBI_GROUPS_ITEMS', 'qbi_groups_items');
define('TABLE_QBI_ITEMSQB', 'qbi_itemsqb');
define('TABLE_QBI_PAYCART', 'qbi_paycart');
define('TABLE_QBI_PAYCART_PAYQB', 'qbi_paycart_payqb');
define('TABLE_QBI_PAYQB', 'qbi_payqb');
define('TABLE_QBI_PRODUCTS_ITEMSQB', 'qbi_products_itemsqb'); 
define('TABLE_QBI_SHIPCART', 'qbi_shipcart');
define('TABLE_QBI_SHIPQB', 'qbi_shipqb');
define('TABLE_QBI_SHIPCART_SHIPQB', 'qbi_shipcart_shipqb');

---

Into a drop in file structure, to which you might have said Thank you, the entire code is able to DROP in with NO edits,

Quote:

---

Originally Posted by Merlinpa1969

Also Adam if I didnt respect your wishes I sure as heck wouldnt have stated that I didnt change ANYTHING except put this

...

Into a drop in file structure, to which you might have said Thank you, the entire code is able to DROP in with NO edits,

---

The question isn't whether your changes are good ideas or even improvements, it's a matter of 1) respect for the developer's wishes, and 2) manageability of the code base, documentation, and support. The fact that I didn't respond as fast as you would have liked to your suggestion is not a good reason to just go ahead and do it yourself. People have made many suggestions for QBI, and there are other features that I am working on at the moment.

There are many Zen Cart contributions that are better because of the collaborative community process, and I fully support that. And, there are contributions that are a mess because of poor documentation and erratic code. My experience over the two years that I've been developing QBI is that it is better that I do all the updates to the program. Even if your ideas are good, I'm the one who is going to be answering users' questions and helping them install the program, so I really need to have control over the code and the documentation to be able to give that level of support. In addition, as there are commercial releases of QBI for other shopping carts, and newer versions in development, it just makes a whole lot more work and trouble for me when this happens. I do not have a system set up to check out code, or a system to evaluate who writes good code and docs and who doesn't. Nor do I think that would be helpful, as it is a mid-sized project.

Zen Cart does not have any way for me to prevent people from doing this, so all I can do is ask people to be respectful of my wishes, and generally 99.9% of the community is. I know that you meant to be helpful and meant no harm, but to protect the integrity of QBI and keep it 100% supportable, I need to make this very clear even if in this case your changes may have been small.

Thanks!
- Adam