Php – How to get a list of product categories and their ID’s from Magento

e-commercemagentoMySQLPHP

I'm trying to import a large number of products from a DB into Magento. The DB has many different product categories, which I've recreated within Magento. However, when importing the products via a CSV, you must list the category ID rather than the name. Is there any way to bring up a list like the following:

id | category
1 | pies
2 | guns
3 | cars

The only way that I can see at the moment is to manually create a product 'Pie', 'Gun' etc and then export to CSV, but this will take a depressingly long time. Just as an aside – does anyone really truly understand all of Magento – it seems insanely complex?

Thanks

Best Answer

There's probably a easy way to do this using PHP / Magento code, but if you want to look directly at the database:

Try something like this:

SELECT entity_id AS categoryID, value AS categoryName
FROM catalog_category_entity_varchar
WHERE attribute_id=111

But attribute_id might be something other than 111 for you. Take a look at the table to see.

Related Solutions

Php – How to get products from a particular category in magento ecommerce

You basically load up the category, get the Product Collection and then filter appropriately.

$products = Mage::getModel('catalog/category')->load($category_id)
 ->getProductCollection()
 ->addAttributeToSelect('*')
 ->addAttributeToFilter('status', 1)
 ->addAttributeToFilter('visibility', 4)
 ->addAttributeToFilter('special_price', array('neq' => ""))
 ->setOrder('price', 'ASC')
 ;

Mysql – How to get a list of user accounts using the command line in MySQL

Use this query:

SELECT User FROM mysql.user;

Which will output a table like this:

+-------+
| User  |
+-------+
| root  |
+-------+
| user2 |
+-------+

As Matthew Scharley points out in the comments on this answer, you can group by the User column if you'd only like to see unique usernames.

Best Answer

Related Solutions

Php – How to get products from a particular category in magento ecommerce

Mysql – How to get a list of user accounts using the command line in MySQL

Related Topic