Announcement

Collapse
No announcement yet.

Problems Importing CSV File

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    Problems Importing CSV File

    Hi All,

    Sorry if I've posted this in the wrong area, I'm new on here so hope its in the right place!!

    I was hoping someone might be able to help me with importing a flat csv file. Its all working fine but it keeps creating new categories on the website rather than using existing ones. I am matching the exact path of the existing categories using a | to seperate the categories......

    Any help would be very much appreciated!

    Chris
    Tags: None
    #2
    Can you post a few lines of your import file?

    Comment

      #3
      I cant at the mo as I'm at work but will try and get something up here later....

      Comment

        #4
        Help still needed!!

        Hi Again,

        I hope I have now managed to attach a zip file with a sample of the csv upload flat file which I am having a problem with.

        Any help/advice would be much appreciated!

        Chirs
        Attached Files

        Comment

          #5
          There are a number of errors in the file.
          1. The column header in column AC:
          'Use External Data
          Actinic Business/ Designer Only.'
          has a line feed/carriage return in it.
          2. The 'Image Filename' in column R is invalid - it is 0 (needs to be a valid image file type)
          3. The 'Minimum Quantity Orderable' needs to be defined and at least 1

          Also make sure you have 'Auto Generate Product References' unchecked.
          Additionally, remember that you can delete all fields that are not used - defaults will be used.

          A working version of your file is attached that works fine and doesn't duplicate any sections or products.
          Attached Files

          Comment

            #6
            Great, thanks v much - will give that a go!!

            Chris

            Comment

              #7
              Another problem is that Section Text column has spaces either side of the delimeter

              you have " | "

              I think it should be "|"

              which is why it is creating new sections.
              Elysium:Online - Official Accredited SellerDeck Partner
              SellerDeck Design, Build, Hosting & Promotion
              Based in rural Northants

              Comment

                #8
                Hi guys,

                Tried the new upload file and also with no spaces either side of the delimiter and its still creating new sections and I cant understand why....

                I have checked the spelling of the section over and over and matched the case format etc any other ideas??

                Thanks for the help...

                Chris

                Comment

                  #9
                  Did you try the file I attached above as a test?

                  Comment

                  Previous template Next
                  Working...
                  X