Access the Settings page on https://gym.sendmoregetbeta.com/admin/editGym Dashboard.

</aside>

<aside> 1️⃣

Please follow along here for how to

Preliminary Information has been gathered from your website, but please note you may want to edit this information and update your Gym Picture.

</aside>

<aside> 2️⃣

On Business and above? Please follow along here for how to set your Custom Widget color & styling

</aside>

<aside> 3️⃣

Please follow along here for how to Set a default country & required fields in forms

</aside>

<aside> 4️⃣

On Business and above? Please follow along here for how to Collect marketing data on widgets

</aside>

<aside> 5️⃣

Please follow along here for how Set Gym Default Emails for Events, Slots, Forms, Payment Receipts Confirmation

</aside>

<aside> 6️⃣

You can control which note/certifications appear in your dropdown list in your dashboard.

See here how to Set the notes and certifications in visitors’ profiles

</aside>

This step is handled by BETA!

</aside>

<aside> ⭐ Access your dashboard, from:

We suggest bookmarking the BETA dashboard to your browser, and we suggest Google Chrome for speed and reliance.

</aside>

<aside>

Last few steps!

Congrats, we are almost there. The day before your launch date, we’ll need a final set of exports from RGP. Certain reports will require custom SQL queries within RGP to ensure data accuracy and information which cannot be migrated from the API.

From these reports, our BETA bots will import the latest data into BETA, ensuring it’s accurate and up-to-date for your launch.

<aside>

How do I run a custom report to export from Rock Gym Pro? </aside>

</aside>

RGP SQL Queries Final Export (Last Evening)

<aside> <img src="/icons/warning_lightgray.svg" alt="/icons/warning_lightgray.svg" width="40px" /> It is important, that in the queries below you update the time ENTER_THE_DATE_HERE_YYYY-MM-DD to the time the of the last performed the export.

If you are not sure of when your last import was ran, please as the BETA team.

</aside>

› 1 ᴏꜰ 6 | Customer Notes & Proficiencies

Notes cannot be pulled from the API, so we import these on the last day, to get the latest info - this can be done on the night, or for multi-locations, over the first few days of operation.

SELECT * FROM notes LEFT JOIN customer ON notes.customer_id=customer.customer_id;

The header of these export should be as follows:

CUSTOMER_ID NOTES EMAIL GUID DELETED FIRSTNAME LASTNAME

› 2 ᴏꜰ 6 | Final membership report

Please follow the RGP help page to https://support.rockgympro.com/hc/en-us/articles/360056598852-Exporting-customer-query-data-to-a-CSV-file

Guide from RGP to Export customer query data to a CSV file </aside>

› 3 ᴏꜰ 6 | New event bookings or future cancelled bookings

We assume the customer hasn’t added any new events in BETA since the initial export) ****(Date format YYYY-MM-DD)

SELECT 
    DATE_FORMAT(b.BOOKING_DATE, "%Y-%c-%d %T"),
    b.ORIGINAL_BOOKED_OFFERING_NAME,
    DATE_FORMAT(b.ORIGINAL_BOOKED_TIME, "%Y-%c-%d %T"),
    b.NOTES,
    b.PARTICIPANT_COUNT,
    b.CANCELLED,
    c.firstname,
    c.lastname,
    c.email,
    c.bday 
FROM 
    schedule_bookings AS b 
LEFT JOIN 
    customers AS c ON b.customer_id = c.customer_id 
LEFT JOIN 
    schedule_events AS se ON b.course_guid = se.session_guid 
WHERE 
    (se.startdate > CURDATE() AND b.CANCELLED = TRUE) 
    OR b.BOOKING_DATE > '2024-01-01 00:00:00';

› 4 ᴏꜰ 6 | Gift Cards

set @giftcardid=(select value from settings where name='GiftCardProductId');
set @enddate = date_add(date(('{ENDDATE}')), interval 1 day);
SELECT REPLACE
	( cardnum, 'GiftCard-', '' ) AS CardNumber,
	(
	SELECT
		i.postdate 
	FROM
		invoices i
		JOIN invoice_items ii ON ii.invoice_id = i.invoice_id 
	WHERE
		ii.EXTRAINFO = cardnum 
		and i.POSTDATE<@enddate
	ORDER BY
		i.postdate ASC 
		LIMIT 1 
	) AS SoldDate,
	CONVERT ((
		SELECT
			sum( PRICE ) 
		FROM
			invoice_items ii
			JOIN invoices i ON ii.INVOICE_ID = i.INVOICE_ID 
		WHERE
			i.VOIDEDINVOICE = 0 
			and i.POSTDATE<@enddate
			AND ii.EXTRAINFO = cardnum 
			AND ii.PRODUCT_ID = @giftcardid 
			),
	DECIMAL ( 10, 2 )) AS Balance 
FROM
	(
	SELECT DISTINCT
		( EXTRAINFO ) AS cardnum 
	FROM
		invoice_items ii
		JOIN invoices i ON ii.INVOICE_ID = i.INVOICE_ID 
	WHERE
		i.VOIDEDINVOICE = 0 
		and i.POSTDATE<@enddate
		AND EXTRAINFO LIKE 'GiftCard%' 
	) AS distinctcards 
HAVING
	balance > 0

› 5 ᴏꜰ 6 | Punch entries

For you Punch entries, we will need to get the full list, as punch use date is not kept on the RGP database.

Select c.guid, sum(p.delta) from punches as p left join customers as c on p.customer_id = c.customer_id where p.voided=false group by c.guid;

› 6 ᴏꜰ 6 | Outstanding membership credit/debit

Please follow the RGP help page to https://support.rockgympro.com/hc/en-us/articles/360057047751-Reviewing-credit-due-balances

Last few steps!

RGP SQL Queries Final Export (Last Evening)

› 1 ᴏꜰ 6 | Customer Notes & Proficiencies

› 2 ᴏꜰ 6 | Final membership report

› 3 ᴏꜰ 6 | New event bookings or future cancelled bookings

› 4 ᴏꜰ 6 | Gift Cards

› 5 ᴏꜰ 6 | Punch entries

› 6 ᴏꜰ 6 | Outstanding membership credit/debit

Videos

Step 0 - During Video Call

Step 1 - Hardware Req

Step 2 - Editing Gym Details

Step 3 - Granting Permission

Step 4 - Payment Methods

Step 5 - Creating

Step 5.1 - Events