Products or Parts are the final items produced by the organization through manufacturing process. In SFactrix, Parts are build through production process as per customer work orders. Creating parts master data helps the manufacturers to create work orders and execute the manufacturing process, maintain timely delivery and maintain the quality of each constituting a final product.

SFactrix Data import process helps users to import bulk products or parts master data into their accounts from external sources through a CSV file. Importing large volume of 'parts' master data becomes effortless through SFactrix Data import process.

How to prepare the parts master data for data import process?

This guide will feature a step-by-step guide to fill in and import data for ‘Parts’, in a CSV file format.

  • To begin filling in the data, Login into SFactrix.ai | Login

  • Home > Data Import > CSV template.

    Parts data CSV template

  • Select the data type template ‘Parts’ from the CSV template links.

CSV template is downloaded successfully.

Parts data import template

Please note the details of each parameter in the ‘Parts’ 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

Parts / Item Code

Enter a unique Part code in minimum 3 characters for identification. Also, the Part Code is also required while creating Work-Order data.

Part / Item Name

Enter a unique name for each Part in minimum 3 characters.

Description

A brief description of the operation of the Part in minimum 3 characters.

is Child?

Enter Yes/No. Yes, if the Part is a subset of the parent part. Child Part is non-sellable and is put together according to the requirements to form a Parent Part.

Parent Part Code (If Child)

Enter the parent part unique code if it is not a child part.

is Purchasable?

Yes/ No. 'Purchasable' if the part is purchased from a supplier.

Manufacture Cost

Enter the cost incurred during the manufacturing of the Part. Enter the correct cost as this information will be used in the metrics.

Manufacture Currency Code

Select the currency code depending on the location of the Plant.

Sales Cost

Enter the exact selling cost of the Part.

Sales Currency Code

Enter the currency of the location where the Part is sold.

Quantity in Stock

Enter the quantity already available in stock to calculate the quantity to be produced.

UOM

Enter the UoM (Unit of Measure) for the quantity specified like (litr, ton, pcs, etc)

Cycle Time (Mins)

Enter the Cycle Time of the part’s production (in min), which is the time taken by the asset to produce 1 quantity of Part.

Manufacturing Process (Parallel or Sequence)

Enter the manufacturing process ‘parallel’ or ‘sequence’. 'Parallel' when a particular Part can be produced simultaneously with another Part of the same Product. 'Sequence' when each Part that belongs to a Product should have a sequence of production and cannot be produced simultaneously.

Supplier Name

Enter the Supplier's name from whom the Part is being supplied.

Supplier Model Number

Enter the model number of the supplied Part.

Supplier Lead Time

Enter the Supplier Lead Time i.e., time taken (in hrs) to deliver the ordered Part.

Supplier Price

Enter the Supplier's price for the Part ordered.

Supplier Currency Code

Enter the Supplier's currency.

Sample data shown below after filling it.

Parts data
  • Name the file as per your choice.

  • Save the file in your system to upload it later into your SFactrix account.

How to import the ‘Parts’ Data CSV file to SFactrix account?

  • Go to the Data import page and choose the data type as ‘Parts’ in the drop-down list.

  • Click on ‘choose a file’ and select the CSV file you have saved in your system.

  • Click on the ‘Submit’ button.

  • Your ‘Parts’ 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 'Materials' data in the CSV template.

https://help.fogwing.io/en/articles/6423030-import-materials-data-in-sfactrix

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

Did this answer your question?