map_stripe_coupons_to_netsuite.rb

# Mike Bianco <mike@suitesync.io>

# Description: Connect Stripe coupons to existing NetSuite discount items
# Usage: map_stripe_coupons_to_netsuite.rb mapping.csv
# Link: https://gist.github.com/iloveitaly/eed7602d055d5402dd34d0ba79de6ca2

require 'stripe'
require 'csv'

Stripe.api_key = ENV['STRIPE_KEY']

# CSV Mapping:
#   - stripe_coupon_id:
#   - netsuite_internal_id

if ARGV.empty?
  puts "No CSV path specified"
  exit 1
end

def wipe_netsuite_metadata_fields(stripe_resource)
  stripe_resource.metadata.keys.map(&:to_s).each do |metadata_key|
    if metadata_key.start_with?('netsuite_')
      stripe_resource.metadata[metadata_key] = nil
    end
  end
end

csv_path = ARGV.first
csv_mapping = CSV.read(csv_path, headers: true)
ns_metadata_key = 'netsuite_discount_item_id'

csv_mapping.each do |csv_line|
  stripe_coupon_id = csv_line['stripe_coupon_id']
  ns_internal_id = csv_line['netsuite_internal_id']

  if ns_internal_id.nil?
    puts "#{stripe_coupon_id}\tno netsuite ID"
    next
  end

  stripe_coupon = (Stripe::Coupon.retrieve(stripe_coupon_id) rescue nil)

  if stripe_coupon.nil?
    puts "#{stripe_coupon_id}\tinvalid coupon ID"
    next
  end

  if stripe_coupon.metadata[ns_metadata_key]
    puts "#{stripe_coupon_id}\tplan already linked"
    next
  end

  puts "#{stripe_coupon_id}\tmapping coupon"

  wipe_netsuite_metadata_fields(stripe_coupon)

  stripe_coupon.metadata[ns_metadata_key] = ns_internal_id
  stripe_coupon.save
end