Size Spec: Updated CSV Import Template - Released: 6/4/2021
Importing from CSV is a great way to create a size spec. Once in the product's Size Spec page, click on the 3-dot menu in the upper right-hand corner and click "Import From CSV".
How to Import from CSV:
- Ensure that your .CSV file matches the "Sample Template". The format requires the following column headers:
- POM Name
- POM Code
- Tolerance (+ / -)
- Sizes across the columns (S, M, L, XL, etc...)
- Sample Size
- The following column headers are optional and may be left blank:
- How to measure: this will import any entered values. Blanks will import blank.
- Critical: this will import any "TRUE" or "t" values as checked checkboxes and "FALSE", or "f" values as unchecked checkboxes. This is not case-sensitive. Blanks will import blank.
- Type: this will import any "half" or "h" values as Half, and "full" or "f" values as Full. This is not case-sensitive. Blanks will import blank
- Note: Backbone offers a "Sample CSV template" when opening the "Upload CSV" Module. See video above for further clarification.
Tips and Tricks
- The format of the numbers in the CSV should be either all in decimals, or all in fractions. If there is a mixture, all values will be converted to decimals upon import.
- The measurements and tolerances can be formatted to millimeters, centimeters, inches, feet, yards, or inches and must match the dropdown when importing
- There should not be any additional blank rows in between your POM rows
- Enter a Sample Size (you only need to do this once)
- You can add any POM Names and Codes you'd like. You do not need a code, Backbone will auto-generate one if you don’t provide one.
- Note that importing from a .CSV does not link imported POM's to your POM Library
- The template is originally a .xlsx file, be sure to file > save as > .csv when saving in Excel.