Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * * 6 votes

NEW! Complete Order Editing Tool!


3242 replies to this topic

#2861 akunamachata

  • Community Member
  • 49 posts
  • Real Name:john

Posted 02 March 2009, 04:05

View Postakunamachata, on Feb 25 2009, 08:57 AM, said:

Also i think there's a bug with DISCOUNT: where i insert the discount of $10 and it updated to the total as $10 more instead of subtracting $10.00 from the total.


Please disregard the above, i was being dump...

Today, i was doing troubleshooting to see why i can't discount, and when i search the text DISCOUNT to see where it located, and i found it in language/english/edit_orders.php, where it say HINT_TOTALS, use - value, so then i use - $amount and wala, it worked great!, i love this contribution alot.

However, my Individual Shipping contribution won't work with Order_Editor... it shows but it won't calculate from the item itself, except if i insert it manually, then its find, so it won't grab from the item...

By all mean, i will try to figure it out on my own, but, if anyone can help, very great thanks!.....

Thank you, you guys once again!

#2862 rocdy

  • Community Member
  • 152 posts
  • Real Name:Rocdy Dewanto
  • Gender:Male
  • Location:Jakarta

Posted 13 March 2009, 02:04

I have some questions about latest order editor version.
I have installed and run successfull but i cannot edit my shipping cost.

After that i find some addon that is required the order editor to install, that is manual Create Order, and after i finish install, i can edit my shipping cost when the order are create manually. But for the order made by customer , i still cannot edit the shipping cost.

Any ide to make my edit order can working for both of them. Sory for my bad english because i'm from indonesi. Thank
Rocdy

Beginner in php programming and still learning from this forums.
Special thanks for Oscommerce Community Forums that help me a lot. :-)

#2863 royal38

  • Community Member
  • 70 posts
  • Real Name:Jean D.

Posted 13 March 2009, 17:23

Hello,

I use the contrib order editor which is great but I have a little bug with it : Discount don't apply on subtotal, only on total.

Because of that, tax and price excluding tax are wrong because there are based on the subtotal (in my version).

[img]http://img11.imageshack.us/img11/3527/discountt.jpg[/img]

As you can see, subtotal don't include the discount :angry: but is included in the total. :blink:

I try all this afternoon to modify the file order.php which is in the file "order_editor", but I failed to apply "discount" which is a custom on the subtotal.

I don't know how to apply discount on this code :

[img]http://img19.imageshack.us/img19/2940/discount2.jpg[/img]

Thanks a lot for your help.

Bye ;)

#2864 goyito

  • Community Member
  • 28 posts
  • Real Name:gregorio

Posted 27 March 2009, 11:43

Hello:
Do you know if anybody have been working on the shipdate contribution for order Editing Tool?
Waiting for your answer,
Sincerly yours
Gregorio

#2865 sunset_rider

  • Community Member
  • 1 posts
  • Real Name:Philipp

Posted 30 March 2009, 09:05

Thanks for the contrib. Works great for my shop and was easy to install.
However, I still have one problem: The headlines of the functions are not displayed correctly.
[img]http://img16.imageshack.us/img16/503/bild1aqr.th.jpg[/img]
There is obviously something missing to the includes/languages file. I have not found anything related to this issue in the included instrcutions-file. Does anyone know how I can solve this problem?
Thanks in advance!

Edited by sunset_rider, 30 March 2009, 09:10.


#2866 royal38

  • Community Member
  • 70 posts
  • Real Name:Jean D.

Posted 07 April 2009, 15:05

Hello,

Can someone tell me how to add or substract the value of ot_custom_x to the subtotal?

When I add a custom field, it's add the value to the total but not on the subtotal.

Can someone help me to solve these?

Thansk a lot.

#2867 bugnet

  • Community Member
  • 4 posts
  • Real Name:David

Posted 09 April 2009, 14:17

Easy-Easy install contrib, very practical to use and to edit itself (if needed, add fields etc) !!!
I was trying to fix some bug with urlencode or anything like that, because order editor do not support special characters for payment methods or shipping methods, so I got a payment method "Cartão de crédito" and when changed, shows only "Cart" and ends up missing the rest of sentence, any idea ?

thks !

#2868 Teamjr

  • Community Member
  • 173 posts
  • Real Name:Dominic Bregante
  • Gender:Male
  • Location:California

Posted 09 April 2009, 22:58

Hello,

I am using version 5.0.6 and all has been working fine. Just added Fedex for shipping and Order Editor only shows Fedex Express rates. How do I get it to show Home Delivery?

Thanks JR

#2869 weaver

  • Community Member
  • 15 posts
  • Real Name:Rauno Riikman

