How to bulk update the cut-off day on existing subscriptions
Use the Import tool to bulk update the cut-off day on existing subscriptions that charge on a specific day of the week or month. Updating the cut-off day in a subscription rule only applies to new subscribers, so a bulk cut-off update lets you apply a new cut-off day to existing subscriptions. This keeps your cut-off timing aligned with your fulfillment schedule without editing each subscription individually.
This guide covers how to prepare a CSV file and bulk- update the cut-off day for existing subscriptions.
- BigCommerce Integration
- Recharge Checkout on BigCommerce
- Shopify Checkout Integration
- Migrated Checkout Integration
Before you start
- You need permission to use bulk management tools. Store owners have this permission by default and can grant it to other staff members from the accounts page.
- This update changes existing subscriptions only. To apply the same cut-off day to new subscribers, update it in your subscription rule. See Creating a cut-off window.
- Disable any third-party notifications you don't want triggered during the bulk update.
How it works
The cut-off day controls whether a subscription's next charge date skips a cycle when Recharge recalculates it. Recharge recalculates the next charge date after a recurring charge processes, after a charge processes off-cycle (such as during retries), after you edit a charge date, or when a customer uses Order now.
When the next charge date is recalculated:
- If the charge processes before the cut-off day, the next charge date won't be skipped.
- If the charge processes on or after the cut-off day, the next charge date skips the upcoming charge day and moves to the following day.
A bulk cut-off update doesn't move existing charge dates right away. The new cut-off day takes effect the next time each subscription's charge date is recalculated, so confirm it aligns with your order and charge timing before you apply it.
Step 1 – Export the subscriptions you want to update
Start with a subscriptions export so you have the subscription IDs and current schedule values for each subscription.
- In the merchant portal, click Tools & apps and select Exports.
- Create an export using the Subscriptions option from the dropdown menu.
- After the export processes, download and open the CSV file.
Step 2 – Format the CSV file
The CSV file must include only the columns required for a cut-off update. Extra columns can cause the update to fail or change subscription properties you don't intend to update.
- Delete every column except the columns listed in the table below. Keep order_day_of_month for monthly subscriptions or order_day_of_week for weekly subscriptions.
- Delete the rows for any subscriptions you don't want to update.
- Enter the new cut-off day in the cutoff_day_of_month_before_and_after column.
- Keep the current values in the order_day_of_month or order_day_of_week, order_interval_unit, charge_interval_frequency, and order_interval_frequency columns unless you also want to change them.
- Save the file as a CSV.
Required columns
Column | Description |
|---|---|
| subscription_id | The numerical ID of the subscription to update. |
| cutoff_day_of_month_before_and_after | The new cut-off day. For monthly subscriptions, enter the day of the month, such as 20 for the 20th. For weekly subscriptions, enter the day of the week. |
| order_day_of_month | The specific day of the month the subscription charges. Required for monthly subscriptions. |
| order_day_of_week | The specific day of the week the subscription charges. Required for weekly subscriptions. |
| order_interval_unit | The period the order schedule is based on. For a cut-off update, this value is month or week. |
| charge_interval_frequency | How often the subscription charges. For example, enter 3 for a subscription that charges every three months. |
| order_interval_frequency | How often the subscription ships. For example, enter 1 for a subscription that ships every month. |
Step 3 – Import the CSV file
Upload the formatted CSV file to the Import tool so Recharge can validate it before processing.
- In the merchant portal, click Tools & apps and select Bulk updates.
- Click Import a CSV update.
- Select Update subscriptions from the dropdown menu and click Next.
- Upload your CSV file and click Next.
- Confirm the details of your update.
Step 4 – Process the bulk update
After your file is validated, process the update to apply the new cut-off day to each subscription.
- On the Bulk updates page, click Process update.
- In the pop-up, click Update to confirm.
- Check the Processing status on the Bulk updates page. The update is finished when the status shows Complete.
If the Validation status shows Error, or the Error column shows a value after processing, hover over it to download the error file and review which rows failed.
Considerations
Consider the following before bulk updating the cut-off day.
Consideration | Notes |
|---|---|
| Skipped and manually updated charges | Bulk updating frequency or interval columns removes skips and manually updated charges, and Recharge recalculates the charge date. Review skipped charges before processing the update and re-skip them as needed. |
| Migrated subscriptions | Cut-off settings don't apply to migrated subscriptions. |
| Time zone | Cut-off days are based on Eastern Time (ET) and are affected by Daylight Saving Time. |
| Reverting the update | If the update doesn't give the result you expected, you can revert it using a backup file. See Bulk update subscriptions with the Import tool. |
