2025-11-25 02:26:15,013 - INFO - ================================================================================ 2025-11-25 02:26:15,013 - INFO - SCRIPT 9: SYNC ADDITIONAL COSTS 2025-11-25 02:26:15,013 - INFO - ================================================================================ 2025-11-25 02:26:15,013 - INFO - Log file: logs/additional_costs_20251125_022615.log 2025-11-25 02:26:15,013 - INFO - 2025-11-25 02:26:15,017 - INFO - Cost Type Mapping: 2025-11-25 02:26:15,017 - INFO - ------------------------------------------------------------ 2025-11-25 02:26:15,017 - INFO - '' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - ' Amazon adjustment' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - ' Amazon adjustment ' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - '15% restocking fee of the order' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Am z Adj' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Amaz Adj' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Amazon Adj' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Amazon Adjsutment' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Amazon Adjustment' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Amazon Adjustment ' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'AMZ Adj' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'AMZ Adj ' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Amz adj.' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'AMZ adj. ' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'AMZ adj. ' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'AMZ adj. ' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Carrier Credit' → carrier_credits (subtract) 2025-11-25 02:26:15,017 - INFO - 'chargeback fee ' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Clean Up Fee' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'CX did not return the part ' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Damage Repair Fee' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Damaged Repair Fee' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Damaged Repair Fee ' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Double Order ' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Duplicated order placed in error' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'FedEx COA Fee' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'LC adj' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'LC adj ' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'never got delivered to us' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Not Received ' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'offered $10 for the inconvenience due to an error listing' → additional_cost (add) 2025-11-25 02:26:15,017 - INFO - 'Purchased - Customer Cancelled' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Reconsignment Fee' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Reordered LX1000250C 6233429Q ' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Repair fee' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Repair cost' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Repair Fee' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Repair Fee ' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Replacement Part' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Replacement Price Difference' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Replacement Shipping Cost' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Rerouted Parcel Fee' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Rerouting Fee' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Restocking fee' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Return' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Return Label Cost' → label_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Return Re-consignment fee' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Return Reconsignment fee' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Shipping fee' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Supplier Credit' → supplier_credits (subtract) 2025-11-25 02:26:15,018 - INFO - 'SUPPLIER REFUNDED' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - 'Tax charge' → additional_cost (add) 2025-11-25 02:26:15,018 - INFO - ------------------------------------------------------------ 2025-11-25 02:26:15,018 - INFO - 2025-11-25 02:26:15,039 - INFO - Found 6692 total records in orders_additional_costs 2025-11-25 02:26:15,044 - INFO - Aggregated costs for 6502 unique order items 2025-11-25 02:26:15,044 - INFO - 2025-11-25 02:26:15,045 - INFO - Total Amounts to Sync: 2025-11-25 02:26:15,045 - INFO - additional_cost: $45,702.82 2025-11-25 02:26:15,045 - INFO - label_cost: $116,521.22 2025-11-25 02:26:15,045 - INFO - supplier_credits: $60,749.14 2025-11-25 02:26:15,045 - INFO - carrier_credits: $1,814.40 2025-11-25 02:26:15,045 - INFO - 2025-11-25 02:26:15,045 - INFO - Updating orders_items_margin_detailed... 2025-11-25 02:26:15,575 - INFO - Progress: 100/6502 items processed 2025-11-25 02:26:16,083 - INFO - Progress: 200/6502 items processed 2025-11-25 02:26:16,594 - INFO - Progress: 300/6502 items processed 2025-11-25 02:26:17,110 - INFO - Progress: 400/6502 items processed 2025-11-25 02:26:17,623 - INFO - Progress: 500/6502 items processed 2025-11-25 02:26:18,150 - INFO - Progress: 600/6502 items processed 2025-11-25 02:26:18,687 - INFO - Progress: 700/6502 items processed 2025-11-25 02:26:19,208 - INFO - Progress: 800/6502 items processed 2025-11-25 02:26:19,745 - INFO - Progress: 900/6502 items processed 2025-11-25 02:26:20,264 - INFO - Progress: 1000/6502 items processed 2025-11-25 02:26:20,808 - INFO - Progress: 1100/6502 items processed 2025-11-25 02:26:21,414 - INFO - Progress: 1200/6502 items processed 2025-11-25 02:26:22,017 - INFO - Progress: 1300/6502 items processed 2025-11-25 02:26:22,592 - INFO - Progress: 1400/6502 items processed 2025-11-25 02:26:23,177 - INFO - Progress: 1500/6502 items processed 2025-11-25 02:26:23,776 - INFO - Progress: 1600/6502 items processed 2025-11-25 02:26:24,335 - INFO - Progress: 1700/6502 items processed 2025-11-25 02:26:24,863 - INFO - Progress: 1800/6502 items processed 2025-11-25 02:26:25,369 - INFO - Progress: 1900/6502 items processed 2025-11-25 02:26:25,891 - INFO - Progress: 2000/6502 items processed 2025-11-25 02:26:26,407 - INFO - Progress: 2100/6502 items processed 2025-11-25 02:26:26,914 - INFO - Progress: 2200/6502 items processed 2025-11-25 02:26:27,455 - INFO - Progress: 2300/6502 items processed 2025-11-25 02:26:27,977 - INFO - Progress: 2400/6502 items processed 2025-11-25 02:26:28,495 - INFO - Progress: 2500/6502 items processed 2025-11-25 02:26:29,048 - INFO - Progress: 2600/6502 items processed 2025-11-25 02:26:29,641 - INFO - Progress: 2700/6502 items processed 2025-11-25 02:26:30,211 - INFO - Progress: 2800/6502 items processed 2025-11-25 02:26:30,733 - INFO - Progress: 2900/6502 items processed 2025-11-25 02:26:31,267 - INFO - Progress: 3000/6502 items processed 2025-11-25 02:26:31,806 - INFO - Progress: 3100/6502 items processed 2025-11-25 02:26:32,353 - INFO - Progress: 3200/6502 items processed 2025-11-25 02:26:32,954 - INFO - Progress: 3300/6502 items processed 2025-11-25 02:26:33,571 - INFO - Progress: 3400/6502 items processed 2025-11-25 02:26:34,186 - INFO - Progress: 3500/6502 items processed 2025-11-25 02:26:34,780 - INFO - Progress: 3600/6502 items processed 2025-11-25 02:26:35,301 - INFO - Progress: 3700/6502 items processed 2025-11-25 02:26:35,801 - INFO - Progress: 3800/6502 items processed 2025-11-25 02:26:36,305 - INFO - Progress: 3900/6502 items processed 2025-11-25 02:26:36,821 - INFO - Progress: 4000/6502 items processed 2025-11-25 02:26:37,320 - INFO - Progress: 4100/6502 items processed 2025-11-25 02:26:37,816 - INFO - Progress: 4200/6502 items processed 2025-11-25 02:26:38,314 - INFO - Progress: 4300/6502 items processed 2025-11-25 02:26:38,818 - INFO - Progress: 4400/6502 items processed 2025-11-25 02:26:39,320 - INFO - Progress: 4500/6502 items processed 2025-11-25 02:26:39,825 - INFO - Progress: 4600/6502 items processed 2025-11-25 02:26:40,337 - INFO - Progress: 4700/6502 items processed 2025-11-25 02:26:40,865 - INFO - Progress: 4800/6502 items processed 2025-11-25 02:26:41,403 - INFO - Progress: 4900/6502 items processed 2025-11-25 02:26:41,921 - INFO - Progress: 5000/6502 items processed 2025-11-25 02:26:42,435 - INFO - Progress: 5100/6502 items processed 2025-11-25 02:26:45,359 - INFO - Progress: 5200/6502 items processed 2025-11-25 02:26:48,693 - INFO - Progress: 5300/6502 items processed 2025-11-25 02:26:52,239 - INFO - Progress: 5400/6502 items processed 2025-11-25 02:26:55,746 - INFO - Progress: 5500/6502 items processed 2025-11-25 02:26:59,055 - INFO - Progress: 5600/6502 items processed 2025-11-25 02:27:02,412 - INFO - Progress: 5700/6502 items processed 2025-11-25 02:27:05,962 - INFO - Progress: 5800/6502 items processed 2025-11-25 02:27:09,511 - INFO - Progress: 5900/6502 items processed 2025-11-25 02:27:13,207 - INFO - Progress: 6000/6502 items processed 2025-11-25 02:27:16,719 - INFO - Progress: 6100/6502 items processed 2025-11-25 02:27:20,069 - INFO - Progress: 6200/6502 items processed 2025-11-25 02:27:23,465 - INFO - Progress: 6300/6502 items processed 2025-11-25 02:27:26,988 - INFO - Progress: 6400/6502 items processed 2025-11-25 02:27:30,496 - INFO - Progress: 6500/6502 items processed 2025-11-25 02:27:30,565 - INFO - Progress: 6502/6502 items processed 2025-11-25 02:27:30,565 - INFO - 2025-11-25 02:27:30,565 - INFO - ================================================================================ 2025-11-25 02:27:30,565 - INFO - SUMMARY 2025-11-25 02:27:30,565 - INFO - ================================================================================ 2025-11-25 02:27:30,565 - INFO - Total records in orders_additional_costs: 6692 2025-11-25 02:27:30,565 - INFO - Unique order items with costs: 6502 2025-11-25 02:27:30,565 - INFO - Updated in orders_items_margin_detailed: 1365 2025-11-25 02:27:30,565 - INFO - Not found in detailed table: 5137 2025-11-25 02:27:30,565 - INFO - 2025-11-25 02:27:30,565 - INFO - Amounts Synced: 2025-11-25 02:27:30,565 - INFO - additional_cost (adds to COGS): $45,702.82 2025-11-25 02:27:30,565 - INFO - label_cost (adds to COGS): $116,521.22 2025-11-25 02:27:30,565 - INFO - supplier_credits (reduces COGS): $60,749.14 2025-11-25 02:27:30,565 - INFO - carrier_credits (reduces COGS): $1,814.40 2025-11-25 02:27:30,565 - INFO - ================================================================================