5 Replies Latest reply on Jan 16, 2012 2:24 PM by Sorbsbuster

    help import help

    tommytowbar

      Title

      help import help

      Post

       Hi

          i have to import some products all works well but have some products with same product code and it write the same description for all the last product name is there a simple to stop it doing this

       

       

      Andy

      filemaker pro 11

        • 1. Re: help import help
          philmodjunk

          Can you describe that in more detail? Don't understand exactly what is happening when you say "it write the same description for all the last product name".

          What import options did you specify? Is this adding new records to those already present in your database. Did you enable auto-enter options during the import?

          Anything more that you can tell us may help us to help you.

          • 2. Re: help import help
            Sorbsbuster

            Why would you have products with the same product code, but which required a different description?

            • 3. Re: help import help
              tommytowbar

               hi

                 we supply towbars and have the same product code  for different  manufacture eg below

              Citroen
                Berlingo Multispace (Inc 02-08) 98-08   CT4098   1100 70  Pre Mark 60 A 18 148.00  
                Berlingo First Multispace 08-   CT4098   1100 70  Pre Mark 60 A 18 148.00  
                Berlingo Van (Inc 02-08) 96-08   CT4098   1100 70  Pre Mark 60 A 18 148.00  
                Berlingo First Van 08-   CT4098   1100 70  Pre Mark 60 A 18 148.00  
              Peugeot
                Partner Combi (Inc 02-08) 96-08   CT4098   1100 70  Pre Mark 60 A 18 148.00  
                Partner Origin Combi 08-   CT4098   1100 70  Pre Mark 60 A 18 148.00  
                Partner Van (Inc 02-08) 96-08   CT4098   1100 70  Pre Mark 60 A 18 148.00  
                Partner Origin 08-   CT4098   1100 70

              we  would like to update the above information hope this helps

               

              Andy

              • 4. Re: help import help
                philmodjunk

                And where does the "description" come from? a related table?

                Or are you doing an update import specifing matching on the product code field?

                Either way, as Sorbuster has pointed out, if you want different descriptions, you should use different product codes for each, not the same. If this is an externally supplied code (not one you can change) then you should add your own interal product code to be used to distinguish between the different manufacturers.

                • 5. Re: help import help
                  Sorbsbuster

                  You could make the code that you use (for example): 'Peugeot CT4098', to make it different from another part number, 'Citroen CT4098'.  But are they different?  Or is a CT4098 always accurately described as:

                  1100 70  Pre Mark 60 A 18 148.00

                  ...and does that CT4098 fit both Peugeot and a Citroen?