def test_associate_items_with_orders_single_item_subtotal_match(self):
i1 = item()
o1 = order()
amazon.associate_items_with_orders([o1], [i1])
self.assertTrue(o1.items_matched)
self.assertEqual(o1.items, [i1])
def test_associate_items_with_orders_multiple_items_subtotal_match(self):
oid1 = 'Order1'
i1 = item(order_id=oid1, item_subtotal='$20.21', quantity=6)
i2 = item(order_id=oid1, item_subtotal='$2.01', quantity=1)
i3 = item(order_id=oid1, item_subtotal='$0.41')
items = [i1, i2, i3]
o1 = order(order_id=oid1, subtotal='$22.63')
amazon.associate_items_with_orders([o1], items)
self.assertTrue(o1.items_matched)
self.assertEqual(o1.items, items)
def test_associate_items_with_orders_none_match(self):
i1 = item(order_id='1', item_subtotal='$100.00')
i2 = item(order_id='2')
i3 = item(order_id='3')
i4 = item(order_id='4')
oa = order(order_id='A')
o1 = order(order_id='1', subtotal='$5.00')
amazon.associate_items_with_orders([oa, o1], [i1, i2, i3, i4])
self.assertFalse(oa.items_matched)
self.assertEqual(oa.items, [])
self.assertFalse(o1.items_matched)
self.assertEqual(o1.items, [])
def test_associate_items_with_orders_multi_single_matches(self):
i1 = item(order_id='1')
o1 = order(order_id='1')
i2 = item(order_id='2')
o2 = order(order_id='2')
i3 = item(order_id='3')
o3 = order(order_id='3')
amazon.associate_items_with_orders([o1, o2, o3], [i3, i2, i1])
self.assertTrue(o1.items_matched)
self.assertEqual(o1.items, [i1])
self.assertTrue(o2.items_matched)
self.assertEqual(o2.items, [i2])
self.assertTrue(o3.items_matched)
self.assertEqual(o3.items, [i3])
def test_associate_items_with_orders_multi_orders_and_items_by_combi(self):
# Sometimes the same item is shipped in different packages, so tracking
# number doesn't work.
items = [
item(order_id='A', item_subtotal='$2.00', tracking='A')
for i in range(8)
]
o1 = order(order_id='A', subtotal='$4.00', tracking='A')
o2 = order(order_id='A', subtotal='$12.00', tracking='B')
amazon.associate_items_with_orders([o1, o2], items)
self.assertTrue(o1.items_matched)
self.assertEqual(len(o1.items), 2)
self.assertTrue(o2.items_matched)
self.assertEqual(len(o2.items), 6)
def test_associate_items_with_orders_multi_orders_and_items_by_track(self):
# All items and orders have the same order id, but they shipped in
# different packages.
oid = 'ABC'
i1 = item(order_id=oid, item_subtotal='$20.21', tracking='A')
i2 = item(order_id=oid, item_subtotal='$2.01', tracking='A')
i3 = item(order_id=oid, item_subtotal='$0.41', tracking='B')
a_items = [i1, i2]
b_items = [i3]
o1 = order(order_id=oid, subtotal='$22.22', tracking='A')
o2 = order(order_id=oid, subtotal='$0.41', tracking='B')
amazon.associate_items_with_orders([o1, o2], a_items + b_items)
self.assertTrue(o1.items_matched)
self.assertEqual(o1.items, a_items)
self.assertTrue(o2.items_matched)
self.assertEqual(o2.items, b_items)
def main():
parser = argparse.ArgumentParser(
description='Tag Mint transactions based on itemized Amazon history.')
define_args(parser)
args = parser.parse_args()
if args.dry_run:
logger.info('Dry Run; no modifications being sent to Mint.')
# Initialize the stats. Explicitly initialize stats that might not be
# accumulated (conditionals).
stats = Counter(
adjust_itemized_tax=0,
already_up_to_date=0,
misc_charge=0,
new_tag=0,
no_retag=0,
retag=0,
user_skipped_retag=0,
)
orders = amazon.Order.parse_from_csv(args.orders_csv)
items = amazon.Item.parse_from_csv(args.items_csv)
# Remove items from cancelled orders.
items = [i for i in items if not i.is_cancelled()]
# Remove items that haven't shipped yet (also aren't charged).
items = [i for i in items if i.order_status == 'Shipped']
# Remove items with zero quantity (it happens!)
items = [i for i in items if i.quantity > 0]
# Make more Items such that every item is quantity 1.
items = [si for i in items for si in i.split_by_quantity()]
logger.info('Matching Amazon Items with Orders')
amazon.associate_items_with_orders(orders, items)
refunds = [] if not args.refunds_csv else amazon.Refund.parse_from_csv(args.refunds_csv)
log_amazon_stats(items, orders, refunds)
# Only match orders that have items.
orders = [o for o in orders if o.items]
mint_client = None
def close_mint_client():
if mint_client:
mint_client.close()
atexit.register(close_mint_client)
if args.pickled_epoch:
mint_trans, mint_category_name_to_id = (
get_trans_and_categories_from_pickle(args.pickled_epoch))
else:
mint_client = get_mint_client(args)
# Only get transactions as new as the oldest Amazon order.
oldest_trans_date = min([o.order_date for o in orders])
if refunds:
oldest_trans_date = min(
oldest_trans_date,
min([o.order_date for o in refunds]))
mint_transactions_json, mint_category_name_to_id = (
get_trans_and_categories_from_mint(mint_client, oldest_trans_date))
epoch = int(time.time())
mint_trans = mint.Transaction.parse_from_json(mint_transactions_json)
dump_trans_and_categories(mint_trans, mint_category_name_to_id, epoch)
def get_prefix(is_debit):
return (args.description_prefix if is_debit
else args.description_return_prefix)
trans = mint.Transaction.unsplit(mint_trans)
stats['trans'] = len(trans)
# Skip t if the original description doesn't contain 'amazon'
trans = [t for t in trans if 'amazon' in t.omerchant.lower()]
stats['amazon_in_desc'] = len(trans)
# Skip t if it's pending.
trans = [t for t in trans if not t.is_pending]
stats['pending'] = stats['amazon_in_desc'] - len(trans)
# Skip t if a category filter is given and t does not match.
if args.mint_input_categories_filter:
whitelist = set(args.mint_input_categories_filter.lower().split(','))
trans = [t for t in trans if t.category.lower() in whitelist ]
# Match orders.
match_transactions(trans, orders)
unmatched_trans = [t for t in trans if not t.orders]
# Match refunds.
match_transactions(unmatched_trans, refunds)
unmatched_orders = [o for o in orders if not o.matched]
unmatched_trans = [t for t in trans if not t.orders]
unmatched_refunds = [r for r in refunds if not r.matched]
num_gift_card = len([o for o in unmatched_orders
if 'Gift Certificate' in o.payment_instrument_type])
num_unshipped = len([o for o in unmatched_orders if not o.shipment_date])
matched_orders = [o for o in orders if o.matched]
matched_trans = [t for t in trans if t.orders]
matched_refunds = [r for r in refunds if r.matched]
stats['trans_unmatch'] = len(unmatched_trans)
stats['order_unmatch'] = len(unmatched_orders)
stats['refund_unmatch'] = len(unmatched_refunds)
stats['trans_match'] = len(matched_trans)
stats['order_match'] = len(matched_orders)
stats['refund_match'] = len(matched_refunds)
stats['skipped_orders_gift_card'] = num_gift_card
stats['skipped_orders_unshipped'] = num_unshipped
merged_orders = []
merged_refunds = []
updates = []
for t in matched_trans:
if t.is_debit:
order = amazon.Order.merge(t.orders)
merged_orders.extend(orders)
if order.attribute_subtotal_diff_to_misc_charge():
stats['misc_charge'] += 1
# It's nice when "free" shipping cancels out with the shipping
# promo, even though there is tax on said free shipping. Spread
# that out across the items instead.
# if order.attribute_itemized_diff_to_shipping_tax():
# stats['add_shipping_tax'] += 1
if order.attribute_itemized_diff_to_per_item_tax():
stats['adjust_itemized_tax'] += 1
assert micro_usd_nearly_equal(t.amount, order.total_charged)
assert micro_usd_nearly_equal(t.amount, order.total_by_subtotals())
assert micro_usd_nearly_equal(t.amount, order.total_by_items())
new_transactions = order.to_mint_transactions(
t,
skip_free_shipping=not args.verbose_itemize)
else:
refunds = amazon.Refund.merge(t.orders)
merged_refunds.extend(refunds)
new_transactions = [
r.to_mint_transaction(t)
for r in refunds]
assert micro_usd_nearly_equal(t.amount, mint.Transaction.sum_amounts(new_transactions))
for nt in new_transactions:
nt.update_category_id(mint_category_name_to_id)
prefix = get_prefix(t.is_debit)
summarize_single_item_order = (
t.is_debit and len(order.items) == 1 and not args.verbose_itemize)
if args.no_itemize or summarize_single_item_order:
new_transactions = mint.summarize_new_trans(t, new_transactions, prefix)
else:
new_transactions = mint.itemize_new_trans(new_transactions, prefix)
if mint.Transaction.old_and_new_are_identical(
t, new_transactions, ignore_category=args.no_tag_categories):
stats['already_up_to_date'] += 1
continue
if t.merchant.startswith(prefix):
if args.prompt_retag:
if args.num_updates > 0 and len(updates) >= args.num_updates:
break
logger.info('\nTransaction already tagged:')
print_dry_run(
[(t, new_transactions)],
ignore_category=args.no_tag_categories)
logger.info('\nUpdate tag to proposed? [Yn] ')
action = readchar.readchar()
if action == '':
exit(1)
if action not in ('Y', 'y', '\r', '\n'):
stats['user_skipped_retag'] += 1
continue
stats['retag'] += 1
elif not args.retag_changed:
stats['no_retag'] += 1
continue
else:
stats['retag'] += 1
else:
stats['new_tag'] += 1
updates.append((t, new_transactions))
log_processing_stats(stats)
if not updates:
logger.info(
'All done; no new tags to be updated at this point in time!.')
exit(0)
if args.num_updates > 0:
updates = updates[:num_updates]
if args.dry_run:
logger.info('Dry run. Following are proposed changes:')
print_dry_run(updates, ignore_category=args.no_tag_categories)
else:
# Ensure we have a Mint client.
if not mint_client:
mint_client = get_mint_client(args)
send_updates_to_mint(
updates, mint_client, ignore_category=args.no_tag_categories)
def get_mint_updates(
orders,
items,
refunds,
trans,
args,
stats,
mint_category_name_to_id=category.DEFAULT_MINT_CATEGORIES_TO_IDS):
def get_prefix(is_debit):
return (args.description_prefix
if is_debit else args.description_return_prefix)
# Remove items from cancelled orders.
items = [i for i in items if not i.is_cancelled()]
# Remove items that haven't shipped yet (also aren't charged).
items = [i for i in items if i.order_status == 'Shipped']
# Remove items with zero quantity (it happens!)
items = [i for i in items if i.quantity > 0]
# Make more Items such that every item is quantity 1. This is critical
# prior to associate_items_with_orders such that items with non-1
# quantities split into different packages can be associated with the
# appropriate order.
items = [si for i in items for si in i.split_by_quantity()]
itemProgress = IncrementalBar('Matching Amazon Items with Orders',
max=len(items))
amazon.associate_items_with_orders(orders, items, itemProgress)
itemProgress.finish()
# Only match orders that have items.
orders = [o for o in orders if o.items]
trans = mint.Transaction.unsplit(trans)
stats['trans'] = len(trans)
# Skip t if the original description doesn't contain 'amazon'
trans = [t for t in trans if 'amazon' in t.omerchant.lower()]
stats['amazon_in_desc'] = len(trans)
# Skip t if it's pending.
trans = [t for t in trans if not t.is_pending]
stats['pending'] = stats['amazon_in_desc'] - len(trans)
# Skip t if a category filter is given and t does not match.
if args.mint_input_categories_filter:
whitelist = set(args.mint_input_categories_filter.lower().split(','))
trans = [t for t in trans if t.category.lower() in whitelist]
# Match orders.
orderMatchProgress = IncrementalBar('Matching Amazon Orders w/ Mint Trans',
max=len(orders))
match_transactions(trans, orders, orderMatchProgress)
orderMatchProgress.finish()
unmatched_trans = [t for t in trans if not t.orders]
# Match refunds.
refundMatchProgress = IncrementalBar(
'Matching Amazon Refunds w/ Mint Trans', max=len(refunds))
match_transactions(unmatched_trans, refunds, refundMatchProgress)
refundMatchProgress.finish()
unmatched_orders = [o for o in orders if not o.matched]
unmatched_trans = [t for t in trans if not t.orders]
unmatched_refunds = [r for r in refunds if not r.matched]
num_gift_card = len([
o for o in unmatched_orders
if 'Gift Certificate' in o.payment_instrument_type
])
num_unshipped = len([o for o in unmatched_orders if not o.shipment_date])
matched_orders = [o for o in orders if o.matched]
matched_trans = [t for t in trans if t.orders]
matched_refunds = [r for r in refunds if r.matched]
stats['trans_unmatch'] = len(unmatched_trans)
stats['order_unmatch'] = len(unmatched_orders)
stats['refund_unmatch'] = len(unmatched_refunds)
stats['trans_match'] = len(matched_trans)
stats['order_match'] = len(matched_orders)
stats['refund_match'] = len(matched_refunds)
stats['skipped_orders_gift_card'] = num_gift_card
stats['skipped_orders_unshipped'] = num_unshipped
merged_orders = []
merged_refunds = []
updateCounter = IncrementalBar('Determining Mint Updates')
updates = []
for t in updateCounter.iter(matched_trans):
if t.is_debit:
order = amazon.Order.merge(t.orders)
merged_orders.extend(orders)
if order.attribute_subtotal_diff_to_misc_charge():
stats['misc_charge'] += 1
# It's nice when "free" shipping cancels out with the shipping
# promo, even though there is tax on said free shipping. Spread
# that out across the items instead.
# if order.attribute_itemized_diff_to_shipping_tax():
# stats['add_shipping_tax'] += 1
if order.attribute_itemized_diff_to_per_item_tax():
stats['adjust_itemized_tax'] += 1
assert micro_usd_nearly_equal(t.amount, order.total_charged)
assert micro_usd_nearly_equal(t.amount, order.total_by_subtotals())
assert micro_usd_nearly_equal(t.amount, order.total_by_items())
new_transactions = order.to_mint_transactions(
t, skip_free_shipping=not args.verbose_itemize)
else:
refunds = amazon.Refund.merge(t.orders)
merged_refunds.extend(refunds)
new_transactions = [r.to_mint_transaction(t) for r in refunds]
assert micro_usd_nearly_equal(
t.amount, mint.Transaction.sum_amounts(new_transactions))
for nt in new_transactions:
nt.update_category_id(mint_category_name_to_id)
prefix = get_prefix(t.is_debit)
summarize_single_item_order = (t.is_debit and len(order.items) == 1
and not args.verbose_itemize)
if args.no_itemize or summarize_single_item_order:
new_transactions = mint.summarize_new_trans(
t, new_transactions, prefix)
else:
new_transactions = mint.itemize_new_trans(new_transactions, prefix)
if mint.Transaction.old_and_new_are_identical(
t, new_transactions, ignore_category=args.no_tag_categories):
stats['already_up_to_date'] += 1
continue
if t.merchant.startswith(prefix):
if args.prompt_retag:
if args.num_updates > 0 and len(updates) >= args.num_updates:
break
logger.info('\nTransaction already tagged:')
print_dry_run([(t, new_transactions)],
ignore_category=args.no_tag_categories)
logger.info('\nUpdate tag to proposed? [Yn] ')
action = readchar.readchar()
if action == '':
exit(1)
if action not in ('Y', 'y', '\r', '\n'):
stats['user_skipped_retag'] += 1
continue
stats['retag'] += 1
elif not args.retag_changed:
stats['no_retag'] += 1
continue
else:
stats['retag'] += 1
else:
stats['new_tag'] += 1
updates.append((t, new_transactions))
if args.num_updates > 0:
updates = updates[:args.num_updates]
return updates