3242 replies to this topic

[jhilgeman]

If you ever wanted to update any part of an order's information, add new products to an order, insert new information like coupons, change taxes on a specific product, and so on, here's the tool. I truly hope this makes life easier for some of you.

http://www.oscommerce.com/community/contributions,1435

- Jonathan

[dixonmarine]

Thanks, we'll give it a shot. We sometimes have to add charges for hazmat shipping ( see http://www.advantagecomposites.com ) after the fact, so this will help.

Brian

[golfpros]

Installed code, tested it, and re-opened order. Everything seems to work great. Took about 5 minutes to install and test. Simplest install I've done and much needed! Now if I can just find the time to hook it into the admin rather than doing it by URL, it'll be perfect.

Thanks again

[magicproshop]

Hey, congrats on your work, this is a much need contribution. Does this work with MS2?

Thanks again

[Met00]

I have found that I have had to, at times, move and order from a charged order to a "credit" (order was cancelled and I need to retain the order in the system, yet show that it was credited back to the customer). Will this allow me to do that?

[jhilgeman]

I've found the easiest way of "hooking" this into the admin system is via the order details page. At the top of the order details page, there's a "back" button - I just copy the code for this, and change the HREF. There's already a "edit order" graphic, too, so you can use that.

That way, if I need to edit an order, I just go to that order's details page, click on "edit order" and presto, I'm in the editing mode.

This contribution SHOULD work in any 2.2 version, and possibly 2.1.

- Jonathan

[loxly]

Which version are you using it with? It sounds wonderful, but version is important since there are changes between ms1 and ms2 that affect many many contributions.

[bodyfeelings]

I've installed the Contribution very fast... fine

Than I make my first test on a german shop (2.2MS2)

After Updating the following things happened:

The Order is not shown in the view of all orders because the order status was changed to 0

After manuell changing the status in the database it was back again

But than I could see, that the currency was changed from EUR to $

After that I stop testing. Can somebody help ??

[CC]

I was just about to say I had tested this on the basis that this kind of mod has always intrigued me, and I found the same.

Whenever it is used it removes the order from the listings, due to the order status change.

Also, for those that have to add tax to shipping it doesnt do it.
It adds tax to the order total, but not to shipping, so the order grand total is wrong for those that need tax adding in for shipping.

Can I assume that in the US you dont charge tax on Shipping costs?

Apart from that a very nice mod, and certainly an excellent foundation for the community to build on and improve over time.

Nice1 :wink:

[CC]

To alter the currency find this line:

$ot_text = "$" . number_format($ot_value, 2, '.', ',');

And change the "$" to the symbol you wish to display.

[End]

I use ms1, and I got the same problem as bodyfeelings. My shop language is not english, then I change a order "$" appears in the orderhistory.
Also, the "add product" function only chooses products from the english language table... too bad I can´t use this mod until this is fixed, it´s a really nice mod.

[bodyfeelings]

Quote

To alter the currency find this line:  
Code:  
$ot_text = "$" . number_format($ot_value, 2, '.', ',');  


And change the "$" to the symbol you wish to display.

Yes, thats OK, but the script also calculates a new price - not only changing the sign for the currency.

And the first thing I have to solve is the orderstatus problem.

I think there are some things to to for make the contribution working in different cuntries. But I can't. And the contribution is very good for everybody using osc.

[CC]

Quote

Yes, thats OK, but the script also calculates a new price - not only changing the sign for the currency.

That is like I say, becos the order total is not adding tax to the shipping price.

If you work our the total, it is all fine for the product, try making shipping cost 0.00 and you will see it should be the correct total for what ever tax you charge, but it doesnt add tax to the shipping cost, therefore your total ends up incorrect if you have to add tax to shipping in your country.

Have a look through the code, jhilgeman has commented it quite well, so you can see what each section does and build on it from there.

[GFW]

great!

- just implement a button in the admin area
- add tax to shipping price
- change the order status

and it would be a perfect mod

[GFW]

- automatically send the customer a mail with the changes (important for prepayment)

[GFW]

triplepost, sorry

- the EUR should be after the price, and not in front of (like 50.00EUR not EUR50.00)

[bodyfeelings]

Quote

- just implement a button in the admin area  
- add tax to shipping price  
- change the order status  

That would be wonderful....

Quote

automatically send the customer a mail with the changes (important for prepayment)

Must be swiched on/off because not each change is for the customer.

Quote

- the EUR should be after the price, and not in front of (like 50.00EUR not EUR50.00)

In the moment it is fixed in the sourcecode without a variable. It must be variable and depending on the default currency of the shop

[End]

Agree with GFW.

I have noticed a strange thing, when I click the update button in edit_orders and haven´t changed anything the order disappears. Database still has the data, but orderhistory and admin is not showing it. Anyone else got this problem?

[bodyfeelings]

@end

Quote

The Order is not shown in the view of all orders because the order status was changed to 0  

After manuell changing the status in the database it was back again  

[GFW]

this is ment with "order status", after updating the order status is "0" and disappears, but is still there *fg*.

after changing these things, this would be a perfect and really really simple and helpful mod!