Eyewear Systems Product & Images Files

This page contains a detailed description of our product file and associated image files.

Purpose: To enable retailers to be able to import product information, including quantity available and images, into their database. The file can also be used as a price list.

Audience: The file is primarily aimed at online retailers, and therefore the Purchase Price is the dropship price. Apart from this, the file can be equally well used by wholesale purchasers.

Frequency: The file is currently produced on an as-requested basis.

Content: Full details for all products, plus detailed image references for Birdz Eyewear products and the SH... range of sunglasses. An alternative images file with all images named can be downloaded - see below.

Format: The main product file is provided in tab-delimited CSV and Excel 2003 formats. The file contains one row per SKU (see below for explanation). The three image files associated with it are provided in a zip file. All images are in JPEG format:
- imagest contains the main product thumbnail image
- imagesd contains the main product images
- imagesv contains all SKU images, including the SKU thumbnail
Image names correspond to model/SKU names for the products beginning BE..., BH..., SH..., SC... and a few SU... The remainder just have a number and you will need to view these (as thumbnails in Explorer for example) to match them to the product. We will rename these as soon as possible.

Instructions: You can download the file by clicking on the links below. To import the file into your database you will need to write a script or use a database tool such as Navicat. In the longer term (2008), we plan to produce product files suitable for direct import into the more popular e-commerce applications.
- Product Import File in Excel format
- Product Import File in CSV format
- Zipped Images File (13mb zipped)
An alternative images file can also be downloaded by clicking the link below. This contains all images by major product code (e.g BE... SU..., SC...), including some high resolution images. This will be easier to use if you do not need the images file in same format as the product file
- Images By Product Code (26mb zipped)

Overview of Product File: Please read this before using the product file - it will save you time in the long run !
First a couple of concepts:
Products and SKUs: We sell a number of Products - a sunglasses model  such as the SH109. Each product may have one or more SKUs. These are the different colour combinations, for example black frame with smoke lens or brown frame with brown lens. Each SKU is related by code to the Product, for example SH109-1, SH091-2.
VAT: Eyewear Systems is not currently VAT-registered but the file is capable of managing this. The PurchasePrice field contains the standard dropship purchase price before any discounts are applied. For now the PriceExVAT field is the same as the PurchasePrice. All other VAT-related fields should be ignored.
Images: Each SKU can have one or more images associated with it.
- There will always be a ProductMainImage and ProductThumbnail (hopefully these are self-explanatory). It is our aim to have an SKUThumbnail and SKUMainImage for every SKU. All other images may or may not be present, depending up the availability of images and need of the item.  You may choose to import only those products that meet these criteria. The file allows for extra Product and SKU images. In this first release (June 2007) the extra main images will be the same as the SKUMainImages, but this will change with the next release (circa autumn 2007).
- The target Thumbnail size is 150x100 pixels and the MainImage size of 400x300, although this varies considerably depending on the imagesource etc
- There are three image files: imagest contains the ProductThumbnail, imagesd contains the ProductMainImage files, and imagesv contains all of the SKU images, including the thumbnail

Product File Description:

Please help us by providing feedback on any aspect of this facility.