Accolent ERP data Import Template Instructions provide field-by-field information on the data needed to fill out the CSV templates. Always review these instructions before populating a CSV import template.
| Field Name | Required Field? | Field Data Instructions | Sample Data |
| PRODUCT CODE | Required | Enter valid Product Code. Enter 20 character maximum. No spaces. Use only standard ASCII characters (no *, /, etc.). | 18JP1000 |
| UOMs Used | Required | Enter valid picking unit of measure (e.g., EA, CS, DZ). Note one UOM is entered on the Products Import template, that UOM together with all additional UOMs should be entered on this spreadsheet. | EA |
| DEFAULT STOCKING UOM | Required | Is this the Default Stocking UOM? Only one UOM can be the Default Stocking UOM. Enter Y or N. | Y |
| UOM RATIO FOR THIS UOM | Required | This entry specifies how many of the Default Stocking UOMs are in this UOM. If this is the Default Stocking UOM, the UOM Ratio will be 1.00. | 1 |
| PKG QUANTITY FOR THIS UOM | This is a short description of this UOM’s packaging (e.g., Pack of 5). | Pack of 5 | |
| SELLING UOM | Required | Is this UOM an available Selling UOM? Enter Y or N. | Y |
| DEFAULT SELLING UOM | Required | Is this the Default Selling UOM? Only one UOM can be the Default Selling UOM. Enter Y or N. | Y |
| PO UOM | Required | Is this UOM used for creating Purchase Orders? Enter Y or N. | Y |
| DEFAULT PO UOM | Required | Is this the Default PO UOM? Only one UOM can be the Default PO UOM. Enter Y or N. | Y |
| PRICING UOM | Required | Is this UOM the Pricing UOM? Only one UOM can be the Pricing UOM. Enter Y or N. | Y |
| PRICE FACTOR FOR THIS UOM | Required | This entry represents the factor by which the Price entered against the Pricing UOM has to be multiplied to get the Price for this UOM. If this is the Pricing UOM the Price Factor will have a value of 1 | 1 |
| PRICE | Required | If this is the Pricing UOM, enter the Price for this UOM. If not the Pricing UOM, leave this blank. | $50.00 |