4 Replies Latest reply on Oct 26, 2016 4:10 AM by debbiecantley

    using Filemaker to create ebay listings with variations through File Exchange

    LE

      Title

      using Filemaker to create ebay listings with variations through File Exchange

      Post

           I've been working with Filemaker Pro for a while now to create listings on ebay using File Exchange. I'm still a bit of a newbie at databases in general and this query may be a bit esoteric for most users so I'll try to speak in generalities.

           File Exchange uses a header (price, quantity, description, etc.) and fields in a .csv file to create large amounts of listings with relatively little task duplication (as creating hundreds of listings by hand can get repetitive). However, a recent feature of ebay is product 'variations' which are sort of sub-items of listed items that don't require an entire new listing, and instead just have a drop down for size, color, etc. variations of a similar product.

           My issue lies in the fact that, while I can finagle File Exchange to export normal ebay listings in an easily uploadable format that does not require any direct interaction with the spreadsheet, when using variations I'm running into some issues.

           Essentially, I'd like to use my current database of 'base' items and add the same variations to all of them, without having to create a new record for each items 'variation'.

           For example, say we sell Product A, B, and C, which all have the same variations for Blue, Black, and Green varieties. Normally, in order to export from Filemaker and get a new line for each variation of each item, a new record would have to be created for each line. This means four records per product, which, when you get into the hundreds or thousands of products the duplication starts to grow unwieldy. Coupled with the fact that we'd like the ability to change a single variation's quality, say the price, without having to deal with making sure every instance of that variation gets changed. So, I would like to imagine there is a way to simply insert the variation information (which is the same for every product) in the export under each item as it is currently being exported.

           Can anyone point me in the right direction where I might be able to learn how to do this? I will certainly explain more or offer an example if necessary. I simply don't know if something like what I'm imagining is even feasible with Filemaker as it currently stands.

           Thanks very much for your help.

           Cheers.

        • 1. Re: using Filemaker to create ebay listings with variations through File Exchange
          GuyStevens

               This would best be done by creating a related table 'Variations'.

               The idea is that you have a layout for your product. And then a portal for your variations. You can then add as many variations as you want per product.

               Then, if you create a list view based on the variations table you will get one record per variation, and every varation will be related to a product. So the correct product information can be displayed on every variation record.

               And all of this related information can be exported in your csv file.

               Your "Variations" table will need fields like:

               - ID - A number field set to auto enter a serial number
               - ProductIdFk  - A number field where we will store the ID of the product (if you enter data in here trough a portal on the products page the ProductId will be entered automatically.
               - Variation  -  A text field where you enter the variation.
               - And any other fields you might need

               The relationship needs to be like so:

               Products::ID-----[=]-----Variations::ProductIdFk

          • 2. Re: using Filemaker to create ebay listings with variations through File Exchange
            LE

                 Thanks so much! Using a portal on the layout did the trick. It seems so easy, I can't beleive I didn't think of it.

                 One minor thing, how do I control the order of the exported records? I have the portal sorted, the variation table itself sorted, and it still seems to export in the order the records were created. Is there a setting I'm missing somewhere or shall I just make sure I create the variations in the order I'd like them to be exported?

                 Again, thanks for your advice. I'll make sure to come here first before spending days trying to write excel macros to do the same thing, next time.

                 Edit: solved my own problem for once! Turns out the I simply had to check the 'Sort records' option under the relationship between the variations and the products. In case any one else was wondering...

            • 3. Re: using Filemaker to create ebay listings with variations through File Exchange
              GuyStevens

                   Another way would be to go to the variations layout, not the products layout, then sort and then export.

                   You could even make a script for this.

                    

              • 4. Re: using Filemaker to create ebay listings with variations through File Exchange
                debbiecantley

                We are looking for someone to help us with ebay/filemaker integration - is this something you could help with?

                We have variation products and we list to ebay/amazon.  WOuld love it if we could list directly from the Filemaker db.