Products after deleting categories

A question for you.

If i delete a category with products inside... what happen after that to the products? Are they deleted too?

The products aren't deleted. However, the link with this category is removed.
I looked at the code and there seems to be an error there. Right now if you do so, a proper link to the root category won't be created automatically and you won't be able to see the product in the listing. You should change the code to in the file administrator/components/com_hikashop/classes/category.php near line 260. That way, a new link will be automatically created to your main "product category" for all the products which had only a one link to the category you deleted.
Another solution would be to add another category in the products before deleting the category. The link to the deleted category will be removed but the link to the other category will still be there and no additional link will be added.

Sorry, but after editing the file, those products are still dissappeared.

Don't you see them under the main product category ?

I tried on my end with the modification I told you and it worked for me.

Sorry, but noyhing appears. No matter what filter configuration I use.

The behaviour after editing that php is as you described. Products are relinked to another category, but the products that dissappeared at category deleting at previous to php edition have been lost.

Curiously, if i look for those products through joomla search engine, they still are there, but nothing appears at the backend.

May you upload that php file in order to download and try it?

Also, i´d like to know how to set a main "product category" for all the products, i am not sure what are you talking about.

Yes, the products already deleted before changing the code won't appear in the back end as they need to be linked to a category for that, but their data is still there. The only way to have them back will be to go in your database and change some data. In the table hikashop_product_category, in the column product_id search for the id of your missing product. If you find an entry with a category_id which is 0, change the category_id to the id of the category you want it under. If you don't see any entry for your product, you have to create a new one for it.
Then you will see your product again on the back end.

Ah, something I didn't think of. You could try to edit a product and in the URL change the cid value to the id of the product you want to edit.

For example, if the missing product has the product_id 5. You could edit another product and replace &cid=2 (if 2 is the id of the other product) by &cid=5 and you will be able to edit the product and add another category to it so that it's again visible in the listing.

Too late .

I do not need those products anymore, they were only testing products. I want to erase all my previous products in order to create new ones.

I tried to delete the product entries in database. I am not any kind of database nor squl expertise, but i tried erase them using common sense and your previous indications.

I proceeded this way:
- at hikashop_product_category: i listed all entries in product_id field and deleted them.
- at hikashop_product: i listed all entries in product_id field and also deleted them.

As a result, now all those testing products has dissappeared from searching results, but now i got an empty product in my backend with a curious behaviour: i can´t delete it and if i try to edit it, a new product is created with those new settings and this blank products remains.

I guess that i need to delete something more, but i do not know what.

Maybe you had variants on those products ? If so, you will also have to delete the variant entries (in hikashop_product search on the column product_parent_id for the id of your deleted products).

Yes, one of those products has variants.
I deleted entries at hikashop_product on product paren_id and at hikashop_variant on variant_product_id.
The blank product still remains.
¿Could i send you the sql file? I am sure you have further analysis capabilities to discover what´s happenning.

It's easy to find the culprit. Select the product and click on the edit button. On the edit page of the ghost product, if you put your mouse over the title "Products" you should see in the URL displayed at the bottom of your browser the id of that product. Then, you just have to search for that id in the product table and remove it.

As you say, the url says "product_id=o".
But if i go to hikashop_product, product_id, there is nothing inside. No entries.
I created a new product to check it, and this new product appears, but nothing with id=o.

ah, I think I know. You must have an entry in hikashop_product_category with a product_id to 0. You should remove it.

Sorry, but there is nothing related to products in "hikashop_category".

The only two options related to id are "category_id" and "category_parent_id".

The only one with an entry marked with id=0 it´s "category_parent_id".

I wanted to say hikashop_product_category.

There was only a product there, but despite the url link said that id=0, this product had id´s different from 0. After deleting it, ghost product has been erased. I am not sure about what happened, but now the ghost one it´s gone.

Ah ok the link wasn't pointing to any product. That's indeed an alternative to the problem
Glad you found it.