Sales Item Import - Update SSIS Package

As a Product Owner I want the SSIS package that processes the Sales Item file that CFA provide to be updated to handle a Country Code

Notes

Current Process

Input

• Sales Item csv

Run thru SSIS Package

Output

• Sales Item Master csv
• POS Item Mapping csv
• Sales Item Change csv

Future process

Input

• Sales Item csv

Run thru SSIS Package

Output

• Sales Item Master csv (Including Country Code)
• Sales Item Entity csv Not implemented
• POS Item Mapping csv (with country code support)
• Sales Item Change csv

Post process

• Make items Active/Inactive, based on Country Code

Acceptance Criteria

1. Confirm when the Sales Item csv is processed by the SSIS package, that the four files defined above are generated
2. Confirm that if the Country attribute is not present in the Sales Item csv the SSIS package still processes and generates the files successfully
3. Confirm that the Sales Item Entity file is created and converts the Country Code in the Sales Item csv into something that we can use as a Zone
   • Note: any changes to the import will be under another story
4. Confirm that the POS Item Mapping file is created and converts the Country Code in the Sales Item csv into something that we can use as a Zone
   • Note: the change to the import to support a zone will be under another story