Manage coverage groups (DIEF)

1. From FredNXT Head Office, navigate to Inventory and purchasing > Setup > Coverage, then click Coverage groups.

   

2. Select the relevant Coverage group.

   

3. From the File menu, select Export to Excel to export the Coverage Group data from your existing system and save as a spreadsheet.

   

4. Open a blank spreadsheet and copy the relevant data.

   The columns in your .CSV file must be named and ordered exactly as specified in the template to ensure successful import into Fred NXT Office.

   You can also use a blank template to import new Coverage Groups. See GroupsItemCoverage.xlsx

   The following column headers are used to store the following values:

   Header	Value
   ItemId	Product ID
   VendId	Vendor ID
   MinInventOnhand	Safety Stock Qty
   InventLocationId	Store ID
   InventSiteId	Store ID
   ItemCovFieldsActive	Always set to 1

5. Save as .CSV file in an easy to find location. For example, your Desktop.
6. Navigate to the newly created file, then right-click the file and choose to Open with Notepad.
7. Remove any blank lines or spaced commas at the end of the file.
8. Save your file again.

   The file is now ready for importing into Fred NXT Head Office with DIEF.

Ensure the file is closed and in .CSV format before trying to import it.

1. From the Fred NXT Head Office Dashboard, navigate to the Store integration section.

   

2. Click Data Import Export Framework > Processing group.
3. Select ItemCoverage, then click Get staging data.

   

4. Enter a Description, then click OK to close.
5. Click the File Path field to display , then click and browse to the .CSV file you have created.
6. Select Execute Target step, then click Run.

   This is the fast option for importing the file as it takes the file directly from Staging into Target.

7. (Optional) Select Batch mode if you wish to run the import in the background. If Batch mode is not selected, the import runs in Client mode.
8. Click OK to start the import process.