Contract Configuration Batch Processing for SKU tests

Upload an Excel spreadsheet to automatically create contracts for multiple configurations and see the results of the processing.

📋 How to use this tool

Excel File Requirements

Your Excel file uses a flexible schema where only certain fields are required:

Required Fields (must be present):

lineItemId - Unique identifier for each row
sku - Product SKU
applianceBrand - Brand name
applianceDescription - Product description
model - Product model
premium - Premium amount (pence)
appliancePrice - Product price (pence)
orderNumber - Order reference
orderCurrency - Currency code (e.g., GBP)

Optional Fields (with defaults):

firstName → defaults to "bob"
lastName → defaults to "builder"
email → defaults to "test@domesticandgeneral.com"
mobile → defaults to "+447000777446"
title → defaults to "mr"
addressLine1, addressLine2, city, country, postalCode, region → default address values
channel → defaults to 'web'
deliveryEstimate → defaults to today's date

💡 Flexible Usage:

Minimal Excel: Only include the 9 required fields
Partial Data: Include optional fields you want to override
Mixed Rows: Different rows can have different optional fields

Steps to Use:

Enter your JWT token for authentication
Select the retailer domain
Upload your Excel file (.xlsx or .xls)
Monitor real-time progress and view results
Use "Selective Retry" to reprocess only failed items