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.

    csv template link

  • Click on the link mentioned against ‘Materials’ in the CSV template links.

  • CSV template is downloaded successfully.

Materials Data import template

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.

Materials Data import tem
  • 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?

  • 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.

https://help.fogwing.io/en/articles/6423431-import-work-orders-data-in-sfactrix

For any feedback and queries on the functionalities of the ‘Materials’ data import write to our support team at [email protected]

Did this answer your question?