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

import csv
import json
import random
from datetime import datetime, timedelta
from woocommerce import API # 假设已安装 woocommerce-rest-api-python 库

# 辅助函数：生成随机日期
def generate_random_date(start_date, end_date):
    time_delta = end_date - start_date
    random_days = random.randint(0, time_delta.days)
    return start_date + timedelta(days=random_days)

# 核心功能：从文件添加评论
def add_reviews_from_file(filename, all_products, url, consumer_key, consumer_secret):
    product_reviews = {}
    with open(filename, 'r', encoding='utf-8') as file:
        reader = csv.DictReader(file)
        for row in reader:
            product_id = row['product_id'] if row['product_id'] else random.choice(all_products)
            random_date = generate_random_date(datetime(2021, 1, 1), datetime(2023, 12, 31))
            review_data = {
                "product_id": product_id,
                "review": row['review'],
                "reviewer": row['reviewer'],
                "reviewer_email": row['reviewer_email'],
                "rating": int(row['rating']),
                "date_created": random_date.isoformat(),
                "verified": 1,
                "meta_data": [{"key": "cena", "value": row['cena']}] # 尝试添加自定义元数据
            }

            response = add_review(url, consumer_key, consumer_secret, review_data)

            if product_id not in product_reviews:
                product_reviews[product_id] = []
            product_reviews[product_id].append(response)

    with open('review/response.json', 'w', encoding='utf-8') as outfile:
        json.dump(product_reviews, outfile, indent=4)

# 调用 WooCommerce API 添加评论
def add_review(url, consumer_key, consumer_secret, review_data):
    wcapi = API(
        url=url,
        consumer_key=consumer_key,
        consumer_secret=consumer_secret,
        version="wc/v3"
    )
    response = wcapi.post("products/reviews", review_data).json()
    return response

# 示例调用 (需要替换为实际的 URL, KEY, SECRET 和产品列表)
# URL = "http://example.com"
# CONSUMER_KEY = "ck_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
# CONSUMER_SECRET = "cs_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
# ALL_PRODUCTS_IDS = [10, 20, 30] # 示例产品ID列表
# add_reviews_from_file('reviews.csv', ALL_PRODUCTS_IDS, URL, CONSUMER_KEY, CONSUMER_SECRET)

            review_data = {
                "product_id": product_id,
                "review": row['review'],
                "reviewer": row['reviewer'],
                "reviewer_email": row['reviewer_email'],
                "rating": int(row['rating']),
                "date_created": random_date.isoformat(),
                "verified": 1,
                # "meta_data": [{"key": "cena", "value": row['cena']}] # 此行应移除或注释掉
            }