Skip to content

Instantly share code, notes, and snippets.

@versedi

versedi/prices_per_store.sql

Created December 2, 2016 11:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save versedi/1dfb6f863f2b39334f764b67c950e714 to your computer and use it in GitHub Desktop.
Save versedi/1dfb6f863f2b39334f764b67c950e714 to your computer and use it in GitHub Desktop.
Download ZIP
GetPricesPerStores-MagentoSQL
Raw
prices_per_store.sql
SELECT
CPE.sku,
CPED.value,
CPED.attribute_id,
CPED.store_id,
EAV.attribute_code
FROM
catalog_product_entity AS CPE
INNER JOIN catalog_product_entity_decimal AS CPED ON CPED.entity_id = CPE.entity_id AND CPED.attribute_id IN (75,76) AND CPED.store_id IN (1,2,3,4,5,14,15,0)
INNER JOIN eav_attribute AS EAV ON CPED.attribute_id = EAV.attribute_id
ORDER BY sku,store_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment