How to delete the default demo store data from version 8 software quickly and easily.
In admin under System > Database > Raw Database Admin, click on ‘SQL Statement: Submit a Raw SQL Statement’ and execute these statements one at a time:
DELETE FROM ecom_prod WHERE id LIKE 'DEMO-%'
DELETE FROM ecom_cat WHERE id LIKE 'DEMO-%'
DELETE FROM ecom_prodoptions WHERE id LIKE 'DEMO-%'
DELETE FROM ecom_prodoptionsel WHERE id LIKE 'DEMO-%'
DELETE FROM ecom_prodfilter WHERE id LIKE 'DEMO-%'
DELETE FROM ecom_reviews WHERE id LIKE 'DEMO-%'
DELETE FROM cms_banners WHERE id LIKE 'DEMO-%'