Community Add-Ons

Order Editor
for osCommerce Online Merchant v2.2

This is a long-awaited update to my original order editing tool. This time, nearly every aspect of an order can be quickly edited.

PLUS! The ability to add products to an existing order, reliably update order totals, insert coupons & discounts & extra fees, update tax on individual products, edit product information on individual orders, update product quantities, product prices, and more!

AND! It's ready and formatted for the admin area. Installation in 3 easy steps!

Legend:

Download

Report

Expand All / Collapse All

This is the long awaited update to QTpro to make it properly subtract stock from attributes when changing the order's quantities.
This is not a full package. Version 5.0.6.6 must be installed first and then copy the 3 files included here to overwrite the previous files in catalog/admin

Note: if you use a language other than English, you will find that many of the entries in your language file (if included) are in English. My apologies for this, I am unfortunately mono-linguistic. If you do find yourself in this situation, please take the time to update the language file(s) of your choice and post them for others to use.

Note: works with register_globals ON or OFF

Note: JavaScript functions have been tested with Firefox 1.5 and IE6 on WinXP. Guaranteed to not be compatible with all browsers.

If you experience any problems with this contribution, please post to the forums: http://forums.oscommerce.com/index.php?act=ST&f=7&t=54032 If your problem involves tax calculations please include the following information: Your shop setting for Display Prices with Tax, how many tax classes you use, how many tax rates in each class, and how many tax zones you have.

4/27/2006
v2.5
-Fixed multiple tax rate bug where zones were not being taken into account when determining the tax description for a product

-Fixed bug where extra tax fields were being added to the order in certain situations

-Further modified the order class (admin/includes/classes/order.php) in order to support the fix for multiple tax rates, as well as to simplify the code base

-Moved all included functions to admin/includes/functions/general.php as most were needed by the modified order class, as well as to simplify the code base

-Replaced tep_get_tax_rates_description with the stock osC function tep_get_tax_description (copied from catalog/includes/functions/general.php)

-Deleted unused functions tep_field_exists and tep_html_unquote

-Restored and expanded JavaScript help/information files, as requested by Patty, including one new file, admin/includes/javascript/overlib_mini.js

-Added weight by product and total weight of order, with on-the-fly calculation, to assist with shipping charge calculations, as requested by buttonguy

-Further expanded on-the-fly calculations to include subtotal, tax totals, and final total, as requested by Irin. This feature is still in development; since the JavaScript and PHP calculate the totals in different ways it is to be expected that small rounding differences will sometimes be seen after updating. For this reason the on-the-fly total values should be considered an estimate.

-Fixed bug where tax was essentially doubled when calculating a tax entry that had not previously existed on shops where Display Prices with Tax is set to 'true'

-Modified code that handled the deletion of entries in the orders_total table with values of '0'. Shipping, subtotal, and total fields are not deleted in this case, however other fields are. Note that zero value tax fields are automatically deleted

-Condensed various redundant code sections

-Simplified the $ot_shipping_query in the add a product case to make tax calculations easily extendable for custom total components

-Fixed bug in order class that was causing a syntax error with certain versions of MySQL

-Realigned all included language definition files to include all necessary entries, although most new entries are in English (better to be in the wrong language than non-existent)

-Made all total component values into readonly text boxes to support on-the-fly calculations (weight fields, subtotal, tax totals, and final total fields are not editable)

-Fixed bug where shipping field would behave oddly if a value of '0' was input

Order Editor v2.2 is good wholesome fun for the whole family!

FULL PACKAGE

Note: Works with register_globals ON or OFF.

Note: Order Editor still doesn't work correctly on orders with multiple tax classes. A fix for this is still in development.

Note: JavaScript functions have been tested with Firefox 1.5 and IE6 on WinXP. Guaranteed to not be compatible with all browsers.

If you experience any problems with this contribution, please post to the forums: http://forums.oscommerce.com/index.php?act=ST&f=7&t=54032 If your problem involves tax calculations please include the following information: Your shop setting for Display Prices with Tax, how many tax classes you use, and how many tax rates in each class.

4/1/2006
v2.2

-There are no longer any configuration settings within the code that require any input from the user

-Added README file for instructions on what and what not to expect from Order Editor

-Added new field shipping_tax to table orders to help clear up issues with tax on shipping.
Did not include any code for modifying the checkout process. Such changes may be included as optional in the future.

-Added update to admin/includes/classes/order.php to take shipping_tax field into account

-Added Polish and Portugese translations thanks to gawdzinski.pl and apopular, respectively. Package now includes varying levels of support for 12 different languages.

-Modified way subtotal, tax, and total are calculated to take setting of Display Prices with Tax into account. This should make having hardcoded DE v. US settings unneccessary.

-Made small mod to way order status is changed, and when, to clear up bug where orders_status_history table was not always updating properly.

-Added JavaScript function to check payment method. If payment method is the same as the language file definition of ENTRY_CREDIT_CARD (this entry is new for v2.2), the other cc fields are shown.
This happens on the fly, so hitting "Update" is no longer neccessary to see other cc fields when
changing payment method to ENTRY_CREDIT_CARD.

-Added JavaScript calculator for products price.

v2.1 Full Package with German-Rules and US-Rules

I have just added various tweaks which will be useful for German-Users, but this is still usable for international and US users.
All differences are called by checking a simple config-switch inside the file itself on Line 24. Just define DE or US and the TAX will be calculated different for both posibilities.
DE will calculate the included Tax and show it.
US will calculate the Tax and add it to the totals.

Includes the shipping tax.

Based on yesterdays contrib of djmonkey1.

********
One bug is still in there : ot_custom seems not to be recalculated with tax it is just taken off (-) or put on(+) total.
Maybe i am just too lazy to find it.

ot_custom should be handled like the ot_shipping, but its not.
********

The Following was changed:

LINE 24
//DEFINITIONS FOR VARIOUS COUNTRIES
$edit_orders_in_country = 'DE' // Possibilities = 'DE' / 'US'
//US adds TAX to positions and makes sense if prices in shop are displayed without tax.
//DE is used for TAX included in Positions and needs to be displayed how much TAX is included in all.
//DE is used for TAX included in Positions and needs to be displayed how much TAX is included in all.
$german_bt_used = TRUE // TRUE German BT will display the account infos where CC-Info is placed / False German BT is not in use

LINE 275
if ($edit_orders_in_country == 'DE') {
// Correction tax calculation (Michel Haase, 2005-02-18) reissued by KRONEDERSCHOEPFUNG.com for German Users
// German Users need to display prices including TAX and display the included Tax as the TAX Position in the Bill.
$RunningSubTotal += (tep_add_tax(($products_details["qty"] * $products_details["final_price"]), $products_details["tax"])); // version WITH tax

} elseif ($edit_orders_in_country == 'US') {
$RunningSubTotal += $products_details["qty"] * $products_details["final_price"]; //without TAX
}

LINE 335
//CHANGE FOR GERMAN USERS BY KRONEDERSCHOEPFUNG.com
//International Set with TAX ADDED to the SHIPPING
if ($edit_orders_in_country == 'DE') {
$RunningTax += (($ot_value / (100 + $AddShippingTax)) * $AddShippingTax); //Tax is included in Shipping and added to RunningTAX
} elseif ($edit_orders_in_country == 'US') {
$RunningTax += (($AddShippingTax / 100) * $ot_value); //Tax is added to Shipping
}

LINE 488
if ($edit_orders_in_country == 'DE') {
//For German Users the TOTAL MUST NOT BEEN ADDED TO RunningTAX only included TAX needs to be SHOWN IN BILL
//SO if Price is displayed with TAX no need to add TAX TO TOTAL
//was in here before ut taken out
if($ot_class != "ot_tax") {
$RunningTotal += $ot_value;
}
elseif ( DISPLAY_PRICE_WITH_TAX == 'false') {
// For German friends, the tax is included in the price and should not be
// taken in account when calculating total (not sure about shipping part, though :) ) ( ANSWER: Shipping INCLUDES TAX and only needs to be shown how much is included, but not to be added ! )
$RunningTotal += $ot_value;
}
} elseif ($edit_orders_in_country == 'US') {
$RunningTotal += $ot_value;
}

FROM 956 to 1028
<?php
// begin modification for german banktransfer
if ($german_bt_used == TRUE) {
$germanbt_query = tep_db_query("select * from " . TABLE_GERMANBT . " where orders_id = '" . tep_db_input($HTTP_GET_VARS['oID']) . "'");
if (tep_db_num_rows($germanbt_query) != 0) {
$germanbt = tep_db_fetch_array($germanbt_query);

[...]

}
}
// end modification for german banktransfer
?>

FULL PACKAGE

Ok, there aren't any vitamins, but there are some updates. This is a major revision from v1.80, hence the shift to 2.0. Here are the changes made to the package:

3/14/2006
v2.0

-Dropped support for MS1(ie file is written to work with a stock install of osC 2.2 MS2)
-Updated use of $HTTP_*_VARS to $_* (this doesn't play well with versions of PHP prior to 4.1)
-Made code fully compliant with the standard of register_globals being set to OFF (as of PHP 4.2)(no worries- works the same with globals ON!)
-Moved file specific functions to top of file for logical arrangement and to fix bug where certain users saw a call to undefined function error
-Deleted unused function tep_get_country_iso_code_2
-Changed code so that, by default, tax is not applied to shipping and other fees. The code to allow for this is still included (line 282)
-Replaced all instances of print' with 'echo' to comply with instructions found in osC STANDARD file
-Placed the major foreach loops inside if conditionals. This allows for unique situations such as updating an order that has zero products by preventing the script from failing on invalid foreach arguments that previously would have occurred in such situations
-Added ability to add tax onto an order that was originally calculated, during the checkout process, without any tax
-Includes semi-updated language definition files for all included languages (Danish, Dutch, English, French, German, Italian)- the entries all exist, unfortunately my language skills are lacking so many of the new entries are written in English
-Fixed a bug where Order Editor would not properly display and upon updating the order would delete the Estimated Delivery Date as quoted by the UPSXML module
-Fixed a bug where the specials price was always being used when adding a product regardless of whether or not the special was active
-Standardized the language used in base file (English)
-Deleted an incredible amount of extraneous and/or unneccessary code in both the base file and the language definition files
-Standardized the currency format seen in order totals, etc, by using the currencies->format function
-Rolled what had been update steps 1.4 and 1.5 into one step
-Included optional code to allow for creation of subtotal and/or total entry in database if none exists (line 317)
-Added links for details, invoice, and packing slip at the top of the page
-Updated use of the deprecated font tag in the language definition files to inline CSS
-Added ability to post a new comment (and notify the customer with or without sending them the new comment if desired) without changing the status of the order

-Many other minor changes that I've forgotten to list

This is a FULL PACKAGE

It has been tested with register_globals OFF and ON, and worked identically in either environment.

The code is not fully compliant with globals OFF but includes a patch that allows the non-compliant code to function properly.

WARNING- this contribution will not work with any version of PHP prior to 4.1. To find out what version of PHP you're running, go to admin->tools->server info and you will see the PHP version near the top of the page.

If you experience difficulties with anything other than tax calculations (they still don't work), please post to the forums:

http://forums.oscommerce.com/index.php?showtopic=54032

2/28/2006
v1.80

Fixed a bug that was resulting in the deletion of items from multiple orders (thanks to Giirov for this patch)
Moved the version history notes to a new file, changelog.txt (some were in the file, some were in the install notes)
Deleted a whole lot of unused code
(with two steps above reduced the size of the file by over 1000 lines, approx. 9kb)
Made the first steps towards updating the code for PHP 4.2 and register_globals = OFF (this has been a mess and a VERY steep learning curve- for now updating products, updating discounts, shipping, and total, as well as adding new products still need to be rewritten, along with, I think, a number of foreach statements, but with the patch it all functions properly)
Reverted to the v1.73 version prior to updating as the changes I made for 1.75 ended up basically being two new bugs and I'm not at all familiar with other versions
Included the updated Dutch language file that was provided by vendistino

THINGS TO DO:
1. Try to figure out why some of the code is written in Italian, and the rest in English. Regardless, change the code to either be all Italian or all English.
2. Decide whether to sit down with the tax calculation monster and attempt to tame it, or run for the hills.
3. Interpret what, exactly, is happening to the order total when a new product is added, because right now it looks like it might have something to do with German numbering standards (which, if true, would be fine, except that not everyone who uses this is German)
4. Attempt, valiantly, to finally update all the code for register_globals = OFF

our success? individual commitment to a group effort

Community Add-Ons

Order Editorfor osCommerce Online Merchant v2.2

Order Editor
for osCommerce Online Merchant v2.2