Quickbooks Import QBI

[adam5532]

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

[djstern]

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.

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

[adam5532]

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

[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)
/includes/extra_datafiles/quickbooks_db_filenames.php( Replaces the edits to /includes/filenames.php and /includes/database_tables.php )

[sddreamweavers]

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

[adam5532]

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

/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

[Merlinpa1969]

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');

[Merlinpa1969]

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

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,

[adam5532]

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