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
How is the margin calculated
How is the margin calculated
Login
Reset password
or
Register
5 Answers
Apr 07, 2016
Dmytro Grycelyakagentwrote
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
Apr 07, 2016
DaveNwrote
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
Apr 08, 2016
Dmytro Grycelyakagentwrote
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.
Apr 11, 2016
DaveNwrote
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
Apr 13, 2016
Dmytro Grycelyakagentwrote
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