Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * * 6 votes

NEW! Complete Order Editing Tool!


3252 replies to this topic

#2821 DimeNote

  • Community Member
  • 139 posts
  • Real Name:Unknown
  • Gender:Male

Posted 25 November 2008, 01:06

View PostDimeNote, on Nov 24 2008, 10:53 PM, said:

My question relates to Order Editor working along with SPPC. It seems to work fine except for when I try to add a product. The price next to the product in the dropdown is only reflecting the set "retail" price and not the SPPC price according to the customers group. Is there a workaround for this?

If this has been mentioned elsewhere I apologize... perhaps a kick in the right direction?

Thanks.


To make it more clear, when I add a product in the order editor the price defaults to retail regardless of the customer group. Is there a way to reflect the special pricing in this dropdown? It's important to mention that although the incorrect price shows in the dropdown when I add the product the correct price for the customer group is calculated in the order.

Thanks again.

Edited by DimeNote, 25 November 2008, 01:15.


#2822 JangoF

  • Community Member
  • 258 posts
  • Real Name:John Doe #597

Posted 30 November 2008, 09:41

View Postkbking, on Oct 15 2008, 09:24 PM, said:

In your admin/includes/functions/general.php, add in this function:

function tep_get_products_special_price($product_id) {
    $product_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . "  where products_id = '" . $product_id . "'");
    $product = tep_db_fetch_array($product_query);
  
    return $product['specials_new_products_price'];
  }



This worked for me, thanks a lot! Before adding this fix, all I got was a blank screen when trying to edit orders.

#2823 frankschoutens

  • Community Member
  • 6 posts
  • Real Name:Frank Schoutens
  • Gender:Male
  • Location:Kerkrade

Posted 30 November 2008, 13:28

I've a question...

I'm trying to install this great tool. But it will not work by me. I have SPSC installed and when i'm trying to click on the button to edit_order.php, i'll get a blank screen. Can somebody help me please...

Thanks,

Frank

My english is not so great btw.

#2824 dumpfbacke

  • Community Member
  • 5 posts
  • Real Name:R S aus Hier

Posted 10 December 2008, 13:44

Hello,


