Skip to main content

How To Import Products into Product Map via CSV Upload

Anita Vithayathil
  • Updated

 

1. Product Version History

Version Purpose Date
V01 Initial Write up 11/24/25
V02 Structure updated.  12/7/25
V03 Updated to reflect update of step attribute from cycle time to unit cycle time 12/15/25

 

Change notice: Product Map now uses Unit Cycle Time (Effective 11 Dec 2025)

  • We’ve standardized Product Map to store cycle time per unit. React will automatically convert this to a per‑panel target using your boards per panel, so you don’t need to do any extra math.
  • The old per‑panel “cycle_time” field is being retired—please use “unit_cycle_time” in uploads, and note that React targets are shown per panel. If boards per panel isn’t set, React assumes 1 by default. 

 

2. Purpose of this Feature

What This Feature Does

This feature allows user to

  • Upload new products into Product Map via CSV
  • Upload new Steps into Product Map
  • Update existing Steps with the right attributes (ex. Unit Cycle time)

Who should use it

Admins from each site are expected to keep the Product Map up to date with Steps, Substeps, and attributes.

What value does it bring

It enables React to have all the right information when a new job starts which in turn allows accurate downtime tracking.

Where it appears in the UI

This feature is visible on the Product Map UI.

 

3. How This Feature Connects to Other Product Areas

  • React: Every job in requires Product, Step, and Target cycle time (among other values) in order to accurately determine downtimes. These values come from Product Map. Note that the step attribute stored in Product Map is "Unit cycle time", while React's target cycle time is per panel. If Product and Step when a React job is created, then the "Unit Cycle Time" from Product Map step attribute is automatically multiplied by the "Boards per Panel" from Product Map step attribute to get the React's "Target Cycle Time (per panel)".
  • Factory Map: Each operation must be mapped to one or more lines in Factory Map. 

 

4. Step-by-Step Usage Instructions

1. Navigate to Product Map

2. Click on 'Import CSV'

3. Click "Import Product Map CSV"

4. If you do not already have a template, click "Download template" to obtain a CSV template copy.

5. Import the template into Excel, Google Sheets, or another CSV editor. Populate the template with desired values.

Each row represents a 'Step' or operation. Therefore if you want to enter SMT Top and SMT Bottom step, enter 2 rows in the spreadsheet with different Step Names.

Tip: What fields are needed for successful upload?

  • [Mandatory] Site Name: must match Factory Map
  • [Mandatory] Area Name: must match Factory Map
  • [Mandatory] Line Name: must match Factory Map
  • [Mandatory] Product Part Number: String
  • [Mandatory] Step Name: String
  • [Optional] Product Revision: String
  • [Optional] Product Name: String (human-readable version of Part number)
  • [Optional] Product Description: String
  • [Optional] Product Customer: String
  • [Optional] Buildable: 1,0 or true/false
  • [Optional] Unit Cycle time: Cycle time for 1 unit (e.g. 1 board)
  • [Optional] Boards Per Panel: Integer
  • [Optional] Default Headcount: Integer
  • [Optional] Newly Added: 1,0 or true/false

Note

  • Boards per panel, Default Headcount, Unit cycle time are considered 'Mandatory' by certain customers. Please check with your admin to confirm.
  • All values are case-sensitive (customer, part number, etc.)
  • If the header exists, the CSV upload functionality expects a value


 

Tip: What if I want to upload an attribute that does not exist in the CSV template? 

  • Not supported currently. Please add the attribute via the UI.


 

Tip: What if I want to state that the same Step is run on multiple lines?

  • Create a new row per line (and per step). You may enter different cycle times per line.

6. Extract the CSV to prepare for upload into Product Map.

7. Navigate back to Product Map > Import > Import CSV > Choose a file

8. If you followed the template, you should be able to select "Confirm selection and continue".

9. Confirm that the import matches your expectations.

Click "Finish" > "Yes"

10. You will see a banner with the following message. Once the upload is complete, you will receive an email with a 'Success' message or an explanations on what errors occured.

11. Alternatively, click on 'Queue' to view how your upload is being processed.


 


 

Related articles

Comments

0 comments

Please sign in to leave a comment.