Formatting Linesheet & Style Data

Overview

JOOR Data Services can create your styles and digital linesheets after receiving your style information via the JOOR Linesheet Template in Excel. Style information can only be accepted in the JOOR Linesheet Template.

How to Format Linesheet & Style Data

1. Download the linesheet template from the Data Uploader page in your account or see this article
2. The first tab of the file contains instructions on how to properly fill out the “Template” tab
   • All of the PINK shaded columns are required fields. The minimum required fields to create a style (and associated digital linesheet) on JOOR are:
     ​
     • Linesheet Name
     • Season Name
     • Season Year
     • Style Name
     • Style Number
     • Color Name
     • Sizes/Size Name
     • Gender
     • Category 1
     • Category 2
     • Currency
     • Wholesale Price
       ​​
   • Be sure to note in the additional comments field of the Data Uploader that you wish to create multiple linesheets so our team will know to differentiate them by the Linesheet Name column. Please also note that each linesheet can only have one delivery window and season/year.
   • You can either enter your data at the SKU (one size per row) or Colour level (sizes comma-separated) - see below for examples of each
     
     
     
   • Note 1:  that each style number can only have one wholesale price, one retail sales price and one fabrication. For example, style number J001 in the above cannot be listed for both $50 and $55 wholesale price.
   • Note 2: prices are not provided, our team will load a placeholder of 0.01​.
     ​
3. If you would like to add images to your linesheet, please submit them using a shared Dropbox, WeTransfer, or Google Drive link via the Data Uploader. Product images should be saved in the following format: stylenumber_color_order. For more information on image formatting, please see this article.
4. When you are ready to submit your data, navigate to the Data Uploader in your account and submit your file to our Data team. Be sure to note any special instructions, or if multiple linesheets have been submitted in a single template.
5. You will receive an email confirmation once submitted and our team will confirm on that email thread once your styles, linesheets and images have been successfully uploaded.