Laravel集成WooCommerce API：分页限制与客户数据获取异常

一、订单分页仅拉取100条的修复 #

你的分页逻辑存在两个核心问题：

1. 响应头获取方式错误：automattic/woocommerce的Client返回的订单是纯数据数组，响应头需通过getLastResponse()方法获取，而非从订单数组中读取headers字段
2. 循环条件逻辑缺陷：依赖count($orders) >= $per_page判断是否有更多数据，当最后一页数据量刚好等于per_page时会触发无效循环，应通过总页数控制循环

修正后的代码：

$since_id = 0;
$url            =   $this->store['store_url'];
$consumer_key   =   $this->store['consumer_key'];
$consumer_secret=   $this->store['consumer_secret'];
$options        =   [ 'wp_api' => true, 'version' => 'wc/v3' ];
$woocommerce    =   new Client($url, $consumer_key, $consumer_secret, $options);

$page = 1;
$per_page = 100; // WooCommerce API允许的最大per_page值为100
$all_orders = [];

// 首次请求并获取总页数
$args = [
    'per_page' => $per_page,
    'page' => $page,
];
$orders = $woocommerce->get('orders', $args);
$all_orders = array_merge($all_orders, $orders);

// 从响应头提取总页数与总订单数
$responseHeaders = $woocommerce->getLastResponse()->getHeaders();
$totalPages = isset($responseHeaders['X-WP-TotalPages'][0]) ? (int)$responseHeaders['X-WP-TotalPages'][0] : 1;
$totalOrders = isset($responseHeaders['X-WP-Total'][0]) ? (int)$responseHeaders['X-WP-Total'][0] : 0;

// 循环拉取剩余页面数据
while ($page < $totalPages) {
    $page++;
    $args['page'] = $page;
    $orders = $woocommerce->get('orders', $args);
    $all_orders = array_merge($all_orders, $orders);
}

二、客户数据返回空数组的修复 #

空数组通常由以下3种原因导致，逐一排查：

1. API权限不足（最常见） #

你的Consumer Key必须拥有read_customers权限，无权限时API不会报错，仅返回空数组。

• 登录WooCommerce后台 → WooCommerce → 设置 → 高级 → REST API
• 找到对应Key，检查权限是否为Read/Write或至少包含Read权限（需勾选客户相关权限）

2. 分页参数未初始化 #

原代码中$per_page和$page变量未定义，导致传递无效参数给API，返回空。修正后的代码：

$url            =   $this->store['store_url'];
$consumer_key   =   $this->store['consumer_key'];
$consumer_secret=   $this->store['consumer_secret'];
$options        =   [ 'wp_api' => true, 'version' => 'wc/v3' ];

$woocommerce = new Client($url, $consumer_key, $consumer_secret, $options);

// 初始化分页参数
$page = 1;
$per_page = 100;
$all_customers = [];

// 首次请求并获取总页数
$args = [
  'per_page' => $per_page,
  'page' => $page,
];
$customers = $woocommerce->get('customers', $args);
$all_customers = array_merge($all_customers, $customers);

$responseHeaders = $woocommerce->getLastResponse()->getHeaders();
$totalPages = isset($responseHeaders['X-WP-TotalPages'][0]) ? (int)$responseHeaders['X-WP-TotalPages'][0] : 1;

// 循环拉取所有客户数据
while ($page < $totalPages) {
    $page++;
    $args['page'] = $page;
    $customers = $woocommerce->get('customers', $args);
    $all_customers = array_merge($all_customers, $customers);
}

3. 无客户数据或过滤条件错误 #

• 检查WooCommerce后台是否存在客户数据
• 若添加了role、search等过滤参数，确认参数值正确，避免过滤掉所有数据

内容的提问来源于stack exchange，提问作者Salman Khan Sohoo