Syncing Product List element with data/inventory from an Excel file

How can I incorporate my excel inventory into my products?

Hello Pichardo_Maximo,

Thanks for reaching out to Jotform Support. The items(and their stocks) in the Product List element have to be manually added; I'm afraid it cannot be automatically synced with data from an Excel file. I've gone ahead and escalated this as a feature request to our Developer Team. When or if it's developed depends on their workload, how viable it is, and how many other users request it. If there are any updates, we’ll circle back to this thread and let you know.

Let us know if you have any other questions.

Thanks for the update. I really appreciate it.
...

Hi Pichardo_Maximo

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.