How to Import Bill of Materials for Products

Associate Raw Materials with your Products via a Bulk Upload

Brenda Beckham avatar
Written by Brenda Beckham
Updated over a week ago

Once you have your Raw Materials in Uphance, you will want to associate them with your Products.  You can do this manually or you can perform a Bulk Upload.  

To perform a Bulk Upload of the Raw Material associations, navigate to Product Information >> Products. Click the Actions button and select Upload Bill of materials and services import. Then select the Bill of Materials file and upload it.

If you don't have an existing file, download the spreadsheet template, populate it and re-upload it to the system.

Data Fields for Product Association with Raw Materials

Listed below are the fields that will be used to associate your Raw Materials with your Products.  The fields that are required fields are noted below as well.

  • product_identifier (required)

  • product_name

  • season (required)

  • product_variation (required)

  • product_size

  • material_name (required)

  • material_variation (required)

  • material_size

  • material_quantity

  • material_wastage (if blank, this field will be set to zero)

Related Knowledge Articles:

Did this answer your question?