Import Sale Prices for Products through csv

Hi,

You have a price_value field for the price without taxes. That's the one saved in the database.
If you want to import prices with taxes, you need to use instead the price_value_with_tax column in your CSV.
You also want to specify the product_tax_id column with the id of the tax category you want for each product and have your "main tax zone" set to a taxable zone in the HikaShop configuration and have already configured your tax rules in the menu System>Taxes so that during the import, the system can dynamically calculate the price without taxes out of the price with taxes.

You can enter the discounted price in the price_value column and the normal price in the product_msrp column of your CSV in that case.

It should work.
I can see however that for some products, you only specified a product_msrp and not a price_value:
take.ms/5LA2q
In that case, you would get the result you're talking about.
So maybe you tested with such product ?

If you manually enter the retail price and price in a product via the backend interface, does it work like you want ?

Hi,

That's normal.
The system is not meant to be used like you want.
But on the product page of that product, do you properly get the two prices displayed ?
I suppose you do. So then, on the product page, all you have to do is to add some CSS to strike through the MSRP and change the text next to the prices with translation override:
hikashop.com/download/languages.html#modify
And then, if you want the same prices display on the listing, you can edit the file "listing_price" of the view "product" via the menu Display>Views and remove the code:

&& JRequest::getCmd('layout') == 'show' && $this->params->get('from_module','') == ''