Warning: There is currently no Admin page for configuring Subscriptions. Changes need to be made in the Database directly using the Data Editor.

A Subscription pulls data from the following Database tables:

• CRM_Services - Stores the name of the Subscription. Without this table, there is no Subscription to attach anything to.
• CRM_ServiceItems - Stores much of the data that make Subscriptions work. This table provides a connection between a Subscription and an item. Without this mapping, the system will not create Subscriptions for an Associate, nor will they renew.
• CRM_AssociateServices - Stores which Associates have which Subscriptions, as well as the expiration date.

To set up a Subscription, you will have to edit the CRM_Services and CRM_ServiceItems tables with the Data Editor.

Important: Only an experienced SQL developer should use the Data Editor.

Read more: Data Editor

What We’ll Cover

• Giving the Subscription a Name
• Configuring the Subscription
  • Entering ItemID
  • Entering Service Subscription Data
  • CreateAutoship
  • GracePeriod
  • YearlyRenewal
  • Disallowing Autoship Management
  • Saving the Changes
• Troubleshooting

---

---

Giving the Subscription a Name

Edit the CRM_Services table to give the Subscription a name.

1. In the Data Editor, search for and select the CRM_Services table.

   

   Tip: To view the Table Schema, click the icon.

2. Click the + New Row button to add a new row.

3. Click the empty field under ServiceName and enter the name of your Subscription.

   

4. Click the icon to create the new Subscription.

   Take note of the recordnumber. This will be used as the ServiceID in the CRM_ServiceItems table.

You can add more rows to create multiple Subscription offerings.

In the next section, configure the specifics of what this Subscription does.

One SKU could add one month, another SKU could add a year, to the same Subscription (this example would require two entries in the CRM_ServiceItems table).

---

---

Configuring the Subscription

Edit the CRM_ServiceItems table and enter the Subscription details in the necessary fields.

1. Search for and select the CRM_ServiceItems table.

   

2. Click the + New Row button to add a new row.

3. Enter data in the following fields:

   

---

Entering ItemID

Under ItemID, enter the inventory item’s ItemID.

This is the ID you noted in the Setting Up a Subscription SKU section.

---

Entering Service (Subscription) Data

1. Under ServiceID, enter the recordnumber from the CRM_Services table.

2. Under ServicePeriod, enter the number of periods for the given ServicePeriodType.

   For example, if your ServicePeriodType was “Monthly” and you wanted the service to reoccur every two months, you would enter 2 in this field.

3. Under ServicePeriodType, enter the frequency that correlates with the ServicePeriod.

   • Day = 0
   • Week = 1
   • Month = 2
   • Year = 3

   For example, to have a monthly renewal, enter 1 in ServicePeriod and enter 2 in ServicePeriodType.

---

CreateAutoship

Under CreateAutoship, click the checkbox TRUE or FALSE.

Do you want to create an AutoShip to auto-renew the Subscription? If so, select TRUE. Autoship is what charges the Associate. The Subscription is a date to apply business logic to whatever happens at expiration.

The system creates the AutoShip with the ServicePeriod based on ServicePeriodType, so a MONTHLY interval will create a monthly AutoShip.

---

GracePeriod

For GracePeriod, the system does nothing with this data by default.

Use if you want to provide the Associate more time past the expiration date before considered expired.

---

YearlyRenewal

Under YearlyRenewal, click the checkbox TRUE or FALSE.

YearlyRenewal provides a distinction between a Service Subscription and a Membership Subscription defined in the Introduction.

• When set to FALSE (unchecked), you have a Service Subscription.
• When set to TRUE (checked), you have a Membership Subscription.

---

Disallowing Autoship Management

YearlyRenewal, when set to TRUE, hides the Subscription from the Manage Autoship page in Web Office and eCommerce Shop.

You do not want your Associates updating their Subscriptions as they would AutoShips, including changing their renewal date or deleting the Subscription. Subscriptions are not typically something an Associate opts-out of. They must call your customer support and request cancellation.

If the Subscription is optional, set this to TRUE; otherwise, it should be FALSE.

---

Saving the Changes

Click the icon to save the table.

The preceding data entry enables the following features:

• Enables a Subscription with the sale of an inventory item.
• Enables AutoShip creation with the sale of an inventory item.
• Sets up a grace period for a Subscription item.

---

---

Troubleshooting

• Subscriptions Not Renewing After Expiration Date