Contributions

This update for order editor is so, when combined with QT Pro, in admin, you can only add in attributes that are actually in stock in edit_orders_add_product.php. You are also displayed the number of items available.

One instruction file included - one simple modification required.

No major updates, mostly just a roll-up of items contributed. The only thing brand new is the fix for the Free Shipping w Minimum Amount contribution if you have that installed.

-Updated compare files for MS2.2 RC2a release of osCommerce
-Added line from directions that were missing in the compare file admin/orders.php.
-Added comments to changes in existing updated files to identify the changes better.
-Included improved Dutch Translation by PaulusBoskabouter 21 Dec 2008
-Included Turkish language by muzik 28 May 2009
-Included the QTPro addition as an Admin Option like the SPPC addition. Credits go to: Phocea 20 Jul 2009
-Included the Dutch buttons by fschuurman 20 Sep 2009
-Fixed Free Shipping problem reported by Richard Cranium 10 Mar 2009 (see install instructions)
-Removed a number of Thumbs.db files
-Removed some braces from some comments that caused Dreamweaver's Balance Braces to fail.


This is a complete package.

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

Dutch translation was add and reviewed, but no buttons were present. Please find them attached.

Indeed i forgot to remove the unneeded order by in the query (left from first attempt).
Dr Lucas contribution is not ordering the option and it is left to luck alone to have the correct string to find the related stock.
This version use the same sort that QT Pro does when creating the stock record. It is also more efficient, using less SQL queries in the code.

On my installation, Dr Lucas version would not create the whole string for lookup (i.e. 1-1,2-6,4-3) and not update the stock properly, which make sense since the update code is inside a loop fetching attributes one by one (1-1, then 2-6, then 4-3). It can therefore not work if you have multiple options on the same product!

I tried to use the last uploaded package for the Order Editort QT Pro addon and found it was not working properly.
I fixed the code to behave properly and lookup attributes in the stock table in the same way that they are actually entered by QT PRo stock.

I tested this with up to 3 attributes per product without any problems.

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

The content of the oe_autoinstaller/index.php file was moved to control.php to make the php version check work.

Autoinstaller 2.14 for Order Editor 5.0.6.6 by ReyBlack (1 Dec 2008)


Before using the autounstaller make a new directory order_editor (catalog/admin/order_editor)


Download the package and view the screenshot of what you will get after the installation.

The Auto Installer script requires PHP 5.2.0

Autoinstaller 2.14 for Order Editor 5.0.6.6 by ReyBlack (1 Dec 2008)

The script automatically install the contribution: copy files, edit files, alter database tables.
It saves a backup before any action.

The aim of the script is to speed up the contribution installation.
And to make possible to uninstall it.

You will need to do manually only what the script cannot.


Before using the autounstaller make a new directory order_editor (catalog/admin/order_editor)

The Auto Installer script requires PHP 5.2.0 !

Türkçe dosyası ve türkçe bottonlar eklendi . Tek bir dosyadır.

Turkish language and buttons added only one file.

Files affected:
/catalog/admin/edit_orders.php


Work-around for the bug where the Edit Order function hangs (blank screen). I would like to resolve this issue properly, but for the time being this fix will work. The shipping method will appear as a line item in the order (with description, e.g. FedEx, etc.) and the cost of shipping can be edited.

Order Editor will also report that no shipping methods are available. If you don't mind manually figuring the shipping cost then this works as a stop-gap measure to allow you to utilize this wonderful mod and also the Free Shipping mod which many stores use.

The alternative is you have to turn off Free Shipping in your store in order to be able to edit any orders - not very helpful!

FIX:

Around Line 349:

Original:

// Get the shipping quotes- if we don't have shipping quotes shipping tax calculation can't happen
// $shipping_modules = new shipping;
// $shipping_quotes = $shipping_modules->quote();


Change to:

// BOF Fix for Free Shipping mod compatibility by Richard Cranium
// Removing lines below prevents blank page on Order Update function
// Get the shipping quotes- if we don't have shipping quotes shipping tax calculation can't happen
// $shipping_modules = new shipping;
// $shipping_quotes = $shipping_modules->quote();
// EOF Fix for Free Shipping mod compatibility

#################

Around line 663:

Original Code:

// Get the shipping quotes
// $shipping_modules = new shipping;
// $shipping_quotes = $shipping_modules->quote();
// End fix for Free Shipping


Change to:

// Fix for Free Shipping compatibility by Richard Cranium
// Removing lines below prevents blank page on Edit Order from Admin panel
// Get the shipping quotes
// $shipping_modules = new shipping;
// $shipping_quotes = $shipping_modules->quote();
// End fix for Free Shipping

I changed (only) the dutch translation file. Improved the language used, more consistency and corrected some spelling errors.

Only 1 file to replace....

I don't use the state-field at all, it only leads to troubles...
This is what I chaged:
*Removed all state fields from admin as well as from customer notifications.
*Reordered the address fields in admin (please see screenshot):
Billing address first, then shipping address and customers informations
*Added order-no to emails

Please install 5.0.6.6 before - this mod is based on that version.

This is just a modification, no full package !!

greetz
anton

Fixes posted by nocomply and pbor1234 added.
Spanish Language added.

Full Package.

Cross posting here as FYI.

http://addons.oscommerce.com/info/6370

the language_id is not used in the query, selecting the first products_id. In my db the name is ommited there so the name is left empty. Fix is as follows (simply added the languageid to the query):

// Get Product Info
//BOF Added languageid (otherwise products_name is empty)
//$product_query = tep_db_query("select p.products_model, p.products_price, pd.products_name, p.products_tax_class_id from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id where p.products_id = '" . (int)$add_product_products_id . "'");
$product_query = tep_db_query("select p.products_model, p.products_price, pd.products_name, p.products_tax_class_id from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id where p.products_id = '" . (int)$add_product_products_id . "' and pd.language_id = '" . $languages_id . "'");
//EOF Added languageid
$product = tep_db_fetch_array($product_query);
$country_id = oe_get_country_id($order->delivery["country"]);
$zone_id = oe_get_zone_id($country_id, $order->delivery['state']);
$products_tax = tep_get_tax_rate($product['products_tax_class_id'], $country_id, $zone_id);

(this is not a full package, no files attached)

Bugfix when update products quantity negative
on line 190 in edit_orders.php replace:
$quantity_difference = ($products_details['qty'] - $order['products_quantity']);
with:
$quantity_difference = ($products_details['qty'] - $order_products['products_quantity']);

Thanks for a great contribution! I did a quick Finnish translation and added the screenshot from previous post.

Order Editor v. 5.0.6.3
Change log:
-Added Finnish + images
-Added screenshot from previous post

Full package with the following languages:
-English
-Danish
-Dutch
-Finnish
-French
-German
-Italian

This is JUST a screenshot of Order Editor, for people who would like to see it "in action".

I know I know, it's in Norwegian, but you'll get a general idea :-P

NOTE: This is NOT the contribution, just an image.

Dutch language pack Full package

Norwegian added!

Full package

Italian and german added!

Full package

Deutsche Übersetzung für den Order Editor 5.0.6

Viel Spaß
Craxx;)

just downloaded and tried the previous release "v5.0.6 with two bug fixes". If anyone else gets the error
undefined function tep_hide_session_id

just edit catalogadminincludesfunctionsgeneral.php and add the following before the end

function tep_hide_session_id() {
global $session_started, $SID;

if (($session_started == true) && tep_not_null($SID)) {
return tep_draw_hidden_field(tep_session_name(), tep_session_id());
}
}


