how to get product id and sku in magento with SQL

mysql sql magento magento-1.7
Abude picture Abude · Feb 8, 2013 · Viewed 24.7k times · Source

i'm trying to get the product id and the SKU of each product in magento with SQL, i fount that the table catalog_product_entity has all the SKUs but no product id.

Answer

Domen Vrankar picture Domen Vrankar · Feb 8, 2013

entity_id is product's unique id so if you call $product->getId(); you actually get entity_id

The reason for that column name is that product is an EAV (Entity Attribute Value) model so product is an entity - standardized EAV entity identification column name but it can bring confusion...

And the query:

SELECT entity_id as product_id, sku FROM catalog_product_entity

Related questions

List of tables to safely truncate in Magento?

Is there a list of tables that can be safely truncated in Magento? By safely, I mean to preserve products. I've got a few but want to know if there are more: core_url_rewrite # Only safe if no custom …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More