This product has been hidden. No one can see this product listing...

[Xtreme4U2NV]

For some reason, out of the blue, my store did this

"This product has been hidden. No one can see this product listing. Existing customers for this product can still see their orders."

I only have two items in my store, and when I click on either, that is written in red at the top.  Also, both items had two customer fields, both of which have disappeared.

Your thoughts?

[SMFHacks]

At the bottom of the view product page for the product there is a link called "[Hide Product]" when clicked will hide the product from customers.
To reshow it click on the Show Product link and it will be restored.

[Xtreme4U2NV]

At the bottom of the view product page for the product there is a link called "[Hide Product]" when clicked will hide the product from customers.
To reshow it click on the Show Product link and it will be restored.

Excellent, thank you.

Only thing is now, the two custom fields they each had have disappeared.

Here is a breakdown of what happened, which I think lead to this;

- originally I put the wrong paypal address, I had .ca instead of .com like it should have been.  So people were trying to pay blahblah@gmail.CA, not blahblah@gmail.COM
- two people tried to purchase items under wrong address, it would say processing but never went anywhere
- realized my mistake, changed the paypal address
- asked the two people to cancel their transactions and redo
- purchases worked
- today, for some reason, the payments were confirmed from their two first attempts, and once that happened, my two product went hidden, and their two custom fields disappeared.

And here we are now

[SMFHacks]

Hmm strange. The only way for a product to be hidden is if the togglehidden link is clicked and that is an admin level permission do you have any other admins?
Same for custom fields the only way for those to disappear is if they were deleted from the product.

You can check if they still exist for a product by doing the following query:
SELECT * FROM store_item_custom_field WHERE ID_ITEM = IDOFPRODUCTHERE

Replace IDOFPRODUCTHERE in the above statement with the product id.

[Xtreme4U2NV]

I have recreated the custom fields before I saw this post.