Entering a large number of product rows into documents can be very tedious and error-prone. Luckily, if you've already got an Excel sheet or CSV file with all the product rows & information you can import it into your document in just a few clicks.
Option 1: Copy and Paste Rows from Excel
- Click Import Lines
- Copy and paste from your Excel file into the respective spreadsheet columns in the import modal.
- Check that the data you're importing is correct
- Click Continue in the bottom right then Submit
Note: The columns in the import modal directly represent those in the document product table.
Option 2: Importing Data from a CSV File
Already have a CSV file from your ERP or Inventory Management system? You can import it quickly and easily by following these steps:
Step 1: Format your CSV file correctly
Click below to download template CSV files for each document type:
Note: Make sure that your file is a .CSV, .TSV or Excel format. You will have to make sure that the first row in your spreadsheet contains the correct column names.
Watch How to Import your CSV file
Step 2: Import Your File into a Document
While creating a document, click the 'Import lines' button.
There are 2 options you can use to import contacts:
1) Upload your contacts via a CSV file
2) Copy and paste directly into the spreadsheet.
Step 3: Matching Your Fields
After you finish uploading your data, you’ll need to match each column from your spreadsheet to a field in IncoDocs. In some cases, IncoDocs will recognize your column name and do the work for you. You'll also see a few preview rows from your spreadsheet so you get a good idea of what's in each column.
Automatically matched fields will show "Matched to the ______ field" and give you the option to click 'Confirm mapping'. You can also continue without doing so if you're happy with the auto-matching.
If you don’t want to import a column from your spreadsheet, click ‘Ignore this column’ on each field box.
To match the data from your spreadsheet to the right place in IncoDocs, click the dropdown arrow next to the column names.
Click ‘Review’ at the bottom of the modal to move to the next page.
Resolving Validation Errors
The Products Importer will highlight any errors in your data and let you fix them up before submitting. Fields with errors will be highlighted in red and hovering over the field will give you a description of the error so you know what to fix.
💡 PRO TIP: To see just the rows that have errors, you can toggle "Only show rows with problems" in the top left.
Then you can work your way through until there are no more errors. Then turn off the toggle and review your data one last time before continuing to the final step. Once you've reviewed your data and there are no errors, click 'Continue' at the bottom to start the import.
If you need help using this feature, reach out to us in the chat box at the bottom right, or email email@example.com