"Something went wrong, try again"

I am trying to import a product list into a form in order to make sales from a portfolio on my website, however the form is not accepting my product list. There are 4 columns and 477 rows, so manual input is not an ideal solution. I have tried .xlsx, .xls, .csv, and .pdf files and they all get rejected for some reason. All it says is "Something went wrong, try again" so I can't pinpoint the issue.

Hi Cynthia,

Thanks for reaching out to Jotform Support. Let me help you with that:

When importing a product list into your form, Jotform supports importing from CSV, Excel, and PDF files, among other sources. Since you have a product list with 4 columns and 477 rows, importing via CSV or Excel is the recommended method to save time and avoid manual entry.

Here’s how to properly import your product list:

1. In Form Builder, select the Product List field and click on the Shopping Cart icon on the right side of it.
2. In the Product List Settings menu under the Products tab, click on Import.
3. In the Import Products window, select CSV/Excel and upload your file by dragging and dropping or selecting it.
4. Once uploaded, the fields will be automatically mapped to your product fields. Review the mapping and click Review and Import.
5. Review the imported products, uncheck any items you don’t want to import, then click Import.
6. After successful import, click OK to finish.

If you are seeing the message "Something went wrong, try again" for all file types, please ensure that your file is properly formatted according to Jotform's import requirements. Common issues include:

• File format not matching the expected CSV/Excel structure.
• Corrupted or unsupported file content.
• Exceeding any size limits or row limits.

Try to simplify your file or test with a smaller sample to isolate the issue. Also, ensure your internet connection is stable during the upload.

If the problem persists, please share more details about your file format or any error specifics you can observe.

Give it a try and let us know how it goes.

What are the row limits?

Hi Cynthia,

Regarding the row limits for importing product lists into Jotform, there is no specific documented maximum number of rows for product list imports. However, very large files might encounter issues due to size or complexity.

Since you have 477 rows, this is generally within a reasonable range, but if you experience issues, it might be related to file formatting or other factors rather than a strict row limit.

To troubleshoot, you might want to try importing a smaller subset of your product list to see if that works, then gradually increase the size.

If you continue to face issues, please check the file format and content for any inconsistencies or errors.

Smaller files are not working either.

Hi Cynthia,

Since smaller files are also not working and you continue to see the "Something went wrong, try again" message, the issue might be related to the file format or content rather than the size or row count.

Here are some suggestions to troubleshoot this further:

1. Check the file format and structure: Ensure your CSV or Excel file matches the expected format for product imports, with correct column headers and no extra formatting or hidden characters.
2. Try saving the file in a different format: For example, save your Excel file as a CSV UTF-8 file and try importing again.
3. Validate the data: Make sure there are no empty rows, special characters, or unsupported data types in the file.
4. Test with a very simple file: Create a new file with just a few products and basic columns to see if it imports successfully.
5. Clear your browser cache or try a different browser: Sometimes browser issues can affect file uploads.

If these steps do not resolve the issue, please provide more details about your file format and content so we can assist further.

I think I've figured it out--I saved a smaller batch as a PDF workbook instead of a PDF Sheet, though it still didn't import all of my data. It's a start.

Hi Cynthia,

Thank you for the update. It's great to hear that you identified the difference between saving as a PDF workbook versus a PDF sheet. The PDF sheet format is generally more compatible for importing data into Jotform.

Since it still didn't import all your data, I recommend continuing to use CSV or Excel formats for the most reliable import experience, as PDF imports can sometimes be limited or inconsistent depending on the file structure.

If you want, you can try exporting your data as a CSV UTF-8 file and import that into your form. This format tends to work best for large product lists.

Feel free to share any further details or questions you have as you continue working on this.

Hi Cynthia,

Appreciate your patience with the data import issues you've been experiencing. Happy to see that you've found some progress thus far.

I just wanted to check up on you regarding your progress now. Are you continuing to have issues with the Excel data being properly imported?