Jump to content
vedrana

Back Office Product Catalog with tax-included prices?

Recommended Posts

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?  

 

 

prices.jpg

 

 

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 by vedrana
Partial solution (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Agree - this is only relevant for B2B, assume that the majority of the webshops are B2C ??? please help

Share this post


Link to post
Share on other sites

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 :)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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
  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More