Hi, I'm struggling with importing csv data into Products. >From previous posts I understand that "CSV import is not the direct opposite of csv Export", but I still can't get my head around how to import data that includes mandatory pick-list fields. I can do a text-only import OK, but can't get anything to work with look-ups.
e.g. As a test I try to import a single Product record CSV with the minimal mandatory fields: << Cost Price,List Price,Name,Type,Default UOM/Name,Cost Method 9.000,11.000,Minimal fields test product3,goods,Unit,fixed >> This doesn't work and gives me a server error. Can you give me any specific information about why this doesn't work? For look-ups do I need to use an ID instead of a name? It would be great if someone could give me a working one-line csv that will work as an upload into Products. Many thanks, Paul
