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.
Another Note: Importing a CSV into a Spec will override any existing POMs, Grades, and Sample Measurements within that Spec.
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.
Do make sure there is no additional spacing before any values.
Once you have imported your Spec you may you may choose to add your POMs to your POM Library for future use.
To Export or Bulk Export POMs click the checkbox or checkboxes to the left of your POM Image and select the "+" Icon in your bulk action toolbar that will appear at the bottom of your spec
There is a select all option that will appear in your bulk action tool bar once you have selected one POM
If there are no duplicate records, Your POMs will automatically export to the library
If there are duplicate records, the system will prompt you to confirm whether you would like to save