title: How to get a list of product categories and their ID's from Magento?
body: <p>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:</p>
  
  <p>id | category<br>
  1 | pies<br>
  2 | guns<br>
  3 | cars</p>
  
  <p>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?</p>
  
  <p>Thanks</p>