✓ TestedWorks with CSV, Excel, Google Sheets → JSON-LD Schema
By dataclean.to team · 2026-02-05
Automotive dealerships advertise vehicle pricing, lease offers, and service specials across digital channels. Offer schema enables price display in Google Shopping results and vehicle listings. Converting CSV pricing data to structured markup ensures accurate representation of sale prices, financing terms, and promotional offers.
The Problem
Vehicle pricing data in CSV format includes MSRP, sale prices, lease terms, and down payment amounts without schema markup. Promotional offers for service packages, financing rates, and seasonal sales require structured data for search visibility. Manual Offer schema creation for inventory updates, end-of-year sales, and manufacturer incentives creates inconsistencies across listing platforms when managing pricing for hundreds of vehicles. Schema.org Offer Specification
How to Fix It
1
Upload Pricing Data CSV
Import offer information including price, currency, availability, valid dates, and terms. System detects sale prices and regular pricing automatically.
2
Map Price and Currency Fields
Link price columns to Offer properties. Currency codes (USD, EUR, GBP) are validated. Sale prices populate both price and priceSpecification fields.
3
Configure Availability and Terms
Stock status maps to availability property (InStock, OutOfStock, PreOrder). Valid from and valid through dates set offer duration for time-limited promotions.
4
Add Financing and Lease Terms
Monthly payment amounts, interest rates, and lease terms populate priceSpecification with UnitPriceSpecification for structured payment display.
5
Export Offer JSON-LD
Download JSON-LD markup for product pages. Schema includes seller information, accepted payment methods, and warranty details for complete offer representation.
Frequently Asked Questions
How do I represent manufacturer rebates in Offer schema?
Use the priceSpecification property with a UnitPriceSpecification entry for the rebate amount. Set the referenceQuantity to the purchase and include the rebate terms in the description field. Link to manufacturer terms with the url property.
Can I show both lease and purchase pricing in the same schema?
Create separate Offer entries for lease and purchase options, both linked to the same Vehicle product. Each offer should have distinct price, priceSpecification, and terms to avoid confusion between payment structures.
How are trade-in values represented in the offer?
Trade-in values are not directly supported in Offer schema. Mention trade-in allowances in the description field and use the price property for the net purchase price after trade-in credit.
Example: Input → Output
name
email
phone
city
status
Alice Johnson
alice@example.com
+1-555-0101
New York
active
alice johnson
ALICE@EXAMPLE.COM
5550101
new york
Active
Red rows show common data quality issues. dataclean.to normalizes and generates JSON-LD automatically.