Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

EZ QuickBooks Integration Contribution


197 replies to this topic

#41 terrafairtrade

  • Community Member
  • 1 posts
  • Real Name:Lynn Persson

Posted 07 May 2008, 17:20

Looks potentially great!!! I have been avoiding upgrading my website until I could find something that dealt with the QB Integration problem. Couple questions:
1) Does it work with Inventory assemblies in QB Premier Manufacturing & Wholesale (I have 2006). I assemble some of my products.
2) Does it work with product attributes such as color or size?
3) Can it deal with unique items such as artwork?

Thanks! Appreciate any suggestions to make it work.
terrafairtrade

#42 God's Eternal Masterpiece

  • Community Member
  • 25 posts
  • Real Name:Jesse Huang

Posted 09 May 2008, 03:15

View Postmpiscopo, on May 7 2008, 11:37 AM, said:

Jesse, Did you figure this out? If not, send me a copy of your export file so I can look at it. You can also look at your export files to see if the transactions are in them - or if there's a problem. Open it with Excell and you'll be able to see the customer information and the order information.

Mark

I copied the text from my export file and sent it to you. Let me know if you have any problems with it. Thanks for your help!

#43 mpiscopo

  • Community Member
  • 413 posts
  • Real Name:Mark
  • Location:Rockville, MD

Posted 09 May 2008, 12:08

Hi Lynn,

1) I don't know how the Inventory Assemblies works, so I can't answer that.
2) No, it doesn't work with product attributes as I don't use this in osCommerce and am not familiar the use of that feature.
3) Does each unique piece of artwork have its own part number? If so, then it's the same as any other inventory item and should work.

The programmer who created this contribution for me is in this forum (Bogdan) and can be hired to add other features. He does a great job and is very reasonable in his pricing. Many of these features I don't use so I really can't work with him on them - since I wouldn't be able to define the requirements accurately and test the resulting program.

Mark

View Postterrafairtrade, on May 7 2008, 05:20 PM, said:

Looks potentially great!!! I have been avoiding upgrading my website until I could find something that dealt with the QB Integration problem. Couple questions:
1) Does it work with Inventory assemblies in QB Premier Manufacturing & Wholesale (I have 2006). I assemble some of my products.
2) Does it work with product attributes such as color or size?
3) Can it deal with unique items such as artwork?

Thanks! Appreciate any suggestions to make it work.


#44 mpiscopo

  • Community Member
  • 413 posts
  • Real Name:Mark
  • Location:Rockville, MD

Posted 09 May 2008, 12:12

Lynn,

It looks like you're missing the items in the export file - everything else seems to be there. I'll look at it closer today. Did you doublecheck your log files to see that the import matched products in QB to those items?

View PostGod, on May 9 2008, 03:15 AM, said:

I copied the text from my export file and sent it to you. Let me know if you have any problems with it. Thanks for your help!


#45 KillerCK

  • Community Member
  • 1 posts
  • Real Name:Jason

Posted 10 May 2008, 01:18

I noticed that the SALES TAX didn't seem to be showing up in the export (quickbooks_export_orders.php).
I know nothing about Quickbooks so I am not sure exactly what AUTOSTAX is (Seems like it tells Quickbooks to Auto calculate the tax based on the Taxable flag.)
Anyway I looked at the export files and the sales tax section was hard coded for $transaction_detail_amount = 0.
Again I assume because AUTOSTAX was set in the file?
If I am correct in this guess...does Quickbooks use a flat rate somewhere to auto calculate?
I don't see the actual TAX RATE exported in the export.

I modified the export to actually calculate the sales tax per item in the prior loop (at line 148) for products:
$sales_tax .= ($order->products[$i]['qty'] * $order->products[$i]['price'])*($order->products[$i]['tax']/100);

Comments or info on the AUTOSTAX would be appreciated! Thanks!

#46 rebootmt

  • Community Member
  • 5 posts
  • Real Name:Tammy

Posted 12 May 2008, 21:17

Hi!
I'm not sure where I have gone wrong, I have double checked my install....but I can't get the box for quickbooks to show up in the admin area. I have checked and quickbooks.php is installed in admin/includes/boxes...admin/includes/column_left.php has "require quickbooks.php" listed.... For example, if I type in http://mydomain.com/admin/quickbooks_export_orders.php the correct page comes up. I'm not sure why the main box link does not show up.
Any thoughts would be greatly appreciated!!
Thanks so much!

#47 God's Eternal Masterpiece

  • Community Member
  • 25 posts
  • Real Name:Jesse Huang

Posted 15 May 2008, 03:51

View Postrebootmt, on May 12 2008, 04:17 PM, said:

