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

Modified on Sat, 03 Jun 2023 at 07:19 PM

Magento products can be unlinked from Channel items via a database query. This way, you can also remove items from the M2E Pro Listing while keeping them active on the Channel.


To unlink Magento products from Channel items, follow the instructions below:

  1. Find out the Listing ID and Product ID.
  2. Once you know these details, perform the query: 
    UPDATE m2epro_listing_product mlp SET mlp.status = 0 WHERE mlp.listing_id = #listing id # AND mlp.product_id = #pr ID#;
  3. Remove the Not Listed products from the M2E Pro Listing.

The query will set the product to Not Listed status in the M2E Pro database. The Module will lose the connection with the Channel for the product, and you can safely apply the Stop/Remove from Listing action. It will not affect the item on the Channel.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article