base price

[qiherbs]

On the products page in the back-office, there is a column for "base price" and "final price"

 

On the csv import file, there are no such fields.

 

I am assuming that "final price" is the "retail price before tax" field"?

 

What is the corresponding field name for "base price"?

[eleazar]

Correct, the final price in Prestashop is the retail price, the price that your customers have to pay, no matter if tax excluded or included.

 

The base price is the unit price, the final price is based upon (liter, kg, Meter etc.)

Example: If you would sell fabrics, there is this piece 25 cm for $ 3, and in this case the base price for 1 meter would be $ 12 as standard of comparison. Got it?

[qiherbs]

Thx for the explanation -

 

So if I want to change all the "base prices" to 0, I simply make that change in the csv column called "unit price".

 

Is there any scenario in which changing the "base price" to 0, will result in an automatic adjustment of the "final price"?

[eleazar]

Thx for the explanation -

 

So if I want to change all the "base prices" to 0, I simply make that change in the csv column called "unit price".

This is a bit difficult in English, because the use of unit price isn't distinct. Sometimes unit price means the price of a single unit of the product ( like one bottle), sometimes it means what we call the base price. In this case you are right. Which means we have to change this term in csv import to base price. Thank you!

But the bad news is: The database field is called unit_price_ratio, and it seems that the PrestaShop developers confused the unit price with the unit_price_ratio. On the bottom line: you can enter whatever in this import field of your csv file - the result is always 0.

 

Is there any scenario in which changing the "base price" to 0, will result in an automatic adjustment of the "final price"?

I'm afraid, no! There isn't any scenario. This is just a numeric field without any connection to other price fields.

 

But if this is important for you, why don't you use this module: http://addons.prestashop.com/de/8702-csv-import-pro.html ?

A manual can be found here: https://hostjars.zendesk.com/hc/en-us/categories/200336759-CSV-Import-PRO