I'm working on a Magento store and I'm looking to import 22.000 products with a single solution.
I've written a Ruby wrapper for the REST API, it takes around 7 seconds to create a single product (visible in store, assigned to a product category, assigned to website and with one image)
The Ruby wrapper for the REST API is tested against a demo Magento store hosted on a DigitalOcean VPS with 2 CPU'S and 2GB RAM.
It would take a very long time to import the 22.000 with a single solution using the Ruby wrapper.
Since I'm not a very experienced programmer and don't have PHP or SQL knowledge, I'm wondering how a more experienced programmer would solve this.