WooCommerce API v3：产品评论自定义元数据处理指南

import csv
import json
import random
from datetime import datetime, timedelta
from woocommerce import API

# 假设这些是预定义或从配置中获取的
URL = "your_woocommerce_store_url"
CONSUMER_KEY = "your_consumer_key"
CONSUMER_SECRET = "your_consumer_secret"

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):
    """从CSV文件读取评论并添加到WooCommerce"""
    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, product_id, 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)

def add_review(url, consumer_key, consumer_secret, product_id, review_data):
    """通过WooCommerce API添加单个评论"""
    wcapi = API(
        url=url,
        consumer_key=consumer_key,
        consumer_secret=consumer_secret,
        version="wc/v3"
    )
    # 注意：product_id在此处仅用于上下文，实际API调用中review_data已包含
    response = wcapi.post("products/reviews", review_data).json()
    return response

# 示例调用（需要替换为实际数据和配置）
# all_products_ids = [10, 20, 30] # 示例产品ID列表
# add_reviews_from_file('your_reviews.csv', all_products_ids)