Information - Data Integration Guide
An in-depth description of the data sets the Premier EPOS can work with during integration.
PreviousGuide - Shopify - How to Create a Product with Variants (Full Procedure)NextIntegration Options
Last updated
An in-depth description of the data sets the Premier EPOS can work with during integration.
Last updated
This guide will breakdown each option that is available in the Premier EPOS when importing data for use on your web integration.
Your data can be sourced from either the Till, or from your current Website. If you do not have an existing website, this data will need to be completed by the end user.
The database on your Till will act as a primary source of data. It will contain such details as Name of Item, Selling Price, Barcode etc. For a more detailed explanation of the possible data, please see the below section, . This data will be automatically exported by the Integration Wizard.
If you already have an existing website, data can be extracted via another tool, Integration Manger. If no website is available, the data will need to be imported manually by the end user.
If the website data has already been imported into the Till previously, using the Integration Wizard, these details will also be included in the export.
This section will give you further details about each possible data column produced by the Integration Wizard's export.
This is the item name recorded in the Till system. It must be unique to ensure accurate tracking and differentiation from other items in the inventory.
This is the name of the product shown on your website. This name can be different to that of the standard Name of Item used on the Till and unlike the Till Name of Item, it does not have to be unique. The most common reason to have a different name on your website would be to make the product easier to read for your customer.
A Web Product Variant, also known as a child item, is intended to be used as a variation of the product. This variant product could represent different colours, size, weights, etc of a parent item.
An example of this would be a parent product named Winter Coat, while the child items in this example would be named Winter Coat, Large Blue or Winter Coat, Small Red. Another example of this could be a parent item named, Cat Food Can. While child items for this product represent the flavour, such as Cat Food Can, Chicken or Cat Food Can, Tuna for example.
Description of the item for use on the website. This section can include HTML code. Including HTML code in a web product description allows you to enhance the visual appeal and readability of the text. By using HTML tags, you can apply formatting such as bold and italic to emphasise important information or differentiate sections. You can also incorporate colours to draw attention to specific details. This can improve the overall presentation of product information, making it more engaging and easier for customers to read and understand.
This is the standard Selling Price, or Level 1 Price for the item in the Till.
This is the Recommended Retail Price (RRP) for the item in the Till.
This is the Tax Rate for the item in the Till.
This is the primary Barcode (i.e. Barcode 1) for the item in the Till.
This is the Internal Ref Code or SKU for the item in the Till.
SKU stands for Stock Keeping Unit. It is a unique identifier for each distinct item and is used to track inventory in the Till.
This is the primary Supplier (i.e. Supplier 1) for the item in the Till.
This is the Type of item (i.e Dog, Cat, etc) for the item in the Till.
This is the Sub-Type (i.e. Dog > Dry Food) for the item in the Till.
This section is currently reserved for future use, it is intended to allow a unique and customisable pricing structure for account holders at a later date. As soon as this has been approved from beta testing we will update the online help.
This is the primary category for the item. For example 'Clothing'
This is the secondary category for the item. For example 'Clothing > Men's'.
This is the tertiary category for the item. For example 'Clothing > Men's > Casual'.
While both web categories and in-store types/sub-types classify products, they serve different purposes and audiences. Web categories are designed for online navigation and user experience, often structuring items for ease of search and relevance in an online store. In contrast, in-store types or sub-types may relate more to inventory and organisation for physical handling and may not require as detailed a hierarchy as online categories. The distinction ensures optimal functionality and user interaction in both settings.
This is the Price on the website for the item.
This is the location of the item image. Images can be stored on a local hard drive or found online via a URL.
For images stored on a local hard drive, the location is the file path on the system. To find this:
Navigate to the image using File Explorer.
Right-click the image file.
Select "Properties" to view the file path.
To obtain the URL of an online image:
Open the webpage containing the image.
Right-click the image.
Select "Copy image address" to copy the direct URL of the image.
This is the items image ID, which can be either a number or File name. If using the HD location, the file name is already included, so there's no need to add it separately in the Image ID.
If you have any additional questions about the above guide, please contact our Support Team on either 03303 800 142 or .