Posted 15 April 2009, 10:58

View Postroyal38, on Mar 13 2009, 05:23 PM, said:

Hello,

I use the contrib order editor which is great but I have a little bug with it : Discount don't apply on subtotal, only on total.

Because of that, tax and price excluding tax are wrong because there are based on the subtotal (in my version).

[img]http://img11.imageshack.us/img11/3527/discountt.jpg[/img]

As you can see, subtotal don't include the discount :angry: but is included in the total. :blink:

I try all this afternoon to modify the file order.php which is in the file "order_editor", but I failed to apply "discount" which is a custom on the subtotal.

I don't know how to apply discount on this code :

[img]http://img19.imageshack.us/img19/2940/discount2.jpg[/img]

Thanks a lot for your help.

Bye ;)



Hi!

Did you find a solution to this problem with the taxes and discount?

Edited by weaver, 15 April 2009, 11:01.


#2870 royal38

  • Community Member
  • 70 posts
  • Real Name:Jean D.

Posted 15 April 2009, 11:31

View Postweaver, on Apr 15 2009, 10:58 AM, said:

Hi!

Did you find a solution to this problem with the taxes and discount?

It is not really solved. I try something but I have to update the order 3 times to have the godd subtotal. <_<

In catalog/admin/order_editor/order.php , I've add :

