Linked Questions

2 votes
2 answers

Delete all Orders, Sales & Customer Data in Magento [duplicate]

How can i delete all Orders, Sales & Customer Data in Magento website?
Teja Bhagavan Kollepara's user avatar
0 votes
1 answer

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 ...
Andreas's user avatar
  • 323
0 votes
1 answer

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 ...
CodingMageSheen's user avatar
45 votes
14 answers

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 .
amitshree's user avatar
  • 6,896
2 votes
1 answer

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 ...
Raphael at Digital Pianism's user avatar
1 vote
2 answers

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?
hln's user avatar
  • 125
2 votes
1 answer

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 ...
mcoder's user avatar
  • 713
0 votes
0 answers

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; --...
Xenocide8998's user avatar
  • 1,732
0 votes
1 answer

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?
stsnow's user avatar
  • 219
0 votes
2 answers

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 ...
sparecycle's user avatar
  • 1,459
1 vote
2 answers

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 ...
Stephen's user avatar
  • 71
2 votes
0 answers

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 ...
7ochem's user avatar
  • 7,502
2 votes
0 answers

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....
Parth's user avatar
  • 135
0 votes
2 answers

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 ...
Ray44's user avatar
  • 1
0 votes
2 answers

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 ...
G. Reed's user avatar