I have a problem, If I add a field in order tatal it calculates the tax is not new.
can someone help me please :(

We all have the same problem

http://forums.oscommerce.de/index.php?showtopic=63462

Sorry for my English I come from Germany

MFG

Edited by dumpfbacke, 10 December 2008, 13:46.


#2825 dumpfbacke

  • Community Member
  • 5 posts
  • Real Name:R S aus Hier

Posted 10 December 2008, 14:06

View Postdumpfbacke, on Dec 10 2008, 01:44 PM, said:

Hello,


I have a problem, If I add a field in order tatal it calculates the tax is not new.
can someone help me please :(

We all have the same problem

http://forums.oscommerce.de/index.php?showtopic=63462

Sorry for my English I come from Germany

MFG


Pictures say more than a thousand words

[img]http://www.riccos-camera.de/fehler_1_1.jpg[/img]

And now with an extra box

[img]http://www.riccos-camera.de/fehler_1.jpg[/img]

the tax remains the same :(

MFG

#2826 dumpfbacke

  • Community Member
  • 5 posts
  • Real Name:R S aus Hier

Posted 12 December 2008, 09:40

can anyone help me :(

MFG

#2827 dumpfbacke

  • Community Member
  • 5 posts
  • Real Name:R S aus Hier

Posted 12 December 2008, 16:00

I have now found the body, I think, line 328 in the IF loop "ot_custom_".
Here is the sum plus the field together ot_custom_X.

 } elseif ( (tep_not_null($ot_value)) && (tep_not_null($ot_title)) ) { // this modifies if (!strstr($ot_class, 'ot_custom')) { //3
			$new_order_totals[] = array('title' => $ot_title,
					 'text' => $currencies->format($ot_value, true, $order->info['currency'], $order->info['currency_value']),
										'value' => $ot_value,
										'code' => 'ot_custom_' . $j,
										'sort_order' => $j);

					$order->info['total'] += $ot_value;
			$written_ot_totals_array[] = $ot_class;
			$written_ot_titles_array[] = $ot_title;
			$j++;
			
			
		  } //end 3

But if I expand on the whole it nothing happens:

$order->info['total'] += $ot_value;

after add

$order->info['tax'] += $ot_value;


 } elseif ( (tep_not_null($ot_value)) && (tep_not_null($ot_title)) ) { // this modifies if (!strstr($ot_class, 'ot_custom')) { //3
			$new_order_totals[] = array('title' => $ot_title,
					 'text' => $currencies->format($ot_value, true, $order->info['currency'], $order->info['currency_value']),
										'value' => $ot_value,
										'code' => 'ot_custom_' . $j,
										'sort_order' => $j);

$order->info['tax'] += $ot_value;					
$order->info['total'] += $ot_value;
			$written_ot_totals_array[] = $ot_class;
			$written_ot_titles_array[] = $ot_title;
			$j++;
			
			
		  } //end 3

Why not ghet :(

MFG

Edited by dumpfbacke, 12 December 2008, 16:02.


#2828 amcho

  • Community Member
  • 16 posts
  • Real Name:Mike

Posted 15 December 2008, 14:03

Heather,

Have you been able to resolve this problem?
I also end up at the Administrator Login prompt when trying to make changes
to customers orders, and like you I would swear it worked OK before!

mike

View PostDesign Recollections, on Oct 9 2008, 04:18 PM, said:

When I installed this it worked fine the other day. Yesterday I added a contribution for HTML emails and tested it throughly. This was the only email that did not take on the new form, by that I mean that if I edited an order the new email sent to the customer was the bog standard one and not my new super cool version LOL!

Anyways, today I tried to edit an order for the first time for a real customer and after I added the new £ total I was sent back to admin login and then just got a white screen and no updates?? I swear it worked yesterday so where do I look for a solution now?

Any help appreciated, thanks!


#2829 carricksupplies

  • Community Member
  • 12 posts
  • Real Name:Martyn Breckenridge

Posted 15 December 2008, 20:43

Hi, does anyone know hot to get this contribution working with the UHTML Email Contribution. I'm sure its a simple think, but im a n00b

#2830 dumpfbacke

  • Community Member
  • 5 posts
  • Real Name:R S aus Hier

Posted 16 December 2008, 08:03

can anyone help me :(

Post #2827
Post #2825

MFG

Edited by dumpfbacke, 16 December 2008, 08:04.


#2831 amcho

  • Community Member
  • 16 posts
  • Real Name:Mike

Posted 16 December 2008, 11:27

For anyone else getting the Administrator Login prompt when trying to make changes
to customers orders - I have found that if I do login again the update if performed correctly!
Also when I switched off the use ajax functionality (admin - Configuration - Order Editor -
set 'Allow the use of AJAX to update order information?' to false)
it works OK.

Hope this is of some help to someone.....

#2832 desmoworks

  • Community Member
  • 52 posts
  • Real Name:Anthony
  • Gender:Male

Posted 17 December 2008, 17:26

View Postdlew, on Apr 13 2008, 02:13 AM, said:

I was getting a blank page and and an error using free shipping by categories module.

if you get this error in your web logs...

PHP Fatal error: Call to undefined function tep_get_categories_name() in /patph/to/catalog/includes/modules/shipping/freecats.php on line 74


add to admin/includes/functions/general.php

function tep_get_categories_name($cID, $language = ''){
global $languages_id;
if (!tep_not_null($language))
$language = $languages_id;

$cname = tep_db_fetch_array(tep_db_query('select categories_name from '.TABLE_CATEGORIES_DESCRIPTION.' where categories_id="'.$cID.'" and language_id="'.$language.'"'));

return $cname['categories_name'];
}

I found the fix on an OSC netherlands forum.
http://forums.oscommerce.nl/index.php?showtopic=17881

Thank you for this! I'm glad I searched the forums before trying to figure it out myself!!!

#2833 fixion

  • Community Member
  • 54 posts
  • Real Name:klavs klavsen
  • Location:Denmark

Posted 19 December 2008, 10:57

ot_tax missing after using order_editor 5.0.6_6 to edit an order :(

Hi. I wanted to use order_editor to edit my orders - as the normal OSC order editor can't handle shipping without a VAT charge.

I edited an order - but now the ot_tax entry in the orders_total table is missing for that order :(

I tried searching this thread for notes on this, but I can't figure out how to see which (of the 29 pages - with many posts on each) actually mentions ot_tax.. Anyone know how to see the posts in this thread, that mentions ot_tax ?

Any help is appreciated - I am a programmer - I'm just not experienced with the order_editor code.. I was hoping someone could give me a pointer.

I'll glady insert trigger_error("whatever info you want",E_USER_WARNING); lines in the code to pull out data that could help.

#2834 B-Hoff

  • Community Member
  • 4 posts
  • Real Name:Benjamin Hoffman
  • Location:Ohio

Posted 19 December 2008, 13:45

Every time I click edit on an order I get this error:

Fatal error: Call to undefined function tep_round_up() in *************/includes/modules/shipping/usps.php on line 162

Any help would be appreciated.

Thanks

#2835 B-Hoff

  • Community Member
  • 4 posts
  • Real Name:Benjamin Hoffman
  • Location:Ohio

Posted 19 December 2008, 14:40

View PostB-Hoff, on Dec 19 2008, 09:45 AM, said:

Every time I click edit on an order I get this error:

Fatal error: Call to undefined function tep_round_up() in *************/includes/modules/shipping/usps.php on line 162

Any help would be appreciated.

Thanks


Fixed.......

Apparently USPS Methods 4.3.0 added a round up feature that caused the error.

I installed version 4.2.1 and the error is gone.

#2836 CGhoST

  • Community Member
  • 188 posts
  • Real Name:Cyber Ghost

Posted 20 December 2008, 01:30

View PostDimeNote, on Nov 25 2008, 01:06 AM, said:

To make it more clear, when I add a product in the order editor the price defaults to retail regardless of the customer group. Is there a way to reflect the special pricing in this dropdown? It's important to mention that although the incorrect price shows in the dropdown when I add the product the correct price for the customer group is calculated in the order.

Thanks again.

Anyone have a solution to this please?

#2837 taikahn

  • Community Member
  • 9 posts
  • Real Name:Tai Kahn

Posted 20 December 2008, 20:30

When I click on the edit button for the configuration option: "Select your credit card payment method" I get the following error 'dumped inline' above the list and I cannot edit the payment method as the rest of the page is subsequently broken.

Fatal error: Call to undefined function tep_cfg_pull_down_payment_methods() in /home/springs/public_html/store/catalog/admin/configuration.php(125) : eval()'d code on line 1


Anyone?

#2838 imagixx

  • Community Member
  • 80 posts
  • Real Name:Martin B.
  • Gender:Male

Posted 31 December 2008, 01:46

I'm upgrading to Order Editor 5.061 from 2.9.1. I used Admin Comments Toolbar 4.0 extensively, anmd dread having to manually type each repetitive comment over and over again. Now, with the ability to edit the comments in 5.061, Admin Comments Too;lbar ptts its remarks into the first comments field. Naturally I want it to add it only to the New Comments textarea.

I know its simply a matter vof identifying the appropriate field, but I have zip knowledge on dcument elements. Admin Toolbar seems fairly popular, and I'm sure the issue has been solved. But, I can't seem to find the specifics. Any help here? Martin

#2839 imagixx

  • Community Member
  • 80 posts
  • Real Name:Martin B.
  • Gender:Male

Posted 31 December 2008, 03:27

I'm upgrading to Order Editor 5.061 from 2.9.1. I used Admin Comments Toolbar 4.0 extensively, and dread having to manually type each repetitive comment over and over again. Now, with the ability to edit the comments in 5.061, Admin Comments Toolbar puts its remarks into the first comments field. Naturally I want it to add it only to the New Comments textarea.

I know its simply a matter vof identifying the appropriate field, but I have zip knowledge on dcument elements. Admin Toolbar seems fairly popular, and I'm sure the issue has been solved. But, I can't seem to find the specifics. Any help here?

All Right, I'm thinking out loud. How do I designate the last element in the textareas array? If you change

var myTextarea = textareas.item(0);

you can designate the textarea where the comment will be placed:

var myTextarea = textareas.item(5);

will put it in the last textarea (if you have 3 comments 0, 1, 2, 3).

So, how do I designate the last element number?

TIA

Martin

#2840 vicster

  • Community Member
  • 158 posts
  • Real Name:Vickie

Posted 31 December 2008, 23:55

Quote

When I click on the edit button for the configuration option: "Select your credit card payment method" I get the following error 'dumped inline' above the list and I cannot edit the payment method as the rest of the page is subsequently broken.

I pretty much have the same problem. When I try to edit that area in Admin > Config > Order Edit > Select..., the place where you should be making the change disappears and the page is broken. I receive no errors though.

I checked every file to make sure there were no spaces after the final ?> and found none, but I'm sure the problem a missing character, or something simple (I hope, anyway).

Can anyone help?