Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

NEW! Complete Order Editing Tool!


jhilgeman

Recommended Posts

I've replaced the edit_orders.php with the version out of the "order_editor_5_0_9b-Pack" running very well!!!

 

THX so far...

and running into a new problem while try to send the order e-mail:

 

1146 - Table 'DB670984.eorder_text' doesn't exist

SELECT * FROM eorder_text where eorder_text_id = '2' and language_id = '2'

[TEP STOP]

 

SORRY for that but looked into the sql files and can't find the "eorder_text_id"

Link to comment
Share on other sites

I've replaced the edit_orders.php with the version out of the "order_editor_5_0_9b-Pack" running very well!!!

 

THX so far...

and running into a new problem while try to send the order e-mail:

 

1146 - Table 'DB670984.eorder_text' doesn't exist

SELECT * FROM eorder_text where eorder_text_id = '2' and language_id = '2'

[TEP STOP]

 

SORRY for that but looked into the sql files and can't find the "eorder_text_id"

you need to install Send html email 2.1. but I'm thinking there are still an issue to two with this based on some comments here.

Link to comment
Share on other sites

Is there any way to show all shipping modules no matter if its active or not in order editor?

 

If not, then is there a way to manually specify 1 specific shipping module (i.e. flat.php) to use with order editor?

 

Thanks in advance,

 

-John

Edited by tarroz
Link to comment
Share on other sites

Is there any way to show all shipping modules no matter if its active or not in order editor?

 

If not, then is there a way to manually specify 1 specific shipping module (i.e. flat.php) to use with order editor?

 

Thanks in advance,

 

-John

 

not currently.

Link to comment
Share on other sites

1. I have the options mod installed which allows for check boxes, radio buttons, file upload and text boxes as product options when customers order. How can I get the edit_orders_add_product.php, the page used to add products to display correctly? When I bring up a product, it is nothing but drop down fields.

 

2. When I click "add product", the window is not big enough and thier are no scroll bars. Where can I fix this?

 

Thanks!

Link to comment
Share on other sites

Great addon and working well, 2 things:

 

1. I have the PDF invoice/packing slip installed and working. When I hit "new order email" it sends the PDF invoice to the customer, attached and says "PDF Attached". Where can I change what is in the body of the email?

 

2. In my admin when I click on orders I have the option for PDF invoice or packing slip. The PDF invoice when it comes up is blank. Very strange as it emails fine. Any thoughts? Also, the packing slip works fine, all the data is there.

Link to comment
Share on other sites

Hello All,

 

I have a few issues:

 

1. Under edit orders, using AJAX, when I send new comments and/or status, everything works but the link to view the order and the order number listed in the email is always zero. (0) - any ideas?

 

2. I have the PDF invoice/packing slip installed and working. When I hit "new order email" it sends the PDF invoice to the customer, attached and says "PDF Attached". Where can I change what is in the body of the email?

 

3. In my admin when I click on orders I have the option for PDF invoice or packing slip. The PDF invoice when it comes up is blank. Very strange as it emails fine. Any thoughts? Also, the packing slip works fine, all the data is there.

 

Any help would be great!, Thanks in advanced.

Link to comment
Share on other sites

hi you all

 

is there anyone out there who knows how to get rid of the zones in Edit_orders and Edit_orders_ajax

 

i mean when i go the edit the order its suddenly show the zones and we have only All zones so this is not nessesary in fact its anoying.

 

see picture

zones.jpg

Edited by wvdbroek
Link to comment
Share on other sites

Setup: Order_editor latest with manual order contribution that only works when order_editor is installed.

 

Going fine scenario's:

--> frontend order --> details + edit: sort order of total is as we have it in modules --> order totals: module sort orders

1: subtotal

2: loworderfee

3: total

4: tax

*tax=4 last which is OK / the way we want it really.

 

I can add products after which the order editor updates fine.

 

But now:

--> use the manual order mod --> select a client --> continue --> Order totals all show 0,00 and in the right sort order.

