How to Delete One of the Two "Size" Blocks

[qiqi_lin]

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!

[Vimal Kumar]

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



Take a Database backup before delete it.

I hope it will help you!

[qiqi_lin]

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

[Vimal Kumar]

@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.

[qiqi_lin]

@Vimal Kumar 

Sent you the admin

Please help me to check it

Thank you so much.

[Vimal Kumar]

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

[qiqi_lin]

@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!

[Vimal Kumar]

@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.

[qiqi_lin]

@Vimal Kumar 

Can't find it 

But thank you all the same!

I will delete them and re-import.

[Vimal Kumar]

@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.