CMS Max owns Liquor Max which is a eCommerce website solution that integrates directly with RMH. If you are an RMH partner, reseller or end user, we have an amazing high-end, custom, SEO friendly website solution for you! To learn more about RMH click here.
While adding or editing a product, go to the Options tab, once on that tab you must check that box "Item is available on the website." for the product to sync to CMS Max.
(This should be performed by a CMS Max developer)
- Download a zip from the cmsmaxinc/rmh-connector repository.
- Extract it on the server
- Copy the .env.example file to .env and update the configuration values
- DB_HOST: SQL Server host
- DB_DATABASE: SQL Server database name
- DB_USERNAME: SQL Server username
- DB_PASSWORD: SQL Server password
- RMH_CONNECTOR_USES_CENTRAL: If this client uses RMH Central set this to true
- RMH_CONNECTOR_IS_CENTRAL: If this client uses RMH Central and this instance is connected to the Central database, set this to tru
- See notes on configuring for RMH Central
- API_BASE: Base url for the API (ex. https://www.example.com/api)
- API_KEY: The API key (configured in
config/pos.php
on the site) - POS_STORE_ID: In most cases this will be set to 0. Look it up in the SQL Server database table
[Store]
- POS_CASHIER_ID: The ID of the cashier that orders will be inserted under. Look it up in the SQL Server database table
[Cashier]
- POS_REGISTER_ID: The ID of the register that orders will be inserted under. Look it up in the SQL Server database table
[Register]
- POS_TENDER_ID: The ID of the tender that orders will be inserted under. Look it up in the SQL Server database table
[Tender]
. There should be one for web sales. If there isn't, you'll need to create one in RMH Store Manager (Setup -> Financial -> Tender Types). - BUGSNAG_API_KEY: The Bugnsag API key (
reference GitHub
)
- Install the service by executing install.bat
- Start the service by executing start.bat
Run the self-update.bat to update the worker
If you're setting this up for the first time, you'd want to do an initial sync. Go to the command prompt and type:
cd c:\rmh-connector
Sync category maps:
php\php.exe worker sync-category-maps
Sync all items:
php\php.exe worker sync-all-items
Install the service by executing install.bat
Start the service by executing start.bat
If the store is processing orders for shipping make sure that an RMH item exists with an item lookup code of shipping
. When we create orders we enter in the shipping costs under that item. If the item doesn't exists orders will not sync.
If a shipping item already exists and the ItemLookupCode is something other than shipping
you can configure it using the SHIPPING_ITEM_LOOKUP_CODE
config in the .env file.
If a product was sold or updated at the store in RMH, it will automatically sync to the website in 1 second. As well as if a product was sold on the website, the quantity would update in RMH in 1 second
If you get this error when running the sync command:
SQLSTATE[IMSSP]: This extension requires the Microsoft ODBC Driver for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver for SQL Server for x64: https://go.microsoft.com/fwlink/?LinkId=163712
Download the extension here: https://www.microsoft.com/en-us/download/details.aspx?id=36434 . Install and re-run the command.