Joe Germann Posted October 28, 2009 Share Posted October 28, 2009 We currently manage all of our products (>10,000 with >3100 online) and product categories (220) via a Filemaker Pro application with an ODBC interface to an OS Commerce database. It works very well and totally eliminates the need to use a non-volume oriented product interface or to rely on file imports/exports. We can manage 100% of our products, product categories, customers, etc. locally on our own in-house database system and then directly manage and interact with the OSC database without using any of the OSC admin tools. It's quite slick.I have just begun an evaluation of PrestaShop and was wondering if anyone has any experience doing the same or similar thing; driving PrestaShop from an external database application, like Filemaker? I am NOT talking about doing exports/imports, I am only interested in direct ODBC database-to-database communications. I have already set up an ODBC link and can read and write the PrestaShop database from Filemaker Pro using the same structure as I do with the OSC package but to turn this into a usable package I need to understand a lot more about the PrestaShop database structure.Are there good references on the PrestaShop database design and functionality? I am most interested in knowing what the fields in each of the tables are. How these fields operate and/or are expected to operate with each other.I am sure that I can reverse engineer it, but it would be a lot better and less prone to error if I had some good documentation to go by.Thanks,Joe Link to comment Share on other sites More sharing options...
nikmagnus Posted November 21, 2010 Share Posted November 21, 2010 Hi there,I'm looking to do this too: drive the prestashop front-end from Filemaker.Have you had any luck with this?Do you have any resources that you could share to help me set this up?I have the OBDC link communicating with my localhost prestashop.Thanks, Nik Link to comment Share on other sites More sharing options...
Joe Germann Posted November 21, 2010 Author Share Posted November 21, 2010 Hi Nik,I have a fully integrated Filemaker Pro front end and part of the back end completely operational and in production use. We have also implemented (under test) multiple Prestashop stores. We manage all categories, products, SEO things, images, etc. completely from FMP. Our FMP package is a lot more than just talking to Prestashop, it is our business operational world. The software contains full image processing for handling the funky way Prestashop handles images as well as linkage to Quick Books Pro.The Filemaker based package we have is quite powerful but not ready for external use. I am completing the integration into multiple stores and also completing the shopping cart and order handling with Prestashop. I have the code partitioned into public code and private code sections so that we can hand out public pieces while maintain our IP in the private code sections.Tell me more about yourself, your business, and what you might want to do with my software. You may send me a Private Message.Regards,Joe 1 Link to comment Share on other sites More sharing options...
Mike Kranzler Posted May 3, 2012 Share Posted May 3, 2012 Hi Joe, and Nik, You may want to check out Store Manager for PrestaShop. It comes with a 30-day free trial and their team is very active here on the forums if you have any issues. I hope this helps. -Mike Link to comment Share on other sites More sharing options...
zaxxzaxx Posted September 25, 2012 Share Posted September 25, 2012 (edited) Hi Joe. I've a question. Do you sell this Filemaker front end? Thanks a lot Alex Edited September 25, 2012 by zaxxzaxx (see edit history) Link to comment Share on other sites More sharing options...
davewalschot Posted November 1, 2012 Share Posted November 1, 2012 seems an old thead, anybody having an update here? Thanks! Link to comment Share on other sites More sharing options...
blackwinds Posted August 10, 2015 Share Posted August 10, 2015 i also need this anyone selling ? Link to comment Share on other sites More sharing options...
Browserwerk Posted April 4, 2016 Share Posted April 4, 2016 We need this too. So if there is any possibility to buy it, please contact us. Thanks! Link to comment Share on other sites More sharing options...
f.kwakkenbos Posted August 10, 2016 Share Posted August 10, 2016 (edited) We have a working solution for managing your Prestashop shops from Filemaker. Functionalities like: Product management Product combinations management Price management Stock management Purchase management Order management Category management Shop management Please contact us by looking at our website: http://www.flooris.nl It works from a Filemaker Server and communicates with the Store Manager Web API from which we run some PHP Workers to synchronize data between Prestashop and Filemaker. Edited August 10, 2016 by f.kwakkenbos (see edit history) 1 Link to comment Share on other sites More sharing options...
kentcheung2000 Posted September 16, 2016 Share Posted September 16, 2016 Can you add or delete products through FileMaker, including images, to prestashop? Link to comment Share on other sites More sharing options...
f.kwakkenbos Posted September 19, 2016 Share Posted September 19, 2016 Yes that is possible. We have also a solution for managing images inside the Product description. Link to comment Share on other sites More sharing options...
mcenci Posted November 11, 2016 Share Posted November 11, 2016 Yes that is possible. We have also a solution for managing images inside the Product description. Can you tell us a little bit more about this solution? I'm new to prestashop and I'm using Filemaker Server. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts