PhotoStore Documentation


Execute SQL queries from the utilities execution box

The sql execution box located in your store manager -> settings -> utilities -> at the bottom of the page allows you to run special queries that you can create as you need them. Listed below area some common ones.
(All queries below use the prefix ps4_ which is default for photostore. if you used a diffrent prefix be sure to change the query to match it.)

How to use a query?

Take one of the highlighted queries below or build your own and put it into the SQL execution box and then run or execute that query. The store should say the query ran successfull at the bottom of the page if all went well.

How to un-delete all my orders:
UPDATE ps4_orders SET deleted = '0'

WARNING USE THESE QUERIES AT YOUR OWN RISK!

If you enter a query wrong or write a wrong query you can literally destroy your store because you are executing queries directly to the database.