Jump to content

[Solved]Delete Individual Orders


Recommended Posts

I would like to know how to get it so I can delete individual orders from the backend.

Here is my current script that will let me delete all of the orders and its information. I'm just not that familiar with code so that I could get it to delete w/e you want. Which of course each order would have a delete option.

If you are looking to make an extra buck or to I am willing to pay someone to accomplish this asap.

<?php
MYSQL_CONNECT('host','database_username','database_password');
@mysql_select_db("database_name") or die(mysql_error());

$query=`TRUNCATE TABLE `ps_order_credit_data`;
$query=`TRUNCATE TABLE `ps_orders`;
$query=`TRUNCATE TABLE `ps_order_detail`;
$query=`TRUNCATE TABLE `ps_order_discount`;
$query=`TRUNCATE TABLE `ps_order_history`;
$query=`TRUNCATE TABLE `ps_message`;
$query=`TRUNCATE TABLE `ps_cart`;
$query=`TRUNCATE TABLE `ps_cart_product`;
$query=`TRUNCATE TABLE `ps_cart_discount`; 

mysql_query($query);
mysql_close()
?>

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...