Hi!
I'm not sure where I have gone wrong, I have double checked my install....but I can't get the box for quickbooks to show up in the admin area. I have checked and quickbooks.php is installed in admin/includes/boxes...admin/includes/column_left.php has "require quickbooks.php" listed.... For example, if I type in http://mydomain.com/admin/quickbooks_export_orders.php the correct page comes up. I'm not sure why the main box link does not show up.
Any thoughts would be greatly appreciated!!
Thanks so much!

Make sure your catalog/admin/includes/filenames.php file has this code inserted anywhere in the file:

//Quickbooks contribution start

		   define('FILENAME_QUICKBOOKS_PREREQUISITES', 'quickbooks_prerequisites.php');
 
		   define('FILENAME_QUICKBOOKS_UPDATE_PRODUCTS', 'quickbooks_update_products.php');

		   define('FILENAME_QUICKBOOKS_CUSTOM_FIELDS', 'quickbooks_custom_fields.php');

		   define('FILENAME_QUICKBOOKS_UPDATE_LOG','quickbooks_update_log.php');

		   define('FILENAME_QUICKBOOKS_CONFIGURATION', 'quickbooks_configuration.php');

		   define('FILENAME_QUICKBOOKS_EXPORT_ORDERS', 'quickbooks_export_orders.php');

//Quickbooks contribution end

I don't know if that is the answer you're looking for, but that is the same type of code that was missing in my filenames.php file when I installed other modules.

#48 God's Eternal Masterpiece

  • Community Member
  • 25 posts
  • Real Name:Jesse Huang

Posted 15 May 2008, 04:02

View Postmpiscopo, on May 9 2008, 07:12 AM, said:

Lynn,

It looks like you're missing the items in the export file - everything else seems to be there. I'll look at it closer today. Did you doublecheck your log files to see that the import matched products in QB to those items?

I use the actual names of the products in Quickbooks for the product models because I sell things like books and DVDs that don't necessarily have a manufacturer model. Therefore, some of my names have an apostrophe in the name. My SQL database will not accept those names unless I place a backslash before the apostrophe, as in \'s. Anyway, my item list will not import into osCommerce unless I manually edit with a text editor and place backslashes in all the appropriate places. After that the products imported just fine. So I'm wondering if it's because of that problem that my export file will not match the products correctly. Did you find anything else that may cause the problem with the export file?

Edited by God's Eternal Masterpiece, 15 May 2008, 04:03.


#49 rebootmt

  • Community Member
  • 5 posts
  • Real Name:Tammy

Posted 21 May 2008, 02:45

I did recheck to make sure I had filenames.php definitions entered...they were all there....I rechecked my installation again.....and still no quickbooks references show up in the column left in admin. I just don't get why it's not there. Any other ideas?
Thanks so much!

#50 Fortimir

  • Community Member
  • 1 posts
  • Real Name:Sean

Posted 23 May 2008, 16:20

I don't know how no one else seems to have problems.

I followed instructions to the letter, and there were problems in syntax from the get go. I had to remove a comma in general.php... i was asked insert customers_fax into an array, but not create a database entry for it.

I fixed those, but now when I try to upload .IIF, I get:

Quote

1064 - 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 '70s Guitar Classics'' at line 1

select products_id, products_model, products_quantity from products where products_model =''70s Guitar Classics'

ALSO, when I try to make a custom field, I get:

Quote

Fatal error: Call to undefined method box::simpleBox() in /home/rrmusicc/public_html/catalog/admin/quickbooks_custom_fields.php on line 54

What's going on?

#51 bpopa

  • Community Member
  • 23 posts
  • Real Name:Bogdan Popa
  • Gender:Male
  • Location:Bucharest, Romania

Posted 26 May 2008, 15:15

The addon works on a standard php.ini configuration as it was designed to work.
If have special configuration in php.ini (and really need them) you have to edit the code to suit your needs (for example if have magic_quotes enabled in php.ini it may run into troubles because in code it already use addslashes, witch will generated additional slashes and may run into error).

Also, make a test of resulted queries in a mysql client (i suggest Mysql Query Browser), to see where is the problem.
Regarding

Quote

Fatal error: Call to undefined method box::simpleBox() in /home/rrmusicc/public_html/catalog/admin/quickbooks_custom_fields.php on line 54

make a recheck on readme.txt.
I think this step was not completed:

ii) admin/includes/classes/box.php

Add function:

"

function simpleBox($contents){

return $this->tableBlock($contents);

}

"
Let me here know if still can't make it.
Kind Regards,
Bogdan


View PostFortimir, on May 23 2008, 05:20 PM, said:

I don't know how no one else seems to have problems.

I followed instructions to the letter, and there were problems in syntax from the get go. I had to remove a comma in general.php... i was asked insert customers_fax into an array, but not create a database entry for it.

