Jump to content

How to Reset Number of Orders ???


Guest Secret-Services

Recommended Posts

Guest Secret-Services

Hi Buddy's

How to reset number of orders in Admin Home ???

I do not have orders in the section of orders!!!

Regards

Thank You

Link to comment
Share on other sites

Hi Buddy's

How to reset number of orders in Admin Home ???

I do not have orders in the section of orders!!!

Regards

Thank You

It seems you have deleted some customer account(s) orders were created using it. You have to delete orders using SQL manager OR simple SLQ query using TRUNCATE table query.

Link to comment
Share on other sites

Copy&paste code below to a new file with a name delete_orders.php. Upload it to your store root folder and 'RUN' it - just go to your store index page in your fovorite browser and paste the file name delete_orders.php to browser bar and hit ENTER. URL could look like:

http://www.your.store.tld/delete_orders.php

<?php

include_once("includes/global.inc.php");

include_once("classes/db.inc.php");

$db = new db();

$db->misc("TRUNCATE TABLE `".$glob['dbprefix']."CubeCart_order_inv`");

$db->misc("TRUNCATE TABLE `".$glob['dbprefix']."CubeCart_order_sum`");

?>

Done!

Once run delete the file from your server imediately!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...