stripe_order_output.rb

require 'csv'
require 'pry'

orders = CSV.read('orders.csv', headers: true)

output = open('output.csv', 'w')
output.truncate(0)

output.write("order_id, quantity, shipping_address\n")

orders.each do  |row|
  next if row['Type'] != 'sku'

  output.write("#{row['Order']},")
  output.write("#{row['Quantity']},")
  output.write("\"#{row['Shipping Name']}\n")
  output.write("#{row['Shipping Address Line1']}\n")
  output.write("#{row['Shipping Address Line2']}\n") unless row['Shipping Address Line2'].empty?
  output.write("#{row['Shipping Address City']}, #{row['Shipping Address State']} #{row['Shipping Address Postal Code']}\"")
  output.write("\n")
end

output.close