Skip to main content

Bulk updating product and subscriptions for the Shopify Checkout Integration

Shopify Checkout integration
Sections

When you make changes to your products in Recharge or update your products in Shopify, these changes will only apply to future customers purchasing at checkout. If you would like to update existing customers and subscriptions, you will need to perform a bulk update. The Recharge support team can help manually update this data using CSV files from your Exports section. This guide provides instructions on preparing your CSV file for upload.

 

Before you start

Note: Recharge performs bulk updates on a case-by-case basis as a courtesy. If your business model requires frequent bulk updates, we recommended that you use the Recharge API. 
  • The bulk update CSV file must be received at least 5 business days before the date in which the changes need to be made.
  • The minimum number of orders that can be bulk edited is 50.
  • If performing a product title, variant title, or product swap update, note that the product/variant title and variant ID must align with the relevant product title and variant ID in Shopify. If they do not, the title will update in Recharge, but not in Shopify. 

Step 1 - Download the CSV file

  1. In the merchant portal, select Exports. 
  2. Click Create export and select the export you need to download, based on the bulk update type.
  3. Enter your email address. If applicable, you can also enter a date range for order exports.
  4. Click Create export. 

Export type

The table below highlights which export to download, based on the type of bulk update.

Bulk update type

Export Builder CSV

Product title or variant title update

Note: The product or variant title must match the title of the product in Shopify, otherwise the title will revert following the next charge.
  • Subscriptions - Active and/or
  • Subscriptions - Cancelled and/or 
  • Subscriptions - All
Frequency and interval
  • Subscriptions - Active and/or
  • Subscriptions - Cancelled and/or 
  • Subscriptions - All
Day of the month or week
  • Subscriptions - Active and/or
  • Subscriptions - Cancelled and/or 
  • Subscriptions - All
Recurring price
  • Subscriptions - Active and/or
  • Subscriptions - Cancelled and/or 
  • Subscriptions - All
Prepaid order date
  • Prepaid - Queued
Next charge date
  • Charges - Queued
Shipping rates (if set to retain)
  • Charges - Queued
Removing a discount
  • Charges - Queued and/or
  • Charges - Processed
Applying a discount code
  • Charges - Queued

SKU update
  • Charges - Queued

SKU overrides

Note: Only perform if you require the SKU in Recharge to be different than the product SKU in Shopify. Otherwise, to update SKUs to match Shopify, request a regeneration. 
  • Subscriptions - Active and/or
  • Subscriptions - Cancelled and/or 
  • Subscriptions - All
Bulk cancellations
  • Subscriptions - Active

Product swap

Note: Product/variant title and variant ID must match the product in Shopify, otherwise title will revert following the next charge.
  • Subscriptions - Active and/or
  • Subscriptions - Cancelled and/or 
  • Subscriptions - All
Line item properties
  • Subscriptions - Active and/or
  • Subscriptions - Cancelled and/or 
  • Subscriptions - All
Expiration after X number of charges
  • Subscriptions - Active and/or
  • Subscriptions - Cancelled and/or 
  • Subscriptions - All
Update unused discount codes
  • Discounts
Update cart attribute Customers - Shipping Address

Step 2 - Add new columns to CSV

Depending on the type of bulk update, you may need to add additional columns to the end of the CSV to include your new parameters. The table below highlights how many new columns to include and the title for each column.

Note: If you are looking to swap a product to a different product in Shopify, changing the Variant ID will not automatically update other product attributes, such as price. If you require other product updates to be made, you will need to add additional columns. 

Type of update

Additional columns
Product title or variant title
  • NEW Product Title
  • NEW Variant Title
Frequency and interval
  • NEW shipping_interval_frequency
  • NEW shipping_interval_unit_type
  • NEW charge_interval_frequency
  • NEW charge_interval_unit_type

Note: The shipping_interval_unit_type and charge_interval_unit_type must be the same (i.e. months, weeks, or days.)
Day of the month or week
  •  NEW Day of Month
Recurring price
  •  NEW Price
Prepaid order date
  •  NEW order date
Next charge date
  •  NEW charge date
Shipping rates (if set to retain)
  • NEW Shipping Rate
  • NEW Shipping Title 
  • NEW Shipping Code
Removing a discount code  None
Applying a discount code
  • NEW Discount code 
SKU updates None
SKU overrides
  • NEW SKU override
Bulk cancellations  None
Product Swap
  • NEW Product Title
  • NEW Variant Title
  • NEW Variant ID
Note: Changing the Variant ID will not automatically update the price. See the requirements for Recurring price. 
Line item properties
  •  NEW Line Item Properties
Expiration after x number of charges
  •  NEW Expiration
Update unused discount codes 
  • Applicable Channels
  • Any additional NEW columns to update aspects of an existing discount code, such as the value or usage limit 
