New bespoke Shopping Cart software developed from scratch to replace Actinic V10. This new shopping cart offers better integration with a legacy stock control system allowing for more accuracy in ordering.
The new system includes data extracting from and MS SQL Server database every hour using SQL Server Management Studio creating a task that is executed using the Scheduler running a dtexec command.
The data extract creates a CSV file that is then parsed to create all the HTML files and control files. These are then FTPed to the internet server using another scheduled task.
The design of the whole website has been simplified and the shopping cart experience has been designed to be as simple as possible.
The payments are taken using the new SagePay web service (formally Protx) which was easy to integrate by simply rewritting their PHP Integration Kit into Perl.