veloce.co.uk

,

From humble beginnings, Veloce Publishing has grown into one of the most respected and best loved specialist publishers in the UK.

At the tail end of 2019, Veloce Publishing was nearing the completion of its new website. While I was not involved in the frontend development of the website – barring some minor help here and there – I worked extensively on the backend. The new website brought with it an eCommerce system, Ecwid, that was new to the company and incompatible with its existing workflow. As a result, I pitched in to develop a new system to allow the purchases made on the website to be downloaded and formatted such that they could be imported into the company’s existing accounting software.

In order to achieve this, I had to learn how to construct and read valid JSON files, and then develop a solution that integrated Ecwid’s existing API with the company’s custom database built within Filemaker Pro. The resulting solution allowed the end user to press a single button from within Filemaker Pro, and receive a fully-formatted CSV file of every order made through the Veloce website that was awaiting fulfillment. This action would also then notify the eCommerce system that these orders were being processed, avoiding duplicate orders from being downloaded.

Once this system was tested and working, I used my new knowledge of Ecwid’s API system to develop a full suite of tools inside Filemaker Pro that allowed users to directly create, edit and delete products from the Veloce website. This meant that the company could leverage the existing database to avoid any manual input, as well as providing users with a user interface that they were already familiar with. This significantly cut down on both the potential for errors to be introduced into the system, and the time taken to make amendments to the Veloce website

Tools used:

  • Ecwid API
  • Filemaker Pro
  • AccountEdge
  • BBEdit

Languages employed:

  • HTML
  • CSS
  • JSON
  • Filemaker Scripting