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

    Details

    • 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:
      N/A
    • Documentation Change:
      N/A

      Description

      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?

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: