Create discounts (DIEF)

1. Open the required template: GroupsPromotions.xlsx
2. Edit the spreadsheet as follows:

   Header	Description	Value
   OfferID	Discount List Name	<GroupPrefix>MMYY
   Name	Promo Name	DD/MM/YY-DD/MM/YY Promotion
   Description		Leave blank
   RetailStatus		Y – Enabled N - Disabled
   PriceDiscGroup	Store Number	StoreID
   ValidFrom		DD/MM/YYYY 00:00
   ValidTo		DD/MM/YYYY 23:59
   DiscountCode		Leave blank
   ConcurrencyMode		Leave blank
   CategoryHierarchy		Leave blank unless the discount is for whole Hierarchy.
   CategoryName		Leave blank unless using a whole Category.
   UnitOfMeasure_Symbol		EA
   DiscountMethod		DiscPriceIncTax
   DiscOffer	Sale price including Tax - Number with decimals only, no $ required	x.xx
   QtyBreak		Leave blank
   QtyOffer		Leave blank

3. Click File > Save as and save as .csv file in an easy to find location. For example, your Desktop.
4. Click File > Exit to close your file.

   The file must be checked before being imported in Fred NXT Head Office.

5. Navigate to the file, then right-click the file and choose to Open with Notepad.

   Remove any blank lines at the end or spaced commas at the end of the file.

6. Press File > Save.

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

Ensure 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 GroupPromotions (or the relevant template), then click Get staging data.

   

4. Enter a Description, then click OK to close.
5. Click the File Path field to display , then click the folder icon 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.

If you have import issues a warning message is displayed.

1. Click Close on the warning screen.
2. To find the error log, return to GroupPromotions (or the relevant template), then click Execution history.

   

3. Select the problematic batch, then click Error Log.
4. In the Info Log window, read the error log details at the bottom of the screen, then Close.
5. Select the problematic batch again, then click View staging data.
6. Close when done.
7. Based on the error information, check and update your file (as applicable), then attempt the file import again.
8. Once successful, click Close.