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.

subscribe

 

 

(This should be performed by a CMS Max developer)

  1. Download a zip from the cmsmaxinc/rmh-connector repository.
  2. Extract it on the server
  3. 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)
  4. Install the service by executing install.bat
  5. 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.

Building Relationships with Web Developers and Marketing Agencies that want better results

The world's fastest and most SEO friendly website code.