Materials are the raw materials used in producing a new product in the manufacturing unit. Creating Materials data helps the manufacturers maintain appropriate stock levels of raw materials required for manufacturing a new product in the production environment.
How to prepare the 'Materials data' in the data import process?
SFactrix Data import process helps its users to import bulk materials data (master data) into their accounts from external sources through a CSV file. Importing multiple raw materials’/child parts’ data becomes effortless with SFactrix Data import process.
This guide will feature a step-by-step guide to fill in the data for ‘Materials’, in a CSV file format.
Pre-condition: A supplier is a person/company that provides raw materials/items/entities to the manufacturing unit that are used to manufacture a final product or part. Hence, the user should provide the Supplier data while importing data for ‘Materials’ in a CSV template.
To begin filling in the data, Login into SFactrix.ai | Login
Home > Data Import > CSV template.
Click on the link mentioned against ‘Materials’ in the CSV template links.
CSV template is downloaded successfully.
Please note the details of each parameter in the ‘Materials’ CSV template required to fill in the Data. Enter each data carefully to avoid importing invalid data into your account. Make sure no changes are made to the CSV template headers.
Field | Description |
Material Code
| Enter a unique Material code for identification. |
Material Name
| Enter the name of a particular Material in minimum 3 characters. |
Material Variant
| Enter Material Variant in minimum 3 characters (type of material, material texture, etc). |
Description
| Describe briefly about the material for reference. |
Supplier Name
| Enter the supplier’s name of the particular material. |
Purchase Cost
| Enter the cost of purchasing the material. |
Purchase Currency Code
| Enter the currency code for the purchase of the material. |
UOM
| Enter the unit of measure for the material quantity. UoM can be entered as kg, tons, units etc. |
MOQ
| Enter the quantity of material ordered. |
Delivery Time (in Days)
| Mention the delivery time (in days) to deliver the required quantity of material. |
Storage Location
| Mention the place/location to store material, in minimum 3 characters. |
Notes
| Brief a note on each material in minimum 3 characters for the reference purpose. |
Name the file as per your choice.
Save the file in your system to upload it later into your SFactrix account.
How to import ‘Materials’ Data CSV file to the SFactrix account?
To import the ‘Materials’ data to the SFactrix account, log in to SFactrix.ai | Login
Go to the Data import page > click on choose the data type > select ‘Materials’ in the drop-down list.
Click on ‘choose a file’ and select the CSV file that you have saved in your system.
Click on the ‘Submit’ button.
Your ‘Materials’ data is imported successfully.
What's Next?
Please refer to the following page for details of each parameter required to fill in and import the 'Work-orders' data in the CSV template.
For any feedback and queries on the functionalities of the ‘Materials’ data import write to our support team at [email protected]