How to set prices?

[Former Member]

Hi, I saw one impex, where we are setting pices. Impex:-

$prices=Europe1prices[translator=de.hybris.platform.europe1.jalo.impex.Europe1PricesTranslator] UPDATE Product;code[unique=true];$prices;$approved;$catalogVersion; ;0001;5,00 GBP, 5,50 EUR, 7,48 USD, 765,33 JPY

But i am not getting 5,00 GBP What is 00 here

[Former Member]

The default locale for ImpEx imports is German. So the , character is typical for the hundreds/thousands separator. If you wish to use a . instead, then you must change the locale of your ImpEx script. This can be done by adding this line at the top of your script:

 #% impex.setLocale(Locale.ENGLISH);

[Former Member]

Hi Romil,

I don't think you can enter prices like the way you have given above. Prices for a product are given as PriceRow like in the example below:

INSERT_UPDATE Product;code[unique=true];$approved;$catalogVersion

;107701 ;266899

INSERT_UPDATE PriceRow;productId[unique=true];unit(code[unique=true,default=pieces]);currency(isocode)[unique=true];price;minqtd;unitFactor;net

;107701;pieces;USD;179,93;1;1;false ;107701;pieces;JPY;15330;1;1;false ;266899;pieces;USD;86,86;1;1;false ;266899;pieces;JPY;7400;1;1;false

Also the comma represents the . example 179,93 represents 179.93