LMG

11 | LMG Bottlemart - Price File Export

This article covers how to setup LMG Bottlemart Promotion Price export automatically via a Scheduled Job. Product Promotions can also be exported so that Prices can be tracked for each Store and Till. These Promotions can be generated and automatically posted on an online server. This is achieved through the creation of a Scheduled Job.

This article covers how to setup LMG Bottlemart Promotion Price export automatically via a Scheduled Job.

Product Promotions can also be exported so that Prices can be tracked for each Store and Till. These Promotions can be generated and automatically posted on an online server. This is achieved through the creation of a Scheduled Job.

Prerequisites
  • To access Promotions import features, the applicable Operator Privileges will need to be enabled
    • Operat
      • System Setup: "Access Venue, Stores & Tills" flag
      • System Setup: "Maintain Scheduled Jobs" flag

Scheduled Job Setup
  • To set up the Scheduled Job, log in to BackOffice and complete the following steps:
    1. Navigate to System Setup and select Scheduled Jobs 
    2. Select Add Job button and the Job Maintenance window will open 
    3. There are a number of credentials that need to input and they include:
      • Job Name: Give the Job a relevant name 
      • Job Type: External DLL 
      • DLL Name: Jobexport.Dll 
      • ClassName: LMG2 Price Export
    4. Job Options will also require a number of configurations as well: 
      • Include Headers: If this is enabled, the NAME, BARCODE, TAX, PRICE, SPECIAL Headers will be exported
      • Export Filename: The name of the CSV file to be generated 
      • FTP Uri: Provided by LMG
      • FTP Username: Provided by LMG
      • FTP Password: Provided by LMG
      • Till - The TillID to get Prices from
    5. Click OK to save the Scheduled Job

 

Additional Info

Current Export Criteria is as follows otherwise product is skipped:

  • The Product Qty on hand greater than Zero
  • The product must have a size name 
  • The product must have a barcode

Reporting Columns

 
LMG Report Column Names Bepoz Column Names Bepoz Product Example
NAME ProductName Coke 300Ml
BARCODE Barcode 95000077
TAX SellTaxType 1
PRICE ProductPrice 5
SPECIAL ProdPrice.PromoEach 5
RETAIL-PACK-SIZE CaseQty 12
RETAIL-SIZE StockTypeQty 300
RETAIL-UOM StockType Mills
STOCK-ON-HAND QtyonHand 1
LAST-SOLD DateTimeLastSale 0001-01-01
ALCOHOL-BY-VOLUME "" (Empty String)  
DESCRIPTION LongName Coke 300Ml

 

The following below two columns refer to Product Settings - (Base Size)

  • RETAIL-SIZE 
    • 1-2147483647 (INT)
  • RETAIL-UOM
    • Item
    • Mills
    • Grams
    • US Floz
    • USoz
    • UK Floz