Can I upload a csv file to populate the Product List?

Is it possible to import the product data from a CSV file into the product field directly? Now, I need to enter the data into the price list one by one, and it really takes a lot of time to do it because I have many forms that need to update the product prices.

Hello Giormani,

Thanks for reaching out to Jotform Support. Unfortunately, it is currently not possible to import products in bulk through CSV or Excel files. The only option currently available is to manually add products one by one in the payment field.

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. You may check our detailed guide on how to use the spreadsheet to form widgets by clicking this link. Also, it is possible to import data in Excel or CSV format. You may take a closer look at our guide on how to import excel or CSV data into Jotform.

We've gone ahead and escalated your request to our developers, but when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

Thanks for your patience and understanding, we appreciate it.

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.