Change product url structure from database

[DARKF3D3]

I need to remove .html wrote at the end of product page url

To do this I went into "SEO & URLs" page and change:

{category:/}{id}-{rewrite}.html

To:

{category:/}{id}-{rewrite}

The problem it's that Prestashop don't let me save and show error:

Keyword "{id_product_attribute}" required for route "product_rule" (rule: "{category:/}{id}-{rewrite}")

This because PS 1.7 added mandatory {id_product_attribute} but actually on my url I don't have it because I come from PS1.6 where it wasn't mandatory and I don't want to add it.

 

Do you know if there's a way to change this field value from database?

[DARKF3D3]

Any help?

[Marco2020]

did you find a solution ? 

[DARKF3D3]

No, not yet.

[Michi001]

any solution for this?

I want to hide the ".html" also but in PS 1.7.7.1 i cannot save the changes.

What is the database Table for rewrite settings?

[peprv]

On 2/2/2021 at 1:28 PM, Michi001 said:

any solution for this?

I want to hide the ".html" also but in PS 1.7.7.1 i cannot save the changes.

What is the database Table for rewrite settings?

In ps_configuration you will see PS_ROUTE_product_rule

[Michi001]

On 2/4/2021 at 3:02 PM, peprv said:

In ps_configuration you will see PS_ROUTE_product_rule

Thank you! 👍