HTH

Si.

note: blank file attached

9/8/2007
v5.0.6
-Fixed bug that would result in products not displaying as line items in Order Editor if there was no longer a corresponding item in the catalog
-Fixed one additional problem that was causing an E_NOTICE level error

FULL PACKAGE, including upgrade instructions and all files necessary for installation.

This package contains full installation instructions, including the line by line instructions for upgrading from v5.0.4 to v5.0.5 that were not previously included.

This package does not have any changes to the code as compared to the previously released package for v5.0.5.

8/27/2007
v5.0.5
-A large number of small changes to clear up what was a surprisingly large number of E_NOTICE level errors being generated by various Order Editor files

v5.0.4
-Incorporated the use of the iconv() function to prevent strange characters from appearing via the AJAX (aka the UTF-8 bug)
-Added on to the fix for the "too many requires" bug

FULL PACKAGE, including upgrade instructions and all files necessary for installation.

Includes language definition files and buttons for Danish, English, and French.

8/18/2007
v5.0.3
-Fixed the "too many requires" bug as suggested by Vexiphne in the support thread
-Added the file http_client.php to the folder admin/order_editor/ to avoid errors when trying to access the file stored on the catalog side (various reports)
-Fixed the stock check bug as pointed out by yedle in the support thread
-Fixed the CHARSET bug as suggested by VaM in the support thread
-Fixed the shipping tax bug (shipping tax added twice to the order total on sites with Display Price with Tax set to 'true') as pointed out by EuroTimmy in the support thread
-Added discussion of the undefined function tep_hide_session_id() problem to the "Common Problems" section of the install file (various reports, but not a bug)
-Added discussion of the strange characters caused by UTF-8 encoding to the "Common Problems" section of the install file (various reports)
-Added discussion of incredible disappearing credit card fields to the "Common Problems" section of the install file (various reports, but not a bug)

For support please visit the Order Editor support thread:
http://forums.oscommerce.com/index.php?showtopic=54032

FULL PACKAGE, including upgrade instructions and all files necessary for installation.

Includes language definition files and buttons for Danish, English, and French.

8/12/2007
v5.0.2
-Fixed bug where JavaScript would throw error when totalling products info in unlikely event there was an attribute on the page with an attribute_id
equal to the product_id of the product being worked on
-Fixed bug that would result in Low Order Fee remaining in orders where adding products had brought the subtotal greater than the fee threshold
-Changed the way order weight is displayed below the shipping quotes. New way breaks the order into boxes using algorithm in shipping.php class file
-Expanded the Order Totals tooltip hint
-A few other minor changes

For support please visit the Order Editor support thread:
http://forums.oscommerce.com/index.php?showtopic=54032

Full 5.0.1 pack with the french file and button

Have make the Danish fil complte now.
Full 5.0.1 pack with the danish file and button

v5.0.1

FULL PACKAGE

-Fixed bug where comments were not being displayed properly in edit_orders.php.

Fix instructions can be seen at:
http://forums.oscommerce.com/index.php?s=&showtopic=54032&view=findpost&p=1120020
(ie, it's not necessary to download the whole package if you just want to fix v5.0, just read that post)

FULL PACKAGE, including upgrade instructions and all files necessary for installation.

NOTE: This release is not a revision of Order Editor 4.x. The 4.x and 5.x releases were developed independently, and, linearly speaking, are both updates to the 3.x series of Order Editor. As such they would best be considered parallel forks.

For support please visit the Order Editor support thread:
http://forums.oscommerce.com/index.php?showtopic=54032

New features of Order Editor 5.0:
-Fully integrated AJAX interface allows for near real-time updating of the database without use of the update button. In order to update a field the user need only type the new information in the appropriate box then press the tab button or otherwise move the cursor and the appropriate change will be accomplished without reloading the page. Additionally, if you don't like AJAX, these features can be turned off via the admin control panel.
-Real-time shipping quotes using the catalog side shipping modules.
-Order total process using the catalog side order total modules.
-Updated HTML layout does away with many of the nested tables found in previous versions (Cleaner! Faster! Easier to edit!).
-Advanced Add a Product function allows for searching by categories, subcategories, name, or model.
-Form is totally functional on browsers with JavaScript disabled (once you set "Order Editor use AJAX" to 'false' in the admin panel:)).
-Much easier to read HTML install/upgrade instructions.

Order Editor v5.0 BETA 1 for public testing

NOTE: This release is for public testing and is NOT RECOMMENDED FOR USE ON PRODUCTION SITES.

NOTE: This release is not a revision of Order Editor 4.x. The 4.x and 5.x releases were developed independently, and, linearly speaking, are both updates to the 3.x series of Order Editor. As such they would best be considered parallel forks.

FULL PACKAGE, including upgrade instructions

Please post all bug reports on the Order Editor support thread:
http://forums.oscommerce.com/index.php?showtopic=54032

Features of Order Editor 5.0:
-Fully integrated AJAX interface allows for near real-time updating of the database without use of the update button. In order to update a field the user need only type the new information in the appropriate box then press the tab button or otherwise move the cursor and the appropriate change will be accomplished without reloading the page.
-Real-time shipping quotes using the catalog side shipping modules.
-Order total process using the catalog side order total modules.
-Updated HTML layout does away with many of the nested tables found in previous versions.
-Advanced Add a Product function allows for searching by categories, subcategories, name, or model.


Known bugs/issues:
-Shipping tax is apparently not being added to the appropriate tax component, but is added to the total
-Add a Product function does not work at all on browsers with javascript disabled (implementation of javascript-less Add a Product function planned for BETA 2)

Planned revisions for BETA 2;
-Bug fixes as necessary
-Add a Product functionality on javascript impaired browsers
-Ability to toggle AJAX features on/off via admin (for all the haters)
-Clean up and streamline the AJAX code
-Use responseText to generate success messages in AJAX code in order to better catch errors

Please post all bug reports on the Order Editor support thread:
http://forums.oscommerce.com/index.php?showtopic=54032

v4.0.2 - minor update and fixes
-Added functionality to retrieve and hold shipping method from customer side order rather than having it being overwritten after hitting update.
-Added code to unregister session variables
-Updated code to reduce SQL queries where not needed.
-Included usps.php file updated for order editor 4.0 real-time quotes on the administration side.


This is a general update version. This is the best version of the 4.0 contribution.

insaini

My mistake. Forgot to remove some shipping module specific code.

Download this version and disregard 4.0A and 4.0.1A

Sorry about that.

Done

insaini

This is a minor update from the previous version.

-Added a check to display saved shipping method from database if it exists.
-Added an error message to be displayed if shipping quote requested when no products added.

Upgrade.txt now included to upgrade from Order Editor v3.0.2.1

insaini

Here it is,

Order Editor 4.0 Alpha

Contains what I would consider coding enhancements.. basically changed semantics. Added feature includes Real-Time shipping quotes from your installed shipping modules.

Manual Order Maker (1.4.2) has been combined into one contribution.

Shipping Tax field has been removed. Shipping Taxes will automatically be added according to your Tax Class setup. If your shipping taxes arent being added then your Tax Classes arent setup correctly and you should read the Tax Setup documents that come with OSCommerce.

Handling Charge Fee added as well as checks for Real-Time quotes.

Upgrade.txt has not been included. There is no documentation to upgrade from OE 3.0.2.1 to OE 4.0.

This Contribution assumes a fresh install of OSCommerce 2.2 RC1

insaini

