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

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

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.

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?

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.

Hi,

You asked—we delivered. We’re excited to share that Product Import is now live! In a few quick steps, you can now easily import products directly into the Product List in a few different ways. Here’s how to get started:

1. In Form Builder, select your Product List and then click on the Shopping Cart icon.
2. In the Product List Settings menu on the right, click on Import.
3. In the Import Products window that opens, select the platform you want to import your products from: CSV/Excel, PDF, Image, or Shopify (in this example, we used CSV/Excel).
4. Drag and drop your file into the File Upload area.
5. It’ll automatically map your file’s fields to Product Fields. To change a mapping, click on the Downward Arrow under XLSX Fields to select a column or the X icon to delete it. And when you’re done, click on Review and Import.
6. In the Review Products section, click on the fields you want to change manually, or click the Pencil icon to generate text with AI.
7. Then, click on Import to continue.
8. That’s it! Your products have been added. Just click on the OK button to view them.

Here’s a breakdown of how they work:

• CSV/Excel: Upload your file, and Jotform AI will automatically detect and map your data to the product fields. You can review, edit, or generate missing fields with AI before completing the import.
• PDF/Image: Jotform AI will detect and extract product data for you.
• Shopify: Export your Shopify inventory—the exported file is fully supported for direct import.
• WooCommerce: Via API or Csv import

Thanks again for your feedback and helping us improve Jotform. Let us know if there’s anything else we can do for you.