How to add/update products from external apps

Hi,



I’m wondering if anyone here has created a little app to add/update products to CS-Cart from an external application, through odbc connection or webservices.



Any help will be greatly appreciated.



Regards,



Sam

that would be an awesome idea. :D…



EDIT: Sorry that’s not very helpful. I’m not sure how you would do it either. But maybe a little bump up could get you a reply :wink:



EDIT 2: Thinking about it i’m a bit of a pro with software dev haha. I could probably create it if no one has done it before.

[quote name=‘samhn’]Hi,



I’m wondering if anyone here has created a little app to add/update products to CS-Cart from an external application, through odbc connection or webservices.



Any help will be greatly appreciated.



Regards,



Sam[/QUOTE]



Hello,



We are using FileMaker to connect to MySQL via an ODBC-connector from Actual Technologies. Works perfectly, and we’re able to manage our books (products), pages, orders, users, etc. directly from FileMaker. This allow us to handle a huge number of orders, users and product updates very easily. Bulk updates and lists becomes so much easier as well.



However, we’re not creating new products in the MySQL database directly from FileMaker. Because when creating a product, there are many tables in which new rows are created through scripts in CS-Cart, and then linked together (for example cscart_products and cscart_product_descriptions). But we are able to use FileMaker to add new books to our catalog locally, and then export them to CS-Cart using scripts in FileMaker to create the right export format. After the products are created in CS-Cart, we can easily add/manage information through FileMaker/ODBC.



This has taken a lot of time, but it saves a ton when it’s done :slight_smile:



Best,

Per



http://AanDee.com - ร้านหนังสือออนไลน์

Thai Books, world wide delivery

[quote name=‘AanDee’]

This has taken a lot of time, but it saves a ton when it’s done :slight_smile:

[/quote]





That’s very interesting. Is there any info about implementing this or was this completely in house custom work?



What sort of setup in Filemaker is needed?

am interested as well if you could pin point clearly how this is done?