Bulk import of suppliers
TidyWork provides a bulk import function to allow you to import suppliers faster.
To import suppliers into TidyWork, click on the Import/Export option in your Global settings. You will see the SUPPLIERS tab.
Follow the steps, download/open the template, and then add or copy your data (in this case, Supplier data) into the spreadsheet. Note that only the required fields identified (with reqd at the end) in the template need to include data, the rest can remain blank if the information is not available:
Supplier Headings
The Supplier import/export provides the ability to set the following columns in the CSV file:
| Column | Comments |
|---|---|
| Code | A material (or 'stock') code for your item (optional - leaving blank will cause an auto generated code). Up to 25 made up of - alphanumeric characters. Uppercase letters and numbers - optional. Special characters .... "-" (hyphen), "_" (underscore), "." (dot/period), or "/" or "" (backward or forward slashes) - must not contain or have leading or trailing spaces |
| Material Name | Required. |
| Material Category | Required. The full Material Category name as it appears in the Material Category tab under the Materials menu. Also known as Material Type. |
| Suggested Supplier | The full Supplier Name as it appears in the Suppliers list in TidyWork. Can be blank. |
| Usage Unit Pricing Unit | Required. Valid values are: ITEM, m, cm, mm, m2, cm2, mm2, m3, cm3, mm3 |
| Cost Currency Charge Currency | Required. The 3-letter ISO code for a currency that has already been added to the list of Currencies in TidyWork. |
| Unit Cost Unit Charge | Must be a valid decimal value. Invalid values will not be loaded. Can be blank. |
| Catalogue Price Currency | Required. The 3-letter ISO code for a currency that has already been added to the list of Currencies in TidyWork. |
After you complete and save the spreadsheet, click the Choose File and browse to the template file you have created. At this point, you will have the option to Import the file:
Once any necessary corrections have been made, repeat this step using the Import option to complete the data import. Once finished, you will be notified that the import was a success. You will be able to view the suppliers on user list by clicking Suppliers button in your Global settings.
You can also export the suppliers by clicking Export All Supplier Records on BULK DATA IMPORT/EXPORT screen. Modify the existing suppliers information or add new suppliers, then follow the steps above to import the suppliers.