Version: eXtendMultiFulfillment 1.0.3 and above
Audience: User

Overview

The eXtendMultiFulfillment pre-fulfillment upload feature validates common data and formatting errors in CSV/Excel files being uploaded. This allows errors to be corrected before pre-fulfillment record creation.
Row numbers in validation messages are zero-indexed, meaning counting begins at 0. Therefore, spreadsheet line 41 is displayed as row 40 in validation messages. Example messages include “Invalid city at row: 1”, which would be spreadsheet row 2, and “Invalid zip code at row: 13”, which would be spreadsheet row 14.

Usage

The pre-fulfillment upload validates the following categories during CSV/Excel file upload:

CSV/Excel Column Headers

Column headers in the CSV/Excel sheet are validated to avoid data mapping issues. eXtendTech recommends downloading the sample template available on the eXtend Multi-Fulfillment Upload page to ensure proper column headers.


The following columns are mandatory for each line in the upload file:

  • Sales Order
  • Prefulfillment Item Shipment Group
  • Ship Date
  • Ship Method

Data Type Validation

The data types for the following fields will be validated. If the values do not match the expected data type, a validation error will be displayed:

  • Item Quantity (Data type: Integer)
  • Prefulfillment Item Shipment Group (Data type: Integer)
  • Ship Date (Data type: Date)

Address Validation

eXtendMultiFulfillment validates shipping addresses when pre-fulfillment records are created from a spreadsheet upload (Excel or CSV). Validation runs on the entire file before any records are created. If any row fails, the upload stops and no pre-fulfillment records are created.

Only addresses in the United States will be validated. An address will be validated if the country is specified as US, United States, or United States of America. The State, City, and Zip Code validations are provided by the NetSuite system.
  • State: The specified state will be validated against the valid states of the United States.
  • City: The specified city will be validated against the valid cities for the specified state.
    Image Placeholder
  • ZIP Code: The specified ZIP code will be validated against the valid ZIP codes for the specified city.
    Image Placeholder

Frequently Asked Questions (FAQs)

Q: What should I do if I encounter validation errors during upload?
A: Review the error messages, correct the data in your CSV/Excel file according to the validation requirements, and attempt the upload again.

Q: Can I validate addresses for countries other than the United States?
A: Currently, address validation is only available for US addresses. For other countries, ensure the address information is entered correctly according to the country's format.

For more details on using the Pre-Fulfillment Upload feature, see Creating Prefulfillment records using Multi-Fulfillment Upload.