Data Preparation for Import to Quant
The actual launch of Quant is preceded by a very important phase of data preparation. Whether the data is imported into the database manually or automatically, it must have some necessary parameters. This manual provides examples of each data type and recommendations on how to have the data ready for import.
List of basic data that can be imported into Quant:
1. Product data
You can create data for importing products as a spreadsheet in Excel. The file must contain a unique product ID. Each row represents one product and each column represents one property.
What data do we recommend to include in the import at the initial stage?
You can import all the data you need into Quant. The more data, the better work it will be in Quant. However, at the beginning we recommend adding at least the following basic data to the file:
- ID: Must be in the file to uniquely identify the product.
- Measurements: width, height, depth: These are essential data without which it is not possible to create planograms. If you use different product packages, you can include the dimensions in the package file.
- Categorization: for an easy product categorization, it is advisable to include information in the file to which category or subcategory the given product should belong to.
- Other basic attributes: brand, supplier, EAN etc.
Product table
For a detailed procedure for manual import, see the Product Data Import manual.
2. Product packages
Import of product packages is used especially in the case when different types of packages are used for 1 identical product.
The product with ID 88784 Whole Milk Box can be sold as 1 box or as a carton of 6 pieces or as a whole palette of 144 pieces. It is always necessary to specify the number of basic units in the package and the size of the package. You can find the pattern in the picture below.
For a detailed procedure for manual import, see the Product Packaging Import manual.
3. Product Images
This import allows you to import product images that are used to draw products in planograms. Images can be imported from the directory in which they will be stored or using links from a web page.
a) Import images from the directory:
Product images must be stored in the directory under a clearly identifiable name with the Primary Product Id or EAN code. Save the images with this name as png or jpeg format.
For a detailed procedure for manual import, see the Product Images Import manual.
b) Image import from website:
Links to individual images must be copied as image address. A table is created in Excel where each row represents a link to one image. Each link must be paired with a Primary Product ID. You can include the links directly in the product file.
4. Category Hierarchy
It is possible to import a category structure which you can later edit in Quant. Products are easily assigned to categories thanks to the use of filters.
You can create data for import in an Excel spreadsheet. The import can be done directly. Each row must contain the entire structure from the highest level to the lowest.
For a detailed procedure for manual import, see the Category Hierarchy Import manual.