2
Good morning, I have a database of approximately 40 thousand lines for each product one line.
I was using a catalog table (the same as category) where each item (product) that was inserted was intended for the x and y catalog, or only x, so the person added the product and marked in which or which catalogues it would appear.
The site would have the catalogues, where click and appear the products, similar to category, but would be more particular to the catalog.
It worked very well but due to the requirement of agility and import of advertisements (products) in great demand it was impossible to register one by one selecting catalog.
I removed this function and now everything is imported, since the product comes from a main platform always and there is no need to create twice the same product.
I want the system to create catalogs intelligently, even if the system gets a little "dumb".
My idea is, when importing for example 10 products, being that, 2 of them are like this:
Tennis Cord
Tenis Nike
The System identifies that there are equal words in the text, and groups.
Since I want a smart system, I don’t want it to create the catalog in the bank, but yes, when the select happens everything.
That is, a select to create the catalogs, where the person will click on top, and then another select to show the result.
You must have the Tenis result when you find these 2 items with equal text relation, so on if you find more, understood ?
In order not to get too messy since I have a lot of product and I want something kind of clever, it would be, in the end, he would identify the amount of similar names, and before creating the catalogues, if a count were made of those that repeated the most, and then yes, create the catalogues, for example 50 more repeated, not to be too redundant repeating different catalogues for the same items, but with something that, I did not lose items that had little score, since if it has very equal will rise in rank, and those with little equal may be single, and not redundant.
Whatever comes from code is welcome to start!
Related: https://answall.com/questions/1828/
– Costamilam
But why not create catalogues first and just search for them? You can schedule a task to run once a day or more if you need to, this task executes the code to create these catalogs, so it’s faster to query for users
– Costamilam
Because it was like this, it was already created and then searched for them, this method became inefficient, it is not a normal store, it is a project more by seo, the catalogue was created before and marked the link with the product at the time of creating the product or when non-existent the catalogue was created by an option together with the product, in an agile way, as a result the procedure is slow, I used everything that is technology like ajax and javascript that became impossible with the new importing mode, I need to create automatically only by the name of the products.
– Barack
Creating catalog by script would automatically have the same method as the query I want, only I don’t want it to be in the database, it has to be momentary, when the product is disabled, this catalog will no longer appear, I want to physically delete the catalog in the database, and only appear through the sql query.
– Barack
These are the products I will work on to complete what I want: https://www.cellsystem.com.br/home/index.php?p=listar_todos_products
– Barack