Update Purchase Prices for Products (DIEF)

DIEF

To Import a spreadsheet (.CSV file format only) using the Data Import/Export Framework (DIEF), you need to import the Purchase Price Trade Agreement Template.

When using DIEF in Fred NXT Head Office, there are three critical steps"

  • Create the data sheet using the appropriate DIEF Template and save as .csv
  • Upload the data sheet using DIEF.
  • Post the uploaded data sheet to make the changes effective (at store level) and also to view the changes in Fred NXT Head Office.
  1. Open the required template: GroupsPurchasePriceAndDiscount.xlsx
  2. Update fields/details as required.
  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 the relevant Group name, then click Get staging Data.
  3. Enter a Description then click OK.
  4. Click the File Path field to display Folder icon
  5. Click Folder icon 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).

Related Topics