Skip to content

Instantly share code, notes, and snippets.

@Schrank

Schrank/Untitled 1.csv

Created June 18, 2020 11:24
Show Gist options
  • Save Schrank/67dbbea4ff232716f48ec6571fffa14c to your computer and use it in GitHub Desktop.
Save Schrank/67dbbea4ff232716f48ec6571fffa14c to your computer and use it in GitHub Desktop.
Download ZIP
Export magento products as CSV from database (Build with Libre Office)
Raw
Untitled 1.csv
attribute_id attribute_code attribute_type
68 cost decimal =CONCATENATE(B2;"_default.value AS ";B2;"_default,";B2;"_store.value AS ";B2;"_store,") LEFT JOIN catalog_product_entity_ =C2 AS =B2 _default ON =B2 _default .store_id = 0 AND =B2 _default.entity_id = p.entity_id AND =B2 _default.attribute_id = =A2 LEFT JOIN catalog_product_entity_ =C2 AS =B2 _store ON =B2 _store. store_id = 1 AND =B2 _store.entity_id = p.entity_id AND =B2 _store.attribute_id = =A2 =TEXTJOIN("";1;E2:AL2)
64 price decimal =CONCATENATE(B3;"_default.value AS ";B3;"_default,";B3;"_store.value AS ";B3;"_store,") LEFT JOIN catalog_product_entity_ =C3 AS =B3 _default ON =B3 _default .store_id = 0 AND =B3 _default.entity_id = p.entity_id AND =B3 _default.attribute_id = =A3 LEFT JOIN catalog_product_entity_ =C3 AS =B3 _store ON =B3 _store. store_id = 1 AND =B3 _store.entity_id = p.entity_id AND =B3 _store.attribute_id = =A3 =TEXTJOIN("";1;E3:AL3)
65 special_price decimal =CONCATENATE(B4;"_default.value AS ";B4;"_default,";B4;"_store.value AS ";B4;"_store,") LEFT JOIN catalog_product_entity_ =C4 AS =B4 _default ON =B4 _default .store_id = 0 AND =B4 _default.entity_id = p.entity_id AND =B4 _default.attribute_id = =A4 LEFT JOIN catalog_product_entity_ =C4 AS =B4 _store ON =B4 _store. store_id = 1 AND =B4 _store.entity_id = p.entity_id AND =B4 _store.attribute_id = =A4 =TEXTJOIN("";1;E4:AL4)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment