Attire Import Overview
Steps for Import
Suggestions and Best Practices
Steps for Import
Step 1: Access The Import Template
Click the link below to access our import template. This is a read-only link, so you will either need to make a copy into your own Google Drive (recommended) by clicking File -> Make a copy or download and edit the sheet in excel (not recommended) by clicking File -> Download.
Our support team highly recommends that you complete this process in Google Sheets - Excel and other spreadsheet editors can apply automatic formatting that may not be compatible with our importer.
CutTime Attire Import Sheet
Step 2: Populate Your Data
Copy and paste (values only - see note below) your data from your current spreadsheet into the CutTime import template. The column headers in the import template should not be edited.
The import template is pre-formatted to ensure your data aligns with the required format for successful import. To preserve this formatting, please paste your data using the 'Paste Values Only' option. On Windows, use Ctrl + Shift + V; on Mac, use Cmd + Shift + V. Alternatively, right-click and select Paste Special > Values Only when inserting data into the template
Step 3: Save As A CSV
When you have finished populating your import template, you are ready to save and upload it to our import helper for verification. The file will need to be in CSV format for our importer.
- In Google Sheets, click File -> Download -> Comma Separated Values (.csv)
- In Excel, click File -> Save As and change the format from Excel Workbook (*.xlsx) to CSV (Comma delimited) (*.csv)
Step 4: Upload and Import
Once you have your CSV file saved and ready to import, navigate to the Import Data page and click the “Attire” option. Click "Browse select the CSV file you just saved, and click "Preview & Clean-up Data" to open the import helper. The import helper will generate a table displaying the data from the file that you just uploaded. From this screen you can make any final edits necessary before completing the import.
Importer Definitions
Valid records will appear in the table without any highlighting and a green check mark. These records can be imported as-is, but you can also edit them as necessary.
Invalid records will be highlighted red in the table. These records cannot be imported and must be either edited or skipped before the import can be completed.
The field(s) that are not accepted will appear with a help tip in the edit form so you can see why it is invalid and make the necessary adjustments.
Skipped records will be highlighted in dark gray. These records will not be imported, meaning that skipping an invalid record will not prevent valid records from being processed. Both valid and invalid records can be skipped. If a record is skipped by mistake, you can reopen the edit form and select "Unskip" to include it in the import.
Edit A Garment
- At the top of your preview, you will see a red box displaying the number of records with an error. Click "Address next error" to open the edit form.
- After you open the edit form, you can make adjustments to any of the fields that were originally imported. Fields with issues will be highlighted with a red message to indicate the specific problem.
- When you're finished editing, click "Next Error" to save the garment's updated record with your changes. Even after saving, you can click on the desired line to reopen the edit form and make further changes. Fields that have been previously modified will display a blue “Edited” message above them.
- If you'd like to exclude a garment from the import, you can click "Skip row" instead. Skipped records can also be unskipped. See above for more information about skipped records.
Once all attire records have been reviewed, click the green "Validate" button. Any records containing errors will be highlighted in red, and the total number of errors will be displayed at the top of your screen.
Review and correct any errors, then click "Validate" again to confirm the updates. When no errors remain, click the "Save" button to proceed.
A confirmation message will appear indicating the number of records ready for import. To complete the process, click "OK" to proceed with the import.
Once you click the green "Validate and import" button, you're done! Any records that were not skipped will now appear in your Attire page.
Finishing a Partial Import
You can revisit any completed import with skipped or invalid rows at your convenience to edit or unskip them, allowing for the inclusion of those records in a subsequent import.
- Navigate to the Import Data page, and find the import log that you'd like to continue
- Click the "Resume" button on the right side of that row.
- Make any necessary edits to invalid records or unskip any rows.
- Validate and Import!
If you have questions during the inventory cleanup and reformatting process, you can reach out to support@gocuttime.com for help - we are happy to answer your questions and help you with challenges that come up.
Suggestions and Best Practices
Some tips from our support team as you compile and clean your inventory data:
Always save a backup of your original data before making any changes.
Before editing your inventory file, be sure to create and store a copy of the original version. Spreadsheet edits can be prone to errors, and those mistakes may not be immediately obvious—sometimes only becoming apparent after significant work has already been done. While a backup may not recover lost progress, it provides a reliable reference point and ensures you have access to the original data should you need to start over or verify any details
Maintain consistent naming conventions throughout your data.
Inconsistencies in naming—such as using both “FJM” and “Fred J. Miller” for the same manufacturer—can lead to data discrepancies during import. Our support team frequently encounters these types of variations. To help identify and correct them, we recommend using the filter and sort functions in your spreadsheet editor before proceeding with the import.
Review your data for duplicate records.
It's not uncommon to encounter duplicate entries for garments within a spreadsheet, particularly when working with large datasets. While this process tends to be more straightforward in Excel than in Google Sheets, identifying duplicates is an important step before importing your data.
In Excel, you can quickly highlight duplicate Item Numbers by selecting the relevant column and navigating to:
Conditional Formatting > Highlight Cells Rules > Duplicate Values.
This will visually flag any duplicate item numbers, making it easier to identify and remove outdated or redundant records prior to import.
- To highlight duplicates in Google Sheets:
- Select the column containing your Item Numbers.
- Click Format > Conditional Formatting.
- Under “Format cells if,” choose Custom formula is.
- Enter the formula: =COUNTIF(A:A, A1) > 1 (replace A:A with your actual column if needed).
Choose a highlight color, then click Done.
This will visually flag duplicate values in the column, allowing you to review and remove any redundant or outdated records before importing your data.