Uploading accurate data is essential to running your business smoothly. Start with clean, organized data using our templates to maximize efficiency and accuracy.
📥 Import Data in WebManager
- Log into WebManager
- Click Manage Data
- In the expanded list of options, select Upload Data Sheets
- Under the dropdown menu titled Choose what type of data you want to import, specify the type of file you’re uploading.
- Click Drop files here to upload to select your spreadsheet. You can either drag and drop the file or browse your computer to find it.
- Once selected, click Open
- In the preview screen, review your data to ensure accuracy, then click My Data Looks Good
- Click Push Data Live
🛠️ Common Upload Errors & How to Fix Them
| Error | Cause | Fix |
|---|---|---|
| Object reference not set to an instance of an object | Hidden formulas, blank rows/columns, or formatting issues | Copy and "Paste Values" into a new worksheet, or save as a .txt file and re-import |
| Excel Upload – Input string not in the correct format | Sort Order column is empty | Enter "0" for all items under the Sort Order column |
| Cannot get a text value from an error cell | Unexpected data in cells | Use Conditional Formatting to find and fix error cells |
| Network error when clicking "Upload my Data" | Corrupt spreadsheet data | Copy data into a new spreadsheet and re-upload |
| Upload Error – "EOF in Header" | File saved in .xlsx format |
Save the file as a .xls format and upload again |
| Target of an invocation | Duplicate headers present | Find and remove duplicate header rows |
| An error was encountered importing your file: An item with the same key has already been added. | Duplicate line items on file, cell(s) contain more characters than allowed; improperly formatted fields | Review formatting of cells, ensure they are under the max character count and there are no duplicate line items |
👀 View the Uploaded Files Log
Whether your manually uploading files directly into our system or have an integration which automates the flow of data from your system into ours, you can see what files have been uploaded into our system.
- To view your uploaded files log, do the following:
- Log into the WebManager portal
- In the left navigation, click Manage Data → View Uploaded Files
- Click on the Processed folder to view the files that have been uploaded
Note: Your folder structure may differ based on your upload process whether it's a manual process or an automated one.
💬 FREQUENTLY ASKED QUESTIONS (FAQS)
Q. What file types can I upload?
A. We recommend uploading .xls files. Some .xlsx files may cause errors unless converted.
Q. What if I need to upload multiple data sheets at once?
A. Each sheet must be uploaded separately. Batch uploading is not currently supported.
Q. How can I make sure my data is clean before uploading?
A. Use the provided templates and ensure there are no hidden formulas, blank rows, or duplicate headers. If you plan to use your own templates, you must map your data headers to our headers.
Q. What does "My Data Looks Good" mean?
A. It confirms that your data appears correct in the preview and you're ready to push it live.
Q. Why does my upload freeze or fail?
A. This could be due to a corrupt spreadsheet, incorrect file type, or internet connectivity issues. Click the refresh button or click Dashboard and then click Manage Data > Upload Data Sheets again.
Q. Can I undo a data upload?
A. Data uploads cannot be undone directly. To correct errors, modify your spreadsheet and upload again. Clean data is essential. Please review your data prior to uploading a data file to ensure accuracy and avoid errors and delays.
Q. Why is one column not uploading into the system?
A. Make sure the header name matches exactly what the system requires. For example, if your template uses “Base Price” (with a space), but the system expects “BasePrice” (no space), it won’t upload correctly. Adjust the header to match the exact format used in the system.
Explore our Resource Center
Quickly find answers to your questions by searching the ANDMORE Resource Center.
Contact ANDMORE Support
Need further assistance? Click the Support link located in the lower-right corner of your screen.