EZ QuickBooks Integration Contribution
#41
Posted 07 May 2008, 17:20
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.
#42
Posted 09 May 2008, 03:15
mpiscopo, on May 7 2008, 11:37 AM, said:
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
Posted 09 May 2008, 12:08
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
terrafairtrade, on May 7 2008, 05:20 PM, said:
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
Posted 09 May 2008, 12:12
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?
God, on May 9 2008, 03:15 AM, said:
#45
Posted 10 May 2008, 01:18
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
Posted 12 May 2008, 21:17
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
Posted 15 May 2008, 03:51
rebootmt, on May 12 2008, 04:17 PM, said:
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
Posted 15 May 2008, 04:02
mpiscopo, on May 9 2008, 07:12 AM, said:
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
Posted 21 May 2008, 02:45
Thanks so much!
#50
Posted 23 May 2008, 16:20
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
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
What's going on?
#51
Posted 26 May 2008, 15:15
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
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
Fortimir, on May 23 2008, 05:20 PM, said:
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
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
What's going on?
#52
Posted 26 May 2008, 19:48
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
rebootmt, on May 21 2008, 02:45 AM, said:
Thanks so much!
#53
Posted 18 June 2008, 01:33
"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
Posted 20 June 2008, 02:56
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
allminefree, on Jun 18 2008, 02:33 AM, said:
"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
Posted 22 June 2008, 17:04
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
mpiscopo, on Jun 20 2008, 02:56 AM, said:
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
Posted 27 June 2008, 18:07
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
Posted 29 June 2008, 15:10
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
arunstrom, on Jun 27 2008, 07:07 PM, said:
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
Posted 10 July 2008, 19:11
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
Posted 14 July 2008, 18:18
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
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
trothmaster, on Jul 10 2008, 08:11 PM, said:
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
Posted 27 July 2008, 05:10
terrafairtrade, on May 7 2008, 11:20 AM, said:
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.














