OLD Super Orders 2.0 (See v3.0 thread instead)

s_mack:

Peter - you can CAREFULLY edit your order manually using pypMyAdmin.

Step 1) Put your store into "down for maintanance" mode
Step 2) Make a complete backup of your database
Step 3) Start editing... CAREFULLY

To completely edit an order, you'll need to update values in ALL of these tables:

orders (change new order total and tax total)
orders_products (change each product as required... or delete if that's the case... CANT ADD)
orders_products_attributes (if you deleted a product above, make note of its ID and delete the corresponding attributes. If they are only changing attributes, change here)
orders_total (Change all the values for that order ID as required)

BACKUP BACKUP BACKUP

and good luck.

• Steven

Ehh.........:wacko: Will it calculate the numbers or do i have to do that by my self???... Can't add... i need to add, change amoun and delete some...... i do this tomorrow if i cant find any other solution.....Thanks..
I think i have seen an "edit Orders" somewere...

Peter

something wrong with your calculator? Yes, you have to calculate manually.

I woudn't recommend installing edit orders at the same time as superorders... certainly not on a live site without extensive testing. But its your biz.

• Steven

s_mack:

something wrong with your calculator? Yes, you have to calculate manually.

I woudn't recommend installing edit orders at the same time as superorders... certainly not on a live site without extensive testing. But its your biz.

• Steven

No battery:P

Can i make a new order at my own name and then rename orders_products_id and orders_id in to the "old" orders numbers in zen_orders_products???

Peter.................:sadwalk:

no. don't do that.

s_mack:

no. don't do that.

Installing Edit Orders mod after uninstall SO ??:lookaroun ...

Peter:sadwalk:

s_mack:

no. don't do that.

I did it anyway and it seems to work.. So even calculated the amount right when i change one product abount from 24 to 18 :D :D

Please.. tell me i'm in deep water now or i will continue..
**HAVE I FORGOTT som table?? i still have my backup...
**
Changed in:
zen_orders_products
zen_orders_total
zen_orders
Have no attributes :D

I also figured it out how to get the currency right in

Peter :D

I have to learn MySQL... This is cool and so easy to solve problems:yes:
You SQL-pro-guys! please tell me if i have forgott somthing... Because this solved many problems for me...

Peter.... Tired... Time in bangkok 5:32 AM..zzzzzzzzzzzzz

i tried to make this mod to be compatible with Info at a Glance mod but no luck...anybody?! :lookaroun

-edit- wrong thread.. sorry

Would be nice if the Search boxes were in all of the Order Details pages and related pages

Meaning, you'd work on one order details, then search for another order to work on.

I use the Search boxes under Customer > Orders all the time. It would save lots of clicks if those search boxes were right on all the order details pages and related pages.

Thanks :)

DogTags:

Would be nice if the Search boxes were in all of the Order Details pages and related pages

Meaning, you'd work on one order details, then search for another order to work on.

I use the Search boxes under Customer > Orders all the time. It would save lots of clicks if those search boxes were right on all the order details pages and related pages.

Thanks :)

I 2nd that! :)

anyone figure out how to add/subtract items from an order? am i just blind, or is it not in this release?

getyourgameshere.com:

anyone figure out how to add/subtract items from an order? am i just blind, or is it not in this release?

Read from http://www.zen-cart.com/forum/showpost.php?p=256408&postcount=98

I had to do it in phpMyAdmin and it seams to work :yes:

Peter

PeterBKK:

Read from http://www.zen-cart.com/forum/showpost.php?p=256408&postcount=98

I had to do it in phpMyAdmin and it seams to work :yes:

Peter

Ah thanks, it looks like I accidentally skipped over that the first time.

I used phpMyAdmin to edit an order before.. and didn't like it too much :P. Right now I'm still using 1.3 on my live site, so whenever that functionality is back i'll be switching over :)

Either way, thanks for the great contributions, BlindSide!:thumbsup:

Does anyone know if this is compatible with the 1.3.5 release? kelvyn asked a while back but I don't believe I saw a reply.
:smile:

sleepless:

Does anyone know if this is compatible with the 1.3.5 release? kelvyn asked a while back but I don't believe I saw a reply.
:smile:

Although, Super Orders 2.0 does not override any files, there are 3 files that you need to make edits in and the instruction are in the readme file. Assuming that these changes are merged into the 1.3.5 version of these files there should be no reason for it not to work with 1.3.5.

If you already made the optional changes you will also need to merge those changes into the new ones.

Good Luck!

Thank you for the reply.
I have never used Super Orders before, but I would love the added features. So here goes... :smile:

tajul_ashyqin:

i tried to make this mod to be compatible with Info at a Glance mod but no luck...anybody?!

I zipped here the files I edited for INFO-at-Glance to work.
These work for me for:

Zen Cart 1.3.5 0904 release
INFO-at-Glance 1.5
Super Orders 2.0 rev45
Good Luck! :smartass:

And I also have a leetle problem: :no:
super_edit.php just loads an empty popup for me. No content, nothing. Tried to reupload, but nothing happens. Otherwise, all seems fine. Anyone had same?

BTW: what does purchase order mean? On the other side of the world (hungary, you now, we are going to have a Stephen Colbert-bridge soon :lol: ) I don't know what the heck is it supposed to mean! Somebody care to shed some light on me poor head?
Thanks now. And then :)

Ok, never mind, the latest, wikipedia rulez: http://en.wikipedia.org/wiki/Purchase_order

Cheers,
f.

PeterBKK:

I have to learn MySQL... This is cool and so easy to solve problems:yes:
You SQL-pro-guys! please tell me if i have forgott somthing... Because this solved many problems for me...

Peter.... Tired... Time in bangkok 5:32 AM..zzzzzzzzzzzzz
Peter, it's awesome to see you picking this stuff up! :smartass: It sounds like you got everything, but I can't see it so I won't say for sure. Sometimes the best way to figure it out is just try it and see what happens. Keep a log (mental or written) of what you did, so you can back it out if necessary.

Nearly everything about an order is editable...except for the products themselves. I held off delibrately because product setups are sooo complicated, and they are going to change again once the team introduces SKU and qty-by-attribute features. Since I can do all the order editing I need directly from the database, I'm content to wait till then.

tajul_ashyqin:

i tried to make this mod to be compatible with Info at a Glance mod but no luck...anybody?!
Don't use that myself, but I could certainly take a look. No timetable though. :P
DogTags:

Would be nice if the Search boxes were in all of the Order Details pages and related pages

Meaning, you'd work on one order details, then search for another order to work on.

I use the Search boxes under Customer > Orders all the time. It would save lots of clicks if those search boxes were right on all the order details pages and related pages.
Wow, awesome idea! Why didn't I think of that...?
getyourgameshere.com:

anyone figure out how to add/subtract items from an order? am i just blind, or is it not in this release?
See above. I have the ability to split products into separate orders, but otherwise you're on your own. Just too complicated and too many pending changes to be worth the effort right now.
sleepless:

Does anyone know if this is compatible with the 1.3.5 release? kelvyn asked a while back but I don't believe I saw a reply.
Yes you should be fine.