How do i upload products from a pricelist in .txt format

[Guest]

Hi every one. i have a problem too find a solution to upload my pricelist from my supplier, its in a .txt format and looks like this

 

Artikelnummer;Benämning;Lagersaldo;Tillverkarens Artikelnummer;Grupp;U-Grupp;A-Grupp;Pris(SEK)

1400116;Intel MS440GX Barebone;0;;Datorer - övriga märken;PC Övriga;Intel;5800.00

1406850;Server Intel ISP2150 19'' 4st Hot Swap HDD;0;;Datorer - övriga märken;PC Övriga;Intel;13353.00

1406851;Server Intel ISP1100 19'' 1U, 2*3.5''HD;0;;Datorer - övriga märken;PC Övriga;Intel;9000.00

1406852;Server Intel ISP4400 4way 4U, 5*3.5''HD,XEON;0;;Datorer - övriga märken;PC Övriga;Intel;40246.00

1406853;Server Intel SPSH4 10*1'' HD,4*XEON, max24GB;0;;Datorer - övriga märken;PC Övriga;Intel;41500.00

1406855;Server Intel ISP2250ALLX 2U 19'', S5000PAL, 1+0PSU;0;SR2500ALLX;Datorer - övriga märken;PC Övriga;Intel;11118.00

1406856;Server Intel SR2500ALLXR 2U 19'';0;SR2500ALLXR;Datorer - övriga märken;PC Övriga;Intel;10353.00

1406857;Server Intel SR1550ALSASR Barebone 1U, Rack, SAS;0;SR1550ALSASR;Datorer - övriga märken;PC Övriga;Intel;8780.00

1406898;Server Intel AD450NX 4*500Watt, 6*VRM,Pedestal;0;;Datorer - övriga märken;PC Övriga;Intel;72300.00

 

i want to have a software that can convert it so i can use it in easy populate.

 

can some one help me out ?

 

Regards Patrik

[♥geoffreywalton]

Just change the column headings to those required by EP.

 

Personally I'd write an excel macro to do it, guess you also need to apply a mark up to the price. Depending on how complicated the rules are an access db might be the way.

 

It is not difficult so happy hacking.

[Guest]

ok can you give me a clue too the headings then ? what shell it say ? just a example please it would be helpful

[♥geoffreywalton]

The clue is read the excellent EP documentation.

 

Download a file from EP and use those, deleting the columns you do not use/need.