Admin Advanced Search: Search By Seo Name

Just tried to use Admin advanced search to find all products with "clone" in the SEO name.

I was disappointed to find there is no way to search based on keywords in SEO name !

This is very important to us as our staff sometimes forget to update the SEO name when cloning a product.

Unfortunately it is not possible in CS-Cart. You can use the following query in the phpMyAdmin

SELECT object_id FROM cscart_seo_names WHERE name LIKE '%clone%' AND type = 'p';

Thanks for the Sql command line. will do.

Correct, it is currently not possible, hence the "Feature Request".

Actually, this was not so much of a issue with older CSC v2 as the SEO name was not cloned with the other fields during product cloning. It was only when the clone was saved that the Seo name was auto-generated when the field was blank. Assuming the operator had changed the title of the product, the SEO name would be intrinsically unique.

Now in v4 the SEO name is auto-generated at the time of cloning, which results in near-duplicate SEO name with ....-clone tacked onto the end. Not a great idea!

As a feature request:

1. Admin Product Advanced Search by "SEO name"

2. Blank "SEO name" after product clone ... as per v2.x.x with SEO name auto generated only upon first save.

Not sure that CS-Cart team checks feature requests here. If so, I will be happy

Yes, being a community forum, you are probably right... and the uservoice requests only seem to get attention based on votes, so minor annoyances like this don get much attention.

Its still a wish, maybe there is a simple code change to create blank "SEO name" field at product clone ... as with SEO name auto generated only upon first save.

Yes, being a community forum, you are probably right... and the uservoice requests only seem to get attention based on votes, so minor annoyances like this don get much attention.

Its still a wish, maybe there is a simple code change to create blank "SEO name" field at product clone ... as with SEO name auto generated only upon first save.

You can delete all SEO names with 'clone'. CS-Cart will generate SEO name back based on product name at first necessity.
It is necessary to create .sql file in var/backups with the following content:

DELETE FROM cscart_seo_names WHERE name LIKE '%clone%' AND type = 'p';