Product List: Import products from excel.

Dear SUpport

i need to create an order form for our customer. The customer orders 500 items from us. I have my product list in excel (as attached ). How can i import the items to the form?

i

Hi Amore,

Thanks for reaching out to us for help. You can import your excel data to Tables easily let me show you how:

1. In My Forms page, click on My Forms.

2. Click on Tables in the window that opens.

3. Click on Create Table.

4. Then click on Import Data.

5. Click on Upload File and select the excel file you want to upload.

6. Switch the Set the first row as column headers option to ON.

7. Click on Import Data.

That's all. If you intended to do something different you can get back to us anytime with the details.

HI

I NEED THE excel item code to be the product list

at the moment, we have manually add the item in product list

Hi Amore,

Thanks for getting back to us. Unfortunately, it's not possible to import external data to the Product List element. You will have to manually setup each products in the form.

While the feature you're looking for is currently not available, 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,

is there any alternative for us to upload 500 record of product list ?

Hi Amore,

Thanks for getting back to us. Unfortunately, there's currently no way around this. Uploading products from another source is not possible at the moment. But I've already escalated this to our Developers as a feature request. Once we hear from them for any updates, we'll let you know.

Thanks for your understanding, we appreciate it.

Hi lshamore47

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 support will be available soon!

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