Detailed Order Info In Database

I have a few different sessions set up as store pages. I just had a client purchase a session, however I'd like to change the type of session she ordered. This is the kind of change I think I could have made with Photocart and PHPMyAdmin, but I'm not finding anywhere in the Sytist database that the details or an order are stored. Where is that?

The sessions are almost exactly the same thing (same price), but for reporting, I'd like to keep things as accurate as possible.

Thanks!
:) H

Edited by

If you view the order in the admin, there is an edit link under the product. You can use that and probably change the item.

Edited by

Well, I'll be! I found the link to edit the payment, just not the order. What an Easter egg! Thanks, Tim!

I may still need to know where the order info is kept as I'm trying to use Zapier to create a trigger for my Xero account where, when an order is placed and a new line is put into the table, Zapier sees it and takes the info from MySQL and ships it over to my Xero account so that I don't have to put it in manually. My laziness wants to do as little work as possible! :)

Thanks again!

Edited by

The order information is in the database table ms_orders and the order items are in ms_cart.

Edited by

What folder within the heirachy are these in?

Edited by

These aren't folders, they are part of the database.

Edited by

Newbie question - where do I find the database? sy-config.php

Edited by

You will find that in your hosting account, if you are self hosted. If you are hosted by Tim you may not have access to that. A word of warning if you do not have experience with data bases i would not attempt to do any work in it, you can easily crash your site. It will be listed under "MyPHP Admin" in your hosting account. From there you will have access.

Edited Fri Nov 03, 23 7:08 PM by Vance Birno

Thanks for the advice Vance - I will download and keep a vigin copy just so I can restore if need be. Only doing R&D at this stage.  Ok see what you mean. Fascinating look under the hood. Tim you are a marvel. 

Edited Fri Nov 03, 23 9:19 PM by Darrell Jones