Ein kleiner Fehler bei der Berechnung war noch drin ...

Problem: Die MwSt. wird aus der Zwischensumme (oder gar nicht), anstatt aus der Endsumme berechnet.

Lösung: Beim UPDATE der Änderung wird die MwSt. richtig berechnet und gespeichert.

Achtung: Die Änderungen wurden in der Version 2.7.3 vorgenommen. Desweiteren wurde der MwSt.-Satz von 19 % direkt in der Datei angegeben (Zeile: 439, 440)!

This is a slight refinement of the bug fix posted in v3.0.2

5/11/2007
v3.0.2
-Fixed bug in code for new order confirmation emails that caused all Invoice URL links to be non-SSL even on sites with SSL and would also cause the link to be incorrect if the catalog was stored in a folder other than the root

5/1/2007
v3.0.1
-Fixed bug in code for new order confirmation emails that would result in default currency always being used to display products prices

05/01/2007
v3.0 - Danish
-Changed line 2450 in file admin/edit_orders.php

Order Editor - Now in English and Spanish
All translate except the image.

Order editor - Ahora en inglés y español
Todo traducido excepto la imagen.

As always, Order Editor allows you to quickly and easily change almost any part of an order.

Edit customer details including customer, billing, and shipping addresses, as well as email address and telephone number!

Add or delete products!

Edit product names, tax rates, products attributes, products attributes prices, download info, and more!

Reliably calculate new subtotals, tax totals, and grand totals!

Add new comments and/or change the status of the order!

NEW- edit or delete existing comments!

Send out new order confirmation emails complete with the updated order information!

Plus, Order Editor also has these usefule features:
-dropdown menus to allow for easy changing of country and/or state
-a dropdown menu for payment method that can be turned off via the admin control panel
-a dropdown menu to allow for easily changing the currency type associated with an order
-Up to date stock values for each item in an order, as well as the total weight of each line item and the total weight of the order
-On the fly JavaScript calculator that will show you an estimate of the value of each line item and all order totals as you type changes!
-NEW: a simple shipping method dropdown to allow for easily changing the shipping method of an order, also configurable in admin
-Handy tooltips to help explain various portions of the page
-register_globals ready!
-short_open_tag ready!

Changed files: admin/edit_orders.php, admin/includes/functions/general.php, admin/includes/classes/oe_order.php, admin/includes/languages/english/edit_orders.php

After seeing the patch posted by eholme I did some research into MySQL queries, specifically the use of LEFT JOIN vs. INNER JOIN, and found that the use of LEFT JOIN within Order Editor was totally unnecessary.

The following changes were made for this version:
-the query eholme optimized was deleted
-all remaining instances of LEFT JOIN were replaced with INNER JOIN
-cleaned up the code for a number of queries to make them easier to read

Changed files: admin/edit_orders.php, admin/search_suggest.php, admin/includes/classes/oe_order.php

I had a problem with this contribution with sites where there was hundreds of thousands of products. The mysql server was eating up all of the processor time for at least 10 minutes. It turned out the fix was simple

Replace the section beginning at line 2333 in edit_orders.php with the following:
<?php
// ############################################################################
// Get List of All Products
// ############################################################################

$result = mysql_query("
SELECT pd.products_name, p.products_id, cd.categories_name, ptc.categories_id
FROM " . TABLE_PRODUCTS . " p
INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd
ON pd.products_id=p.products_id
INNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc
ON ptc.products_id=p.products_id
INNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd
ON cd.categories_id=ptc.categories_id
WHERE pd.language_id = '" . (int)$languages_id . "'
ORDER BY categories_name");


while($row = mysql_fetch_array($result))
{
extract($row,EXTR_PREFIX_ALL,"db");
$ProductList[$db_categories_id][$db_products_id] = $db_products_name;
$CategoryList[$db_categories_id] = $db_categories_name;
$LastCategory = $db_categories_name;
}

or just repace the file

4/28/2007
v2.9.3
-Fixed bug where tax rate was not being assessed properly for products added to the order using the "Add a Product" feature.
-Updated code to change use of $countryid and $zoneid to $order->delivery['country_id'] and $order->delivery['zone_id'], respectively.


For bug reports, questions, comments, concerns, recommendations, weather reports, etc, please post in the Order Editor thread of the osCommerce forums: http://forums.oscommerce.com/index.php?showtopic=54032

Wrong VAT with the Edit Order with version 2,6 - 2.9

Chance this code, dowload the file with the infomation

This is a minor update. There is no reason to update unless you are running Separate Pricing Per Customer (SPPC) and would like Order Editor to pull customer specific pricing from the database when adding a product.

Non-SPPC users, have no fear. The code for SPPC is disabled by default so you can use this contribution without any problems related to the SPPC-specific code.

If you are using SPPC, you will probably want to activate the patch. Instructions for doing this are found at line 597 of admin/includes/edit_orders.php.

There were also some minor cosmetic changes and a revision of the text for the payment method tooltip.

Changed files: admin/edit_orders.php, admin/includes/languages/english/edit_orders.php

fixed small bug which was deleting orders with ROUNDING

I have tried to use ORDER_EDIT 2.9.1, but i found following major bugs in VAT calculation:

1. VAT calculations (specially in Javascript) are usual done in un-correct way, specially when you have
DISPLAY_PRICE_WITH_TAX set to TRUE
2. tax rounding is default set to 4 decimal places, which is for me (SLOVAKIA) bad, because we have 1 decimal place rounding rule

I have rewritten order_edit to make things OK with steps above, but I want to point to contrib creator, that this thing should be fixed!

typical mistake is f.e.tax calculation without rounding set properly

//removed by MGX $RunningSubTotal += (($products_details['tax']/100 + 1) * ($products_details['qty'] * $products_details['final_price']));
$RunningSubTotal += Round($products_details['final_price'] * ($products_details['tax']/100 + 1),1) * $products_details['qty'];

My contrib needs following to be setup OK:

1. decimal tax place set 1 -> should take variable from admin (do you know how?)
2. installed ot_round contrib (I round according SK law final price at 0.5 down or up)

Mgx

This is the German language file 2.9.1 and a button image for Order Editor. Just add the files to the right folders under admin/includes/languages/german and admin/includes/languages/german/images/buttons

This is the dutch language file 2.9.1 and a button image for Order Editor. Just add the files to the right folders under admin/includes/languages/dutch and admin/includes/languages/dutch/images/buttons

3/10/2007
v2.9.1
-Changed the way data is handled before being sent to the database by utilizing both tep_db_input and tep_db_prepare_input due to problems associated with using just one or the other
-Added a whole new case to handle the new order emails to allow for updating the order and sending a new email in one step
-Rolled the necessary code from admin/edit_orders_email.php into admin/edit_orders.php
-Added JavaScript code to change displayed stock levels "on the fly" as product quantities are changed
-Added additional checkboxes for sending a new order email, one checkbox next to each update button
-Added JavaScript code so that all three email checkboxes will check and uncheck together
-Fixed the HTML for the Payment Method box to correct bug where Payment Method table would resize depending on which payment method was chosen
-Incorporated the use of tep_html_oe_no_quote in the tooltips to avoid problems caused by special characters such as ' in the tips (my apologies to the French, but apostrophes break the tooltips)
-Corrected a number of small items in the HTML which were not valid HTML 4.01 Transitional
-Added three new functions to admin/includes/functions/oe_functions to allow for passing parameters when drawing checkboxes and radiobuttons
-Changed files: admin/edit_orders.php, admin/includes/languages/english/edit_orders.php, admin/includes/functions/oe_functions.php
-Deleted files: admin/edit_orders_email.php

- Incorporated: some additional help information regarding the "New order confirmation" checkbox.

- Incorporated: a feature which allows an admin to email an updated order confirmation email after an order has been edited.

- Modified: changed one and only <? tag to <?php tag in edit_orders.php, since some servers are set (in php.ini) to "short_open_tag = Off". On this servers the <? tag causes a parse error.

2/05/2007
v2.8.5
-Fixed bug where "add a product" step(s) would be displayed at the bottom of edit_orders.php during the "edit" process if the "back" button near the top of the page was pressed during the "add a product" phase

This is v2.8.4 with the correct file for admin/includes/functions/oe_functions.php (also changed for this version)

2/01/2007
v2.8.4
-Adjusted the numbers in the code for add a product to reflect that there are now only four total steps
-Removed obsolete javascript code for function related to old version of add a product
-Fixed bug where oID was not being displayed properly during add a product on sites with register_globals off, also tweaked code and language file for better language independency
-Cleaned up code for add a product, doing away with a few small bugs (including the one where step 2 would disappear after selecting a products options) and removing some unnecessary code
-Incorporated features as posted by wHiTeHaT on the support thread for searching by model during the add a product steps
-Renamed SearchSuggest.php to search_suggest.php to keep filenames inline with osCommerce standards
-Tweaked search_suggest.php for neater display of products information while searching (still doesn't look quite right in Firefox)
-Changed files: admin/edit_orders.php, admin/search_suggest.php, and includes/languages/english/edit_orders.php

1/8/2007
2.8.3
-Fixed bugs in customer data fields that would result in lost data on sites with register_globals set to OFF
-Re-fixed javascript bug that somehow slipped back in since v2.7.3
-Maybe something else, but if so it's slipped my mind

This is the dutch language file and a button image for Order Editor. Just add the files to the right folders under admin/includes/languages/dutch and admin/includes/languages/dutch/images/buttons

Updated file "edit_orders" in spanish language.

Traducción completa y completada del archivo "edit_orders" al idioma español. Corregidas algunas lineas de codigo perdidas.

By ramusgue

11/28/2006
v2.8.2
-Fixed some little bugs and a Tax issue
-Fixed a problem that prevent you form using ' in the customer data field
-Added to the AJAX Add Products the possibilities to see quantities on the fly

P.s. In the last packege i forgot to erase two line used for italian PIVA and CF.

11/28/2006
v2.8.2
-Fixed some little bugs and a Tax issue
-Fixed a problem that prevent you form using ' in the customer data field
-Added to the AJAX Add Products the possibilities to see quantities on the fly

Just added some of the basic features from the original Ajax contributions.

- search by model
- show price / special price

This is only SearchSuggest.php. Just replace the one file if you need to search by model.

11/13/2006
v2.8.1
-Added the missing file serachsuggest.php to the package
-Added the instruction for the missing function tep_get_products_inventory_qty() used to get the stock quantities

11/13/2006
v2.8
-Completely change the way products are added, using new AJAX routine. Now Products are addede in less the 5 sec ;) . Minor graphical issues when products as OPTIONS, will be fixed in a next release
-Added a little column that let u see how many pieces of that product u have on stock, very usefoul for who do a lot of modification and phone order and need to have a clear situation of his/her stock

P.S. This release have an updated install.txt and the missing searchsuggest.php

11/13/2006
v2.8
-Completely change the way products are added, using new AJAX routine. Now Products are addede in less the 5 sec ;) . Minor graphical issues when products as OPTIONS, will be fixed in a next release
-Added a little column that let u see how many pieces of that product u have on stock, very usefoul for who do a lot of modification and phone order and need to have a clear situation of his/her stock

