Requested Product Doesn't Exist (On frontend, even though product has a sku)

[johnmajor_johnm]

Hey there, I am not a developer, but I help manage my companies e-commerce site. We just migrated from M1 to M2. There were a lot of bumps in the road, but we're finally live. Unfortunately, there's still more issues to be had. For one, we pushed a bunch of products over from a custom version of filemaker and these products have custom options. However, when you select the custom options add to the cart, it says, "Requested Product Doesn't Exist." I've heard that this could be because it doesn't have a SKU, but it does have a SKU. I'm at a loss as to what could be causing this. It's only for about 20 or so products that we pushed recently.

Is there anything that could be causing this? I could send examples through DM, I just don't want to post them publicly. Our developer is working on it, but honestly there are so many problems, this is one I'm seeking outside help for.

[theMageComp]

Hello @johnmajor_johnm 

This should be the issue of sku only.

Did you confirm?

Ther are chaces of Products without sku in catalog_product_entity table in the database so try to assign SKU manually

[Rahul Gupta]

@johnmajor_johnm please check whether this product has been assign to any website, check its status, check its qty.

Thanks