About

I need a data specialist to parse a Squarespace order confirmation MBOX file and extract all order-level and product-level data into a clean CSV. Data to extract per order: Order ID (from subject line like "(00833)") Order date (from the email body) Customer name Email Shipping address (name, street, city, state, ZIP, country) Phone Shipping method text Product title Product variant/color Per-item personalization fields Item quantity Item price Item subtotal Shipping total Discount Tax Order total Deliverables: One CSV with one row per line item All fields above populated No blank fields for any order present in the MBOX Clean headers, consistent formatting Files I will provide: One .mbox file containing all Squarespace “Order has arrived” emails. Skills Needed: Email/MBOX parsing HTML scraping (BeautifulSoup or similar) CSV formatting Python (likely needed) Strong attention to detail Timeline: Fast turnaround preferred (same day or next day).