Skip to content

Instantly share code, notes, and snippets.

@fbrnc

fbrnc/gist:4760571

Created February 12, 2013 06:11
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fbrnc/4760571 to your computer and use it in GitHub Desktop.
Save fbrnc/4760571 to your computer and use it in GitHub Desktop.
Download ZIP
Create sku to id lookup table (as csv)
Raw
gistfile1.sh
mysql -hHOST -uUSER -pPASS DBNAME -e 'select sku, entity_id from catalog_product_entity' -B | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > skuToId.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment