cancel
Showing results for 
Search instead for 
Did you mean: 

How to Delete One of the Two "Size" Blocks

Highlighted

How to Delete One of the Two "Size" Blocks

I had imported the wrong size block, and then I imported the right one.

I thought the wrong one will be covered by the right one.

But they both appear on the product page. How to delete the wrong one of every product?

This is one of the product pages:

https://www.buyshowercurtain.com/pirate-seal-parrot-shower-curtain.html

 

Who can help me to solve the problem? thanks in advance!

 

9 REPLIES 9

Re: How to Delete One of the Two "Size" Blocks

Hi @qiqi_lin,

You can delete the wrong one from the admin.

 

Go to Admin->Catalog->Attributes->Edit Attribute (check the correct one size attribute)-> Delete it.

Then check the associated product options under:
Admin->Catalog->Products->Edit Product->Associated Product

Screenshot from 2019-11-06 14-29-10.png

Take a Database backup before delete it.

I hope it will help you!

----
Problem solved? Click Accept as Solution!
Highlighted

Re: How to Delete One of the Two "Size" Blocks

My Magento ver. 1.9.2.1, I can't find the Attribute appearing on product page from where you said.  

 

 

ab.jpg

Highlighted

Re: How to Delete One of the Two "Size" Blocks

@qiqi_lin 
Make sure that you have edit the correct attribute code.
Search once with name  in same grid.
It seems there are some duplicated product attributes.

----
Problem solved? Click Accept as Solution!
Highlighted

Re: How to Delete One of the Two "Size" Blocks

@Vimal Kumar 

Sent you the admin

Please help me to check it

Thank you so much.

Highlighted

Re: How to Delete One of the Two "Size" Blocks

Hi @qiqi_lin,

It was coming from custom options  from  products. I have removed the wrong one.

Now product details page is showing fine.
https://www.buyshowercurtain.com/pirate-seal-parrot-shower-curtain.html

Screenshot from 2019-11-07 08-24-26.png

----
Problem solved? Click Accept as Solution!
Highlighted

Re: How to Delete One of the Two "Size" Blocks

@Vimal Kumar 

 

I want to delete the wrong one of all products for Once.

There're thousands of Products. How to do that?

Thank you!

Highlighted

Re: How to Delete One of the Two "Size" Blocks

@qiqi_lin,

There is not any direct way in magento admin to delete the wrong one of all products for Once.

These are saved in following tables.

Product custom option information will get from below tables

  • catalog_product_option
  • catalog_product_option_price
  • catalog_product_option_title
  • catalog_product_option_type_price
  • catalog_product_option_type_title
  • catalog_product_option_type_value

If you are good in database then you can check mapping in the above tables.

  • catalog_product_option is the main table.

Or you can delete products and re-import.

I hope it will help you!

Please mark as solution if work for you, so it will help to others as well.

----
Problem solved? Click Accept as Solution!
Highlighted

Re: How to Delete One of the Two "Size" Blocks

@Vimal Kumar 

 

Can't find it 

But thank you all the same!

I will delete them and re-import.

 

Highlighted

Re: How to Delete One of the Two "Size" Blocks

@qiqi_lin 

Glad to help you!

BTW this table you can found in the database.
But it will be best if you can re-import products.

I hope it works for you!

Please accept as a solution so it will help to other as well.

----
Problem solved? Click Accept as Solution!