11/1/2006
v2.7.4
-Repaired problem with IE and the shipping and billing address blocks related to IE's inability to recognize the display property "table-row"

10/31/2006
v2.7.3
-Modified code so that javascript functions for edit and add a product cases would only display when necessary thereby avoiding javascript errors
-There were two sections where code assumed certain data to be an array; added check to verify whether the array exists to avoid errors

10/24/2006
v2.7.2
-Deleted unnecessary function tep_html_noquote from admin/includs/functions/oe_functions.php

10/24/2006
v2.7.1
-Fixed bug where no error would be displayed when attempting to access an order that didn't exist, just a blank screen

Full Install To 2.7, And The admin/danish/edit_orders.php Is Full Update Now

10/16/2006
v2.7
-Overhauled the customer info and payment sections based on code released as part of Josh Dechant's MOECTOE suite.
Integrated a number of new features including dynamic drop-down menus for state and country and the ability to set the billing address same as the customer address and the shipping address same as the billing address.

-Introduced two new files:
admin/includes/classes/oe_order.php
admin/includes/functions/oe_functions.php
These files take the place of changes to the order class and general functions file seen in previous versions.

-Trimmed down what has become a monstrous JavaScript section of the admin/edit_orders.php file- it's not compatible with dinosaur browsers, but it's also noticeably shorter.

-Added a screenshot to the contribution package

This is actually another correction for v2.6.4 but I didn't want to start getting weird with the version numbers.

This package includes what I hope are accurate installation instructions as well as up to date Russian and German language files (so much for the language pack). Thanks goes to Irin and Onkel Flo, respectively, for those translations.

There is no missing JavaScript file.

If you have any questions, concerns, comments, etc, please post in the support thread:
http://forums.oscommerce.com/index.php?showtopic=54032

Added the missing javascript file

Added full german language pack

This is a complete package!

This is a corrected package for v2.6.4 to fix small error in admin/edit_orders.php.

This is only admin/includes/languages/russian/edit_orders.php with Russian translation of v2.6.4.

This is a package of various language definition includes for Order Editor. They are all at various stages of compatibility; some are very recent while others are much older. Each one is in need of being updated.

If you are familiar with any of the languages included here, please(!) update the appropriate file(s) and upload the new updated package for others to use.

Even better: if you are familiar with a language not included here, create the appropriate file and add it in!

Languages included: Danish, Dutch, French, German, Hungarian, Italian, Norwegian, Polish, Portugese, Slovak, Spanish, and Swedish.

9/22/06
v2.6.4
-Changed overlib function to a DHTML tooltip, thus doing away with the file admin/includes/javascript/overlib_mini.js
-Integrated currencies editing ability based on a contribution by eww
-Included optional code at about lines 2051 and 2065 for searching the dropdown menus when adding a product
-Forked the various language definition includes into a separate package

***IGNORE Previous CURRENCIES Package, as it contained incomplete manual instructions***



What this is:
If you DO NOT make use of multiple currencies, you don't need this add-on. Instead, install the most recent FULL PACKAGE version.


This simple addon will give you the ability to manually edit a user's currency or currency value on their purchase.

Screenshot:
http://img171.imageshack.us/img171/483/currencyprevbo4.gif

If you DO NOT make use of multiple currencies, you don't need this add-on. Instead, install the most recent FULL PACKAGE version.


This simple addon will give you the ability to manually edit a user's currency or currency value on their purchase.

Screenshot:
http://img171.imageshack.us/img171/483/currencyprevbo4.gif

This is ONLY the Dutch Translation for the 2.6.3 release.

Please download the 9 August 2006 Full Package by djmonkey1

Please ignore the file below!

This is ONLY the Dutch Translation for the 2.6.3 release.

Please download the 9 August 2006 Full Package by djmonkey1

