KEY LESSON POINTS:
- Export file.csv ps_authororation_role from the Database;
- File modification via Excel;
- Import of the modified file into the Database.
N.B: IF YOU ARE NOT A DATABASE EXPERT, PLEASE DO NOT FOLLOW THIS GUIDE.
First of all, we are exporting as the.CSV PS_AUTHORIZATION_ROLE:
This is done by clicking on you at the bottom of the left-hand side.
Once downloaded, the Excel tamite will have to be modified:
Once you set the whole, you will have to click on the end.
A new column must now be added to those already in place, to which we will have to give the value ‘1’ in each space:
Having done so, we will save the file.
Once the file has been modified, we will import it into the database. First, we go to ps_access and then click on Importa, at the top:
You will need to upload the previously modified file and then click on:
Having done so, we check whether everything has been successful, via the Prestashop panel: