CVS import how ?

[merlin_nl]

Hi all,

I currently have a webshop that was build by a former partner of ours, but it was build in PHP4 and with no room for updates or customization, so it is time to rebuild
As I was looking arround, my eyes came onto prestashop, which looks like a very good system and I am interrested in using it.

At the moment most things are looking good, and some things I have to modify (themes, blocks, that sort of things)
But currently I have the big import problem and also an aditional question about it.

Q1: how can I use this CSV format or what needs to be changed ?

SupplierID;Description;Costprice;Salesprice

184401;3M Optische Precisie Muismat Lichtgrijs MS201MX;9;13
184410;3M Optische Precisie Muismat Rood MS201RX;9;13
149606;3M Post-It Photo Paper 10x15 20 vel + 5 gratis,halfglanzend;4;6
149569;3M Post-It Photo Paper 10x15 20 vel + 5 gratis,mat;3;5
149593;3M Post-It Photo Paper A4 20 vel, zijdeglans;7;10
184760;3M Privacy Filter, 12" 12 inch TFT/Laptop;40;55
184807;3M Privacy Filter, 12" Wide 12 inch breedbeeld TFT/Laptop;42;57

Q2: Can prestashop import update current articles ?
For instance :

I have article 184401, the "Muismat" with prive 12;15 in the system and my supplier changes the prices, so it would become 9;13
If this happens, the article would be in the import csv with the new price...
Does prestashop update the article or inserts another one ?


With regards,

Ronny Roethof

old website: www.budgetpc.nl

[merlin_nl]

I have found the error
it was the " in the CSV file, but this is a little problem, as monitors use " for the screenwidth (inches)
Now the quiestion rises "How can I still insert the " ?"

Also I have found out that the prices in the CSV file are with taxes, and the import doesn't look at that.
I have to recalculate the CSV through a script (which is doable )

Also the CSV importer does not know how to import reseller prices, how can I add that option ??

Thx in advance