2 | ILG Pricebook Import

This article covers a step-by-step guide to importing the ILG Pricebook in BackOffice. ILG Pricebook Import begins with creating and configuring a Scheduled Job which will Import the Monthly Pricebook file from ILG. When imported, this will create and update links to Bepoz Products in the local Database using the SupplierItem table by linking the 'GTIN' from the Pricebook file with the 'Barcode_1' of Database Products.

This article covers a step-by-step guide to importing the ILG Pricebook in BackOffice.

ILG Pricebook Import begins with creating and configuring a  Scheduled Job  which will Import the Monthly  Pricebook  file from ILG. 

When imported, this will create and update links to Bepoz Products in the local Database using the SupplierItem table by linking the 'GTIN' from the Pricebook file with the 'Barcode_1' of Database Products.

Prerequisites 

• To access Promotion Import features, the applicable Operator Privileges will need to be enabled 
• Operator Maintenance 'General' Tab
• System Setup: "Access Venue, Stores & Tills" Flag 
• System Setup: "Maintain Venue, Stores & Tills" Flag 
• System Setup: "Maintain Scheduled Jobs" Flag

Scheduled Job Setup - Retrieve and Process ILG Pricebook 

• To get started, log in to BackOffice and complete the following steps:
1. Navigate to System Setup in the sidebar, expand and select Scheduled Jobs to open the Scheduled Jobs Tab
   
2. From the header section of the Tab, select the Add Job button which will open a Job Maintenance window for a New Job
   
3. Begin by giving the New Job a relevant Job Name, the Job Type should be 'External DLL', DLL Name should be set to 'Jobscandata.Dll', and the Class Name should be set to 'ILG Pricebook File'
• Optionally configure additional setups; e.g., Venue(s), Run Missed Jobs, Chained Job, etc.
  
4. Configure a Schedule or Schedules for when the Job will run
• Again, it's recommended to check for the Monthly Pricebook daily so scheduling the Job to run every day at a specific time or at Startup is suggested
  
5. Configure the Job Options with the proper credentials and settings for each field as follows:
• Server URL is the URL of the FTP server; in this case, this should be 'mftp.ilg.com.au' or other as provided by ILG
  
• Remote Directory is the containing folder on the FTP server and should be provided by ILG
  
• Username as provided by ILG 
  
• Password
• Customer Number as provided by ILG
  
• Local Path only needs to be used if the file will be retrieved Locally rather than via the FTP server; when retrieving locally then the Local containing Folder Directory must be entered accurately into this field
  
• File Spec is the File Name or Search String; in this case, this should be set to '*pb.xxml'
  
• Supplier drop-down will list all of the configured Suppliers in the System and should be set to the appropriate Supplier in regards to the incoming Pricebook
• Venue drop-down will list all of the System's Venues and should be set to the Venue where Pricebook Products will be matched
  
6. Select OK to save the Job
7. Reopen the Job by selecting from the list of Scheduled Jobs and then click on the Run Now! button to run the Job manually or optionally, leave the Job to run at the next scheduled day & time/s

• When the Job is run, SmartController will show that it has Started and then will show when the Job has Finished OK as well as the number of Products that have been Imported

BackOffice Pricebook

• To view the Imported Pricebook in BackOffice, navigate to the Stock Control module on the sidebar, expand, and select Supplier Price Book which will open the Supplier PriceBook Tab
• The list can be filtered to a specific Supplier by using the Supplier drop-down or alternatively leave as 'All Suppliers'
  

• Information Imported, matched, and contained in the Pricebook will include the Product Long Name, Item Volume, CaseQty, CostEachEx, and Barcode
• Products in the Database will be matched & linked with Products in the Pricebook based on the Local Product's Barcode_1
• If Products from the Pricebook are not matched & linked with Products in the Database they can be linked manually using the Set Local Product button
• Other data from the Pricebook file will be matched with data in Bepoz such as Product ID being equivalent to the ItemCode in Bepoz, UnitSize equivalent to UnitName, etc.