Zen Cart Logo
Forums / Addon Admin Tools / Quickbooks Import QBI

Quickbooks Import QBI

Views: 373,817

Results 281 to 300 of 1,218
2 Jan 2007, 7:27 AM
#281
adam5532 avatar

adam5532

Totally Zenned

Join Date:
Jan 2005
Location:
Oregon
Posts:
517
Plugin Contributions:
0

Quickbooks Import QBI

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

2 Jan 2007, 3:15 PM
#282
landshark avatar

landshark

New Zenner

Join Date:
Mar 2006
Posts:
83
Plugin Contributions:
0

Re: Quickbooks Import QBI

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

Using: Zencart 1.3.7 and lovin' every minute of it.

4 Jan 2007, 10:08 AM
#283
adam5532 avatar

adam5532

Totally Zenned

Join Date:
Jan 2005
Location:
Oregon
Posts:
517
Plugin Contributions:
0

Re: Quickbooks Import QBI

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

4 Jan 2007, 11:12 PM
#284
adam5532 avatar

adam5532

Totally Zenned

Join Date:
Jan 2005
Location:
Oregon
Posts:
517
Plugin Contributions:
0

Re: Quickbooks Import QBI

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

5 Jan 2007, 12:32 AM
#285
adam5532 avatar

adam5532

Totally Zenned

Join Date:
Jan 2005
Location:
Oregon
Posts:
517
Plugin Contributions:
0

Re: Quickbooks Import QBI

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

5 Jan 2007, 7:17 AM
#286
djstern avatar

djstern

New Zenner

Join Date:
Apr 2005
Posts:
66
Plugin Contributions:
0

Re: Quickbooks Import QBI

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.

6 Jan 2007, 5:39 PM
#287
michelle_rvc avatar

michelle_rvc

New Zenner

Join Date:
May 2006
Posts:
31
Plugin Contributions:
0

Re: Quickbooks Import QBI

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

6 Jan 2007, 6:56 PM
#288
adam5532 avatar

adam5532

Totally Zenned

Join Date:
Jan 2005
Location:
Oregon
Posts:
517
Plugin Contributions:
0

Re: Quickbooks Import QBI

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

6 Jan 2007, 9:28 PM
#289
michelle_rvc avatar

michelle_rvc

New Zenner

Join Date:
May 2006
Posts:
31
Plugin Contributions:
0

Re: Quickbooks Import QBI

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

7 Jan 2007, 4:10 AM
#290
djstern avatar

djstern

New Zenner

Join Date:
Apr 2005
Posts:
66
Plugin Contributions:
0

Re: Quickbooks Import QBI

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?

7 Jan 2007, 5:18 AM
#291
adam5532 avatar

adam5532

Totally Zenned

Join Date:
Jan 2005
Location:
Oregon
Posts:
517
Plugin Contributions:
0

Re: Quickbooks Import QBI

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

8 Jan 2007, 8:04 PM
#293
sddreamweavers avatar

sddreamweavers

New Zenner

Join Date:
Dec 2006
Posts:
4
Plugin Contributions:
0

Re: Quickbooks Import QBI

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.

9 Jan 2007, 2:00 AM
#294
adam5532 avatar

adam5532

Totally Zenned

Join Date:
Jan 2005
Location:
Oregon
Posts:
517
Plugin Contributions:
0

Re: Quickbooks Import QBI

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

9 Jan 2007, 3:31 AM
#295
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: Quickbooks Import QBI

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 )

Zen cart PCI compliant Hosting

9 Jan 2007, 4:35 AM
#296
sddreamweavers avatar

sddreamweavers

New Zenner

Join Date:
Dec 2006
Posts:
4
Plugin Contributions:
0

Re: Quickbooks Import QBI

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/index.php?showtopic=18717*

9 Jan 2007, 5:48 AM
#297
adam5532 avatar

adam5532

Totally Zenned

Join Date:
Jan 2005
Location:
Oregon
Posts:
517
Plugin Contributions:
0

Re: Quickbooks Import QBI

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

9 Jan 2007, 6:07 AM
#298
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: Quickbooks Import QBI

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

Zen cart PCI compliant Hosting

9 Jan 2007, 6:17 AM
#299
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

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

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,

Zen cart PCI compliant Hosting

9 Jan 2007, 8:23 AM
#300
adam5532 avatar

adam5532

Totally Zenned

Join Date:
Jan 2005
Location:
Oregon
Posts:
517
Plugin Contributions:
0

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

...

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