Success Case: Optimizing V2 URLs for SEO and Compatibility
February 14, 2025
A customer inquired whether there was existing code to manage V2-style URLs, such as:
- https://...com/product_info.php?products_id=123
- https://...com/some_name-p-123.html?
They expressed concern that, without a straightforward way to add rewrite rules to the root .htaccess file, this could negatively impact search engine rankings.
The osCommerce support team responded by explaining that any name for a product URL could be set in the SEO Page Name field. They also provided an SQL command to automate naming:
UPDATE products
SET products_seo_page_name = CONCAT('some_name-p-', products_id, '.html');

This solution allows for efficient URL management, ensuring compatibility with search engine optimization strategies.