Jump to content

Change product url structure from database


Recommended Posts

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?

Share this post


Link to post
Share on other sites
  • 2 weeks later...
  • 8 months later...
  • 11 months later...

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?

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
  • 4 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More