I fixed those, but now when I try to upload .IIF, I get:

Quote

1064 - 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 '70s Guitar Classics'' at line 1

select products_id, products_model, products_quantity from products where products_model =''70s Guitar Classics'

ALSO, when I try to make a custom field, I get:

Quote

Fatal error: Call to undefined method box::simpleBox() in /home/rrmusicc/public_html/catalog/admin/quickbooks_custom_fields.php on line 54
,

What's going on?


#52 bpopa

  • Community Member
  • 23 posts
  • Real Name:Bogdan Popa
  • Gender:Male
  • Location:Bucharest, Romania

Posted 26 May 2008, 19:48

Hi Tammy,

I know you tried it, but i make a resume on it.To have the quickbooks box appear in the left you have this steps completed :

1. check for admin/includes/boxes/quickbooks.php (it must exists at this location)
2. check for this line in admin/includes/column_left.php : require(DIR_WS_BOXES . 'quickbooks.php'); (it must be there)

Practically up there, in first step declares the content of the box, and at second step just includes that content.Nothing fancy.

If still won't work, i suggest you to try some debug stuff on these files.
For example , can use some print("something here");die; in the file at first step (to check if this file is included).
You can use outputs like in the example on this files to see if at a precise step application goes trough there.

Let me know here if still can't make it installing correctly and what are the results of the advices i gave you.
Regards,
Bogdan



View Postrebootmt, on May 21 2008, 02:45 AM, said:

I did recheck to make sure I had filenames.php definitions entered...they were all there....I rechecked my installation again.....and still no quickbooks references show up in the column left in admin. I just don't get why it's not there. Any other ideas?
Thanks so much!


#53 allminefree

  • Community Member
  • 1 posts
  • Real Name:Paul

Posted 18 June 2008, 01:33

Getting the following error when importing into QB's

"The transaction is not in balance. Make sure the amounts in the detail area on the form for this transaction equal the amount at the top of the form."

I am at a loss as to how to resolve this...I can see all the data in the Orders.IIF file.

Anyone got any ideas?

Paul

#54 mpiscopo

  • Community Member
  • 413 posts
  • Real Name:Mark
  • Location:Rockville, MD

Posted 20 June 2008, 02:56

Paul,

I looked at the iif file you sent. You have bold tags in the order total field. Open the file with excel and you'll see the <b> and </b> tags. Check your database to see if the tags are in the database or whether you're inserting them in your PHP code.

Mark

View Postallminefree, on Jun 18 2008, 02:33 AM, said:

Getting the following error when importing into QB's

"The transaction is not in balance. Make sure the amounts in the detail area on the form for this transaction equal the amount at the top of the form."

I am at a loss as to how to resolve this...I can see all the data in the Orders.IIF file.

Anyone got any ideas?

Paul


#55 bpopa

  • Community Member
  • 23 posts
  • Real Name:Bogdan Popa
  • Gender:Male
  • Location:Bucharest, Romania

Posted 22 June 2008, 17:04

Hi Paul,

Orders_Total are inserted with bold, see orders_total table, column text.
quickbooks_export_orders file which export orders make use of the oscommerce order class (admin/includes/classes/order.php) to get all details about orders.
The totals in quickbooks_export_orders.php is taken in variable '$transaction_total' in the way it came from the database.

In 'order.php' class file, all the details are retrieved in 'function query($order_id)'.
Totals are placed in 'this->info' structure.Look for something like this:

'last_modified' => $order['last_modified'],
'total' => strip_tags($order_total['text']),
'shipping_method' => ((substr($shipping_method['title'], -1) == ':') ? substr(strip_tags($shipping_method['title']), 0, -1) : strip_tags($shipping_method['title'])),
'shipping_cost' => strip_tags($shipping_method['value']));


and take a look at 'total=> .........'.
Check if there is 'strip_tags' function when assigning the value to 'total'.
That function will escape all html tags and get the value without the <b> tags that is causing problem for you.

Check these tips and let me know, if the problem is solved.

Regards,
Bogdan

View Postmpiscopo, on Jun 20 2008, 02:56 AM, said:

Paul,

I looked at the iif file you sent. You have bold tags in the order total field. Open the file with excel and you'll see the <b> and </b> tags. Check your database to see if the tags are in the database or whether you're inserting them in your PHP code.

Mark


#56 arunstrom

  • Community Member
  • 2 posts
  • Real Name:Amy

Posted 27 June 2008, 18:07

I'm really excited to use this contribution. Thanks for making it!

I do have a problem. I followed the installation and now when I try to get to my admin page it's blank. I know I did something majorly wrong somewhere, I just can't figure out where. I know I haven't given you much info but does anyone have any ideas where to start?

Thanks!
Amy

