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_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 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(15)
]
o1 = order(order_id='A', subtotal='$4.00', tracking='A')
o2 = order(order_id='A', subtotal='$12.00', tracking='B')
o3 = order(order_id='A', subtotal='$14.00', tracking='C')
amazon.associate_items_with_orders([o1, o2, o3], items)
self.assertTrue(o1.items_matched)
self.assertEqual(len(o1.items), 2)
self.assertTrue(o2.items_matched)
self.assertEqual(len(o2.items), 6)
self.assertTrue(o3.items_matched)
self.assertEqual(len(o3.items), 7)
def get_mint_updates(
orders,
items,
refunds,
trans,
args,
stats,
mint_category_name_to_id=category.DEFAULT_MINT_CATEGORIES_TO_IDS):
mint_historic_category_renames = get_mint_category_history_for_items(
trans, args)
# Remove items from canceled 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'
merch_whitelist = args.mint_input_merchant_filter.lower().split(',')
trans = [
t for t in trans if any(merch_str in t.omerchant.lower()
for merch_str in merch_whitelist)
]
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:
cat_whitelist = set(
args.mint_input_categories_filter.lower().split(','))
trans = [t for t in trans if t.category.lower() in cat_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',
max=len(matched_trans))
updates = []
for t in matched_trans:
updateCounter.next()
if t.is_debit:
order = amazon.Order.merge(t.orders)
merged_orders.extend(orders)
prefix = '{}: '.format(order.website)
if args.description_prefix_override:
prefix = args.description_prefix_override
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)
prefix = '{} refund: '.format(refunds[0].website)
if args.description_return_prefix_override:
prefix = args.description_return_prefix_override
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:
# Look if there's a personal category tagged.
item_name = amazon.rm_leading_qty(nt.merchant.lower())
if (mint_historic_category_renames
and item_name in mint_historic_category_renames):
suggested_cat = mint_historic_category_renames[item_name]
if suggested_cat != nt.category:
stats['personal_cat'] += 1
nt.category = mint_historic_category_renames[item_name]
nt.update_category_id(mint_category_name_to_id)
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
valid_prefixes = (args.amazon_domains.lower().split(',') +
[prefix.lower()])
if any(t.merchant.lower().startswith(pre) for pre in valid_prefixes):
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, unmatched_orders + unmatched_refunds
