Details
Store Toolkit – formally Nuke – includes a growing set of commonly-used e-Commerce administration tools aimed at web developers and store maintainers including the following features:
WP e-Commerce
- Re-link broken WP e-Commerce Pages
- Re-link existing Sales from pre-registered Users
- Repair WordPress option ‘wpsc_version’
- Manage Permalinks for WP e-Commerce Pages (e.g. Products Page, Checkout, etc.)
- Nuke support for clearing WP e-Commerce store records
- All in One SEO Pack integration (All in One SEO Pack)
WooCommerce & Jigoshop
- Nuke support for clearing store records
If you find yourself in the situation where you need to start over with a fresh installation of Jigoshop, WooCommerce or WP e-Commerce then a ‘nuke’ will do the job.
This Plugin clears the following WP e-Commerce 3.7 and 3.8 database tables:
- …wpsc_product_list
- …wpsc_productmeta
- …wpsc_product_categories
- …wpsc_item_category_assoc
- …wpsc_product_images
- …wpsc_product_order
- …wpsc_product_files
- …wpsc_product_rating
- …wpsc_purchase_logs
- …wpsc_cart_contents
- …wpsc_submited_form_data
- …wpsc_claimed_stock
- …wpsc_wishlist (Add to Wishlist)
- …wpsc_creditcard (Offline Credit Card Processing)
Since the release of WP e-Commerce 3.8 Store Toolkit also includes support for nuking the following custom Post types and taxonomies:
- Products (wpsc-product)
- Categories (wpsc_category)
- Tags (product_tag)
- Wishlist entries (wpsc-wishlist)
Store Toolkit includes support for nuking the following WooCommerce & Jigoshop store details:
- Products (product)
- Categories (product_cat)
- Product Images
- Tags (product_tag)
- Orders (shop_order)
Store Toolkit’s ‘nuke’ feature will clear the contents of the above mentioned tables, the 1.2 release brings controlled tactical detonations but as with any nuclear weapon there is no second chance so ensure you backup the contents of these tables if there is even the slightest chance you’ll need them in the future.
Documentation
Looking for support, a copy of the readme, Plugin updates, Ideas or usage instructions? Check out our Documentation for Store Toolkit.
Gurbhej Singh –
Is the plugin compatible with WooCommerce version 4.0.1 ? Is there any new updates coming out soon to this plugin?
Byron Keet –
Hi Gerbhej, Apologies for the very later reply. The plugin is compatible with the most updated version of WooCommerce (now 4.2.2). We have a few updates in the pipeline but nothing being pushed in the next couple of months.
All the best,
Visser Labs
Larry Betts –
Hey! This is a great plugin! I have a store I’m trying to migrate and it has about 8000 useless products. I decided to “nuke” them. There’s one more item under the “Where things can go wrong during this process is:” section. The host we’re migrating from has ridiculously low maximum queries per hour allowed. When it hits the cap it goes to the install screen. I found out about this issue will before installing your plugin. Actually, it’s one of the reasons we’re migrating. But this plugin is BEAST!
Matt Morse –
Hopefully small feature request…
It would be sweet to be able to bulk remove orders for a given total – especially $0 total orders. Our non-profit has a store where 99% of all orders are $0 and those are clogging the database.
Thanks!
Michael Visser –
Hi Matt, that’s doable, I’ll get it up on the feature request board and into queue. 🙂
Cory –
Can this plugin delete orders by date range? Apologies if this has already been answered!
Michael Visser –
Hi Cory, thanks for asking. Store Toolkit does not support nuking Orders by a date range but it’s a great suggestion! I’ll get this baked into the next Plugin update 🙂
Nes –
Hi
im new too all this and i F***ed up!
I want to totally erase everything! I mean everything as if i just installed wordpress and the woocommerce plugin.
themes, pages, products, categories, menus everything.
am i in the right place? and if so can you provide a “how to”?
thanks in advanced.
Nes
Michael Visser –
Hi Nes, our Plugin nukes the database records for WooCommerce and some WordPress details. It’s a very simple Plugin, install it, activate it, open up WooCommerce > Store Toolkit and hit Nuke. 🙂
extension verge –
Hi, Neat post. There is a problem with your web site in internet explorer, could check
this? IE still is the marketplace chief and a huge section of other people will omit your great writing
due to this problem.
Mariusz –
Plugin Woocommerce – Store Toolkit it’s not work if you have >4900 products in your shop !
Mariusz –
i have problem with del woocommerce product – 5400 pcs . error – Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 40 bytes) – what’s problem ??
Jaraed –
Thank you! This is quite useful and appreciate it being free.
Question – using the Jigoshop version.
Trying to use this on my test site of my jigoshop. Want to delete all orders. able to do 800 processing orders, but can’t get rid of the 4500 completed orders.
When I try to nuke it, processes for 15 seconds then goes to a blank page. nothing on it.
Thank you for your help
Michael Visser –
Hi Jaraed, I’ll take a look into this for you re: Processing vs. Completed Orders not being nuked.
The blank screen likely means that PHP has either timed out or you have so many Orders that WordPress has consumed all available memory. I’ve got a way to get around this for WP e-Commerce and will apply it to Jigoshop and WooCommerce’s release.
Jared –
Please do let me know when it is available. I just created the test site and eager to start messing around, but need to make sure all client data is gone.
Thank you
Fabian –
Hello! For some reason i can’t use this plug in. Can’t find it anywhere and when I press “Settings” on the plugin in the plug in menu i get this message:
“You do not have sufficient permissions to access this page.”
What’s the problem?
Regards, Fabian
Michael Visser –
Hi Fabian, please try de-activating and re-activating the Plugin as it may reset the permissions assigned to that User.
jess –
Just updated to the current version. And now it gets hung on a blank page when trying to delete my woocommerce store. Worked great before. Now deletes nothing. Can I get my old plugin back?
Michael Visser –
Hi jess, can you please confirm what data you are nuking from your WooCommerce store and how many Products/Orders you have.
jess –
I’m trying to delete 4000 products. It worked great when I had much less products to delete. This is the error I get now;
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request.
Thanks for your reply.
plasmagrid –
have WP E-Commerce 3.8.8.5
Fatal error: Call to a member function get_var() on a non-object in /home/content/64/9645064/html/wp-content/plugins/wp-e-commerce-store-toolkit/store-toolkit.php on line 52
when relinking pages.
Michael Visser –
Hi plasmagrid, thanks for raising that. I’ll get it patched in the next Plugin update.
stacie –
Hi,
Im getting the same problem that many others seem to be having, when trying to re-link pages I get this error –
Fatal error: Call to a member function get_var() on a non-object in /home/slimsc5/public_html/wp-content/plugins/wp-e-commerce-store-toolkit/store-toolkit.php on line 52
Any ideas? Im using the latest wordpress version and just downloaded your plugin from wordpress?
Michael Visser –
Hi stacie, I’ll be resolving this issue shortly.
Phil Dunton –
Trying to nuke an wp ecommerce update gone bad. (LATEST)
Installed this plugin but it fails with the following message:
“You do not have sufficient permissions to access this page.”
OS is Windows 7 Home Premium Logged on as administrator.
???
Phil Dunton
Tucson
Rob-K –
Do you have WP Firewall installed/activated? I often get this error when the firewall blocks an install or change to any core files.
Rob –
can this plugin delete a single product permanently??
Michael Visser –
Hi Rob, this Plugin will remove All Products permanently. You can configure which store details are removed.
Jeff Hughes –
I downloaded the plugin and then FTPed the file to the plugin folder and extracted. I went to activate the plugin but it did not appear in the list.
Also I looked in the folder and it was empty
Michael Visser –
Hi Jeff, thanks for raising that. Please download the Plugin from the following URL. I’ve updated the download link above.
http://wordpress.org/extend/plugins/wp-e-commerce-store-toolkit/
Gloria –
Hi there,
I encounter the same problem, activated the plugin but it doesn’t show up on the list and I’d just downloaded the plugin so it’s the updated version. Quick check: does WPEC have to be activated for this plugin to work?
eldiekenjewel –
Hi there,
Me too, although I´ve installed the latest version (1.8.1), I still can´t find it back in the menu. Any idea what can be done to use it anyway?
Michael Visser –
Hi Gloria, yes WP e-Commerce does have to be active as Store Toolkit hooks into the Products menu.
James Hall –
hi – i’m getting a fatal and a page of errors when i nuke everything. The errors look like this (partial):
Warning: array_diff() [function.array-diff]: Argument #1 is not an array in /home/jimfrank/public_html/wp-includes/taxonomy.php on line 1751
Warning: array_map() [function.array-map]: Argument #2 should be an array in /home/jimfrank/public_html/wp-includes/taxonomy.php on line 1755
Warning: array_diff() [function.array-diff]: Argument #1 is not an array in /home/jimfrank/public_html/wp-includes/taxonomy.php on line 1751
Warning: array_map() [function.array-map]: Argument #2 should be an array in /home/jimfrank/public_html/wp-includes/taxonomy.php on line 1755
Warning: Invalid argument supplied for foreach() in /home/jimfrank/public_html/wp-includes/taxonomy.php on line 1761
Fatal error: Call to undefined function wpsc_intermediate_image_sizes_advanced() in /home/jimfrank/public_html/wp-content/plugins/wp-e-commerce-store-toolkit/includes/release-3_8.php on line 194
Michael Visser –
Hi James, what Plugin version of WP e-Commerce are you using and is WP e-Commerce Plugin activated at time of nuke? Thanks. 🙂
Miguel –
Hi,
I’m having some kind of issue with my e-commerce plugin and can’t solve it.
My products page just doesn’t work, instead keeps returning this error:
– Fatal error: Call to a member function action() on a non-object in ………………../public_html/wp-content/themes/mystique/page.php on line 18
My line 18 of page.php has this code
action('before_primary'); ?>I tried to use Store Toolkit plugin to repair that error with the function ” Re-link WP e-Commerce Pages “, or if without any good result remove definitly e-commerce plugin and the aplly the nuke feature to remove the leftovers.
It turns that when I used the repair function, it just didn’t work too and returned this error message:
Fatal error: Call to a member function get_var() on a non-object in /……………/public_html/wp-content/plugins/wp-e-commerce-store-toolkit/store-toolkit.php on line 50
So Before I remove it definitly do you have any hint or sugestion?
Thanks in advance
Michael Visser –
Hi Miguel, there’s a bug in your Theme, instead of ‘action…’, change it to ‘do_action…’, then save and refresh. 🙂 As for the error on line #50 I’ll take a look at that, what version of Store Toolkit and WP e-Commerce are you using?
Honey –
Hi, I have been having the problem of ppl putting things in their shopping carts but not checking out, which has made some of my stock unavailable. In searching a fix to this problem I came upon a thread where you shared this plugin. I just downloaded it and cleared the claimed stock and it’s fixed! Thanks SO much!!
Michael Visser –
No problem Honey, you know I’m powered by beers… just saying.
http://visser.com.au/donate
NicoWeb –
Heeeeelp !
I’m running version 1.6.
I erased all products and tags… great BUT half of my categories are gone (over 150 from 300!). As the category importer doesn’t work properly (v2.8.4.3), I have to start over category importing almost manually…
🙁
Michael Visser –
Hi NicoWeb, is this still happening in the latest release? Would love to hear from you! 🙂
Jason Miller –
Currently developing a site and this plugin has come in very handy. So thanks for putting it out there. However, since we upgraded from wp-ecommerce 3.7 to 3.8.3 we’ve had some issues with the product nuke. It actually deletes some of my custom wp nav menu items that have the same name as the product categories. I didn’t fully investigate but I think maybe the term_id should be term_taxonomy_id in the delete where clause. Instead I commented out your delete block in the includes/release-3_8.php and used the following, which uses the wp_delete_post which is supposed to take care of all of the term relationships.
$product_sql = "SELECT id FROM " . $wpdb->prefix . "posts WHERE post_type = 'wpsc-product'";
$products_to_delete = $wpdb->get_results( $product_sql );
if( $products_to_delete ) {
foreach( $products_to_delete as $delete_me ) {
//echo $delete_me->id . ', ';
wp_delete_post($delete_me->id, true);
}
}
Michael Visser –
Hi Jason, good stuff, I’ll make the change and get a Plugin update on its way 🙂
Stephan Boehme –
Hi Michael….
FYI – I got a error after switch Nuke 1.5.4 to 1.5.5
Fatal error: Call to undefined function wpsc_get_major_version() in /is/htdocs/…./wp-content/plugins/wp-e-commerce-nuke/nuke.php on line 20
Michael Visser –
Thanks for the comment Stephan, I’ll patch that up now, I’m using that function to detect the current WP e-Commerce version after the existing method was rendered obsolete. Expect an update shortly 🙂