Validation of the order guide file
After you upload an order guide file, its contents are validated. The total number of
records and the total valid records are calculated. You can review the results of the
validation in the File Upload Details form in the Business Center.
To be considered valid, the customer or item must exist in the database. Item visibility factors, such as whether the item is in the customer's assortment, are not considered during validation.
These calculations are made during validation:
- The total number of records. This formula is used:
number of customers * number of items - The total number of failed records. This formula is used:
(invalid customers * total number of items) + (valid customers * invalid items) - The total number of valid records. This formula is used:
(valid customers * total number of items) - (valid customers * invalid items)
If failed records are found, the reason for the failure is displayed in the Results section of the File Upload Details form. During validation, the name of the order guide is also analyzed. If the name in the file matches the name of an existing order guide for a customer in the file, you are notified in the Results section. If you upload an order guide for a customer that already exists, the contents of the customer's order guide are replaced.