It is possible to programmatically import data into Drupal. Data can be imported from a script that uses Drupal Node API.
You would want to programmatically load data into Drupal where you have a regularly updated list of products, where data is sourced from an external database or where you are doing a migration from another system.