The Hole file is on danish Now
Full Pack

PLEASE NOTE! For users whose primary language is other than English, make sure you add this to your language definition file for edit_orders.php, translated as necessary:

//add-on for downloads
define('ENTRY_DOWNLOAD_COUNT', 'Download #');
define('ENTRY_DOWNLOAD_FILENAME', 'Filename');
define('ENTRY_DOWNLOAD_MAXDAYS', 'Expiry days');
define('ENTRY_DOWNLOAD_MAXCOUNT', 'Downloads remaining');

ALSO: many of the included language files are out of date. If you could please update the language(s) you are familiar with and post those files here many others will certainly appreciate it.

FULL PACKAGE
8/9/2006
v2.6.3

-Added ability to display and edit download information per product as well as including download information when adding a downloadable product to an order

-IMPORTANT: Changed the way the stock check works. Order Editor had been checking the setting of "Check stock level" in Administration->Configuration->Stock; however after a post by Scotty1 in the support thread it was brought to my attention that it is more logical to go by the setting of "Subtract stock". That shift has been made for this version.
This is a subtle but important change as it could affect the way Order Editor handles stock levels depending on the settings of your site(s).

FULL PACKAGE

PLEASE NOTE: for those whose primary language is other than English: make sure you add this to your language definition file, translated as necessary:

//add-on for downloads
define('ENTRY_DOWNLOAD_COUNT', 'Download #');
define('ENTRY_DOWNLOAD_FILENAME', 'Filename');
define('ENTRY_DOWNLOAD_MAXDAYS', 'Expiry days');
define('ENTRY_DOWNLOAD_MAXCOUNT', 'Downloads remaining');

ALSO: many of the included language definition files are still out of date. If you could please update the language of your choice and post it here for others to use, it will be greatly appreciated.

8/9/2006
v2.6.3

-Added ability to display and edit download information per product as well as including download information when adding a downloadable product to an order

-IMPORTANT: Changed the way the stock check works. Order Editor had been checking the setting of "Check stock level" in Administration->Configuration->Stock; however after a post by Scotty1 in the support thread it was brought to my attention that it is more logical to go by the setting of "Subtract stock". That shift has been made for this version.
This is a subtle but important change as it could affect the way Order Editor handles stock levels depending on the settings of your site(s).

FULL PACKAGE

PLEASE NOTE: for those whose primary language is other than English: make sure you add this to your language definition file, translated as necessary:

//add-on for downloads
define('ENTRY_DOWNLOAD_COUNT', 'Download #');
define('ENTRY_DOWNLOAD_FILENAME', 'Filename');
define('ENTRY_DOWNLOAD_MAXDAYS', 'Expiry days');
define('ENTRY_DOWNLOAD_MAXCOUNT', 'Downloads remaining');

ALSO: many of the included language definition files are still out of date. If you could please update the language of your choice and post it here for others to use, it will be greatly appreciated.

8/9/2006
v2.6.3

-Added ability to display and edit download information per product as well as including download information when adding a downloadable product to an order

-IMPORTANT: Changed the way the stock check works. Order Editor had been checking the setting of "Check stock level" in Administration->Configuration->Stock; however after a post by Scotty1 in the support thread it was brought to my attention that it is more logical to go by the setting of "Subtract stock". That shift has been made for this version.
This is a subtle but important change as it could affect the way Order Editor handles stock levels depending on the settings of your site(s).

Only file with slovak language. v_2.6

FULL PACKAGE

8/1/2006
v2.6.2

-Fixed bug in JavaScript that would result in incorrect totals for some tax rates and the final total

FULL PACKAGE

-Fixed bug where taxes were not being calculated properly when adding a product

-Added Slovak translation by krtko

-Very minor changes to the README file

Includes instructions for upgrading from v2.6 to v2.6.1

Only file with slovak language

v2.6

FULL PACKAGE

This is actually just a roll-up that includes all the bug fixes since v2.5 and one new bug fix for sites that use apostrophes in product names. If you are using v2.5.4 this is a simple one step change, instructions for which are included in the upgrade text in the package.

-Fixed bug where product names with apostrophes were not being displayed properly

-Added new full French translation by lordbdp

-Added new full Danish translation by TheExterminator

-Updated the install instructions, the README, and included an upgrade text file

This is admin/edit_orders.php only. Please download v2.5 for the full package.

-Fixed bug where "add a product" function would fail on certain sites with shared SSL. Patch instructions can be found in the support thread: http://forums.oscommerce.com/index.php?s=&showtopic=54032&view=findpost&p=879478

This is only the admin/includes/languages/french/edit_orders.php with totaly French translation.

This is admin/edit_orders.php only. Please download v2.5 for the rest of the package.

-Fixed bug where the user would see an SQL error when deleting a product that had an empty field for quantity

-Fixed bug in JavaScript where code was looking for a field that would not necessarily exist and so would throw an error when it didn't

The File Is Translate To Full Danish Now, And Chance The Small Error

This is admin/edit_orders.php only, please download v2.5 for the rest of the package.

-Added display of products attributes prices, as applicable, when adding new products. This is not a bug fix and is the only thing different from v2.5.1 so unless you're heavily into products attributes prices there is no big reason to update.

This is admin/edit_orders.php only. Please download v2.5 for the rest of the package.

-Fixed bug where PHP was not pulling price prefix from database when adding a product with attributes.

-Fixed limitation of JavaScript where calculator function was not taking prefixes into account when adding in attributes prices.

-A few other minor cosmetic changes

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

This package is admin/edit_orders.php only, please download v2.4 for the install instructions, etc.

Includes a one-line change (line 346) to fix bug where Order Editor would generate a duplicate tax field upon updating.

NOTE: A limitation of the file has been identified involving shops that have multiple tax rates in any given tax class, with different rates applying only to certain tax zones. In this instance Order Editor will generate a new tax field for that class. A fix for this will be included in v2.5, available soon.

I have installed the latest version of Order Editor (2.4) and now my dropdown box for the payment method is back to a text box. I have installed the previous version that is suppossed to let you turn this on throught he admin panel, but I don't get the options in "My Store" to turn it on/off. I have run through the code several times, and can't seem to get the dropdown to work anymore. Could someone please help me? I've had this posted in the forums for weeks and have gotten no help. Thanks,

In v2.4 the core file makes reference to JavaScript functions that were not included in the final release. This should take care of that problem.

This is the file admin/edit_orders.php only. Please download v2.4 for the rest of the files, install text, etc.

Note: works with register_globals ON or OFF

4/8/2006
v2.4
-fixed bug in Payment Method dropdown where cc fields were not automatically displayed upon
selecting the Credit Card option from the list

-integrated multiple tax class patch by Hartmut Holzgraefe. Modified various portions of the patch,
such as the function tep_get_tax_rates_description and the expanded $orders_query, to allow for
having multiple tax rates per class.

-included modification of the $orders_products query in admin/includes/classes/order.php as part of
the fix for multiple tax classes and did away with duplicate query within edit_orders.php

-placed the function tep_get_tax_rates_description in admin/includes/functions/general.php so it
would be available to the order class

-included new input field, Price(base), to allow for on-the-fly calcs to include any product
attributes that may exist, and also to allow for editing of both price fields for each product in
an order to keep them in line with each other. Please see the README for more on this.

-Slightly modified the display text of the configuration input for Payment Method selector

-Changed javascript calculator to always format price calcs to four decimal places (as recommended
by Irin)

v2.3 by quick_fixer

