If you're experiencing issues when uploading a table to AMP, a red error message will appear with a description of what went wrong. Start by reviewing the message carefully, as it usually provides specific information about the issue. For example, you might see an error if columns haven't been tagged correctly, or if the “SKU” column is missing:
If the error message doesn’t resolve the issue, follow the troubleshooting checklist below:
1. Check File Format
Make sure the file you're uploading is in CSV format:
- In Excel, go to File > Save As.
- Choose CSV as the file format and save the file.
2. Remove Empty Rows or Columns
Ensure there are no empty rows or columns in the spreadsheet:
- Scroll to the bottom and end of your table to check for any unnecessary empty rows or columns.
- Delete any empty rows or columns before uploading the file.
3. Verify SKU/Product ID Column
Make sure every row has a value in the column you've tagged as SKU/Product ID.
- Ensure that all SKU/Product ID values are unique.
4. Check Column Header Consistency
If you're updating an existing table, verify that the column header you've tagged as SKU/Product ID exactly matches the header in your file upload.
- The tag in AMP should align with the column header in the CSV file.
By following these steps, you should be able to resolve most issues with uploading tables to AMP. If you're still encountering difficulties after checking these points, feel free to reach out to our support team for further assistance.