Jump to content

Products are shown which doesn't exist


Recommended Posts

Hi

I have 4 product in front panel of my site, which don't have any information like Name, Price or Image!!! in the back panel and Catalog section, there aren't exist too! but it shows on my front end!

There are some products with ID 391-393-394-397 but in front end 392-395-396 are being shown without any information While these aren't exist in Catalog!

 

Whats the problem? and why it was happened?

How can I fix it and delete products from my front end?

01.jpg

02.jpg

Share this post


Link to post
Share on other sites

The products were not removed correctly.
There are two main tables for products in the database. ps_product and ps_product_shop and a table with the texts ps_product_lang.
Find out if there are problematic product ids in the ps_product_shop table.

There can also be product ids in the ps_category_product table.

Edited by D. Tengler (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites
6 hours ago, D. Tengler said:

The products were not removed correctly.
There are two main tables for products in the database. ps_product and ps_product_shop and a table with the texts ps_product_lang.
Find out if there are problematic product ids in the ps_product_shop table.

There can also be product ids in the ps_category_product table.

If I delete them in those tables, does this problem(showing deleted products) fix?

 

Share this post


Link to post
Share on other sites
On 11/30/2020 at 3:39 PM, D. Tengler said:

Yes

It's happened again and no product has been deleted by anyone!

What's the problem and why does it happen?

How can I prevent this issue again?

Share this post


Link to post
Share on other sites
3 hours ago, D. Tengler said:

And you don't have a Cron running?

Any automatic product updates from a feed?

Yes I don't have any of them.

There is a situation, that I sometimes get signed out  all of a sudden by the server. Is it possible that issue connect to this case?

Edited by IFTHEN (see edit history)

Share this post


Link to post
Share on other sites

I explain everything, but if you have any question, ask it I will answer it.

On 12/3/2020 at 4:17 PM, WebSoft said:

Hi.

Your case needs further investigation.
It is not possible to identify the problem based on the information provided.

 

Share this post


Link to post
Share on other sites

This is exactly the case where targeted advice cannot be given.
Why is this happening?
The problem can be caused by x things and no one wants to ask about x things.
Your problem can be solved by a professional in a few minutes.
You can try to put your problem in the job section.

https://www.prestashop.com/forums/forum/235-job-offers/

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More