How is the margin calculated
Avatar image
Apr 04, 2016
DaveN wrote
Hi, I've looked for the definitions in the documentation but can't seem to find what I'm looking for.

In the main product screen where I can see Product, Sku, Image, Price it then has Wholesale. I don't have the column that is Supplier Cost Ex and can't export it either with the additional check box option.

Is the gross profit being worked out from the Wholesale column or the Supplier Cost? I was just running through updating pricing and realised supplier cost is not available on the quick export to .xls and only when I do all available fields. Yet it gives me margin, along side the price/wholesale columns?

Can supplier price ex be added to the quick export, as you would work out GP off this. Supplier cost (my buy ex tax), then GP, taxes are added to this where you don't already have an RRP from aren't they?

Thanks
Reply
5 Answers
Avatar image
Apr 07, 2016
Dmytro Grycelyak agent wrote
Hello Daven,

Please specify more exactly what do you mean by Supplier Cost Ex.
As we know PrestaShop has Wholesale Price, Retail (Base) Price (excl Tax) and Final Price.

Concerning the Profit Margin. It is calculated by the formula described above:
https://en.wikipedia.org/wiki/Profit_margin
Avatar image
Apr 07, 2016
DaveN wrote
Hi Volodymyr, the confusion comes when I do the detailed export and I have Price (so base price ex tax), Wholesale (this I was confusing with sell my products to Wholesalers price ex) as the export has, "Supplier Unit Price (Tax Excl.)".

What is, "Supplier Unit Price (Tax Excl.)"?

Thanks
Avatar image
Apr 08, 2016
Dmytro Grycelyak agent wrote

Hello Daven.



PrestaShop and Store Manager allow to manage Supplier Unit Price





which can also be exported and imported, however basically it has nothing to do with the profit margin.

Avatar image
Apr 11, 2016
DaveN wrote
Hi Again, I've know where this was confusing now.

On the main page it lists Base Price, Price with Tax, Wholesale Price, Margin. So you're saying it uses Wholesale Price against RRP price to generate the Margin which makes sense.

It seems to be different when you want to import your pricing via .csv though. "Wholesale Price", under Import Assign .csv columns to DB fields is has the explanation of this field as "Wholesale Price - cheaper than retail price offered to customers who purchase in bulk".

The only other logical field you could choose when importing/updating is Supplier Cost Ex. But as you mentioned this would have no impact on margin.

Does this make more sense? One supplier/wholesaler supplies their pricelist to me in buy ex per unit. I want to import/update pricing based on this and then add margin as they have no RRP.

Thanks

David
Avatar image
Apr 13, 2016
Dmytro Grycelyak agent wrote
Hello Daven,

Thank you for your suggestion.

You're welcome to submit it as a feature request and we will consider it in future:
https://support.emagicone.com/823795-PrestaShop-Manager-Feature-Request