Linked Questions
15 questions linked to/from Clearing Magento after testing
2
votes
2
answers
2k
views
Delete all Orders, Sales & Customer Data in Magento [duplicate]
How can i delete all Orders, Sales & Customer Data in Magento website?
- 3,827
0
votes
1
answer
269
views
Delete old data before migration [duplicate]
We did an export of some old transactions, products and categories some time back. However there have been multiple updates to the data so a new export is required.
In order to do so we need to way ...
- 325
0
votes
1
answer
261
views
Clearing all orders from Magento Store [duplicate]
I have filled my database with a bunch of test data. Before going live I want to clear all the test orders in the database. I view my database using cPanel usually.
What is the best way to clear ALL ...
- 532
46
votes
14
answers
69k
views
Magento 2: How to truncate customers, products, reviews and orders table
Does anyone have list of tables I need to truncate to delete all test customers, products, reviews and orders in Magento 2 ? I'm looking for something similar to Clearing Magento after testing .
- 7,076
2
votes
1
answer
4k
views
Magento 1: proper way to use transaction begin and rollback
So I'm working on some tests where I need to create fixtures data.
Basically I used to have the following pseudo code that worked fine:
public function setUp()
{
// Programmatically create a ...
1
vote
2
answers
6k
views
how to SET FOREIGN_KEY_CHECKS = 0 in phpMyAdmin [closed]
I am trying to truncate some mySQL tables from phpMyAdmin web interface, but for foreign keys constraint I am not able to do it. Is there a way to SET FOREIGN_KEY_CHECKS = 0 in phpMyAdmin?
- 125
2
votes
1
answer
877
views
magento delete all product and reindex from start
i want to reindex product id after i delete all product from admin .
From admin i deleted all products , but when i add new product i still see product ids to be increment from last product id, How ...
- 713
0
votes
0
answers
698
views
magento 2: cleaning customer and order info
I know a solution was posted for this in magento 1: Clearing Magento after testing
I altered this to work for M2 tables, are there any tables I am missing?
Magento 2 SQL
SET FOREIGN_KEY_CHECKS=0;
--...
- 1,782
0
votes
1
answer
426
views
Clean orders and products
How can I delete all the orders and products, with their relative data, in order to have a clean Magento's environment?
- 219
0
votes
2
answers
226
views
Attempting to merge a different shopping cart with Magento
I have an ambitious goal of merging about 1000 orders from a custom, shopping cart solution (not Magento) that we used before my company switched to Magento. This is for the sake of customer service ...
- 1,469
1
vote
2
answers
218
views
Group Products Broken and will not open Associated Products
Issue: When I create a grouped product with a couple of simple products and attempt to view the group on the front end of site I get an error log.
a:5:{i:0;s:588:"SELECT `e`.*, `at_status`.`value` AS ...
- 71
2
votes
0
answers
300
views
Delete all orders and quotes of customers that do not exist anymore
On our testing environment we are constantly creating new customers and also (mass) removing them again, currently only having 12 customers. Now after a while our sales_flat_order (5038 rows) and ...
- 7,562
2
votes
0
answers
132
views
Magento 2.3.2 : How to clear magento database after testing
I am currently doing a lot of tests in Magento so I can get familiar with it. Unfortunately the database is extremely cluttered with my tests. I wish to clear up the database so I can start over again....
- 135
0
votes
2
answers
65
views
Magento 2.2.4 : Unable to select all products in backend. Only visable
In the product grid, I want to disable 2000 products.
I'm only able to do so 200 at a time or whatever is visible."20,30.50,200".
I'm "selecting All" and not just selecting "select visible".
Does ...
- 1
0
votes
2
answers
48
views
Products don't show in search results or categories after data reset
I recently needed to clear my test data, so I ran through the steps in this post: Clearing Magento after testing
Ever since then any products I add don't show up in categories (I've confirmed they're ...
- 1