Its been a while since Ive used an online webshop (which I have not built myself) but in the past I did use CS Cart.
Its looking quite different to the system I used but even so, It was fairly powerful back then but still easy to manipulate.
I also spent some time with magento and CS Cart was just easier to work with for me at the time
I had a quick peek and it supports multiple languages, Danish already being one of them along with a wide range of payment processors.
Edit: Sorry, I forgot to add, it allows importing and exporting for various data sets.
I used to import our entire catalog which was created / maintained in FileMaker regularly, I also used to export sales data and bring it back into FileMaker, I just never got round to building an automated way of doing this
Thanks for you input. I will have a look at CS Cart. And since my customer is still leaning towards Magento I hope to hear more from our other friends here about
- Magento experiences
- Experiences with other - easier - leaner - more straight forward - platforms
Our internal FileMaker solution syncs to Prestashop and while Prestashop is easy to dive into it is also very messy - Just have a look at some of the source or just the CSS for the standard theme. It's very bloated, the code is hard to read, modules, themes and extensions often feel very sloppy and amateurish. That said, in hindsight Prestashop feels like the wrong decision for us, which is why we are looking for alternaitves right now. Since our website is already built with Wordpress, we lean towards WooCommerce right now, a Wordpress Shop Plugin. Thsi enables us to keep the overall site design and work from the same admin panel.
However the Wordpress database structure is more abstract and less straight forward - basically every item like post, page, and so on is a record in a post table only distinguishable by a post type field. You (and plugins you install) can register additional post types like products, product attributes, etc - these go into the same table. This is quite clean once you understand it, but I still have to figure a few things out and at first sight it's less obvious than fixed tables for products, orders, customers and so on.
On the other hand if you want a shop solution that looks good and works well out of the box, try Shopify. From a technical perspective this should be top-notch, as it is built with Ruby on Rails and looks to be done by competent people, great presentation as well. It provides a well documented API to create, read, update and delete product, orders, customers, etc - so the option for integration should be fine, maybe even better than direct SQL manipulation, considering FileMakers integrated SQL performance.
However it comes with a price tag - see their plans for more info. But this should be fastest and easiest solution to get you started.