How to unmap listed eBay item from Magento product in database via query

If you list a Variational product on eBay and sold at least one Child Product, you won't be able to change variations for the product. In case M2E Pro sends a changed set of variations, eBay returns the error.

So, the workaround was implemented: variations are sent as Out of Stock. This was made to avoid the error.

You can unlink Magento products from eBay items following instructions below:

  1. First, you find the Listing ID and Product ID
  2. Once you know these details, please perform the following query: UPDATE m2epro_listing_product mlp SET mlp.status = 0 WHERE mlp.listing_id = #listing id # AND mlp.product_id = #pr ID#;

The query will set the product to Not Listed status in the M2E Pro database. M2E will lose the connection with eBay for the product and you can safely apply the Stop action. It won't affect the item on eBay.

After that, you can change the item on eBay and in Magento as you need and import the item into Unmanaged (3rd party) listings anew. After that, you can map the item to Magento product and move into M2E Listings again.

#map item