Return to main navigation Page
You can validate Table Data by mapping Commerce and/or Configuration attributes to a Data Table column. When you add this functionality, the validation will determine if the Table Data is valid or invalid. Column data must match one menu value in the linked attribute.
Setting Up Data Table Validation
Navigate to the Data Table Administration page.
Click Admin to go to the Admin Home Page.
Click Data Tables in the Developer Tools section.
The Data Table Administration page appears.
Select a Validation Type and Validation Mapping for each row in the schema.
If validation type is 'Configurable Attribute', select from configurable menu attributes in the product hierarchy.
When adding a validation to a Data Table with existing data, and invalid data is present, a button named Invalid Data will allow you to:
Import .CSV will not update existing record. but it will allow you to modify values.
To replace the table, you must clear the Data Table and upload the file. Alternatively, delete the table and upload a new one through .CSV.
Validating Against Both Menu Attributes
If you are migrating a Data Table that has a commerce menu attribute validating one column and a configurable attribute validating another column:
Another option is to remove either the commerce or the configuration validation, migrate the Data Table, and then add the validation back to the migrated table.