Magento – Store / Website / Shop komplett aus Multishop / -Remove store

Are contained in a multiple Magento stores and should be completely removed from these, to this small “Suitcase packing list” help.

We start with the last ending at first imagined and presented:

1. Orders. This is supported by some extensions such as e.g.. Seamless Delete Order of EMThemes.com, ASPerience DeleteOrders of hedererjs (Here, the orders must be canceled, ended or closed his), Delete Orders of Mageex or Orders Eraser of Wyomind. These are just some examples in which the former probably most used. I've also used them and find them very good, because it really cleans up, including invoices and shipments deletes. Furthermore, it does not interfere with the state in which the job is just.

2. CMS pages

3. Delete a Customer (There may be problems, if the orders were first removed, possibly just once a customer profile “Edit and save” and then delete)

4. Customer groups

5. Newsletter subscribers

6. Categories (Unfortunately, all individually, here may need to first delete the links to the articles)

7. Article

8. Searches delete (Catalog > Searches > filter > delete)

9. Attributsets

10. Attribute

11. URL Rewrite Administration

12. Transactional emails

13. Unfortunately, you can store / view-not simply delete. Only the site has a delete button, But the work has never been. Attempting to delete always got this error message: “Site could not be deleted. Please try again later.” and “Before modifying the website code please make sure that it is not used in index.php.”. Of course, the index had been altered but.

Now, there is the hard version, The website, etc.. to banish from the shop. For this purpose, in the DB in the tables:

core_website (for the site)
core_store_group (for the store)
core_store (for the Store View)

one at the entry to be deleted. Selbstvertständlich here is a useful backup DB. It must be paid to ensure, that is deleted in any case, the default Web site, have a currently active in the admin area.

Should there be a better way?

Continue to be some order- histories and articles received. And, sporadically Bestsellers. These can now only be removed manually from the database, where again caution!
For the best-seller, for example, the tables “sales_bestsellers_aggregated_daily” “sales_bestsellers_aggregated_monthly” and “sales_bestsellers_aggregated_yearly” responsible. If everything is well maintained, You can remove the corresponding data on store_id.
To watch:

1. Store_id looking right at the table “core_website”
2. In the three tables, the SQL command “SELECT * FROM `sales_bestsellers_aggregated_daily` WHERE store_id=[just found the number, e.g.. 2]”
3. Bottom right “OK” click
4. Now the results are displayed
5. Are they sure the data, which is to delete it, then again in the SQL tab and the command “DELETE FROM `sales_bestsellers_aggregated_daily` WHERE store_id=[just found the number, e.g.. 2]”
6. Here, too, with “OK” confirm
7. Then the data are removed
8. But it can also be searched by name or specific products. be deleted. Here, then, instead of “WHERE product_name='[the required name]'” or parts of names WHERE product_name like '%[Part of the name]%'”

Used in Magento versions 1.4.1.1 and 1.5.1.0 Comments? Additions? Notes? Gladly!