Why you want to analyse this in your Prestashop…
Let’s say you want to understand who changed the status of each order and track if the declines are correct: who canceled most the order? Why?
Some orders are changed automatically, some others are changed with the intervention of someone in your team.
This information will help you to understand who has been modifying which order and ultimately improve your internal processes or build some use cases and best practices.
You will get the following kind of information:
Let’s take an example.
Imagine you have on your prestashop website an sudden increase in the payment cancellation. You might want to know who changed the status manually for each order so that you can understand if the decision making process is the right one and if not too many orders have been cancelled – when they shouldn’t have been cancelled.
Tested successfully on Prestashop 1.6 and Prestashop 1.7 version.
What you will exactly get
Start by looking at the product discovery page.
You’ll get a few line to copy-paste in your browser enabling you to extract the data from your Prestashop boutique withouth having to install any plugin, just by using the SQL Manager feature.
With this file, you’ll be able to analyze better your order flow status and potentially improve your internal processes.