-Added an improved payment method dropdown menu (modified from a previous contribution by nuttycat) that is cross-browser compatible and compatible with older browsers

-Added switch on and off payment method dropdown menu control from Admin panel...In section: "My Store" you will find Display Payment method dropdown menu....set to true or false (will revert to a input field). Both will work with existing code. This is useful if you don't know what other payment methods are called you can select from the list. On the other hand, you can set the variable to false from the admin if you only have one payment method. ALSO featured is in the case that the payment method for the order is different from the module titles then it will add the payment method as an option in the dropdown menu. AND the dropdown menu will default to the payment method assigned to the order.

-Fixed attribute dropdown bug when adding new product query that rendered the attribute dropdown menu did not default to the language of choice (e.g. it defaulted to spanish instead of what your default language was set to).

-Updated the define: HINT_UPDATE_TO_CC because it wasn't clear to me what the hint meant so I elaborated from the existing define.

-modified the button for "button_add_article.gif" for the spanish folder....because for some reason someone created a button with bold text....I just wanted to be consistent with other language buttons

FULL PACKAGE

Bug fix for syntax error caused by extraneous characters.

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.

Full package includes POLISH and PORTUGUES language translation

File included is admin/includes/languages/portugues/edit_orders.php only.

To lower the contribution :
v2.1 Full Package

Hungarian translation included.

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.
NOW ALL OT CUSTOMS WILL BE PROCESSED LIKE THEY SHOULD.

Includes the shipping tax.

Based on yesterdays contrib of myself and prvevious coders.


********
NOW ALL OT CUSTOMS WILL BE PROCESSED LIKE THEY SHOULD.

THANKS TO : Kornie

He sent me this snippet wich solves the prob ( I have added it to the pack ):

LINE 339
if(($ot_class == "ot_customer_discount" || $ot_class == "ot_custom" ) && ($RunningTax != 0)) {
if ($edit_orders_in_country == 'DE') {
$RunningTax += (($ot_value / (100 + 16)) * 16); //Tax is included in Discounts and added to RunningTAX
} elseif ($edit_orders_in_country == 'US') {
$RunningTax += (($AddShippingTax / 100) * $ot_value); //Tax is added to Shipping
}



********

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

3/21/2006
v2.1

FYI- Works with register_globals turned off!

- Fixed error caused by extraneous character in admin/includes/languages/english/edit_orders.php (thanks to mrossi for first finding and correcting this)
- Thanks to banachek, added Spanish language translation
- Thanks to M@verick, added full (as of v2.0) French translation with button
- Updated language support for a number of additional languages (as found strewn throughout the contribution packages), although most need updated translations
- Fixed bug where product_id was not written to database when adding a product on sites where register_globals was turned off
- Fixed bug where syntax error was displayed when adding a product with a quote or quotes in the product name
- Added checkbox for deleting items and changed code so items can have quantities of zero and less than zero. This allows for negative quantity calculations, including negative tax, in case you want to issue a credit
- Changed the way tax on shipping is calculated, again, by adding two optional methods starting at line 292. The first method calculates the rate based on a tax class id of '1' and information stored in the admin configuration and order details. The second method is a hardcoded rate, activated by default and set at 0.00
- Modified stock subtraction function in the add product case so that it will only occur if "Subtract stock" is set to true in admin->configuration->stock
- Replaced instances of "edit_orders.php" in the file code with FILENAME_ORDERS_EDIT
- Updated stock check queries to adjust product stock and products ordered when editing product quantities in order information
- Revised code for updating cc info
- Various other minor modifications too numerous to remember

3/21/2006
v2.1

- Fixed error caused by extraneous character in admin/includes/languages/english/edit_orders.php (thanks to mrossi for first finding and correcting this)
- Thanks to banachek, added Spanish language translation
- Thanks to M@verick, added full (as of v2.0) French translation with button
- Updated language support for a number of additional languages (as found strewn throughout the contribution packages), although most need updated translations
- Fixed bug where product_id was not written to database when adding a product on sites where register_globals was turned off
- Fixed bug where syntax error was displayed when adding a product with a quote or quotes in the product name
- Added checkbox for deleting items and changed code so items can have quantities of zero and less than zero. This allows for negative quantity calculations, including negative tax, in case you want to issue a credit
- Changed the way tax on shipping is calculated, again, by adding two optional methods starting at line 292. The first method calculates the rate based on a tax class id of '1' and information stored in the admin configuration and order details. The second method is a hardcoded rate, activated by default and set at 0.00
- Modified stock subtraction function in the add product case so that it will only occur if "Subtract stock" is set to true in admin->configuration->stock
- Replaced instances of "edit_orders.php" in the file code with FILENAME_ORDERS_EDIT
- Updated stock check queries to adjust product stock and products ordered when editing product quantities in order information
- Revised code for updating cc info
- Various other minor modifications too numerous to remember

Now includes a drop-down for enabled payment methods.
Includes (i believe) a bug fix for duplicate custom additions. In the version i used a custom_ot entry was being created for every order total. I have changed it so that only one blank custom_ot entry is ever created just before the Total.

This package only includes the edit_orders.php file from the root of the admin directory.

Respect and copyright to all previous developers.

Hi Guys,

thanks a lot for this great update...
Some language defines were not or were incorrectly translated for French users.
It's done, now...

- French button added
- Spanish translation added (thx to banachek)
- English fixed define added (thx to mrossi)

FULL PACKAGE...

Hint for developpers, a dropdown menu for payment method will be very appreciated...
;o)

Big thanks to banachek for providing this translation!

File included is spanish/edit_orders.php only.

EXCELLENT, I love Vitamins! Small error on line 64 in english language file, just remove the 1 in the define section, I have attached a fixed english language file, just copy to /admin/languages/english/

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

The zip contains one file, admin/edit_orders.php. The last full package was v1.80.

This is still in the testing phase but it's working pretty well.

Changes include, for taxes, the ability to add taxes to an order where previously there were none. What happens is, when you update the order, the code checks to see if there is a value for $RunningTax and if there is an entry in the order_totals table with a class of "ot_tax". If tax > 0 and ot_tax doesn't exist, it writes a new entry to the order_totals table for tax, thus allowing for taxes to be computed.

The problem with this is that the final total does not initially include the newly computed taxes, so you have to hit "Update" again to get everything to show up correctly.

