1 2 3 4 Previous Next 52 Replies Latest reply on Jun 21, 2017 5:46 AM by nrgsoft

    FileMaker Pro eBay and Amazon API

    filopastrymaker

      We are using FileMaker Pro to manage our orders and product data.

       

      We get orders from our own websites, eBay and Amazon.

       

      Currently there's a lot of copy/paste between browser and FMPro to consolidate all our orders.

       

      I am looking for a way to import the eBay and Amazon orders into FmPro. I already have the basic connection to the respective APIs as we use a PHP script run via a web browser to update stock quantities.

       

      Any help greatly appreciated.

        • 1. Re: FileMaker Pro eBay and Amazon API
          David Moyer

          Hi,

          can you use a query string URL to get this information?  If so, you can use a text field and the Insert From URL script step to automate checking the site.  I can provide an example of how I use it if you think it will be helpful.

          • 2. Re: FileMaker Pro eBay and Amazon API
            debbiecantley

            I would be really interested in how this could be achieved.  We are also ebay and amazon sellers, with large product database.  We are recreating our database using Filemaker and would be so pleased if we could also list products from it directly to ebay and amazon.  We do not need to do much more than push an initial listing. 

             

            Anyone able to suggest who could do this for us?

            • 3. Re: FileMaker Pro eBay and Amazon API
              David Moyer

              Hi,

              can you give an example of how you perform this operation manually?  That's where I need to start.  The thing I'm familiar with would look something like this:

              http://www.amazon.com/?query=findmyproduct&user=me

              • 4. Re: FileMaker Pro eBay and Amazon API
                debbiecantley

                At the moment we use a two step method. 

                 

                1. Our own product database which effectively 'creates' the product by input from various people to complete all necessary product information, categories, and images.

                 

                2. Linnworks - which is an inventory management system that lists to ebay/amazon and manages stock levels.

                 

                Our issue is the weak link between 1 and 2 - which is a csv file exported then imported.  The import to Linnworks is not simple and often throws up errors unless we are very careful, and listing from LInnworks to ebay and amazon is not quick either.  It is a clunky way of doing things, and I am trying to come up with a simpler quicker solution.

                 

                At present we enter all product data including images, title, description, etc into our database, we select the appropriate categories and detail required by ebay / amazon and we then export a csv file with the correct category IDs.  So instead of exporting a csv then importing I was wondering if it were possible to use the same field headers and link to the ebay api? likewise with Amazon.

                 

                Alternatively as a simpler solution, Linnworks do have an API, which might be an easier way to set this up.  Your views and help much appreciated.

                • 5. Re: FileMaker Pro eBay and Amazon API
                  David Moyer

                  I wonder what method filopastrymaker  uses.

                  Mmmm, filo.

                  • 6. Re: FileMaker Pro eBay and Amazon API
                    miler24

                    Another option that we've had a lot of success with is simply using ShipStation.  It'll connect to just about everything (including Ebay and Amazon) and you can easily import your orders via their API into your FileMaker solution.

                     

                    Eric

                    DocuWrx

                    • 7. Re: FileMaker Pro eBay and Amazon API
                      twelvetens

                      Hi Debbie,

                      I've done a fair bit of integration with Linnworks, and I've tended to use an ODBC connection, and ESS within Filemaker. The SQL Table layout that Linnworks is pretty logical (no EAV model like Magento etc), so it's actually pretty simple to work out where data from Filemaker needs to go.

                      • 8. Re: FileMaker Pro eBay and Amazon API
                        debbiecantley

                        Hi James,

                        Thanks for your reply - would you be able to take a look further at our current system and give me an estimate of what you would charge for an API with Linnworks?  I am new to this forum and to Filemaker, so not sure what protocol is?

                        • 9. Re: FileMaker Pro eBay and Amazon API
                          debbiecantley

                          Hi Eric,

                          Sadly we are in the UK and ShipStation does not cover Royal Mail integration, which is a shame as it looks fantastic software!

                          • 10. Re: FileMaker Pro eBay and Amazon API
                            miler24

                            We actually use ShipStation to bring in the orders and EasyPost to ship them.  EasyPost has Royal Mail integration.

                            1 of 1 people found this helpful
                            • 11. Re: FileMaker Pro eBay and Amazon API
                              twelvetens

                              Hi Debbie,

                              I've sent you a direct message.

                              James.

                              • 12. Re: FileMaker Pro eBay and Amazon API
                                nicolai

                                Linnworks seems to be a good bet.

                                 

                                I have done integration with Shopify using their REST API. It works pretty well with FileMaker, although relies on the free BaseElements plugin for communicating with web services. Amazon and Ebay have their own API, but can use the same technology.

                                 

                                If it does not work out with the other guys, feel free to get in touch with me.

                                 

                                Nicolai

                                • 13. Re: FileMaker Pro eBay and Amazon API
                                  filopastrymaker

                                  Thanks for the reply.

                                   

                                  I'm not sure if a query string URL can be used.

                                   

                                  Requester credentials are required to access the data via the API.

                                   

                                  An example in PHP for retrieving orders using the GetOrdersRequestType call is as follows:

                                   

                                  ***********************************************************************

                                  require_once 'EbatNs_Session.php';
                                  require_once
                                  'EbatNs_ServiceProxy.php';
                                  require_once
                                  'EbatNs_DataConverter.php';

                                  $session
                                  = new EbatNs_Session();
                                  $session
                                  ->setSiteId(3);
                                  $session
                                  ->setUseHttpCompression(1);
                                  $session
                                  ->setAppMode(0);
                                  $session
                                  ->setDevId('YOUR_DEV_ID_HERE');
                                  $session
                                  ->setAppId('YOUR_APP_ID_HERE');
                                  $session
                                  ->setCertId('YOUR_CERT_ID_HERE');
                                  $session
                                  ->setRequestToken('YOUR_TOKEN_HERE');
                                  $session
                                  ->setTokenUsePickupFile(false);
                                  $session
                                  ->setTokenMode(true);

                                  $proxy
                                  = new EbatNs_ServiceProxy($session, 'EbatNs_DataConverterUtf8');

                                  require_once
                                  'GetOrdersRequestType.php';
                                  $getordersrequest
                                  = new GetOrdersRequestType();
                                  $getordersrequest
                                  ->setCreateTimeFrom("2016-10-25T18:22:00.000Z");
                                  $getordersrequest
                                  ->setCreateTimeTo("2016-10-26T18:22:00.000Z");
                                  $getordersrequest
                                  ->setIncludeFinalValueFee("true");
                                  $getordersrequest
                                  ->setOrderStatus("Active");
                                  $getordersrequest
                                  ->setSortingOrder("Ascending");
                                  $getordersrequest
                                  ->setVersion("981");

                                  $response
                                  = $proxy->GetOrders($getordersrequest);

                                   

                                  ***********************************************************************

                                   

                                  The response is typically in xml format

                                  • 14. Re: FileMaker Pro eBay and Amazon API
                                    David Moyer

                                    I wish I could help.  I should learn PHP.  I can do this with .NET and web services.  Typically, the vendor, say FedEx, will have sample files you can use as a template to access their service via any of several different methods ... makes it easy.  Getting the response into FM and parsing the XML is probably the difficult part.  (I use Insert From URL into a text field, and parse the xml from there.)

                                    There are better parsing functions out there for XML, but here's one that will work in "easy" situations:

                                    Another custom function for text parsing

                                    1 2 3 4 Previous Next