Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email

Magento Forum

Order management question and sql questions in one, ya i know!!!! 
Jr. Member
Total Posts:  5
Joined:  2008-02-21

Ok i know nothing about sql. I have an order management software that I had some sql php guy build for me back in the day. Ive been using it for my other cart. It pretty much cuts out the back end order management. I can use this to view new orders in real time and assign them to supplier. It gives me the order number, prodcutname/sku, customer name, number, ip address, email and customer notes.

If the order is pending it stays at the pending page. If paypal ipn sends a message back saying its paid, it automatically changes its status to confirmed and moves it to the confirmed page, and the same for refunded and shipped.

This way, i can see all paid orders, i can see which group they are in and if they are verified i know i can attach this to the supplier. The supplier has a separate login where he can view the order and mark it shipped.

This helps me greatly since im not sending a physical product, but a virtual currency in mmorpg games.

I want to use this for Magento, since its the best cart in the world.

Can someone answer this question for me.

I query my old database with names within tables. Now in magento database setup its not by names, its value_id’s within each table.

How in the world do i query a table like that...........

So far this is how i post variables.

Order_id is a row in the table order_id_etc..

$order_id = $_POST["order_id"];

I have been searching and I hope im not asking too much, but a little understanding of magento’s database would help allot.

Lastly. Anyone out there want to help me modify this software to work with magento? I will release the software to the public if people are interested.

There is nothing out there that fits my needs when it comes to order management. I have searched deligently.

Does anyone have an idea of any other way to keep this type of information organized for my business? Ive thought it out quite a bit and cant find anything.

Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top