For globals, nearly every variable has been accounted for. $_GET is accomplished without the patch and there are only five variables (and possibly a sixth, or more, that I can't identify) left to get working with $_POST.

This is a BETA for testing and development only. Please do not use this on a production site- the most recent stable release is v1.80.

Included in the zip is the edit_orders.php file only. I've changed the way the prices are displayed so that prices with tax are properly displayed, but the sub-total is still wrong. I can't figure out where the sub-total is actually being calculated, and as far as tax is concerned it's all wrong. It charges tax on shipping when it's not supposed to if all the items in the order are taxable, totals it up all crazy, doesn't count tax at all if it wasn't counted in the order initially, etc.

Also, I've done more work on the register_globals fix. Currently the only portion of the file that doesn't work on it's own (without the extract hack) is the add product function.

If you come up with anything please post to the forums:
http://forums.oscommerce.com/index.php?showtopic=54032

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

Thats no new version its only a version-mix

It contains the version "Infobroker 12 Sept 2005" + the Adress Block of v1.72

Das ist ein Mix aus der version von "Infobroker 12 Sept 2005" + der Verbesserung des adress Blocks aus v1.72.

Es wird die MWST richtiggerechnet.

Das Problem von 2 MWST sätzen ist nach wie vor vorhanden.

Complete Dutch translation file for v1.75

only the ../dutch/edit_ordes.php

In this version of OE untaxed price of product id equal to taxed price. This file help to fix this bug.

12/30/05
v1.75
IMPORTANT- this file does not include the changes introduced by v1.74. At this time I don't know what exactly was changed for that version. This file is an update of v1.73.

IMPORTANT- this file will give the appearance but NOT the functionality of being able to edit previous comments. Please don't post any messages about not being able to edit comments, this is a known issue.

Using code supplied by nana, aka Frank, updated the way the file maintains records. In the new scheme, an entry is written to the orders_status_history table every time an update is made to the order, thus allowing the store to maintain a record of the changes that have been made (at the very least a record that some sort of change was made). A HUGE thanks to Frank for this code.

This version with no tax on the shipping cost

version 174
this version whit tax on shipping cost

Fix the bugs for incl BTW

v1.73
Fixed the products attributes with price bug. Editing the price associated with an attribute will NOT re-calculate the final price, you have to do that manually.

v1.72
Modified so that Customer, Shipping, and Billing address fields are all displayed and are editable. My versions are built off v1.61b and in that version only Billing and Shipping address fields were shown, except that the info for Billing Address was being taken from Customer Address fields which is WRONG WRONG WRONG.

When done this way, any time you updated an order, the customer address information would overwrite the billing address information. I changed that so it makes sense.

Also I added a line into the language definition file so that you can have "Customer Address" as a table heading as well as just "Address" as a line heading.

Which reminds me, I have not updated any of the included language definition files besides the english version for the changes I have made. Sorry. If you are using any of the other languages on your shop, you will have to update the appropriate language definition files.

This is a small update from the last version. All I did here was edit the code so that suburb, state, and company will only display if those options are set to true in admin->configuration->customer details.

Also, I forgot to mention that I numbered the previous version as 1.70.

New! Improved! Riddled with bugs!

But, progress rolls on.

This is a full package- if you're updating, the only files I modified are the two edit_orders.php files.

For help please visit the forums: http://forums.oscommerce.com/index.php?showtopic=54032

In the contribution “Error: shipping field is displayed in target currency” I get after updating the total amount with double taxes. Is there someone who has the same problems and maybe a solution?
For this contribution I only changed the colours in the standard OSCommerce colours and added the complete Dutch translation.

Little code change that work on my e-shop. Sub-Total and Total Prices are shown with tax. Based on the latest contribuition of infobroker. Please backup!!

Actualizacion en Español para el fichero de edicion de ordenes para OSC. Tiene adicionalmente el boton de Añadir Productos en Espanol. Suerte
Jonatan Valencia Ortiz

Actualizacion en Español para el fichero de edicion de ordenes para OSC. Suerte
Jonatan Valencia

I made small change to accomodate German version fix (prices shown with taxes) Could not verify independently, but it does not break the old version. Let me know if there are issues with it. All known languages are in this build.

Dutch edit_orders.php
5 september 2005 additions/changes.
Uptodate with edit_orders version 1.61b.

A.S. Kerkmeester, www.flashbios.org

The Norwegian language file for Order editor

I hopefully fixed the multi-currency support issue that was reported by several people. I could only test it for CDN and USD.
Taxes on shipping are quite complicated, so for simplicity I aligned them with product tax that is not necessarily correct (especially if there are different tax breaks for different products) However, it is better than before and proper fix is too complicated (need to move huge chunks of code from catalog due to improper design) I tested this with CCGV and Manual Order contributions (which I also modified to add ability to choose currency of the order) Let me know if there are problems with the latest changes - my testing was very limited.

This is the Italian Language file (complete) working with 1.6a version. Simply installation, only change the file "edit_orders.php" with this one. Bye Bye

Sorry, guys, I did not realize that the post is HTML formatted. The original message should be like this:
If your attribute has a single quote in the name, e.g. 6' special cable, the attribute fields (name/value) will be shown incorrectly. To fix, simply replace (no <pre> tags!!!):
$order->products[$i]['attributes'][$j]['option']
with this:
<pre>
tep_parse_input_field_data($order->products[$i]['attributes'][$j]['option'], array("'"=>"""))
</pre>
and this:
$order->products[$i]['attributes'][$j]['value']
with this:
<pre>
tep_parse_input_field_data($order->products[$i]['attributes'][$j]['value'], array("'"=>"""))
</pre>

in HTML output (around lines 959-961) My previous message has translated Double quote into HTML format. Don't!!! Use the code <pre>"</pre> instead.

Theoretically speaking, all HTML output (both - product and attribute names) should be escaped to protect from special HTML characters, but this seems to be rare situation in the stores and left as an exercise.

ZIP FILE IS EMPTY.

If your attribute has a single quote in the name, e.g. 6' special cable, the attribute fields (name/value) will be shown incorrectly. To fix, simply replace:
$order->products[$i]['attributes'][$j]['option']
with this:
tep_parse_input_field_data($order->products[$i]['attributes'][$j]['option'], array("'"=>"""))
and this:
$order->products[$i]['attributes'][$j]['value']
with this;
tep_parse_input_field_data($order->products[$i]['attributes'][$j]['value'], array("'"=>"""))

in HTML output (around lines 959-961)

Theoretically speaking, all HTML output (both - product and attribute names) should be escaped to protect from special HTML characters, but this seems to be rare situation in the stores and left as an exercise.

ZIP FILE IS EMPTY.

not a complete package. zip empty.
follow ths instructions to solve problem with taxes:

find the first $RunningSubTotal +=
and replace the complete line with:
$RunningSubTotal += $products_details["qty"] *

$products_details["final_price"] * (DISPLAY_PRICE_WITH_TAX ==

'true'?(1+($products_details["tax"]/100)):1);

find the second $RunningSubTotal +=
and replace the complete line with:
$RunningSubTotal += ($order->products[$i]['qty'] *

$order->products[$i]['final_price'] * (DISPLAY_PRICE_WITH_TAX == 'true'?

(1+($order->products[$i]['tax']/100)) : 1) );

Ability to edit CVV2 numbers.
Fixes the update query for V1.6.0.3 (no documentation to insert new company fields into the database).

Simple .htm file for ease of use. Text file included, also.

If you like version 1.59a, and want the "update" button to work without giving you a "tep stop" error regarding the comments field, remove the following code (line 127-130) from edit_orders.php.

Remove this:

if(!$CommentsWithStatus)
{
$UpdateOrders .= ", comments = '" . tep_db_input($comments) . "'";
}

Thanks all,

TADD

Hi,

Here is the french file for *order Editor

Full Package

A danish translation.

All files in the ZIP-file.



Lang.: Danish, English, German, Dutch

Order Editor with german language file ! Full package !

only use 1.56 if you have register_globals is turned off

Full Version with register_globals fix

When "register_globals" is turned off on the server (pretty standard these days), adding products to the order doesn't work. This is a quick workarround.

Someone else please update the package, either making it not dependant on register_globals, or incorporate my fix.

Ik heb de "edit_order.php" Language file vertaald naar het nederlands.

Origineel was van Riccardo Roscilli (posting van 8 feb) LET OP: Ik heb alleen maar de file voor in de Dutch Language folder vertaald.

Deze versie werkt nu goed bij mij, geen last meer van de BTW bug.

Mvg, Cor

This button corresponds with the style of the buttons inn “Norwegian admin buttons” : http://www.oscommerce.com/community/contributions,1368/category,all/search,norwegian

David L Lilleaas

I tried to analyse the 'tax calculation problems' reported before. I found some ... hmm ... bugs (relating to OUR shop). I marked all changes, so every should feel free to think about my solutions und thoughts.
++++++++++++
Read my info.txt for more information. All important changes can be found after my Name ('Michel Haase'). Good luck.

Fist of all, thank you to all the guys partecipating in this contrib.
I corrected some bugs in this contribution:
- fixed values with tax
- added support for products specials when adding product to the order
- Italian language file updated

http://www.oscommerce.it

I´ve updated ONLY the langue file for sweden

Found a tax fault when you add a product.

It calculates the tax included as a product post.

Wich give a wrong total sum.
OBS!!! Dont install until this fix is done..

I´ve updated the langue file

Found a tax fault when you add a product.

It calculates the tax included as a product post.

Wich give a wrong total sum.

Added norwegian language to the Order Editor.

Seems not to be my day... the last ZIP file was damaged, so here's a new one...

Just forgot to include the english language file in 1.6 below ;-) Sorry! This package should be complete now...