#57 bpopa

  • Community Member
  • 23 posts
  • Real Name:Bogdan Popa
  • Gender:Male
  • Location:Bucharest, Romania

Posted 29 June 2008, 15:10

Hi Amy,

I think you need to revise the installation process.
I suggest to take a closer look at:

Step2, Step3, and from Step4 points: i), iv), vi), vii).

These are critical steps which if are not correctly completed, will sure make application go blank.


Also you may use add this line:
error_reporting(E_ALL ^ E_NOTICE);

at beginning of admin/includes/application_top.php file (after the <?php tag ) to see where it goes in error.
However i strongly recommend a full revise of the installation process.

Let me know the results.

Regards,
Bogdan



View Postarunstrom, on Jun 27 2008, 07:07 PM, said:

I'm really excited to use this contribution. Thanks for making it!

I do have a problem. I followed the installation and now when I try to get to my admin page it's blank. I know I did something majorly wrong somewhere, I just can't figure out where. I know I haven't given you much info but does anyone have any ideas where to start?

Thanks!
Amy


#58 trothmaster

  • Community Member
  • 2 posts
  • Real Name:mike

Posted 10 July 2008, 19:11

hey everyone, I'm having two issues:
when i click prerequisits items say "Not Verified"....is that ok?

second: when I click Export Orders i get a blank page.

i had a similar blank page problem due to permissions before could this be related?

step 3 was a bit confusing maybe i messed that up?

any ideas?

Edited by trothmaster, 10 July 2008, 19:15.


#59 bpopa

  • Community Member
  • 23 posts
  • Real Name:Bogdan Popa
  • Gender:Male
  • Location:Bucharest, Romania

Posted 14 July 2008, 18:18

Hi,

1) Prerequisites are placed there in order to make the user pay attention that before use this module features, it must do some steps before.
See the readme.txt file about their purpose.
Once you've verified them they'll change their status to "Verified".

2)When click the export orders the page should stay as it is and a orders.csv file should prompt for download.
I think there are some special settings for your server if this error appears.
I suggest a debug on the page that deals with the export (admin/quickbooks_export_orders.php).
Also you may place a error_reporting(E_ALL ^ E_NOTICE); at the beginning of the file (mentioned above) after the first "<?php" to see what goes wrong.

3) "Step 3" in the readme file is

Quote

COPY the *.php files into your application, in the same folders they're in this addon.
.

You open the directory structure of the module and copy the files from it in the same directory of your application.
For example, copying "quickbooks_export_orders.php" from the module to application you'll have to copy
"<module_download_dir>/code_files/admin/quickbooks_export_orders.php" to "<your_app_install_directory>/admin/quickbooks_export_orders.php".
These are new files and for sure you won't have them and can copy.
For the other ones you'll need to insert pieces of codes inside them considering that everyone has customized parts.

Regards,
Bogdan


View Posttrothmaster, on Jul 10 2008, 08:11 PM, said:

hey everyone, I'm having two issues:
when i click prerequisits items say "Not Verified"....is that ok?

second: when I click Export Orders i get a blank page.

i had a similar blank page problem due to permissions before could this be related?

step 3 was a bit confusing maybe i messed that up?

any ideas?


#60 JRN

  • Community Member
  • 12 posts
  • Real Name:Jason Nelson

Posted 27 July 2008, 05:10

View Postterrafairtrade, on May 7 2008, 11:20 AM, said:

Looks potentially great!!! I have been avoiding upgrading my website until I could find something that dealt with the QB Integration problem. Couple questions:
1) Does it work with Inventory assemblies in QB Premier Manufacturing & Wholesale (I have 2006). I assemble some of my products.
2) Does it work with product attributes such as color or size?
3) Can it deal with unique items such as artwork?

Thanks! Appreciate any suggestions to make it work.

Very simple mod to make this contribution work with product attributes. The total cost of item+attribute is stored in the same table this contribution uses to pull the products price. Instead of using the field products_price use the field final_price from the orders_products table.

This mod should not make any difference to those of you who do not use attributes becasue the field final_price = (products_price + cost of attributes). If you have 0 cost of attributes final_price=products_price.

Open the file quickbooks_export_orders.php in your admin directory. There are only two changes and they are very minor.

On or around line 149 replace:

$amount = $order->products[$i]['qty'] * $order->products[$i]['price'];
with
$amount = $order->products[$i]['qty'] * $order->products[$i]['final_price'];

On or around line 163, replace:
transaction_detail_price = $order->products[$i]['price'];
with
transaction_detail_price = $order->products[$i]['final_price'];

Thats it! Should work for everyone even if you don't use attributes as I said. As always backup and good luck.

Jason

Edited by JRN, 27 July 2008, 05:14.