Formula Studio

Reshape any feed field, without writing code

Every DMS export has its quirks and every channel wants something slightly different. Formula Studio lets you build exactly the value each channel needs — a readable title, a normalized condition, a price with a fallback — and see the result on every one of your vehicles before you save.

  • 35 formula functions
  • Step-by-step explanations
  • Live preview on your inventory

Fix the data your DMS gets wrong

Formulas combine, clean and transform any column. Builders write the common ones for you, and snippets cover the rest.

  • Titles like “2024 Chevrolet Silverado 1500 LT Crew Cab 4WD”
  • Condition codes N, U and C mapped to new, used and certified
  • Price with a fallback to MSRP, or blank to leave a vehicle out
  • The first photo from a list, or every photo after the cover
  • Days in stock and age bands for campaign segmentation

See exactly what a formula does

Pick any vehicle and the Explain panel evaluates the formula step by step, showing the value of every part. Compare shows the saved output beside the edited one with a Changed filter, and misspelt fields and functions come with a one-click fix.

Write it once, use it everywhere

Save a formula as a custom field on the dealership and every feed can use it. Value maps translate codes in bulk, and a shared library of ready-made fields — best price, vehicle title, normalized condition, lead photo, validated VIN — covers the most common needs.

How it works

Live in an afternoon.

  1. STEP 01

    Connect your export

    Paste the URL of the inventory file your DMS or inventory tool already publishes. Mi Auto Sync reads it server-side and re-reads it every night.

  2. STEP 02

    Start from a template

    Pick the channel template, map any columns it could not match, and preview the output on your real vehicles.

  3. STEP 03

    Publish a URL or push a file

    Give the channel your feed URL, or have Mi Auto Sync upload the file to the channel’s FTP or SFTP server on a schedule. Either way it’s today’s lot, health-checked, with every delivery logged.

FAQ

Common questions

No. Builders write common formulas for you, and the syntax is closer to a spreadsheet than a programming language. Every formula previews live on your vehicles.

Run it yourself, or let us run it for you.

Self-Serve from $79 or Managed from $199 per rooftop per month. Every plan starts with a 14-day free trial.