Note: Make sure to include the Applicable Channels column to confirm where the discount code can be applied.
Cart attributes
  • NEW attribute

Step 3 - Insert new data

After adding the additional columns, you will need to populate the column with the new data for the bulk update.

Tip: If there are customers/subscriptions/orders that do not require an update, you can either leave the cell blank or remove the row completely.

Type of update

Format
Product title or variant title
  • Fill in columns with the product title and variant title.
  • The variant title column can be left blank if you do not use variants.
Frequency and interval
  • Frequency refers to the number and unit type refers to the unit of measurement. For example, shipping_interval_frequency would be 3 and shipping_interval_unit_type would be months.
Day of the month or week
  • If filling out the day of the month, use numerals (for example, 4 to indicate the 4th day of the month).
  • If filling out the day of the week, use the title (for example, Tuesday).
Recurring price
  • Enter the new price based on the original recurring_price column.
Prepaid order date
  • Enter the next order date for each order in the prepaid cycle.
  • If the prepaid cycle renews, you will also need to prepare a CSV file for the Next order date. This will ensure that the upcoming charge order does not overlap with the last shipment order of the previous cycle.
Next charge date
  • Enter the next charge date.
  • The bulk update will change the date for all subscription items in the order.
Shipping rates (if set to retain)
  • Shipping Rate refers to the numeric shipping price (for example, 10.00 if you charge $10)
  • Shipping Title is the name of your shipping rate as displayed to customers (for example, Expedited Shipping)
  • Shipping Code is the name of your shipping rate displayed internally. This is commonly the same as the shipping title.
  • Shipping Code and Shipping Title are optional columns if the title/code is remaining the same.
Removing a discount code
  • Delete any rows of orders from the CSV which will not require the discount code to be removed.
Applying a discount code
SKU updates
  • Delete any rows of charges containing subscriptions that do not require a SKU update.
SKU overrides
  • Enter the SKU for the Recharge product. Note that this SKU will override what is set in Shopify. 
Bulk cancellations
  • Delete all rows of subscriptions you want to keep and list only the subscriptions you want to be cancelled. If you're cancelling 10 subscriptions, the CSV should have 10 subscriptions listed.
Product swap
  • The Variant ID is a mandatory column. To locate IDs, visit Find a variant ID.
  • Product Title and Variant Title are optional columns. If the titles are remaining the same, you only need to fill in the Variant ID column.
  • Updating the Variant ID will not automatically update other product attributes, such as price or title. If you require other updates, be sure to add these additional columns.
Line item properties

Line item properties must be styled in JSON format. For example:

"[{"name":"sizes","value":20},{"name":"sizeXXL","value":50}]"
Expiration after x number of charges
  • Enter the numerical value in the new column (ie. 6)
  • If a subscription is at or past the limit, it will not update the status to expired or deleted. You will need to perform a bulk cancellation.
Update unused discount codes 
  • You can update any of the following aspects of an existing discount code by adding additional columns to the CSV file.
    • Applicable channels. This is where the discount code can be applied to an order. By default this is set to all channels when updating a discount code, so you must specify if discounts can be added the code through the Checkout page, Customer Portal, Merchant Portal, or through the API. (ie. checkout if the discount code can only be applied through checkout orders)
    • The value, or amount, of the discount. (ie. 50 if the discount is for 50% off the order)
    • The discount type. You can confirm if the discount is a fixed amount, a percentage discount or a shipping discount. (ie. percentage if the discount is 50% off the order)
    • The Status of the discount code. (ie. enabled if you are turning on a disabled discount code)
    • A new starts or ends at date to determine how long the discount code can be used for.
    • A usage limit to set the number of times this discount code can be used by all customers before it's invalid. (ie. 100 if the discount code should only be used by the first 100 customers)
    • If you would like to restrict the discount code by email so that a customer can not use a discount code more than once. 
    • If the discount code should apply to all products in the order or only the subscription products.
    • If the discount code should apply to a specific product or collection.
      • You will also need to provide the product or collection ID to confirm which product or collection the discount code should apply to.
    • The duration of the discount code. (ie. one time, forever or a specific number of charges)
    • If the discount code should only apply to first-time customers.
Cart attribute
  • Each array entry will contain name and value keys.

Step 4 -  Send the CSV file to Recharge

Once the CSV file is prepared and the file reviewed for accuracy, send a copy to the Recharge support team. Include the following information in your request:

  • The type of bulk update
  • The number of rows contained in the file
  • The .myshopify.com URL

Please accommodate at least 5 business days for this bulk update to be completed.

Was this article helpful?
0 out of 0 found this helpful

Related articles

Didn’t find what you’re looking for?

Contact us