📊CSV Import Templates

Sales Orders

Sales order CSV format for order management and fulfillment systems.

Explanation

Standard format for importing customer orders with line items and shipping info.

Examples

Order CSV

Output

orderId,orderDate,customerEmail,sku,quantity,unitPrice,shippingAddress,city,state,zipCode
ORD-001,2024-12-15,john@example.com,PROD-001,2,29.99,"123 Main St",New York,NY,10001
ORD-001,2024-12-15,john@example.com,PROD-002,1,15.50,"123 Main St",New York,NY,10001
ORD-002,2024-12-16,jane@example.com,PROD-003,1,89.99,"456 Oak Ave",Boston,MA,02101

Code Examples

JavaScript

// Parse orders with line items grouping
function parseOrders(csvData) {
  const lines = parseCSV(csvData);
  const ordersMap = new Map();
  
  lines.forEach(line => {
    if (!ordersMap.has(line.orderId)) {
      ordersMap.set(line.orderId, {
        orderId: line.orderId,
        orderDate: new Date(line.orderDate),
        customerEmail: line.customerEmail,
        shippingAddress: {
          street: line.shippingAddress,
          city: line.city,
          state: line.state,
          zipCode: line.zipCode
        },
        items: []
      });
    }
    
    ordersMap.get(line.orderId).items.push({
      sku: line.sku,
      quantity: parseInt(line.quantity),
      unitPrice: parseFloat(line.unitPrice)
    });
  });
  
  return Array.from(ordersMap.values());
}

Try it Now

Open in CSV/JSON Converter

💡 Tips

One row per line item (repeat order info)
Group by orderId during import
Include order date for tracking
Validate inventory before import
Calculate totals after grouping
Include order status field

⚠️ Common Pitfalls

Duplicate orderIds must have same customer/address
Missing line items break orders
Quantities must be positive integers
Price changes after order creation
Shipping info validation needed