While we provide the StyleSpec.doc as a guide to creating the tables/files required, this page will provide sample/template files to review and in most cases the DEPART.TBL, SUBDEPT.TBL, PRODUCT.TBL, CATEGORY.TBL samples can be used without modification with your product, if this is the case then all that is required by you is the ????STYL.TXT and RANGE.INF files that contains your barcode and product information in the format specified in the StyleSpec.doc below helps explain StyleSpec.doc in a more friendly fashion (as it has been noted that its a little cryptic) also to help are some samples of the files are provided on this page to further assist you in creating the files required by POS systems.
The RANGE.INF file simply contains a Unique Season Code, a short Season Name description, and a date code YYYYMMDD
In this case
Line 1) W08CM -> is made up of (W)=Winter, (08)=2008 and (CM)=CLOTHING-MENS/BOYS (W08CM)
a sample of this file can be seen/downloaded here RANGE.INF (while the file has the extention of .INF it is simply a text file, and nothing to do with .INF files of windows)
Sample TBL Files,
Clicking on the following should display the contents of the file, to download 'right' click and select 'save target as' (wording may differ between browsers) to save to you local drive
DEPART.TBL (View contents of DEPART.TBL)Generally you can use the above TBL sample files as is, and will only need modifying if you have additional Depart, SubDept, Product or Category that are not covered in the above samples. The first line of all TBL Files is the number of paired items (item name and item code) in the file, so if we look at DEPART.TBL the first line is 7 this means there are 7 Items made up of the Item name and the TBL link code that is used in the ???STYL.TXT file (see table below) eg: (this is the contents of DEPART.TBL in bold)
Now for the meat of it!.. the ????STYL.TXT This is the main file that is required and is made up of your product details, and using information found in the above TBL files to select and fill in the fields we need with the best Depart, SubDept, Product or Category that fit/suit your product line. hopefully the following sample file (below) will help explain the contents of the file.
While the file ????STYL.TXT can simply be a text (.txt or .csv) file, you may find doing it in a spread sheet (.xls) simpler and easier to maintain, we will accept files created in this manner.
To make things a bit easier, you can use the BLANKSTYLE.XLS as a template to use, it already has all the fields set out, just fill in the cells with your product details or use it as a guide for your system export routines, but please do reference the StyleSpec.doc (or use the table below) for the length of each field (cell), (as we will mercilessly truncate any feilds (cells) that are too long)
So lets have a look at a raw line of data in the ????STYL.TXT (if not using xls) (There are also links to some examples at the bottom of this page)
(the following line should be/show all on one line and not word wrapped)
8WFBM,BEDFORD MEXICAN SHORT,ASS,ASSORTED,XL,30.00,59.95,40.00,74.95,9999999999999,9999999999999,C ,N/A,M ,FW,W08,24B,4 ,NNNNNNYYYYNN,STARS,10990,01/07/08,01/10/08,36,0.00,24,12, ,23,
|Now lets have a closer look at that line above and break it
down field by field
in the below table we can see what each field is and it's max length for each field. (At the bottom of the page are some downloadable samples in CSV and XLS format with 10 products to show you what the files look like)
If you are doing it in a TXT or CSV then It is imperative that fields that are blank should be padded with a space and comma delimited, every line should have 30 fields, (29 commas in each line), see sample CSV below.
CSV/TXT example -> StyleSpec.csv
XLS Example-> StyleSpec.xls
Blank Template XLS -> BLANKSTYLE.XLS
If you are using the default TBL files as listed at the top of the page then all we need from you is the ????STYL.TXT (or CSV or XLS) and the RANGE.INF.
Creating seperate ????STYL.TXT files for each style, ie: Mens, Ladies, Kids, Wetsuites, Accessories etc.... will make things a lot simpler for retailers looking for and downloading particular styles
Files can be emailed to email@example.com
Oh! and if its your first time please supply us with your brand logo for the pages
For further assistance and new brand enquiries please email firstname.lastname@example.org
Terms and Conditions of Fair Use
This site is copyright ©1998-2009 by Osipos Pty Ltd. All rights reserved. The material on this site may not be published, reproduced, broadcast, rewritten, or redistributed without permission.
Osipos currently makes available 'Style files' for download free of charge, including for non-Osipos users.
However the use of unapproved 'automated'
result in your account being banned.
Osipos reserves the right to change or modify this policy without notice.