Audit Trail

Audit Trail is for PCI Compliance reasons. It will track an admin user’s footsteps through the admin for audit purposes in the event that something happens and requires to be isolated.

The reason behind this is the audit trail table will grow to be huge if we do not purge the records.

These are purged to a text file which can be accessed on the server.

 

To setup Audit Trail configurations, please follow these steps below :

1.  Login to your VPCART administration.

2.  Go to Advanced Settingsat the top and click Software Configuration on the mouse over.

3.  Click Audit Trail in the Setting Up Your System section.


There are two configs for the Audit Trail as shown below:

Xauditpurgeday

How frequent in days the purge will be processed while logging into the Admin Console.Let's say you set the value to 3, then that means every 3 days, the purge will be triggered once the admin logs in.

It is an automatic process based on how many days you have setup in the xauditpurgeday.

If Admin does not log in on that specific day, the next day while admin logs in, the process will be triggered too.

Xauditpurgedirectory

Where the purge backup text files will be stored. Default directory is export. You can setup to any directory you wish,but make sure the directory exists in your server and has read/write permission.


In VPCART, the audit trail history is stored in a new table called: tblaudithist.

The tables below are monitored:

Table product – any add/update/delete/bulk delete activities.
Table categories - any add/update/delete/bulk delete activities.
Table orders - any add/update/delete/bulk delete activities.
Table suppliers - any add/update/delete/bulk delete activities.
Table customers - any add/update/delete/bulk delete activities.
Table groups - any add/update/delete/bulk delete activities.
Table quantitydiscounts - any add/update/delete/bulk delete activities.
Table coupons - any add/update/delete/bulk delete activities.
Table customerprices - any add/update/delete/bulk delete activities.
Table content - any add/update/delete/bulk delete activities.
Table blogs - any add/update/delete/bulk delete activities.
Table news - any add/update/delete/bulk delete activities.
Table affiliates - any add/update/delete/bulk delete activities.
Table billing - any add/update/delete/bulk delete activities.
Table projects - any add/update/delete/bulk delete activities.ete
Table registrant - any add/update/delete/bulk delete activities.
Table pinnumbers - any add/update/delete/bulk delete activities.
Table gifts - any add/update/delete/bulk delete activities.
Table currencyvalues - any add/update/delete/bulk delete activities.
Table languages - any add/update/delete/bulk delete activities.
Table shopcountries - any add/update/delete/bulk delete activities.
Table shopstates - any add/update/delete/bulk delete activities.

To check the Audit history, please follow these steps below :

1.  Login to your VPCART administration.

2.  Go to Advanced Settingsat the top and click Admin User Management on the mouse over.

3.  Click Admin Audit Trail in the tab.

4.  A list of admin activities will be displayed :