No product found due to missing or invalid ID

No product found with the ID equal to [ID] 'woocommerce_api_no_product_found'

Issue:

A product update sent to WooCommerce has failed as the product was not found on the site by its internal WooCommerce ID.

Applies to:

woocommerce

Solution:

Products are linked from Stock2Shop to WooCommerce using the WooCommerce internal ID of the product and variant. When a product is not linked correctly, no updates will happen on the website. The link can be incorrect if any the following has occurred:

  • When the product initially tried to sync to the website, there was a queue error and the “Add” instruction was skipped without resolving the issue.
  • The product has been removed / changed on WooCommerce causing the IDs to change after S2S created or already linked to the product- You will need to resend the product to the website either by creating the product again or auto linking to a product that is already on the website.

Removing the product off your website and adding it from S2S:

  • Log in to S2S > Queue > Failed > Click 3 dots on failed item > View product to see which product you need to fix.
  • View the SKUs on the variant tab.
  • Login to WooCommerce backend > Products > Search for the SKUs that you just found in S2S with the error > delete all those SKUs off WooCommerce if you find any.
  • Go into the product in S2S and view channels tab. Queue Error > 3 dots > View Product > Channels* > click REMOVE ALL on WooCommerce links.
  • Save on the General Tab.
  • Skip any and all updates (failed) to do with the product that was already in the queue. A new ‘ADD’ to WooCommerce queue item will be added at the back of the queue.

Relink to existing product on website:

  • Log in to S2S > Queue > Failed > Click 3 dots on failed item > View product to see which product you need to fix.
  • View the SKUs on the variant tab
  • Log in to WooCommerce backend > Products > Search the SKUs that you just found in S2S with the error > Make sure the product is set up correctly as a variable/simple product. If the set up is not the same as S2S and your workflow is to create variable products from S2S, then you should rather delete the product and read the steps above.
  • Go into the product in S2S and view channels tab. Queue Error > 3 dots > View Product > Channels > click REMOVE ALL on WooCommerce links.
  • Save on the General Tab and Variant Tab.
  • Skip any and all updates (failed) to do with the product that was already in the queue. A new ‘ADD’ to WooCommerce queue item will be added at the back of the queue.