Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Bulk delete of product options

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design
 
Thread Tools Search this Thread
  #1  
Old 02-23-2015, 06:25 PM
  beetlejuice's Avatar 
beetlejuice beetlejuice is offline
 

eXpert
  
Join Date: Apr 2007
Posts: 251
 

Default Bulk delete of product options

I have a store where I need to be able to delete approx 2500 products and their respective options and variants.

I understand once you delete the options the variants will disappear, but is there a quick way of a "bulk" delete of all product options?

I was hoping that in the product export csv there was a column titled Options that I could then just N to all, but not so lucky

Any suggestions?

Cheers

Greg
__________________
XCart 4.5.4, 4.6.1, 4.64 stores
Many, many mods from Altered Cart
XCart Mods Reboot template
The XCart Store Templates and Mods
WCM CDSEO Pro
BCSE Rewards Points and Gallery Mods
and a few others
Reply With Quote
  #2  
Old 02-23-2015, 06:44 PM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,078
 

Default Re: Bulk delete of product options

If you need to delete these products then just delete them - this process deleted absolutely everything related to the products info - images, options, variants, detailed images, reviews, etc.
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote

The following user thanks cflsystems for this useful post:
beetlejuice (02-23-2015)
  #3  
Old 02-23-2015, 06:49 PM
  beetlejuice's Avatar 
beetlejuice beetlejuice is offline
 

eXpert
  
Join Date: Apr 2007
Posts: 251
 

Default Re: Bulk delete of product options

Hi Steve

Sorry didn't explain myself properly, I need to keep the base product just delete all the options and variants. Customer wants to remove options etc and have all options showing to the customer in the product list. In other word he wants the customer to not have to go into each product to find out there are further options, wants to take a couple of steps out of the ordering process.
So I thought, lets delete all options etc, then once back at the base number, clone each product as many times as necessary and change necessary details where applicable to duplicate the old options and variants.

Thanks for replying so quickly
__________________
XCart 4.5.4, 4.6.1, 4.64 stores
Many, many mods from Altered Cart
XCart Mods Reboot template
The XCart Store Templates and Mods
WCM CDSEO Pro
BCSE Rewards Points and Gallery Mods
and a few others
Reply With Quote
  #4  
Old 02-23-2015, 06:54 PM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,078
 

Default Re: Bulk delete of product options

You can do products search, select all you want to modify, click on modify selected and go from there - the bulk modify may work for bulk delete although not sure.
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #5  
Old 02-23-2015, 06:59 PM
  beetlejuice's Avatar 
beetlejuice beetlejuice is offline
 

eXpert
  
Join Date: Apr 2007
Posts: 251
 

Default Re: Bulk delete of product options

Yeah thought of that, but it's a few pages of products to go through to do it that way provided it works. Thought there may have been a option with the product csv file being able to import it with no options etc, sounds like that's not an option though.

ah well off to XCart's back end and try your suggestion,

Thanks again Steve
__________________
XCart 4.5.4, 4.6.1, 4.64 stores
Many, many mods from Altered Cart
XCart Mods Reboot template
The XCart Store Templates and Mods
WCM CDSEO Pro
BCSE Rewards Points and Gallery Mods
and a few others
Reply With Quote
  #6  
Old 02-23-2015, 07:01 PM
  cflsystems's Avatar 
cflsystems cflsystems is offline
 

Veteran
  
Join Date: Apr 2007
Posts: 14,078
 

Default Re: Bulk delete of product options

Yes there is no option in the import file to delete. Although there is an option on the import screen to delete all of whatever type you are importing... but this will delete all not just the products in the import file
Good luck
__________________
Steve Stoyanov
CFLSystems.com
Web Development
Reply With Quote
  #7  
Old 02-24-2015, 02:43 AM
  beetlejuice's Avatar 
beetlejuice beetlejuice is offline
 

eXpert
  
Join Date: Apr 2007
Posts: 251
 

Default Re: Bulk delete of product options

Update for anyone else

Because each product option has a different class you can't bulk delete, so it's going to have to be one by one for 2500 products.

Has to be another way, that's just plain unmanageable.

Any suggestions, even at PhpMyAdmin level?

Cheers

Greg
__________________
XCart 4.5.4, 4.6.1, 4.64 stores
Many, many mods from Altered Cart
XCart Mods Reboot template
The XCart Store Templates and Mods
WCM CDSEO Pro
BCSE Rewards Points and Gallery Mods
and a few others
Reply With Quote
  #8  
Old 02-27-2015, 12:37 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline
 

X-Guru
  
Join Date: Dec 2010
Posts: 6,373
 

Default Re: Bulk delete of product options

Hi Greg,

Please check if your X-Cart version has this page:
http://demo.x-cart.com/demo/admin/tools.php#cleardb

It allows you to tick just the "Product Options" checkbox in the "Remove data" section and drop all data associated with product options.
__________________
Alex Solovev,
Qualiteam

---

User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote

The following 2 users thank qualiteam for this useful post:
beetlejuice (02-27-2015), cherie (03-05-2015)
  #9  
Old 02-27-2015, 01:57 AM
  beetlejuice's Avatar 
beetlejuice beetlejuice is offline
 

eXpert
  
Join Date: Apr 2007
Posts: 251
 

Default Re: Bulk delete of product options

Hi Alex

Yes it does woohoo

Time to back up beforehand, then give it a whirl.

Thank you so much, after 3 days I'm only 1/4 way through.

EDIT ***** Worked like a charm******

Thanks again Alex

Cheers

Greg
__________________
XCart 4.5.4, 4.6.1, 4.64 stores
Many, many mods from Altered Cart
XCart Mods Reboot template
The XCart Store Templates and Mods
WCM CDSEO Pro
BCSE Rewards Points and Gallery Mods
and a few others
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 02:49 PM.

   

 
X-Cart forums © 2001-2020