Can I import products via excel/google sheets?

When creating an order form, am I able to import the product list, rather than upload one-by-one/manually?

Hello Caitlin,

Thank you for reaching out to Jotform Support. Unfortunately, each product has to be added one at a time. However, I will make a feature request for this functionality but please note that we are not able to guarantee an ETA of when this will be developed and implemented.

Let us know if you have any further questions or concerns.

Hi Caitlin 

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.