problem to delete all products in Prestashop

[LeoBundle]

Hello, I am facing a strange problem when deleting all products from the databases or even trying to delete them from within the store back office My home page is having strange problems, such as I see all the icons have become very large and the page has become strange The second problem is when adding a product, for example, it must have the product number ID 1 no the id with me in my store  become 7853 and This means that I have a number of products 7853 but i cant see this products i have problem i think in database file but i don't know how to fix this 

[Nickz]

Since when?

What does your logdata say, and strange files in your shop?
What php setting you use on which shop version and theme?

[LeoBundle]

3 hours ago, Nickz said:

Since when?

What does your logdata say, and strange files in your shop?
What php setting you use on which shop version and theme?

thank you for replay i'm use php 7.2 and theme 1.7.8 with version prestashop 1.7.8 and i'm uploaded example images i have 4899 products i want to delete all 4899 i'm use this code mysql To delete them quickly

SET foreign_key_checks = 0;

-- Delete all products
DELETE FROM ps_product;
DELETE FROM ps_product_shop;
DELETE FROM ps_product_lang;
DELETE FROM ps_stock_available;

-- Enable foreign key checks
SET foreign_key_checks = 1;

i'm use this code after product deleted i'm screen home page with image name after.png and image with name id you will see Product id 7849 

I think the ID Represents the number of products This is the first product I added after I deleted them from the databases 

 

Edited November 15, 2023 by LeoBundle (see edit history)

[ps8modules]

1 hour ago, LeoBundle said:

Hello, I am facing a strange problem when deleting all products from the databases or even trying to delete them from within the store back office My home page is having strange problems, such as I see all the icons have become very large and the page has become strange The second problem is when adding a product, for example, it must have the product number ID 1 no the id with me in my store  become 7853 and This means that I have a number of products 7853 but i cant see this products i have problem i think in database file but i don't know how to fix this 

Hi.

What was the reason for removing the products from the database? The products are stored in the base in 9 database tables. You should have used the Prestashop function in the product list to remove all products. To make the action faster, just delete the TRUNCATE table ps_category_product. TRUNCATE sets autoincrement to 1.

[LeoBundle]

2 hours ago, ps8moduly.cz said:

Hi.

What was the reason for removing the products from the database? The products are stored in the base in 9 database tables. You should have used the Prestashop function in the product list to remove all products. To make the action faster, just delete the TRUNCATE table ps_category_product. TRUNCATE sets autoincrement to 1.

thank you for replay  I delete products from the database because they are deleted quickly because I have more than 4924  

I installed an extension ps-cleaner and after install I tried it and deleted the products, but I also had a problem with the home page, which is that the pictures are too large I do not know the reason for this problem, and when I add a new product, I see that the product should become ID 1 Because I deleted all the products, I see something else. I see that the new product that I added is recent ID 7849 This indicates that there are products their number is 7849 But I don't see them

Edited November 15, 2023 by LeoBundle (see edit history)

[Nickz]

Looks like you are on course to make a brand new shop.
You might be better off with a different system though.

 

Where does the shop come from? What version numer do you use? 1.4, 1.5. 1.6 or 1.7?

[ps8modules]

Here the error is only with the autoincrement in the database and further with the image size setting.

When the mime calls @LeoBundle, I'll fix everything for free.

 

Edited November 16, 2023 by ps8moduly.cz (see edit history)

[LeoBundle]

5 hours ago, ps8moduly.cz said:

Here the error is only with the autoincrement in the database and further with the image size setting.

When the mime calls @LeoBundle, I'll fix everything for free.

 

thank you @ps8moduly.cz i'm resloved my problem and thank you guys

[LeoBundle]

5 hours ago, Nickz said:

Looks like you are on course to make a brand new shop.
You might be better off with a different system though.

 

Where does the shop come from? What version numer do you use? 1.4, 1.5. 1.6 or 1.7?

thank you @Nickz i'm resloved my problem