-
End-User | Products & SmartPOS
-
End-User | Stock Control
-
End-User | Table Service and Kitchen Operations
-
End-User | Pricing, Marketing, Promotions & Accounts
- Prize Promotions
- Points, Points Profiles and Loyalty
- Product Promotions
- Repricing & Discounts in SmartPOS
- Vouchers
- Account Till Functions
- Pricing, Price Numbers and Price Modes
- Raffles & Draws
- Marketing Reports
- Accounts and Account Profiles
- Rewards
- SmartPOS Account Functions
- Troubleshooting
- Product Labels
- Packing Slips
-
End-User | System Setup & Admin
-
End-User | Reporting, Data Analysis & Security
-
End-User | Membership & Scheduled Billing
-
End-User | Operators, Operator Permissions & Clocking
-
Interfaces | Data Send Interfaces
-
Interfaces | EFTPOS & Payments
- NZ EFTPOS Interfaces
- Linkly (Formerly PC-EFTPOS)
- Adyen
- Tyro
- ANZ BladePay
- Stripe
- Windcave (Formerly Payment Express)
- Albert EFTPOS
- Westpac Presto (Formerly Assembly Payments)
- Unicard
- Manager Cards External Payment
- Pocket Voucher
- OneTab
- Clipp
- eConnect-eConduit
- Verifone
- AXEPT
- DPS
- Liven
- Singapore eWallet
- Mercury Payments TRANSENTRY
- Ingenico
- Quest
- Oolio - wPay
-
Interfaces | SMS & Messaging
-
Interfaces | Product, Pricing, Marketing & Promotions
- Metcash Loyalty
- Range Servant
- ILG Pricebook & Promotions
- Oolio Order Manager Integration
- Ubiquiti
- Product Level Blocking
- BidFood Integration
- LMG
- Metcash/IBA E-Commerce Marketplace
- McWilliams
- Thirsty Camel Hump Club
- LMG Loyalty (Zen Global)
- Doshii Integration
- Impact Data
- Marsello
- IBA Data Import
- Materials Control
- Last Yard
- Bepoz Standard Transaction Import
-
Interfaces | Printing & KDS
-
Interfaces | Reservation & Bookings
-
Interfaces | Database, Reporting, ERP & BI
-
Interfaces | CALink, Accounts & Gaming
- EBET Interface
- Clubs Online Interface
- Konami Interface
- WIN Gaming Interface
- Aristocrat Interface
- Bally Interface
- WorldSmart's SmartRetail Loyalty
- Flexinet & Flexinet SP Interfaces
- Aura Interface
- MiClub Interface
- Max Gaming Interface
- Utopia Gaming Interface
- Compass Interface
- IGT & IGT Casino Interface
- MGT Gaming Interface
- System Express
- Aristocrat nConnect Interface
- GCS Interface
- Maxetag Interface
- Dacom 5000E Interface
- InnTouch Interface
- Generic & Misc. CALink
-
Interfaces | Miscellaneous Interfaces/Integrations
-
Interfaces | Property & Room Management
-
Interfaces | Online Ordering & Delivery
-
Interfaces | Purchasing, Accounting & Supplier Comms
-
SmartPOS | Mobile App
-
SmartPDE | SmartPDE 32
-
SmartPDE | Denso PDE
-
SmartPDE | SmartPDE Mobile App
-
MyPlace
-
MyPlace | myPLACE Lite
-
MyPlace | Backpanel User Guides
- Bepoz Price Promotions
- What's on, Events and tickets
- Staff
- System Settings | Operational Settings
- Vouchers & Gift Certificates
- Member Onboarding
- Members and memberships
- System Settings | System Setup
- Reports and Reporting
- Actions
- Offers | Promotions
- Messaging & Notifications
- System Settings | App Config
- Surveys
- Games
- User Feedback
- Stamp Cards
-
MyPlace | Integrations
-
MyPlace | FAQ's & How-2's
-
MyPlace | Release Notes
-
YourOrder
-
YourOrders | Backpanel User Guides
-
YourOrders | YourOrder Kiosk User Guide
-
YourOrders | Merchant App User Guide
-
WebAddons
-
Installation / System Setup Guides
- SmartPOS Mobile App | Setup
- SmartPOS Mobile App | SmartAPI Host Setup
- SmartPOS Mobile App | BackOffice Setup
- SmartPOS Mobile App | Pay@Table setup
- SmartKDS Setup 4.7.2.7 +
- SmartKDS Setup 4.6.x
- SQL Installations
- Server / BackOffice Installation
- New Database Creation
- Multivenue Setup & Config.
- SmartPOS
- SmartPDE
- Player Elite Interface | Rest API
- Interface Setups
- Import
- KDSLink
- Snapshots
- Custom Interface Setups
-
HOW-2
- Product Maintenance
- Sales and Transaction Reporting
- SmartPOS General
- Printing and Printing Profiles
- SQL
- Repricing & Discounts
- Stock Control
- Membership
- Accounts and Account Profiles
- Miscellaneous
- Scheduled Jobs Setups
- Backoffice General
- Purchasing and Receiving
- Database.exe
- EFTPOS
- System Setup
- Custom Support Tools
-
Troubleshooting
-
Hardware
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:
- Navigate to System Setup and select Scheduled Jobs
- Select Add Job button and the Job Maintenance window will open
- 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
- 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
- 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