Update Sales Prices for Products (DIEF)

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

   Field	Definition	Value
   JournalName	Name of the journal being imported	Sales
   AccountRelation	Price group	Price Group
   ItemRelation	Product item number	123456
   QuantityAmountFrom	Used if there is qty breaks	1
   QuantityAmountTo	Used if there is qty breaks	x or Blank
   UnitId	Unit of Mesure	ea or PACKxx
   Amount	Trade Agreement Price	Price
   FromDate	Date when Trade Agreement becomdes active	dd/mm/yyyy
   ToDate	Date when Trade Agreement ends	dd/mm/yyyy
   FredItemDescription	Product item name	TestProduct 100mg, 60 Caps

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 importing.

1. From the Dashboard, navigate to Data synchronisation > Store Integration > Data import Export Framework > Processing Groups.

   

2. Select GroupsPriceAdjustment (or the relevant Group name), then click Get staging Data.

   

3. Enter a Description then click OK.
4. Click the File Path field to display
5. Click and browse to the import file.
6. Select Execute Target step.

   

   This is the faster import method as it transfers the import file directly from Staging to Target.

7. Click Run (in the ribbon).
8. (Optional) Select Batch mode, then click OK. This mode allows you to do other work while the import is processed.

   If no selection is made, the import runs in Client mode. It remains displayed on screen.

   If Fred NXT Head Office encounters any issue during the import, a warning message is displayed.

   

   1. Close the message.
   2. Select GroupProducts, then select Execution History to locate the Error log.

      

   3. Select the batch, then click Error Log.

      The error log details are located at the bottom of the screen.

   4. Close the error log.
9. Update your file to correct any data or formatting error, then attempt the import again.
10. Close when successful.

Replicate this process with the remaining two templates.

Trade agreements must be posted, so that new prices become effective and can be viewed when viewing products.

1. From the Fred NXT Head Office Dashboard, click, Merchandising > Pricing and discounts > Price/discount agreement journals.

   

2. Select the newly created trade agreement, then click Lines.
3. Check the details (as required).
4. Click Post.

   

   Prices are now applied to your product(s).