Skip to content

Instantly share code, notes, and snippets.

@manutheblacker
Last active October 10, 2023 08:19
Show Gist options
  • Save manutheblacker/8a6b5245946c3a769098812bb29113bf to your computer and use it in GitHub Desktop.
Save manutheblacker/8a6b5245946c3a769098812bb29113bf to your computer and use it in GitHub Desktop.
Exporting magento2 products details + webkul marketplace data
SELECT * FROM `marketplace_product`
INNER JOIN `catalog_product_entity` ON catalog_product_entity.entity_id = marketplace_product.mageproduct_id
INNER JOIN `catalog_product_index_price` ON catalog_product_index_price.entity_id = marketplace_product.mageproduct_id
INNER JOIN `marketplace_userdata` ON marketplace_userdata.seller_id=marketplace_product.seller_id
INNER JOIN `catalog_product_entity_varchar` ON catalog_product_entity_varchar.entity_id=marketplace_product.mageproduct_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment