Kinetic Pulse
  • Home
  • Services
  • Portfolio
  • Blog
  • Terms
  • Contact

Remove all products and categories from a Zen Cart

April 14, 2010

Don’t you just hate it when you realise you need to clear out all your old products and categories froma ZenCart install and start again? Particularly if you have done an import using EasyPopulate and the client(ahem) has given you a spreadsheet of duff data?!

Simply login to phpMyAdmin and run these statements on your database.
WARNING: This will delete ALL your product data!

DELETE FROM zen_customers;
DELETE FROM zen_customers_info;
DELETE FROM categories;
DELETE FROM categories_description;
DELETE FROM group_pricing;
DELETE FROM manufacturers;
DELETE FROM manufacturers_info;
DELETE FROM products;
DELETE FROM products_attributes;
DELETE FROM products_attributes_download;
DELETE FROM products_description;
DELETE FROM products_discount_quantity;
DELETE FROM products_options;
DELETE FROM products_options_values;
DELETE FROM products_options_values_to_products_options;
DELETE FROM products_to_categories;

Share

Facebook Google+ Twitter Pinterest Email
  1. robjson says

    May 23, 2010 at 6:08 pm

    Thanks Laura,

    Exactly what I was looking for!

    Rob

Back to Blog

Testimonials

Thanks so much for all your work on this, really appreciated. It’s come on in leaps and bounds since you took over.
Pete KewRedwood Strip Curtains
Thank you for all of your hard work its looks fab and I am over the moon with it!
Amanda MercerAmanda Mercer Ceramics
It’s been fab working with you – we love the site and certainly going to recommend you!
James DaviesThirty Eight Degrees North
Amazing and brilliant, Kinetic Pulse have lifted a dream to reality, Highly recommended and great if you are total novice, they know their stuff…Thanks again
Annie LindridgeSalt Yourself Out
Thank you guys so much for all that you’ve done helping us to create a really awesome website!! We get such great feedback – everyone loves it & we couldn’t be prouder! Look forward to working with you again soon!
Wild Thyme PlantsWild Thyme Plants
Absolutely fantastically professional web developer – I would highly recommend!!! Thank you so much Kinetic Pulse!
Tania MarstonDoris Designs
I like it.  I like it a lot !!!

 You have interpreted what I wanted to achieve perfectly considering what you have to play with i.e not redoing the whole thing in the process.

Fiona Simmons-MooreSouth Gloucestershire Parents & Carers

Twitter

@HMRCcustomers Will do - thanks for the swift response

Last year from Kinetic Pulse's Twitter

@HMRCcustomers I've submitted Self Assessment repayment requests multiple times over the past 6 months (always waiting 4 weeks between) and never has anything happened. There seems to be no way of tracking or chasing them either. Now, of all times, this is important

Last year from Kinetic Pulse's Twitter

Apologies to all clients who have had website issues today. There was a major outage for our hosting company @cloudabove but, as always, they have been fantastically open and transparent about what's going on and are working hard to restore service.

About a year ago from Kinetic Pulse's Twitter

@thegrapesbath @bathdrummer Thanks - looking forward to opening night!

About 2 years ago from Kinetic Pulse's Twitter

woobox.com/tjkbms/k1orue

About 3 years ago from Kinetic Pulse's Twitter

Copyright 2021 Kinetic Pulse