We currently use the Veeqo platform to manage orders from multiple sales channels. We need to set up a new workflow which requires a custom web-based application to interact with Veeqo’s API. This will include pulling order data, manipulating the data, producing invoices and manifests, and marking orders as dispatched in Veeqo.
Whilst People Per Hour requests us to set a budget, we are open to all realistic quotes for this work.
Goal
• Pull orders from the Veeqo platform • Check for orders over a certain value and split them into smaller child orders • Produce a pdf with one order invoice per A4 page • Produce a spreadsheet manifest detailing the orders • Notify Veeqo that the orders have been dispatched
Detailed Requirements
The app should have a simple password protected UI, with buttons for creating batches and carrying out processes as below. We would provide an html/css template for the UI. The app will need to be web-based so that it can be accessed from multiple locations.
On a button click - We will require the app to pull data for orders which have been assigned to a specific warehouse in Veeqo. We will call this data a “batch” and it should contain all unshipped orders which have been assigned to the warehouse since the last batch was pulled.
The app will then need to automatically check the batch for orders with a total value over a certain threshold – this threshold will be set via the UI. Orders over this threshold will need to be split into child orders containing composite parts of the original order – See examples below.
On a button click – We need to be able to download a csv report containing all of the data for the batch so that we can see where orders have been split etc. We will provide a template for this file.
On a button click - We need to download a pdf file containing invoices for the orders in the batch, one order per A4 page. We will provide a template for the pdf. In cases where an order has been split, only the child orders should be included, not the parent orders. For example, if order A has been split into child orders A-1 and A-2, these two child orders will require individual invoices, but not the original order A.
On a button click - We need to download a spreadsheet manifest collating the data in the batch. This will include displaying orders 1 per row, as well as totalling the quantity of each individual product within the batch. We will provide a template for this spreadsheet.
On a button click - All orders in the batch should be marked as dispatched in Veeqo.
To meet data protection requirements, batches should remain in the system for a set period of time before being deleted. We will also need a button to be able to delete any individual batch, though order numbers will likely need to remain in the system to protect against duplication.
Order Split Examples
The UI will contain a field for adding a value threshold for splitting orders. Any order over this value will need to be split into child orders to ensure that they are below the given threshold.
These orders will include instances where the customer has added multiple items to their order, and also instances where we have a kit made up of multiple items.
These child orders should be given their own unique new order number to be used on the invoices, manifest, and report. This order number can be the original order number with a suffix.
Below are some examples with the threshold set to £20 -
Order A 1 x SKU1 £15 1 x SKU2 £15 Total £30
Should produce –
Order A-1 1 x SKU1 £15 Total £15
Order A-2 1 x SKU2 £15 Total £15
--
Order B 3 x SKU3 £30 1 x SKU4 £10 Total £40
Should produce –
Order B-1 2 x SKU3 £20 Total £20
Order B-2 1 x SKU3 £10 1 x SKU4 £10 Total £20
--
Order C 1 x SKU5 £30 -- Kit parts = 1x SKU6 & 1x SKU7 Total £30
Should produce –
Order C-1 1 x SKU6 £15 Total £15
Order C-2 1 x SKU7 £15 Total £15
Hosting
We are open to advice on hosting of the app based on the requirements for completing processes and storage of data.