const ecommerceWorkbook = {
name: "E-commerce Data Import",
description: "Import customers, products, and orders",
sheets: [
{
name: "customers",
slug: "customers",
fields: [
{ key: "customerId", type: "string", label: "Customer ID" },
{ key: "email", type: "string", label: "Email" },
{ key: "firstName", type: "string", label: "First Name" },
{ key: "lastName", type: "string", label: "Last Name" },
],
},
{
name: "products",
slug: "products",
fields: [
{ key: "productId", type: "string", label: "Product ID" },
{ key: "name", type: "string", label: "Product Name" },
{ key: "price", type: "number", label: "Price" },
{ key: "category", type: "string", label: "Category" },
],
},
{
name: "orders",
slug: "orders",
fields: [
{ key: "orderId", type: "string", label: "Order ID" },
{
key: "customerId",
type: "reference",
label: "Customer",
config: { ref: "customers", key: "customerId" },
},
{
key: "productId",
type: "reference",
label: "Product",
config: { ref: "products", key: "productId" },
},
{ key: "quantity", type: "number", label: "Quantity" },
{ key: "orderDate", type: "date", label: "Order Date" },
],
},
],
};