Multiple Customers or Products Import Problem


  • Default avatar
    fernando    
     13 years ago
    0

    Hi I have this line in my cvs file

    3,TEST03,Published,Coupon,Product,Percent,Overall,10,,Total,2,,,20100810,Customer,77,78,Include,7,1,No,No

    I'm sure that the ids of customers and products exists, but the error say invalid customer id. If I replace 77,78 by 77 and 7,1 by 7... all works fine

    Pls help!, I have the last PRO version

    Regards

    PS: Sorry but my ugly english
  • Your avatar
    seyi    
     13 years ago
    0

    Hi Fernando, i think the commas might be causing the problem as it is being used as a seperator. Try this:

    3,TEST03,Published,Coupon,Product,Percent,Overall,10,,Total,2,,,20100810,Customer,"77,78",Include,"7,1",No,No

    Where the quote is used to indicate a string within a column.
  • Default avatar
    fernando    
     13 years ago
    0

    Thanks,

    With these details the import was successfull, but Its a good idea to upgrade the documentation (CSV spreedsheet format), another key is generate the CSV file in ASCII format because the "quote" is diferent in UTF-8 format.


    Thanks a lot and have a nice day