Disable or remove Product Customization

[GoodWeb]

I've accidentally enabled Product Customization on some products and despite configuring the two fields to zero ('0') they still show a "Product Customization" tab when viewing the product. 

 

HOW TO I DISABLE THIS?!?

 

All I can think of is to edit the database directly, but that's can't possibly be the only or best way.

 

 

[endriu107]

Normally when you change value to 0 this fields should disappear, maybe you have some errors in database or your cache need to be cleared.

[GoodWeb]

That was a good suggestion I hadn't thought of, but it has not helped. I cleared browser cache and the PrestaShop cache options under Performance are not enabled (since the store is not live yet).

 

To be clear, no fields appear since they are set to zero, but everything else related to that tab still appears. (See image below)

 

Is something like this a PrestaShop bug or is it a Theme bug?

[rocky]

Check whether product.tpl in your theme uses the following code to check whether to display the customization tab:

			{if isset($product) && $product->customizable}

If it does, then check the ps_product and ps_product_shop tables in your database and make sure the "customizable" field is set to 0 for the product. If it is set to 1, the tab will still be displayed even if uploadable_files and text_fields is 0.

 

If it's set to 0 in the database and it's still not working, it must be a caching issue.

[GoodWeb]

Thanks. Turns out I had most products set to 1 in customizable column. I changed them to 0 using PHPMyAdmin.

[GoodWeb]

Actually, that didnt fix anything (yes, cleared caches too).

Looks like I'll have to edit that TPL file.

[rocky]

Did you change both the ps_product and ps_product_shop tables?

[GoodWeb]

Did you change both the ps_product and ps_product_shop tables?

I finally got around to revisiting this issue. You are right that I had to edit both tables.