Wiki

    Contact support:

    Email: support@erply.com

    9 Nov, 2021
    Permalink:
    Also available in:EstonianFinnish

      Product recipe import


      Product Importer allows you to Import recipes for Bundle and Assembly products. 
      You must first have created a Bundle or Assembly product.

      Once the product has been created in Erply, you need to make an excel table with the code, quantity and product code of the product to be added to the recipe.

      If the product to be added to the recipe is available in Erply, the Importer will recognize it. If the product is missing, the Importer will add it to Erply. 
      In this case, more information should be filled in for the new product, such as name, product group, price, etc.

      When the spreadsheet is ready, you can upload it for Import. Go to PIM - Import Products - Add Products. 
      Then upload your file in either xlsx or CSV format. Check File has headers and click Create.

      Type: 

      • Select type Regular Products

      Configurations:

      • Match existing Products by Product Code - Then the importer will know if the recipe product has already been created or not and under which Bundle / Assembly product should it go.
      • Select Operation Add new and update - This allows the importer to update the Bundle / Assembly product information and if necessary add a new product if it does not already exist in Erplys.


      Mapping: 

      • Select the headings for the columns, if it is a Bundle product, select Bundle product and if it is an Assembly product, select Assembly product. 
      • Apply and validate configuration 
      • Confirm and start the import

      When the import is complete, reopen the Bundle / Assenbky product and select tab Recipe. 
      There you will now see the imported Recipe products and their quantities. 
      It is also shown what is the total recipe cost for these products.