This is a large update for using the order editor in western europe countries (tested in switzerland
and germany) but it should work everywhere else. I updated and reworked almost everything, so it 's impossible to comment all the changes ;-). Mainly there are some bugfixes (e.g. corrected
tax calculation for this listing type, some currency issues), some new features (different taxes for discount modules, extentable) and a new (nice ;-) layout.

Just try it out, it's not an "official" update and probably too specific for my needs, but I think it brings a lot of useful stuff...

Traduction française a copier dans

admin/includes/languages/french

This file ONLY contains a personalised version of the edit_orders.php.

Same as 1.59, but with comments and status code removed to reduce probabilities of errors and duplication of code. Also included a slight mod to the update of the credit card fields, the update subtotal field (for Australian tax) and the back button (thanks Didier). I made the changes to the comments and status fields because I find the orders.php a better page to update the order comments and status as I have other contributions linked to these fields from that page.

If you wish to try this contrib out, simply copy your own catalogadminedit_orders.php to a safe location and use the one in this package in its place. If you don't like it, just copy your own back again.

Caveat Emptor:
I know very little PHP and SQL code (I just hacked the original) so use this at your own peril.

Traduzione in italiano dell'editor.
http://www.oscommerce.it/

Fixed selection problems.

Full German translation for the edit order package.

Vollständige deutsche Übersetzung für das "edit order package"

Full Norwegian translation for the edit order package

Full swedish translation for the edit order package

Este fichero sirve para incluir el idioma español

Changelog :

- multi-language support for product options and product description
- correction of currency display during display of tax, subtotal and total (currency is displayed AFTER the amount)
- bigger display fields of payment method, product name and options values
- the option value prefix if now displayed

Minor Change:
- Updated Order Edit page to show full Credit Card Number

Minor Change
- Edit doesn't keep opening multiple windows
- Edit now stays in same window and back button works

/admin/includes/language/german

Hello, I just translated the edit_orders.php into traditional chinese version, and pls upload to

/admin/includes/language/tchinese/

An excellent mod.

Our store does not use subtotals on our orders meaning that when an order was updated its value was set to zero as there had been no subtotal added in.

Added a check to see if the ot_subtotal class existed, and if not, the value found in $RunningSubTotal is added to the value already set by the other totals in $ot_value. This fix fixed the ot_total for us, and I have attempted to add it so that it does not break anything for other who do actually use subtotals.

Changes:
- Friendlier User Interface when modifying customer information
- Add the buttons DETAILS and EDIT to order.php
- Made the files completely multilingual
- When you add products you dont have to confirm every change, this prevents selecting wrong products when forgetting to submit first.
- Added dutch language version

For anyone using the Purchase Order Contribution, these small modifications will allow you to edit the three new fields you added to the database directly from the Order Editor in Admin. Previously you had to go to the database and make these changes. This download is just a text install file with instructions on how to set it up.

This contrib was all over the place, and the suburb error was not updated in 1.5 which has now been fixed.

-Updated in 1.55 edit_order.php - there was a few spelling mistakes for suburb, so when the order was updated this field data would dissappear. *FIXED
-Updated in 1.55 language files to corespond with correct countries. - Support English/German and Spanish.


FORUM FOR THIS CONTRIBUTION:
http://forums.oscommerce.com/index.php?showtopic=54032&st=0

Just a little modification on the design.

Original code by Jonathan Hilgeman. So any credit goes to him.

I've edited this great contrib for having the quantity in the inventory always up-to-date!!!

The original mod don't subtract item (or add them) to the inventory table, resulting in a big mess for the peeps that use the inventory as a base for the re-stock of products. So i come out with this modifications. It's little but very usefoul.

If u don't wanna type i've included a ready-to-try files, to copy in catalog/admin/

I've used as a base the version 1.4.

That should do the trick. For me this worked very well. let me know if there is any problem. i'll try to help.

I've a request: how to change the selection menu when u add a new product and let it be like the "move product" menu?

P.S. If u like the mod let me know.
If u find any bug let me know.

alex@drako.it
http://www.drako.it

Jonathan Hilgeman's original contribution, but added spanigh and german languages for admin functions only. Emails are still sent in english, but admin functions are in respective languages. No other changes to script whatsoever.

The other person must have some modifications because the sql statement in the previous file for add product didn't work. Fixed the SQL statement and now runs fine.
This contribution was just what I was looking for! Great job guys.
--Kristy

This download includes all files. I made a small modification to one of the SQL select statments that was used in the "Add Product" part of this Contribution. I am running MS2.2 although I believe this was a syntax error everyone would get. It produced an error message when trying open the "Add Product" section of the page, so this feature was not available.

All is fixed now and it works perfectly.

Updated install instruction to keep the TABLE_HEADING... scheme.

All files are included.

I updated the install instructions to set it up so that there was a link on the orders page to go to the edit order page.

##############
# 07-11-2003
##############
# Edit orders 1.2b1 - cosmetic features
#
# Nuno Chaveiro
# Portugal
#
# chaveiro@catus.net
##############
#
# This is a modification to edit orders 1.2b that displays the form with a better look like the rest of admin.
# Only file changed was edit_orders.php
# Tested in osCommerce 2.2MS2
#
# Please develop further code on this design !
#
#############

This package includes all files you need. The only thing I#ve changed is the calculation for order_total.

The reason for the chnges were that I'm using a shop with prices incl. tax and when changing an order the calculation of the order_total part was made without tax.

Now you can use this fantastic tool also with shops only working with prices inkl. tax.

Have fun

Version 1.2a

- Fixed a query problem on osC 2.1 stores.

Version 1.2

- Updated instructions and added some more recommendations.

- Corrected the bug in which the "Billing Address" fields would update the "Customer" fields.

- Added separate "Billing Address" fields, along with compatibility for osC 2.1 (which didn't have separate billing address info)

- Added "Company" and "Suburb" fields to each address section to make them "complete."

- Added ability to add auto-calculated "Tax" entry to the order total.

- Added option for taxing shipping via a variable near the top of the script.

- First (and hopefully last) fix for currency formatting. It used to only calculate using U.S. dollars (how ethno-centric of me...).

- Some additional, but minor bug fixes and corrections.

Version 1.1:

- Added status editing (fixed order status bug from 1.0).

- Added comments editing. (with compatibility for osC 2.1)

- Added customer notifications.

- Added some additional information to the instructions file.

- Fixed bug with product names containing single quotes.

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!