Output order data

Output order data

#!/bin/bash

# List all the site URLs
sites=$(wp site list --field=url)

# Loop over each site
for site in $sites
do
  # Create a safe filename from the URL
  filename=$(echo "$site" | sed 's/https\?:\/\///' | sed 's/\//_/g')

  # Get a list of all order IDs
  order_ids=$(wp --url="$site" post list --post_type='shop_order' --format=ids)

  # Loop over each order
  for order_id in $order_ids
  do
    # Get the order date
    order_date=$(wp --url="$site" post get "$order_id" --field=post_date)

    # Get the billing email
    billing_email=$(wp --url="$site" post meta get "$order_id" '_billing_email')

    # Append the data to the CSV file
    echo "$billing_email,$order_date,$order_id" >> ~/"$filename.csv"
  done
done