Can I import product data from a CSV into the Product List?

  • Profile Image
    ceemjay
    Asked on June 21, 2020 at 11:16 AM

    Great start but only becomes useful when products can be imported from a CSV file.Need an indication of the max number of products it can handleWould be nice to have product options with different prices eg door knobs could be in steel, chrome or brass all at different prices



    This is a re-post of a comment on Introducing a new product list form field

  • Profile Image
    Basil_A
    Answered on June 21, 2020 at 02:13 PM

    Hi,

    Unfortunately, it is not possible to import the product data from a CSV file into the product field directly.

    It is possible to use the spreadsheet to form a widget to allow the user to select products and the price can be transferred to a payment field.

    https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    It is also possible  to import  data in Excel or CSV format to JotForm, please check this link for more information: https://www.jotform.com/help/308-Import-App-Easily-Import-Your-Excel-or-CSV-Data-into-JotForm

    Let us know if you have any further questions.

  • Profile Image
    ceemjay
    Answered on June 21, 2020 at 02:50 PM

    Thanks can I suggest you consider implementing this feature urgently?  Maintaining a large list of products through that interface is unmanageable.

    Using the sheet-to-widget how does the customer know what the codes are?

    Not sure how the import option you mentioned would help me in any way or am I missing something?


  • Profile Image
    jonathan
    Answered on June 21, 2020 at 07:28 PM

    I have now also submitted a feature request ticket to the development team using the details provided on this ticket.

    Because it is requested feature, we cannot provide you any time frame as to when it will be available. But we will notify you here and in your email for any news/updates on the status.

    ---

    Using the sheet-to-widget how does the customer know what the codes are?

    You will have to do a workaround for this on the design of your form. Example you may send to the customers ahead the list of available codes via email, or have it posted on a website page where lists/catalogues can be check.

    ---

    Not sure how the import option you mentioned would help me in any way or am I missing something?

    After you are able to import the data into the form submissions, you can use the submission edit feature to allow updating the submission of the form. You can use the existing answered fields in calculations/conditions to create the product list or payment options on the form.