$custom_query = tep_db_query("select sum(value) as cusval from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "' and class like 'ot_custom%'");
$custom = tep_db_fetch_array($custom_query);
	
$subval = $this->info['subtotal'];
$sumcus = $custom['cusval'];
	

$this->info['subtotal'] = $subval + $sumcus;// - $this->info['shipping_cost'];//$subval + $sumcus;



Someone have a best solution?

Thanks a lot

Edited by royal38, 15 April 2009, 11:31.


#2871 weaver

  • Community Member
  • 15 posts
  • Real Name:Rauno Riikman

Posted 15 April 2009, 20:00

View Postmaniac101, on Feb 11 2009, 09:25 PM, said:

Has anyone managed to get discounts working properly ?
Im using easy discount, but im really struggling to integrate this in - at the moment it doesnt get added or subtracted from the total once you edit an order - so it breaks the original discount value as well! so i can put anything in that value as it uses ot_easy_discount and the edit_order.php code lets it live there but doesnt recalculate the value of the discount. every way ive tried of integrating the easy_discount code results in errors for trying to use easy_discount values in the code.
Im going to keep trying for a little while longer before i give up!

Also tax doesnt get calculated properly either. if i add a custom discount, this gets taken off the total properly, but the tax amount always relates to the original value of the order - which isnt correct for tax. the tax should be recalculated based on the discount being taken off the original total. I can probably fix that but if anyone has fixed it already id be keen to find out how.

aside from that it works well - only when ajax turned off om admin though.
thanks


Hi!

Did you get the tax calculation to work properly? There is at least couple of people who would be very interested how it could be corrected... I tried to play with the code from royal38 below but couldn't get enough good results. There could be start though..

Thanks

#2872 weaver

  • Community Member
  • 15 posts
  • Real Name:Rauno Riikman

Posted 15 April 2009, 20:06

View Postroyal38, on Apr 15 2009, 11:31 AM, said:

It is not really solved. I try something but I have to update the order 3 times to have the godd subtotal. <_<

In catalog/admin/order_editor/order.php , I've add :

$custom_query = tep_db_query("select sum(value) as cusval from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "' and class like 'ot_custom%'");
$custom = tep_db_fetch_array($custom_query);
	
$subval = $this->info['subtotal'];
$sumcus = $custom['cusval'];
	

$this->info['subtotal'] = $subval + $sumcus;// - $this->info['shipping_cost'];//$subval + $sumcus;



Someone have a best solution?

Thanks a lot


Thanks for answer. I get some results with the code you provided but can't get it work properly either. I asked help from maniac101 as he had said he probably can get it to work...

Greets

#2873 royal38

  • Community Member
  • 70 posts
  • Real Name:Jean D.

Posted 16 April 2009, 07:55

Can you put the solution on this topic when you got it?

Thanks a lot.

#2874 weaver

  • Community Member
  • 15 posts
  • Real Name:Rauno Riikman

Posted 17 April 2009, 08:50

View Postroyal38, on Apr 16 2009, 07:55 AM, said:

Can you put the solution on this topic when you got it?

Thanks a lot.


Yes offcourse, but I was referring previously to maniac101's post above at february 11, so i don't know if he really have worked out a solution... It's a quite serious bug in this contribution that taxes are not recalculated when giving discounts, so it would be nice if somebody who knows this system could fix it


greets

#2875 ~Kira

  • Community Member
  • 181 posts
  • Real Name:Starlight Design
  • Gender:Female
  • Location:USA

Posted 28 April 2009, 17:33

I would like some programming help as well. I'm not sure if this has to do with order editor or the store in general, but I need to get it fixed. The taxes are not showing up in various places, although they are being charged.

[img]http://27moons.com/hotlinked/ordereditor.gif[/img]
☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆

#2876 oranges

  • Community Member
  • 17 posts
  • Real Name:bob

Posted 30 April 2009, 20:11

got a question. Does this contrib allow you to edit the order histiory that only shows up in the customers account?

im using a contrib that emails the customer a pin when he orders, and the pin is visible in his order history and nowhere else (it doesnt show up on the invoice, only in the order email and his order history) so im thinking this contrib wouldnt let me edit what i need. Thanks

#2877 andes1

  • Community Member
  • 180 posts
  • Real Name:andrea pataquiva diaz

Posted 02 May 2009, 12:51

View Postroyal38, on Apr 16 2009, 08:55 AM, said:

Can you put the solution on this topic when you got it?

Thanks a lot.

QUOTE (djmonkey1 @ Feb 13 2007, 09:19 PM) *
Find in admin/edit_orders.php
CODE
// 1.4.0.1 Shipping Tax
and a few lines below that change
CODE
if($ot_class == "ot_shipping")//a good place to add in custom total components
to
CODE
if( ($ot_class == "ot_shipping") || ($ot_class == "ot_custom") )//a good place to add in custom total components

then find
CODE
//just adding in shipping tax, don't mind me
$ot_shipping_query = tep_db_query("
SELECT value
FROM " . TABLE_ORDERS_TOTAL . "
WHERE orders_id = '" . (int)$oID . "'
AND class = 'ot_shipping'");
and change it to
CODE
//just adding in shipping tax, don't mind me
$ot_shipping_query = tep_db_query("
SELECT value
FROM " . TABLE_ORDERS_TOTAL . "
WHERE orders_id = '" . (int)$oID . "'
AND (class = 'ot_shipping' OR class = 'ot_custom')");

and see how it works then.

#2878 misulicus

  • Community Member
  • 4 posts
  • Real Name:Mihai

Posted 06 May 2009, 00:33

hey..great mod
i get this error on the edit_orders.php page

no matter what value i change i get a Success! green window below..then right after it sows me again the site banner then Administrator Login form
then some order info then again site banner and Administrator Login boxes then again the rest of the order
how to fix this ?

#2879 Frogger34

  • Community Member
  • 25 posts
  • Real Name:Corne
  • Gender:Male
  • Location:Netherlands

Posted 06 May 2009, 13:32

Taxes getting mest up in the Order Editor ?

[img]http://www.kiesebrink.nl/oscfiles/OE5066tax.jpg[/img]

The total isn't wright,
in this image the products cost 6.0924 excl tax
shipping excl tax costs 3.25

netto total will be 9.34
Tax is 19% so will be 1.77 ( and not the 1.16 which is told in the editor)
Total then will be 11.1146 ( almost good some ronding i supose the editor shows 11.12 )

Wat is happening with my tax caculations?

i see more people are having trouble with the tax thing, so i have been looking in the forum, i have installed
version 5.0.6.6

---

I have seen something, the tax for the shipping isn't in the tax total, that's what iam missing, can i include it somewhere
so the total tax is complete ?

Edited by Frogger34, 06 May 2009, 13:33.


#2880 Frogger34

  • Community Member
  • 25 posts
  • Real Name:Corne
  • Gender:Male
  • Location:Netherlands

Posted 06 May 2009, 13:54

View PostFrogger34, on May 6 2009, 03:32 PM, said:

Taxes getting mest up in the Order Editor ?

[img]http://www.kiesebrink.nl/oscfiles/OE5066tax.jpg[/img]

The total isn't wright,
in this image the products cost 6.0924 excl tax
shipping excl tax costs 3.25

netto total will be 9.34
Tax is 19% so will be 1.77 ( and not the 1.16 which is told in the editor)
Total then will be 11.1146 ( almost good some ronding i supose the editor shows 11.12 )

Wat is happening with my tax caculations?

i see more people are having trouble with the tax thing, so i have been looking in the forum, i have installed
version 5.0.6.6

---

I have seen something, the tax for the shipping isn't in the tax total, that's what iam missing, can i include it somewhere
so the total tax is complete ?

i have now changed the netto to the sub_total_ex module but then the amount is shown incl vat in the first field, if i edit the order the field will change correctly but if if re-edit the order the first field is again shown incl. vat, database values are good, what am i missing ?