Fixing migration errors
This article contains a list of possible error codes that may appear after using the Bulk Actions tool for validating migrations.
- Shopify Checkout Integration
- Recharge Checkout on BigCommerce
Before you start
- The chart contained in this guide is for use with the Bulk Actions tool. To enable this tool, you can request access by clicking Apps then selecting Marketplace in the merchant portal.
- Error and warning codes are listed in alphabetical order by error/warning code for easy browsing.
Migration errors
Error Code |
Description |
How to fix it |
billing_postalcode |
The zip code must be the standard 5 digit number or the 5-4 format | US zip codes should all have 5 digits. Some spreadsheet software, like Excel, will remove any leading zeros from numbers. You will need to format the value to include the leading zero if it is only 4 digits. |
charge_interval_frequency |
Value ‘0’ must be greater than ‘0’ | All active subscriptions should have a charge frequency and the value should be greater than 0. If these are set to zero or missing, then you'll either need to leave them off the import or change these to a valid frequency and import them as a cancelled subscription. |
charge_interval_unit_type |
Must be one of [‘day’, ‘days’, ‘week’, ‘weeks’, ‘month’, ‘months’], found ‘foo’ | The only values allowed in this column are day, days, week, weeks, month, or months. If you have customers set to year or years, you’ll need to change this to month and change the charge_interval_frequency to 12. If the subscription is not prepaid, then change the shipping_interval_frequency to 12 as well. |
charge_on_day_of_month |
Value '41' must be less than or equal to 31" | This column should only be the day of the month. You should only fill this in if all your customers are charged on the same day of the month. Otherwise, you'll leave this field blank. |
customer_created_at |
‘'20-01-02' must be in ISO format (YYYY-MM-DD or YYYY-MM-DDTHH:MM:SS) | Dates must be formatted as yyyy-mm-dd. |
customer_created_at |
'2999-01-01' must be on or before today (2020-04-13)" | Dates must be formatted as yyyy-mm-dd and date must be before today’s date. |
AUTHORIZE_NET_NOT_ENABLED_FOR_SUBSCRIPTIONS |
Fetch error related to Authorize.net connection |
The Shopify Payment Partner Platform feature does not support subscriptions. You should switch back to your payment processor. See Handling "Payment Provider is Not Enabled" error when using Shopify Payment Partner Platform guide for more information. |
Is_prepaid |
Subscription is not prepaid, 'charge_interval_frequency' should equal 'shipping_interval_frequency' |
If your charge_interval_frequency is greater than your shipping_interval_frequency then this is a prepaid subscription and you should mark is_prepaid as yes. Otherwise, you can leave is_prepaid blank and change the shipping_interval_frequency to match the charge_interval_frequency.
See the Importing prepaid subscriptions guide for more information. |
last_success_charge |
‘'20-01-02' must be in ISO format (YYYY-MM-DD or YYYY-MM-DDTHH:MM:SS) | Dates must be formatted as yyyy-mm-dd. |
last_success_charge |
must exist |
You've marked the row as a prepaid subscription but left out the last_success_charge value. This date is required by our system to determine when their current prepaid cycle started.
See the Importing prepaid subscriptions guide for more information. |
next_charge_scheduled_at |
Must be blank | If the status is "cancelled" then the next_charge_scheduled_at should be blank. |
quantity |
Value 0 must be greater than 0 | If your old platform supports a quantity of zero, you’ll need to decide how to handle these in Recharge as a zero quantity is not allowed in our system. You can either import these as cancelled subscriptions and the value to 1 or greater, or leave them off the import. |
shipping_email |
Email is not valid | The email address listed is not valid per MX records. You can try to edit these manually if it's a typo. Otherwise, you may need to leave these customers off Recharge until you have the correct email address. Make sure the email is correct/updated in Shopify, then update it to match in the template. |
shipping_interval_frequency |
Value '2' must be less than or equal to 1.0 | The shipping_interval_frequency is higher than the charge_interval_frequency. We don't support charging more often than you ship so you'll need to change these values or leave these rows off the import CSV. |
shipping_interval_frequency |
Value ‘0’ must be greater than ‘0’ | All active subscriptions should have a shipping frequency and the value should be greater than 0. If these are set to zero or missing, then you'll either need to leave them off the import or change these to a valid frequency and import them as a cancelled subscription. |
shipping_interval_unit_type |
Must be one of ['day', 'days', 'week', 'weeks', 'month', 'months'], found 'foo'" | The only values allowed are day, days, week, weeks, month, or months. If you have customers set to year or years, you'll need to change this to month and change the charge_interval_frequency to 12. Change the shipping_interval_frequency to 12 as well if it is not prepaid. |
shipping_province |
State does not match with specified address | There is an issue with the shipping address. Please validate that the province/state is a valid address. |
external_product_id |
Must be a valid Product ID in your new platform, ID 1234 not found in 555 | The Product ID doesn’t match any of the products in your new store. Make sure you have formatted this column to remove any special characters and ensure the ID is for the original item in the new platform. |
external_variant_id |
Must be a valid product variant ID in your new platform, ID 1234 not found in store 555 | The Variant ID doesn’t match any of the variants in your new store. Make sure you have formatted this column to remove any special characters and ensure the ID is for the original item in the new platform. |
| <country> must be a valid shipping country for Store | <country> must be a valid shipping country for Store | The shipping country isn't listed in the Countries list in the shipping settings in Recharge. You need to add the country to the available shipping countries in Recharge shipping settings. |
Bundles migration errors
These errors can occur when using the bundle content template.
Error Code |
Message |
How to fix it |
|
|
At least one of the products wasn't found in its correspondent collection |
The ID of one of the products in the bundle does not match with any of the products included in the collections that were configured within the bundle. Ensure each product is associated with the product and variant ID are present in the bundle collection. |
|
|
Collection ID not found in product configuration |
The collection ID does not match with any of the collections that were configured within the bundle. Ensure this collection is added in the bundle settings. |
|
|
Customer does not exist |
The included email does not have an active subscription to the parent bundle. You must migrate this customer’s parent bundle subscription into Recharge prior to migrating bundle selections. |
|
|
Number of items does not satisfy the ranges set it up in the variant. |
The total of items does not meet the bundle rules. It can be lower or higher than the bundle size. Ensure the sum of each row associated to this subscription ID matches the quantity set in the bundle settings. |
|
|
Subscription does not exist |
The subscription ID is not associated with the parent bundle. You must swap this subscription ID to the parent bundle product. |
Warning codes
Warnings are informational messages that do not affect the ability to import the row.
| Warning Code | Description | How to fix it |
stripe_customer_id |
A payment processor token has not been provided | This warning indicates that you are importing a row that does not have a payment customer ID. You can import the subscription without this ID, but you won't be able to charge the customer until you have a card on file for the customer. The customer will need to re-enter a card after they are imported into the Recharge system. |
next_charge_scheduled_at |
'2020-12-01' should be within 3.0 months from today (value in column 'charge_interval_frequency') |
This warning indicates that the next_charge_scheduled_at may be too far into the future. It is expected to be charged within the charge_interval_frequency. If the customer skipped a shipment or changed their charge date then you can ignore this warning. Otherwise, confirm their charge date is correct. |
recurring_price |
Value '0' should be greater than 0 | This warning indicates that you've set the recurring price to $0 for this subscription which means the customer will NOT be charged for their subscription. |
