import csv
import sys

csv_file = open('salesjan17.csv')

csv_reader = csv.reader(csv_file, delimiter=',')

# skip the header row
next(csv_reader)

order_numbers = []
products_title = []
product_variants = []
price_before_discounts = []
price_after_discount_before_taxes = []
final_prices = []



for row in csv_reader:
    sale_ID, date, order_number, transaction_type, sale_type, sales_channel, \
    pos_location, billing_country, billing_region, billing_city, \
    shipping_country, shipping_region, shipping_city, product_type, \
    vendor, title, variant_title, sku, quantity, amount_before_tax, \
    line_item_discount, discount, amount_after_discount_before_taxes, \
    total_tax, total_amount = row

    order_number = row[2]
    product_title = row[15]
    product_variant = row[16]
    price_before_discount = row[19]
    price_after_discount_before_tax = row[22]
    final_price = row[24]

    order_numbers.append(order_number)
    products_title.append(product_title)
    product_variants.append(product_variant)
    price_before_discounts.append(price_before_discount)
    price_after_discount_before_taxes.append(price_after_discount_before_tax)
    final_prices.append(final_price)

    #print(order_numbers, final_prices)

    print(sale_ID , '-' , title)



csv_file.close()