--> then I add a product --> order_editor updates BUT now changes the sort order somehow ( checked also in dbase and indeed, sort order values are changed in orders_total

NOW TAX is first instead of last....

after all are ok.

 

Don't think it is the manual order mod but something in the order_editor when order totals are 0 ?

 

Thanks!

 

Kookie

Link to comment
Share on other sites

Hi,

Can you please help me with this?

 

I installed contri 1435 OrderEditor version 5.0.9,

on a OsC rc2a with Super Download shop, iDeal, Paypal IPN.

My dialog for edit orders

1. Misses the 'submit' buttons

2. shows the next text 3 times:

 

Warning: number_format() expects parameter 1 to be double, string given in C:\Server\www\myserver.dev\public_html\winkel\admin\edit_orders.php on line 1737

 

 

This is the piece of code around line 1737 in edit_order.php

if (ORDER_EDITOR_USE_AJAX == 'true') { echo
'   <td align="right" class="dataTableContent">' . "\n" .
'     <input name="update_totals['.$i.'][title]" id="'.$id.'[title]" value="'
        . trim($order->totals[$i]['title'])
        . '" onChange="obtainTotals()"></td>' . "\n" .
'   <td align="right" class="dataTableContent">' . "\n" .
'     <input name="update_totals['.$i.'][value]" id="'.$id.'[value]" value="'
        . number_format($order->totals[$i]['value'], 2, '.', '')
        . '" size="6" onChange="obtainTotals()"></td>' . "\n" .
'   <td align="right" class="dataTableContent">' . "\n" .
'     <input name="update_totals['.$i.'][class]" type="hidden" value="'
        . $order->totals[$i]['class'] . '"></td>' . "\n" .
'   <td align="right" class="dataTableContent">' . "\n" .
'    <input name="update_totals['.$i.'][id]" type="hidden" value="'
        . $shipping_module_id . '" id="' . $id . '[id]"></td>' . "\n";
} else { echo
'   <td align="right" class="dataTableContent">' . "\n" .
'     <input name="update_totals['.$i.'][title]" id="'.$id.'[title]" value="'
        . trim($order->totals[$i]['title']) . '"></td>' . "\n" .
'   <td align="right" class="dataTableContent">' . "\n" .
'     <input name="update_totals['.$i.'][value]" id="'.$id.'[value]" value="'
        . number_format($order->totals[$i]['value'], 2, '.', '')
        . '" size="6">' . "\n" .
'     <input name="update_totals['.$i.'][class]" type="hidden" value="'
        . $order->totals[$i]['class'] . '">' . "\n" .
'     <input name="update_totals['.$i.'][id]" type="hidden" value="'
        . $shipping_module_id . '" id="' . $id . '[id]"></td>' . "\n";
}

AFAIK the warning means that number_format($order->totals[$i]['value'], 2, '.', '') in the if statement before else is wrong, because $order->totals[$i]['value'] seems to be a string, while a 'double numeric' is required.

 

What can I do to avoid the warnings?

These warnings completely destroy the lay out.

 

This is my development configuration:

MySQL

* Server: MySQL host info: 127.0.0.1 via TCP/IP
* Serverversie: 5.1.41-community
* Protocolversie: 10
* Gebruiker: XXXXXXXXX@localhost
* MySQL Karakterset: UTF-8 Unicode (utf8)

Web server

* Apache/2.2.14 (Win32) PHP/5.3.1
* MySQL-client versie: mysqlnd 5.0.5-dev - 081106 - $Revision: 289630 $
* PHP uitbreiding: mysql

 

Thanks in advance for your help!

Eveline

Hi Eveline,

I have to admit that I have virtually no knowledge of programming, but if it is of help you can edit the admin\includes\application_top.php and change the level of error reporting thus:

 

error_reporting(E_NONE);

 

It's near the top of the file I think.

 

This surpresses the error, but doesn't cure the problem. I have the same problem with my site, so if you fin dout what the cause is, please let me know.

 

Good luck,

Carl

Link to comment
Share on other sites

Need help.

 

This was wonderfull working until now. When I click "Send an order confirmation Button" gets this error:

 

Fatal error: Cannot redeclare do_magic_quotes_gpc() (previously declared in /homepages/6/d308676125/htdocs/admin/includes/functions/compatibility.php:18) in /homepages/6/d308676125/htdocs/admin/includes/functions/compatibility.php on line 30

 

I dont know what is the problem because there was working perfect until I instaled SPPC or Header Tags.

 

Contribution instaled order:

ORDER EDITOR 5.0.9 > Administration access level acounts > SPPC > HIDE PRODUCTS FOR SPPC > SPECIALS FOR SPPC > SUPPLIER ADMIN AREA > ULTIMATE SEO URLS5 > HEADER TAGS SEO

 

Any suggestion?

Link to comment
Share on other sites

The button is this:

<div class="update4" align="center"><?php echo ENTRY_SEND_NEW_ORDER_CONFIRMATION; ?> <?php echo tep_draw_checkbox_field('nC1', '', false); ?></div>
             <div class="update5" align="center"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?></div>

 

The function that dosn´t work is this:

	// CHECK FOR NEW EMAIL CONFIRMATION

   if ( (isset($_POST['nC1'])) || (isset($_POST['nC2'])) || (isset($_POST['nC3'])) ) {
//then the user selected the option of sending a new email

   tep_redirect(tep_href_link(FILENAME_ORDERS_EDIT, tep_get_all_get_params(array('action')) . 'action=email')); 
//redirect to the email case

 } else  { 
    //email? email?  We don't need no stinkin email!

 if ($order_updated)	{
		$messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
	}

	tep_redirect(tep_href_link(FILENAME_ORDERS_EDIT, tep_get_all_get_params(array('action')) . 'action=edit'));

	}

break;

// 3. NEW ORDER EMAIL ###############################################################################################
case 'email':

	$oID = tep_db_prepare_input($_GET['oID']);
	$order = new manualOrder($oID);


,,,,

,,,,

Link to comment
Share on other sites

Hi,

 

First of all I like to thanks to all developers created this great contribution. Without it the work with creating order or modifying it can be a pain.

 

Idea for a enhancement:

By default the contribution has the possibility to define which total modules are added by default for a new manual created order. But, in 90% some total modules e.g. discount wont be used for a "normal" order.

 

By default I'm using the totals as follows in the total section:

 

Subtotal

Shipping

including Tag %

Total Net withou Tax

Rounding difference

Total

 

But some time I need to add a new line in the total for "discount". I'm doing this by click on the "+", type "Discount 5%" in the title and the related value. Everything goes well and the order will be calculated and stored correctly.

But, take a look into the orders_total table for the created order. The new discount line becomes a class = ot_custom_xy and a sort_order=xy. In my point of view this is wrong. Why? The discount module has a defined title, class=ot_customer_discount and a sort_order=3. To make sure all the calculation in the reports or stats will get the correct values, you have to modify the class and for the correct printing in "invoice" you have to modify the sort_order. Else the discount will be placed above the Subtotal.

 

My idea:

Is it possible to enhance the total section in a way to select the available total modules from within a dropdown? With this all the related values for class, sort_order, title will get the defined values automatically. The dropdown must also have the possibility to type in a free text. The code logic has to handle it as: if the text can't be found from the list of available modules the title will be set as type in, the class can be set to ot_custom_xy and the sort_order can be set to xy.

 

This is what I like to enhance in the order editing tool and I like to ask you about idea how to implement it.

 

I'm looking forward to read some lines about.

 

regards

 

peter

Link to comment
Share on other sites

  • 3 weeks later...

Problem with state selection:

 

That problem goes that way:

 

Let's say u don't use a dropdown selection for state when customers create an account or u added this future after accounts where already created.

 

When u modify an order first on state field take the customer state . But if this state it isn't on the list when u update your order it takes the first state on the list not the state the customer put .

 

That is because

 

$update_customer_state = tep_get_zone_name($_POST['update_customer_country_id'], $_POST['update_customer_zone_id'], $_POST['update_customer_state']);

 

 

<tr class="dataTableRow">

<td class="dataTableContent" valign="middle" align="right" nowrap><?php echo ENTRY_CITY_STATE; ?></td>

<td colspan="2" valign="top" class="dataTableContent" nowrap><input name="update_customer_city" size="15" value="<?php echo stripslashes($order->customer['city']); ?>" <?php if (ORDER_EDITOR_USE_AJAX == 'true') { ?>onChange="updateOrdersField('customers_city', encodeURIComponent(this.value))"<?php } ?>>,</td>

<td valign="top" class="dataTableContent"><span id="customerStateMenu">

<?php if (ORDER_EDITOR_USE_AJAX == 'true') {

echo tep_draw_pull_down_menu('update_customer_zone_id', tep_get_country_zones($order->customer['country_id']), $order->customer['zone_id'], 'style="width: 200px;" onChange="updateOrdersField(\'customers_state\', this.options[this.selectedIndex].text);"');

} else {

echo tep_draw_pull_down_menu('update_customer_zone_id', tep_get_country_zones($order->customer['country_id']), $order->customer['zone_id'], 'style="width: 200px;"');

}?></span><span id="customerStateInput"><input name="update_customer_state" size="15" value="<?php echo stripslashes($order->customer['state']); ?>" <?php if (ORDER_EDITOR_USE_AJAX == 'true') { ?>onChange="updateOrdersField('customers_state', encodeURIComponent(this.value))"<?php } ?>></span></td>

</tr>

 

There will always get the first state and when post will verify if state equal 1 and it is always true .

 

U need to make something like this:

 

$array_zones = tep_get_country_zones($order->customer['country_id']) ;

 

but in the select must be a default value: Something like Select a state : ... with id = - 1 .... so when u use post

 

$update_customer_state = tep_get_zone_name($_POST['update_customer_country_id'], $_POST['update_customer_zone_id'], $_POST['update_customer_state']);

 

If the customer state wasn't in the list of state the default value from the customer will be selected

 

 

Hope someone will implement this so everybody will understand.

 

A good day.

 

 

My solution:

 

<tr class="dataTableRow">

<td class="dataTableContent" valign="middle" align="right" nowrap><?php echo ENTRY_CITY_STATE; ?></td>

<td colspan="2" valign="top" class="dataTableContent" nowrap><input name="update_customer_city" size="15" value="<?php echo stripslashes($order->customer['city']); ?>" <?php if (ORDER_EDITOR_USE_AJAX == 'true') { ?>onChange="updateOrdersField('customers_city', encodeURIComponent(this.value))"<?php } ?>>,</td>

<td valign="top" class="dataTableContent"><span id="customerStateMenu">

<?php if (ORDER_EDITOR_USE_AJAX == 'true') {

$zones_array = array();

$zones_query = tep_db_query("select zone_id, zone_name from " . TABLE_ZONES . " where zone_country_id = ". (int) $order->customer['country_id']. " order by zone_id");

$zones_array[0] = array('id' => '-1', 'text' => 'Select state');

 

while ($zones_values = tep_db_fetch_array($zones_query)) {

$zones_array[] = array('id' => $zones_values['zone_id'], 'text' => $zones_values['zone_name']);

}

 

echo tep_draw_pull_down_menu('update_customer_zone_id', $zones_array, $order->customer['zone_id'], 'style="width: 200px;" onChange="updateOrdersField(\'customers_state\', this.options[this.selectedIndex].text);"');

} else {

$zones_array = array();

$zones_query = tep_db_query("select zone_id, zone_name from " . TABLE_ZONES . " where zone_country_id = ". (int) $order->customer['country_id']. " order by zone_id");

$zones_array[0] = array('id' => '-1', 'text' => 'Select state');

 

while ($zones_values = tep_db_fetch_array($zones_query)) {

$zones_array[] = array('id' => $zones_values['zone_id'], 'text' => $zones_values['zone_name']);

}

echo tep_draw_pull_down_menu('update_customer_zone_id', $zones_array, $order->customer['zone_id'], 'style="width: 200px;"');

}?></span><span id="customerStateInput"><input name="update_customer_state" size="15" value="<?php echo stripslashes($order->customer['state']); ?>" <?php if (ORDER_EDITOR_USE_AJAX == 'true') { ?>onChange="updateOrdersField('customers_state', encodeURIComponent(this.value))"<?php } ?>></span></td>

</tr>

Edited by zipicip
Link to comment
Share on other sites

Ok installed this. all works but one issue.

When i cleck on new order email i get the dialog to ask if i want to send the email. i say yes and i get the error below.

My update is however all saved. Everything is ok except this error

Any help please?

 

 

1146 - Table 'store1.eorder_text' doesn't exist

 

SELECT * FROM eorder_text where eorder_text_id = '1' and language_id = '1'

Link to comment
Share on other sites

I use version 5.09b and have a problem with shipping quotes, I have 4 flat rates shipping options, displaying is fine only that they appear without selected option. But when I like to change shipping option nothing happens, when I hit update.Shipping option in field above total stay the same and the value too. I tried both with ajax or without I have the same error too with warning: number_format() expects parameter 1 to be double

Link to comment
Share on other sites

I have installed ORDER EDITOR 5.05

and I am getting this error when I enter to EDIT any order and press in NEW ORDER EMAIL.

 

Fatal error: Call to undefined function tep_add_base_ref() in /home/xxxx/public_html/compras/admin/edit_orders_ajax.php on line 1144

 

I have downloaded and updated the module to order_editor_5_0_9

but I still get the error.

 

I have searched all .php files in my oscommerce and the funcion tep_add_base_ref

doesn´t exist IN ANY OF ALL THE FILES.

 

What can I do?

Thanks!

Francisco

Link to comment
Share on other sites

I have installed ORDER EDITOR 5.05

and I am getting this error when I enter to EDIT any order and press in NEW ORDER EMAIL.

 

Fatal error: Call to undefined function tep_add_base_ref() in /home/xxxx/public_html/compras/admin/edit_orders_ajax.php on line 1144

 

I have downloaded and updated the module to order_editor_5_0_9

but I still get the error.

 

I have searched all .php files in my oscommerce and the funcion tep_add_base_ref

doesn´t exist IN ANY OF ALL THE FILES.

 

What can I do?

Thanks!

Francisco

Link to comment
Share on other sites

  • 2 weeks later...

Installed latest version and have this problem:

 

1146 - Table 'test_oscommerce.eorder_text' doesn't exist

 

SELECT * FROM eorder_text where eorder_text_id = '1' and language_id = '1'

 

I've seen the comments about adding "Send HTML Email V2" - Is this the add-on that's needed?

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

 

If so, there's more to the solution than installing "Send HTML Email V2" because this add-on doesn't create the eorder_text table.

 

Which Add-On creates the eorder_text table and inserts the required data?

 

I've even seen some comments here with the sql to create the eorder_text table, but if I simply add that table, I still don't know what data to insert.

 

So, I will ask the questions that many here seem to want answered, again:

 

1. Do we need to install "Send HTML Email V2" and if so, is this the Add-On that's needed?

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

 

2. Which Add-On creates the eorder_text table and populates it?

 

3. If the eorder_text table is not created by an add-on, then what data do we need to put in it?

Edited by hostricity
Link to comment
Share on other sites

you can avoid all of that and use the last one I uploaded, which works without all this garbage. Several folks since my upload have dumped their versions (with problems) and ran without supporting them.

Link to comment
Share on other sites

  • 2 weeks later...

you can avoid all of that and use the last one I uploaded, which works without all this garbage. Several folks since my upload have dumped their versions (with problems) and ran without supporting them.

 

Surfalot - I installed your version of Order Editor and it works great. I tried to install the version 5.0.8 upgrade (not created by you) so the Order Editor would work with the HTML Email contribution and it did not work. Is there an easy way to get these two contributions Order Editor 5.0.7 and HTML Email to work together.

 

Thanks,

Link to comment
Share on other sites

surfalot:

I got that problem to, and also I have your version 5.09b (28 feb 2010) :

 

1146 - Table 'test_oscommerce.eorder_text' doesn't exist

SELECT * FROM eorder_text where eorder_text_id = '2' and language_id = '4'

 

that message only shows when i choose "new order confirmation" and then "update" without ajax

(if i onlu push on "update" without "neworderconfirm" checked, it works fine)

 

With ajax "allow the use of ajax to update order information" set to true i get this message:

(i have qtpro 4.51a+ alots a bugfixs installed)

(i have "send admin html e-mails 1.5")

 

Message: Odefinierat fel

Rad: 305

Tecken: 3

Kod: 0

URI: http://www.xxxxx.se/admin/edit_orders.php?oID=39&osCAdminID=54720248574e1be4b1005968b06746dc

 

and

 

Message: Unknown runtime error

Rad: 201

Tecken: 3

Kod: 0

URI: http://www.xxxxx.se/admin/edit_orders.php?oID=39&osCAdminID=54720248574e1be4b1005968b06746dc

 

Do you have any ideas how i can solve this problems?

Link to comment
Share on other sites

in edit_orders.php, the line 305 is:

 

from products_options po, products_options_values pov, products_options_values_to_products_options po2pov, orders_products_attributes opa, orders_products op

 

and line 201 is:

 

//Send text email

Link to comment
Share on other sites

Great contribution! I just installed this Add-on, it's great, and is the easiest install! All add-ons should be this easy to install!

 

I installed this Add-on because I wanted to be able to change a product's price to a negative value. But, simply changing the price to a negative value doesn't have the desired outcome.

 

Example: I have an order in OSC. This order has Product1 and Product2 in it. Product1 is normally $20, and Product2 is $29.99. I go into Order Editor and change Product1's cost to negative $40. The total SHOULD be negative $10.01. But the total is $69.98.

 

Also, if the calculation for the total uses absolute values, the total should be $69.99, why is it $69.98?

 

 

Help please, thanks!

 

 

Chap

Edited by chap

Eagerly awaiting 2.2

Link to comment
Share on other sites

Hi, sorry if this has been covered but i get so many results when searching but not finding what I need.

 

We have the order editing setup on the site. However, a customer can have a pending order in with a request for quote, we can edit it to include the appropriate shipping amount, but then there is no way for them to get back on to "complete" this order or check out. Is there a way that people can get back in to pay for their pending order after it has been edited?

 

John

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...