Vinted Sales Automation

Objective

Maintain an accurate sales and profit tracker that imports historical Vinted sales and can later update automatically when an order is completed.

Current status

The historical-import phase is complete. A five-page image-based Vinted sales export was processed with OCR and added to a safe copy of the existing Excel tracker as a new "Vinted Sales" sheet. The live automation phase has not yet been implemented.

Source material

• Existing tracker: Sales_Tracker_Fixed.xlsx
• Historical export: Export of sales.pdf
• Tracker structure: Sales Log, Summary, and 157 populated item rows.

Historical import results

• 46 completed Vinted orders extracted via OCR.
• £763.50 in total revenue identified.
• Most sales matched cleanly to existing cost rows.
• One £20 bundle mapped across two separate stock rows.
• Four small sales flagged for manual review — no reliable cost match was available.
• The original workbook was preserved untouched; all work happened in a safe copy.

Issues found in the original tracker

• A delivery-cost reference contained a broken #REF! formula.
• "Items Sold" appeared to include unsold items and unrelated expenses.
• The source export didn't include individual sale dates or order IDs.
• Without a stable order ID, duplicate detection is inherently weaker.

Target data model

Planned automation

Using completed-order email notifications rather than an unofficial Vinted API:

For an Excel/OneDrive workflow, Power Automate is the natural first option. The automation should trigger only when payment or the order is fully completed — not when an item is merely marked sold.

Next actions

1. Resolve the four unmatched cost rows.
2. Repair the delivery-cost reference and "Items Sold" summary logic in a new safe copy.
3. Add Order ID, dates, status and platform columns to the model.
4. Collect several representative Vinted completion emails.
5. Build and test the Power Automate parsing flow.
6. Add duplicate prevention and an exception queue for messages that fail to parse.
7. Reconcile automated totals against Vinted's own monthly totals.

Acceptance criteria

• A completed sale creates exactly one tracker row.
• Cancelled or returned orders never count as income.
• Reprocessing an email doesn't create a duplicate.
• Unmatched stock items are visibly flagged.
• Revenue and profit summaries update correctly.

Related