3252 replies to this topic

[fmosse]

Hi!

I have installed Order Editor 5.0.9c and I have the following problem.
When I enter to the EDIT ORDER page, if the billin or shipping country address is the "default country address" of the shopping cart, it shows ok. But if the user has choosed other country, I always see "AFHGANISTAN"... Whan can I do?
Thanks!!!
Francisco

[TrentFahey]

scandic_outlet, on 21 January 2011, 13:53, said:

hi
about:
What I don't understand is the purpose of being able to add items to somebody's already completed order if (in the process) you are not sending it back to the shopping cart for more payment? Are we just adding these items to their order for free or am I missing something here?
---
if your customer purchases 1 xlarge t-shirt in color blue - but wen you process the order, you learn the item has sold out (stock was counted wrong or something)
Its a nice feature to be able to change the t-shirt to e.g. red color, if the customer agrees to take a different product.

Any progress on getting this to work with 2.3.1?

I appreciate that there is a need for modifying orders, for one reason or another, let's be honest we don't live in a perfect world. However it does raise business concerns about potential theft and lack of audit trail, ie adjustment invoice number, credit notes, or a simple revised by?? On date etc.

In the situation which the modified order does change price due to out of stock, different attribute cost etc, how do you process the payment by the existing payment gateway or method.

If a customer wants to add another product to the order then a better approach would be to create a new order. You want the sale now so why risk telling the customer to go back online and place order with the risk of then not following through with the order. We all want to make it as easy as possible for the customer.
Another situation where payment processing is required in the admin is for phone orders. It makes sense to have the ability, while customer is on the phone, to in admin create an order (manual order editor), then edit the order (order editor) , then process the payment (??)

Is there a contrib that uses the catalog payment modules in the admin section to process payments?

Currently we have created a dummy customer account (in catalog) select the products and process the order and payment with the customer payment details, then in admin we create a manual order then edit to match the actual order. Then we go into the dummy account order and edit it so that it has 0 products and cost so that stock levels and totals balance. Very long and not ideal.

Any suggestions or contribs I have missed.

Thank you

Ps. Keep up the good work oscommerce community.

[Teamjr]

Hello,

I just installed OE 5.0.9c on RC2a. When I go to edit an order, I get a blank page. I noticed a few pages back about an issue with USPS module, so I disabled it and I still get a blank page on edit? Any ideas where to diagnose? I am not really going to edit orders, but want to install manual order contribution and it says I need this one installed first.

Thanks JR

[Teamjr]

Hello,

Sorry, error fixed. Missing line in general.php.

Thank you

[gaspower]

Hello,

I am having an issue with OE 5.0.9 and SPPC. When adding an item for a customer group, OE does not seem to add the group price, but only retail price. Is there any patches for this issue? The current code I have in edit_orders_add_product.php is,

