Uploaded image for project: 'PrestaShop 1.7'
  1. PrestaShop 1.7
  2. BOOM-5049

Final price(tax incl.) is not displayed in back office product catalog


    • Type: Improvement
    • Status: To be specified
    • Priority: Minor
    • Resolution: Canceled
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Product Management
    • Labels:
    • Tests & Expected Results:
    • Documentation Change:


      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?




            • Assignee:
              pablo.borowicz Pablo Borowicz
              dosatunde Tunde Erika Dosa
            • Votes:
              0 Vote for this issue
              2 Start watching this issue


              • Created: