vedrana Posted March 4, 2018 Share Posted March 4, 2018 (edited) Hello devs and merchs! Sorry to see so many negative posts and comments, I appreciate all the hard work put into 1.7, it really looks great, a lot more user friendly. I hope module developers can keep up. Has anyone figured out how to display prices with taxes included in the Back Office Product Catalog in PrestaShop 1.7+? Is it an SQL thing? what does " 0 AS `price_final` " mean in the query? Does it make an empty column? And where does that column go if it does? The query is exactly the same in 1.6 so it's weird the output is different in 1.7 Does anybody have any resources to share about how the databases/tables are thought out/work in PrestaShop? I see that products have a single price field in the product database which is tax excluded, and I can understand why, things would get messy if it didn't... But then where is the final price kept, or how is it calculated? Could it be calculated with an SQL query or is it done with Javascript? I could ignore tax rules, I only have one tax so a simple calculation would suffice... Or better yet, would it be logical/doable to have a feature where the user chooses if the price in the database includes the tax or not, and then the site changes calculations accordingly? Anybody any thoughts on the matter? Update: A wonderful man posted the solution to displaying price_final here: https://www.prestashop.com/forums/topic/626192-17-how-to-display-product-price-include-tax-in-backoffice-catalog/?tab=comments#comment-2720226 The filters don't work though, So the remaining question is how do we get the filters to work? Edited March 17, 2018 by vedrana Partial solution (see edit history) 1 Link to comment Share on other sites More sharing options...
Lalaru Posted March 5, 2018 Share Posted March 5, 2018 In other words : In backoffice > catalog > products list : Price WITHOUT tax is interesting in B2B mode. Price WITH tax is interesting in B2C mode (default mode), therefore it should be the default behavior. Link to comment Share on other sites More sharing options...
Simon Posted March 6, 2018 Share Posted March 6, 2018 Agree - this is only relevant for B2B, assume that the majority of the webshops are B2C ??? please help Link to comment Share on other sites More sharing options...
vedrana Posted March 12, 2018 Author Share Posted March 12, 2018 Hi everybody! I opened an issue about this in the forge, as I learned that's the place to post bugs and improvement recommendations. Nobody mentioned this there before, but now it's sure the core developers will look into it. It will probably take a good while, and the changes will probably come with a future version. Thought you might like to know... For those who are interested, you can follow the issue here: http://forge.prestashop.com/browse/BOOM-5049 you need make an account for that, though. It would be great if someone figures out a query for the sql manager in the meantime Link to comment Share on other sites More sharing options...
Massimo333 Posted March 14, 2019 Share Posted March 14, 2019 (edited) What is the solution to have final price on the admin products list (for Prestashop 1.7)? Edited March 14, 2019 by Massimo333 (see edit history) Link to comment Share on other sites More sharing options...
amorxoigel Posted April 8, 2019 Share Posted April 8, 2019 Could you post please ur solution? Link to comment Share on other sites More sharing options...
delete-account-pleas Posted April 14, 2019 Share Posted April 14, 2019 You will need to edit products_table.html.twig and list.html.twig both files can be found on the following location:YourWebshop/src/PrestaShopBundle/Resources/views/Admin/Product/CatalogPage/Lists/ you can add the variable "final_price" which will show the price including vat and discounts. a detailed tutorial can be found here: Add Product Final Price Link to comment Share on other sites More sharing options...
Lalaru Posted May 16, 2019 Share Posted May 16, 2019 It is now included in Prestashop 1.7.6.0 : New features & improvements : A “Price tax included” column has been added to the products list #11484 1 Link to comment Share on other sites More sharing options...
WEBMADE Posted October 22, 2019 Share Posted October 22, 2019 Hi, my version is Prestashop 1.7.6.1: the final price should not be displayed with discounts and rules? I don't see the discounts in list! How can it be done? Link to comment Share on other sites More sharing options...
dragon_sa Posted May 30, 2021 Share Posted May 30, 2021 This is still a problem when setting up product combinations, it is causing a really big problem for us having to try and calculate our pricing minus the tax first, as all our products have tax included prices, makes adding and editing products very slow and cumbersome, I get no time to run my business stuffing around with this. Why cant we just add tax included prices where ever the situation occurs Link to comment Share on other sites More sharing options...
bloggus Posted October 27, 2022 Share Posted October 27, 2022 On 4/14/2019 at 1:08 PM, Crezzur.com said: You will need to edit products_table.html.twig and list.html.twig both files can be found on the following location:YourWebshop/src/PrestaShopBundle/Resources/views/Admin/Product/CatalogPage/Lists/ you can add the variable "final_price" which will show the price including vat and discounts. a detailed tutorial can be found here: Add Product Final Price Hi, Anybody have a guide for this? Seems the links ar enot working. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now