Price Display Issue

[kevin13952]

I'm wanting to edit my selling prices in excel then upload the price changes to PrestaShop. Then I want PrestaShop to show the retail price, my selling price and the percentage of savings.

 

So far the only way I've found to change the selling price and show the percentage of savings is by catalog rules.

 

But catalog rules are too broad.

 

Is there a way to do what I'm describing?

[kevin13952]

It's ridiculous that prestashop doesn't have the following price fields:

 

Wholesale Price

Retail Price

Selling Price

 

This way you can still show the retail price and the percentage discount from the retail to the selling price would display to the customer.

 

As prestashop currently works, you set your retail price and then create a price rule to discount either your entire store or specific categories. Yes, you can create price rules to discount specific products but since you can't import those rules en-mass it's too cumbersome and time consuming to be practical.

 

It's important to be able to use something like excel to set a bulk profit margin from my wholesale price, then upload those values to prestashop so each individual product might have a varying percentage discount from the retail price than other products.

 

For example:

 

I have a widget A that cost me $3.20 USD, The MSRP is $7.99 but I want to markup a 30% margin which would have me selling the item for $4.57. This is a 36.9% discount off of retail.

I have widget B that cost me $2.95 USD. THe MSRP is $7.99 but I want to markup 30% margin which would have me selling the item for $4.21. This is a  40% discount off of the retail price.

 

As you can see, I'm making the same margin but the discount amounts are different because the suggested retail is different.

 

From my perspective this is only possible if Prestashop back office has a field for "Selling Price" and the front office shows the MSRP, the "Selling Price" and the percentage difference of the two. 

Edited January 10, 2016 by kevin13952 (see edit history)

[newcomer]

Actually you can import csv wholesale price into the ps_specific_price table in SQL.

 

But yes your right there is no function to turn on visibility of specific price for products to say wholesale customers.

[Teapot Creative]

Hi

 

If you want an overview tutorial on Prestashops CSV import functionality, I have created a video here: 

 

 

Hope this gives you an idea of best practice and gives you a basic idea of how to import via CSV. 

 

You can import prices with and without VAT, wholesale prices and price discounts in units or percentage. For specific pricing  as previous, this need to be done via phpMy Admin or by add-on.

 

Possibly this module could help: http://addons.prestashop.com/en/18677-import-specific-price-csv.html

 

NickC

Edited May 6, 2016 by Teapot Creative (see edit history)