Test Validate each row of shipment file

Description

Each row of a shipment file needs to be validated to ensure that

The order code is the same for each row.
The quantity ordered column is an integer greater than or equal to 0.
all values for Product Code, must map to corresponding existing values in the database.
error is produced if there are unknown products are in the file (unknown product code)
error is produced if there is no non-negative integer value for Quantity Shipped
error is produced if Quantity Shipped for a product is present but Product Code is not
error is produced if Product Code for is present but Quantity Shipped for that product is not
Acceptance criteria:

Validation is run for each row. If the validation does not pass, the shipment line item does not get persisted in the shipment_line_items

a. Fulfillment services started
b. Ftp server is running
c. Fillezilla is installed, configured and running (Filezilla was used for this test). Remote server was available. Local ftp server was used.
d. Data files are created (see list below)

1. product-not-found.csv


2. quantity-shipped-negative.csv


3. product-left-blank.csv


4. quantity-shipped-blank.csv


5. different-order-numbers-in-rows.csv

Assignee

Unassigned

Reporter

Muhammad Ahmed

Labels

None

Components

Sprint

None

Fix versions

Affects versions

Priority

Major
Configure