My client is adding new products that won't be available for a few weeks. He is not checking the box for "available for sale" which is related to the field ProductLive = 0 (1 for live, available). All ok.
But, when the product is ready to be taken live, in the admin it is not available to edit. There is a blank area after a search, you can see that something should be there, but it can't be updated.
The link when clicking on update has this
and no ID to return a result.
I went into the mysql and changed ProductLive = 0 to 1 and then the product showed up in the admin.
But the client won't be able to take this step. He will need to access from within the cart admin.