Generate Offer Schema from B2B Pricing Data

✓ Tested Works with CSV, Excel, Google Sheets → JSON-LD Schema

By dataclean.to team · 2026-02-05

B2B pricing databases contain offer information with prices, availability windows, seller details, and purchase conditions. Offer schema enables rich product results with pricing display and purchase actions. Structured offer data improves e-commerce visibility and enables price comparison features.

The Problem

Pricing databases mix various price types (list, sale, volume discount) without clear temporal boundaries. Availability status may be inaccurate and shipping restrictions unclear. Without Offer schema markup, search engines cannot display current prices, availability status, or purchase options in product results, reducing click-through rates and conversion from product searches. Schema.org Offer

How to Fix It

Extract Price Information

Parse price amounts and identify currency codes. Distinguish between list prices, sale prices, and promotional offers. Extract price validity periods and expiration dates for time-limited offers.

Determine Availability Status

Identify stock status: in stock, out of stock, pre-order, discontinued. Extract inventory quantities when available. Map to availability property using ItemAvailability enumeration values.

Structure Seller Information

Extract merchant or vendor information and map to seller property using Organization schema. Include seller ratings, shipping policies, and return conditions where applicable.

Parse Purchase Conditions

Extract minimum order quantities, volume discount tiers, and eligibility restrictions. Identify shipping regions and delivery timeframes. Map to eligibleRegion, shippingDetails, and priceValidUntil properties.

Generate Offer Schema JSON-LD

Output Offer schema with required price and priceCurrency fields. Include availability, seller, url for purchase page, priceValidUntil, and itemCondition for complete offer representation.

Frequently Asked Questions

How should I represent volume pricing or quantity discounts in Offer schema?

Create multiple Offer objects with different prices and use the eligibleQuantity property to specify minimum quantities. Alternatively, use PriceSpecification with UnitPriceSpecification objects for detailed tiered pricing structures.

What availability value should I use for pre-order products?

Use the ItemAvailability value PreOrder for products available for advance purchase. Include availabilityStarts property with the date when the product will be in stock and shipping begins.

Can one product have multiple Offer objects from different sellers?

Yes, include multiple Offer objects in the product's offers property array. Each should have a different seller organization. This is common for marketplace platforms where multiple vendors sell the same product.

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.

{
  "@context": "https://schema.org",
  "@type": "Dataset",
  "name": "Cleaned Customer Data",
  "description": "Normalized customer records with standardized fields",
  "keywords": ["customer data", "CRM", "contact list"]
}

💡 How it works: Consistent data formatting reduces import errors and makes your dataset compatible with downstream tools.

Ready to Clean Your Data?

Upload your CSV or spreadsheet and get clean, structured data in minutes.

Get Started Free

Related Use Cases

Schema Generation

B2B To Product Schema

Schema Generation

B2B To Organization Schema