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

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

# 假设的辅助函数和API配置
# URL, CONSUMER_KEY, CONSUMER_SECRET, all_products, generate_random_date 已定义

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)

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"
    )
    # 调用API创建评论
    response = wcapi.post("products/reviews", review_data).json()
    return response

# 示例调用 (实际使用时需要替换为真实数据)
# add_reviews_from_file('reviews.csv', ['123', '456'], 'https://yourstore.com', 'ck_xxx', 'cs_xxx')