Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

How to add/update products from external apps Rate Topic   - - - - -

 
  • samhn
  • Junior Member
  • Members
  • Join Date: 10-Sep 09
  • 15 posts

Posted 20 December 2009 - 01:04 AM #1

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

 
  • jbenitos
  • Senior Member
  • Members
  • Join Date: 09-Dec 09
  • 173 posts

Posted 20 December 2009 - 11:26 AM #2

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 ;)

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.

 
  • AanDee
  • Junior Member
  • Members
  • Join Date: 18-Jul 09
  • 6 posts

Posted 11 March 2010 - 10:06 AM #3

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


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 :)

Best,
Per

http://AanDee.com - ร้านหนังสือออนไลน์
Thai Books, world wide delivery

 
  • JB_1975
  • Member
  • Members
  • Join Date: 24-Feb 10
  • 70 posts

Posted 06 May 2010 - 03:58 PM #4

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



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?

 
  • ghgames
  • Member
  • Banned
  • Join Date: 24-Jun 10
  • 61 posts

Posted 06 October 2010 - 08:23 AM #5

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