//sppc patch
	        //Set to false by default, configurable in the Order Editor section of the admin panel
	        //thanks to whistlerxj for the original version of this patch
    
	        if (ORDER_EDITOR_USE_SPPC == 'true') {
	
	        // first find out the customer associated with this order ID..
            $c_id_result = tep_db_query('SELECT customers_id 
	        FROM orders 
	        WHERE orders_id="' . (int)$oID . '"');
	
            $cid = tep_db_fetch_array($c_id_result);
            if ($cid){
            $cust_id = $cid['customers_id'];
            // now find the customer's group.
            $c_g_id_result = tep_db_query('SELECT customers_group_id 
	        FROM customers 
        	WHERE customers_id="' . $cust_id . '"');
	
            $c_g_id = tep_db_fetch_array($c_g_id_result);
            if ($c_g_id){
            $cust_group_id = $c_g_id['customers_group_id'];
            // get the price of the product from the products_groups table.
            $price_result = tep_db_query('SELECT customers_group_price 
	        FROM products_groups 
         	WHERE products_id="' . $add_product_products_id . '" 
        	AND customers_group_id="' . $cust_group_id . '"');
	
            $price_array = tep_db_fetch_array($price_result);
            if ($price_array){
            // set the price of the new product to the group specific price.
            $product['products_price'] = $price_array['customers_group_price'];
               }
              }
             }
         	}
	        //end sppc patch

Thank you Dom

[popsel]

Hi!

I am setting up an OSC2.2 shop with Order Editor V5.09b in Germany.
On German keyboard we have a comma on num block.
To enter prices the value has to be input with point as a separator.
So I changed this everywhere in my shop using str_replace(",",".",$string)
so it doesn`t matter if I enter a "." or a ",".

I would like to change this also for Order Editor.
Unfortunalety this is quite complicated for me and I can`t find the place to
add some code for this task.

May anybody help me to implement this function to Editor V5.09b ?


Regards

Pospel

[popsel]

Hi!

This treat is getting too long!
So I started a new one for my question.

Regards

Pospel
[/quote]

[Swingy]

Adding this in 2.3.1 with this version 1.1 ( http://addons.oscommerce.com/info/7844/v,23 )

I also have the warning about the headers. (Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site7/fst/var/www/html/shop/admin/includes/template_top.php:14) in /home/virtual/site7/fst/var/www/html/shop/admin/includes/functions/general.php on line 34)

I looked in template_top for blank spaces on wrong places, altered the line 14 in the same way this was done in de template_top for the catalog but nothing works. So can somebody please tell me how I can get rid of it?

<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2010 osCommerce

  Released under the GNU General Public License
*/
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<meta name="robots" content="noindex,nofollow">
<title><?php echo TITLE; ?></title>
<base href="<?php echo HTTP_SERVER . DIR_WS_ADMIN; ?>" />
<!--[if IE]><script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/flot/excanvas.min.js'); ?>"></script><![endif]-->
<link rel="stylesheet" type="text/css" href="<?php echo tep_catalog_href_link('ext/jquery/ui/redmond/jquery-ui-1.8.6.css'); ?>">
<script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/jquery/jquery-1.4.2.min.js'); ?>"></script>
<script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/jquery/ui/jquery-ui-1.8.6.min.js'); ?>"></script>

<?php
  if (tep_not_null(JQUERY_DATEPICKER_I18N_CODE)) {
?>
<script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/jquery/ui/i18n/jquery.ui.datepicker-' . JQUERY_DATEPICKER_I18N_CODE . '.js'); ?>"></script>
<script type="text/javascript">
$.datepicker.setDefaults($.datepicker.regional['<?php echo JQUERY_DATEPICKER_I18N_CODE; ?>']);
</script>
<?php
  }
?>

<script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/flot/jquery.flot.js'); ?>"></script>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script type="text/javascript" src="includes/general.js"></script>
</head>
<body>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<?php
  if (tep_session_is_registered('admin')) {
    include(DIR_WS_INCLUDES . 'column_left.php');
  } else {
?>

<style>
#contentText {
  margin-left: 0;
}
</style>

<?php
  }
?>

<div id="contentText">

[DAVID3733]

Hi there

have installed this contrib on 2.3.1 with a few others and for the most seems to work ok, i have a problem though when new order email is clicked i get the error
Fatal error: Call to undefined function tep_add_base_ref() in XXX/XXX/XXX/admin/edit_orders_ajax.php on line 1144

I have looked through previous posts and see this has been mentioned a few times but couldnt see a fix mentioned.

any help appriciated

thank you

David

[DAVID3733]

Hi

spoke to soon

Found the fix in the earlier post here

post

thank you

[woots_p]

Swingy, on 31 May 2011, 01:05, said:

Adding this in 2.3.1 with this version 1.1 ( http://addons.oscommerce.com/info/7844/v,23 )

I also have the warning about the headers. (Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site7/fst/var/www/html/shop/admin/includes/template_top.php:14) in /home/virtual/site7/fst/var/www/html/shop/admin/includes/functions/general.php on line 34)

I looked in template_top for blank spaces on wrong places, altered the line 14 in the same way this was done in de template_top for the catalog but nothing works. So can somebody please tell me how I can get rid of it?

<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2010 osCommerce

  Released under the GNU General Public License
*/
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<meta name="robots" content="noindex,nofollow">
<title><?php echo TITLE; ?></title>
<base href="<?php echo HTTP_SERVER . DIR_WS_ADMIN; ?>" />
<!--[if IE]><script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/flot/excanvas.min.js'); ?>"></script><![endif]-->
<link rel="stylesheet" type="text/css" href="<?php echo tep_catalog_href_link('ext/jquery/ui/redmond/jquery-ui-1.8.6.css'); ?>">
<script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/jquery/jquery-1.4.2.min.js'); ?>"></script>
<script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/jquery/ui/jquery-ui-1.8.6.min.js'); ?>"></script>

<?php
  if (tep_not_null(JQUERY_DATEPICKER_I18N_CODE)) {
?>
<script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/jquery/ui/i18n/jquery.ui.datepicker-' . JQUERY_DATEPICKER_I18N_CODE . '.js'); ?>"></script>
<script type="text/javascript">
$.datepicker.setDefaults($.datepicker.regional['<?php echo JQUERY_DATEPICKER_I18N_CODE; ?>']);
</script>
<?php
  }
?>

<script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/flot/jquery.flot.js'); ?>"></script>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script type="text/javascript" src="includes/general.js"></script>
</head>
<body>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<?php
  if (tep_session_is_registered('admin')) {
    include(DIR_WS_INCLUDES . 'column_left.php');
  } else {
?>

<style>
#contentText {
  margin-left: 0;
}
</style>

<?php
  }
?>

<div id="contentText">

Move "require(DIR_WS_INCLUDES . 'template_top.php');" After

  $currency_query = tep_db_query("select distinct title, code from " . TABLE_CURRENCIES . " order by code ASC");  
  $currency_array = array();
  while($currency = tep_db_fetch_array($currency_query)) {
    $currency_array[] = array('id' => $currency['code'],
                              'text' => $currency['code'] . ' - ' . $currency['title']);
  }

[DAVID3733]

woots_p, on 03 June 2011, 09:37, said:

Move "require(DIR_WS_INCLUDES . 'template_top.php');" After

  $currency_query = tep_db_query("select distinct title, code from " . TABLE_CURRENCIES . " order by code ASC");  
  $currency_array = array();
  while($currency = tep_db_fetch_array($currency_query)) {
    $currency_array[] = array('id' => $currency['code'],
                              'text' => $currency['code'] . ' - ' . $currency['title']);
  }

Changed this in edit_orders.php and it worked for me as i was having same problem, thanks woots_p

Regards

david

[chemist4]

I installed version 1.1 for osC 2.3.1 and all seemed well, but I realized I had forgotten to run the SQL scripts. So I did that and now the "Update" button no longer shows up. The entire Order Edit page is there with all of the information and options, but I can't actually edit anything because there is no "Update" button to click.

Anyone have an idea of what happened?

[chemist4]

Telling it not to use AJAX brought the Update button back, but now when I click the button I get a blank page. The menus on the side are there, and I have to click on "Customers", then "Orders" to get back where I was. There is a "Success" message at the top and the new information is correct, but why does it not just update the page instead of going off somewhere else? And why would it not work right using AJAX even though I have Javascript on? This isn't a big deal as long as it works, but it is annoying.

Anybody know how to fix it?

[demz]

Hi,

Just to drop in, just installed the latest 1.1 version op an 2.3.1 install and all i get is an Blank page when i press "Edit" seems it cannot find it?
Very strange, all files are there, did the sql update, reviewed the options, all new files are in place...
Even tried it with the new fix and with option off and on..

Triple checked the adjusted files, but everything is okay..
Still an blank 501 page..

Hope someone can help me out

Edited by demz, 16 June 2011, 15:34.

[DAVID3733]

Hi there

I have installed 5_0_9b on 2.2 RCa and all appears to be working except the new order email gets delivered blank also there is no pdf attachement, have toggled swicth in admin>pdf invoices and mime / html . i see this question has been asked a couple of times but no answer.

I have seen a number of comments about various additions to this contrib that are not supported, shoudld i roll back to a previous version for the contrib (i thought 5-0-9b0 looked like the latest full one), if so what is the proper one to install?

Thank you

David

[TRNG98]

I have modified the shop, so I have 2 buttons for order confirmation -- with or without editing. My customers usually like to have modifications, and I hope that the order-edit shall limit on the e-mails. If the order is OK or not, don't matter much for invoice, or advance payment orders, as I can make an invoice on paper and send to the customer. It DO matter for Pay-pal. I have found that the paypal paypal_standard.php function before_process() actually hi-jack the shop, and process the order itself. I can easily block this, as I have kind-a fixed processing in a separate file, while the checkout_process.php handle orders that are OK; the normal way.

What is needed now, is a button in the order-edit, or on the customer-view-orders, or a link that is sent in the e-mail, or whatever --
I need to open the order, crate a shopping cart, and then send it to "paypal_standard.php function before_process()" for processing and communication with pay-pal.

That would just be super-cool. I run 2.2 ....rc2 I think; and I have much to many hacks to consider any upgrading.
If the edited order can be moved back into the shopping cart, this have many uses. It would also, in good weather, work with many payment modules.

I don't have any php editor/debugger, and I don't have any local machine for software testing.

Edited by TRNG98, 22 June 2011, 18:03.

[vashichino7]

Does this mod work with 2.3.1? Please let me know...and can you add different areas maybe a "retail price" and "discount" section... etc?

[gaspower]

Hello,

All seems to be working fine. Was wondering is there away to have the order tool not add a product if inventory is zero, or some how when adding products, it show quanity level?

Thanks Jr

[ocs1409]

hi

i have installed track and trace contribution 3736 in this contribution

the problem is if i use the non-ajax version it works well

in the ajax version it is working except for the part where i want to save the data for the table order_history

the filled in $track_num and $track_pcode are not stored


the code i use in admin/edit_orders_ajax.php is :
//SADESA ORDER TRACKING
// tep_db_query("INSERT into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values
// ('" . tep_db_input($_GET['oID']) . "',
// '" . tep_db_input($_GET['status']) . "',
// now(), " .
// tep_db_input($customer_notified) . ", '" .
// oe_iconv($_GET['comments']) . "')");

tep_db_query("INSERT into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, track_num, track_pcode, comments) values
('" . tep_db_input($_GET['oID']) . "', '" .
tep_db_input($_GET['status']) . "',
now(), " .
tep_db_input($customer_notified) . ", '" .
tep_db_input($_GET['track_num'])) . "', '" .
tep_db_input($_GET['track_pcode']) . "', '" .
oe_iconv($_GET['comments']) . "')");
//SADESA ORDER TRACKING


the code used in admin/edit_orders.php is
//SADESA ORDER TRACKING
// tep_db_query("INSERT into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . tep_db_input($_GET['oID']) . "', '" . tep_db_input($_POST['status']) . "',
// now(), " . tep_db_input($customer_notified) . ", '" . tep_db_input(tep_db_prepare_input($_POST['comments'])) . "')");
tep_db_query("INSERT into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, track_num, track_pcode, comments) values
('" . tep_db_input($_GET['oID']) . "', '" . tep_db_input($_POST['status']) . "', now(), " . tep_db_input($customer_notified) . ", '" .
tep_db_input(tep_db_prepare_input($_POST['track_num'])) . "', '" . tep_db_input(tep_db_prepare_input($_POST['track_pcode'])) . "', '" . tep_db_input(tep_db_prepare_input($_POST['comments'])) . "')");
//SADESA ORDER TRACKING



in the file edit_orders_ajax.php i already changed $_get with $http_get_vars etc but no luck

greetings eric