WooCommerce API v3 产品评论：添加与自定义元数据限制解析

from woocommerce import API
import json
from datetime import datetime
import random

# 配置您的WooCommerce API凭据
URL = "http://your-woocommerce-store.com" # 您的商店URL
CONSUMER_KEY = "ck_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" # 您的消费者密钥
CONSUMER_SECRET = "cs_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" # 您的消费者秘密密钥

def add_review(url, consumer_key, consumer_secret, review_data):
    """
    使用WooCommerce API添加产品评论。
    """
    wcapi = API(
        url=url,
        consumer_key=consumer_key,
        consumer_secret=consumer_secret,
        version="wc/v3" # 使用wc/v3版本
    )

    try:
        # 向 products/reviews 端点发送 POST 请求
        response = wcapi.post("products/reviews", review_data).json()
        return response
    except Exception as e:
        print(f"添加评论时发生错误: {e}")
        return {"error": str(e)}

if __name__ == "__main__":
    # 示例评论数据
    product_id_example = 123 # 替换为实际的产品ID
    random_date = datetime(2023, 5, 15, 10, 30, 0) # 示例日期

    review_payload = {
        "product_id": product_id_example,
        "review": "这是一个很棒的产品，我非常满意！",
        "reviewer": "测试用户",
        "reviewer_email": "test@example.com",
        "rating": 5, # 评分 (1-5)
        "date_created": random_date.isoformat(), # ISO 8601 格式的创建日期
        "verified": True # 是否为验证买家
        # 注意：此处不应直接添加 'meta_data' 字段
    }

    print("尝试添加产品评论...")
    response_data = add_review(URL, CONSUMER_KEY, CONSUMER_SECRET, review_payload)

    if "id" in response_data:
        print(f"评论添加成功！评论ID: {response_data['id']}")
        print(json.dumps(response_data, indent=4, ensure_ascii=False))
    else:
        print("评论添加失败或返回错误信息：")
        print(json.dumps(response_data, indent=4, ensure_ascii=False))

review_data = {
    "product_id": product_id,
    "review": row['review'],
    # ... 其他字段 ...
    "meta_data": [{"key": "cena", "value": row['cena']}] # 此字段将不会被API处理
}