Hello,
please i have just finish installation and integration of the cart with our local payment platform. I had to carry out a lot of test transactions, and now i would like to clear all transactions.
please does anyone know how to do this without having to individually delete each one one at a time.
thank you in advance.
please i have just finish installation and integration of the cart with our local payment platform. I had to carry out a lot of test transactions, and now i would like to clear all transactions.
please does anyone know how to do this without having to individually delete each one one at a time.
thank you in advance.
I don't quite understand your question.
Normally, after you have submitted a shopping cart to your payment gateway and done the payment, the user ends up on the checkout/success page whose underlying controller clears the session's shopping cart.
Normally, after you have submitted a shopping cart to your payment gateway and done the payment, the user ends up on the checkout/success page whose underlying controller clears the session's shopping cart.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
you need to truncate the mysql tables, this will remove the current orders.
Although a year later from the last post, I had this same question and Qphoria answer is the best one. Thanks Q.
I have close to 200 test orders, so I display 200 orders and click them all.
Q said to click each one, but with 1.5.x, there is a check all checkbox! Thanks for that.
Bruce
I have close to 200 test orders, so I display 200 orders and click them all.
Q said to click each one, but with 1.5.x, there is a check all checkbox! Thanks for that.
Bruce
Cool! Good number 1 change!Qphoria wrote:That was the number 1 change in 1.5.xhotwebideas wrote: Q said to click each one, but with 1.5.x, there is a check all checkbox! Thanks for that.
Hi Q,
In 1.5.x i am looking at Reports-sales-orders and I dont see the checkbox. Am I not looking in the right place?
thanks,
In 1.5.x i am looking at Reports-sales-orders and I dont see the checkbox. Am I not looking in the right place?
thanks,
I am having the same problem here, how can I delete all test orders from sales report?
I deleted all from sales > orders
But I still have information on Reports > Sales > Orders/Tax/Shipping
I want to delete all this information as was generated for test propose.
Thank you.
I deleted all from sales > orders
But I still have information on Reports > Sales > Orders/Tax/Shipping
I want to delete all this information as was generated for test propose.
Thank you.
Did anyone have an aswer to remove all test orders from the reports, customers dont want to see these figures!
Cheers M
Cheers M
I was wondering if anyone has found a solution on how to clear (reset) or delete sales report data? The scenario below describe the issue:
Scenario:
When you fresh-install opencart, you will need to test it to make sure everything is working well. One aspect of the testing involves placing a "demo" or "test" order. After placing a "test" order (demo order), a sales REPORT is automatically generated in the Admin section. However, you will NEED to delete/clear (reset) this "test" sales report before launching your live store.
The Problem
There doesn't seem to be a way (for dummies like me) to delete or clear the data generated during the testing process. For example, if you placed a test order worth $500, the sales report automatically records $500. And because you can't delete or clear out the $500 test (demo) order from sales report, your sales report will not give an ACCURATE report by the time you finally launch your live store.
*******Please note that "Order" data can be easily deleted from Admin BUT the issue I (and others) are talking about is with the "REPORT" sections of OpenCart. It would be great if the "REPORT" sections have "Reset" button *******
This issue has already been clearly highlighted in simple terms by others in this community, but so far there seem to be no solution. The solution mentioned by Qphoria (respect and gratitude to the GURU) does not seem to clear "test" data from "Reports". Any help out there???
Thanks
Scenario:
When you fresh-install opencart, you will need to test it to make sure everything is working well. One aspect of the testing involves placing a "demo" or "test" order. After placing a "test" order (demo order), a sales REPORT is automatically generated in the Admin section. However, you will NEED to delete/clear (reset) this "test" sales report before launching your live store.
The Problem
There doesn't seem to be a way (for dummies like me) to delete or clear the data generated during the testing process. For example, if you placed a test order worth $500, the sales report automatically records $500. And because you can't delete or clear out the $500 test (demo) order from sales report, your sales report will not give an ACCURATE report by the time you finally launch your live store.
*******Please note that "Order" data can be easily deleted from Admin BUT the issue I (and others) are talking about is with the "REPORT" sections of OpenCart. It would be great if the "REPORT" sections have "Reset" button *******
This issue has already been clearly highlighted in simple terms by others in this community, but so far there seem to be no solution. The solution mentioned by Qphoria (respect and gratitude to the GURU) does not seem to clear "test" data from "Reports". Any help out there???
Thanks
I opened the database in phpMyAdmin and removed the data in the _order section. I took a backup first but it seems to work so far.
Open the database in phpmyadmin, move to SQL tab and execute the following query:
TRUNCATE `order`;
TRUNCATE `order_download`;
TRUNCATE `order_fraud`;
TRUNCATE `order_history`;
TRUNCATE `order_misc`;
TRUNCATE `order_option`;
TRUNCATE `order_product`;
TRUNCATE `order_total`;
Don't forget to take a BACKUP first!
TRUNCATE `order`;
TRUNCATE `order_download`;
TRUNCATE `order_fraud`;
TRUNCATE `order_history`;
TRUNCATE `order_misc`;
TRUNCATE `order_option`;
TRUNCATE `order_product`;
TRUNCATE `order_total`;
Don't forget to take a BACKUP first!
[quote="devplus"]Open the database in phpmyadmin, move to SQL tab and execute the following query:
Thank you for your solution to the problem that everybody (including myself) has had. In my case I had to delete the [fraud] and [history] ones because I don't seem to have them - maybe I've got an older version, but the rest worked a treat.
Hope it also helped 007 who posted an excellently worded request on behalf of the rest of us who don't seem to be able to ask the right questions to get proper answers - thanks 007.
Thank you for your solution to the problem that everybody (including myself) has had. In my case I had to delete the [fraud] and [history] ones because I don't seem to have them - maybe I've got an older version, but the rest worked a treat.
Hope it also helped 007 who posted an excellently worded request on behalf of the rest of us who don't seem to be able to ask the right questions to get proper answers - thanks 007.
and wich tables i have to truncate having the same problem on OC 2.0.1.1?devplus wrote:Open the database in phpmyadmin, move to SQL tab and execute the following query:
TRUNCATE `order`;
TRUNCATE `order_download`;
TRUNCATE `order_fraud`;
TRUNCATE `order_history`;
TRUNCATE `order_misc`;
TRUNCATE `order_option`;
TRUNCATE `order_product`;
TRUNCATE `order_total`;
Don't forget to take a BACKUP first!
thank you
I have found.
So ... in order to reset de order id in opencart 2.0.1.1 u have to manualy truncate the order tables tables.
In phpMyadmin u just put this command and mysql will delete all data that are in this tables.
i hope it will be useful for someone.
TRUNCATE `oc_order`;
TRUNCATE `oc_order_custom_field`;
TRUNCATE `oc_order_fraud`;
TRUNCATE `oc_order_history`;
TRUNCATE `oc_order_option`;
TRUNCATE `oc_order_product`;
TRUNCATE `oc_order_recurring`;
TRUNCATE `oc_order_recurring_transaction`;
TRUNCATE `oc_order_status`;
TRUNCATE `oc_order_total`;
TRUNCATE `oc_order_voucher`;
So ... in order to reset de order id in opencart 2.0.1.1 u have to manualy truncate the order tables tables.
In phpMyadmin u just put this command and mysql will delete all data that are in this tables.
i hope it will be useful for someone.
TRUNCATE `oc_order`;
TRUNCATE `oc_order_custom_field`;
TRUNCATE `oc_order_fraud`;
TRUNCATE `oc_order_history`;
TRUNCATE `oc_order_option`;
TRUNCATE `oc_order_product`;
TRUNCATE `oc_order_recurring`;
TRUNCATE `oc_order_recurring_transaction`;
TRUNCATE `oc_order_status`;
TRUNCATE `oc_order_total`;
TRUNCATE `oc_order_voucher`;
Who is online
Users browsing this forum: No registered users and 41 guests