Drupal 7集成MailChimp遇故障：弃购邮件等功能异常求助

Hey there, let's work through these MailChimp integration hiccups with your Drupal 7 site—you’ve already nailed a solid chunk of the functionality, so nice work getting that far! Let’s break down each unresolved issue and how to fix them:

1. Getting Abandoned Cart Campaigns to Send #

Abandoned cart flows rely on tight sync between Drupal’s cart events and MailChimp’s tracking. Here’s what to check:

• Verify MailChimp Campaign Setup: Head to your MailChimp account’s Automations > E-commerce section, make sure your abandoned cart campaign is enabled for your linked store, and the trigger (e.g., "1 hour after cart creation without checkout") is set correctly.
• Hook Into Drupal’s Cart Events: Use Drupal Commerce hooks to sync cart updates to MailChimp in real-time:
  • When a user adds items to their cart, fire a POST to usX.api.mailchimp.com/3.0/ecommerce/stores/{store_id}/carts with the cart ID, user’s email (critical for linking to a subscriber), and line items.
  • When an order completes, send a PATCH to the same cart endpoint to mark it as completed (set abandoned: false and populate the order_id field)—this tells MailChimp not to trigger an abandoned cart email for that cart.
• Handle Anonymous Users: For guests, you’ll need to capture their email during checkout and retroactively update the corresponding MailChimp cart record with that email. Use hooks like commerce_checkout_form_submit to trigger this update.

2. Displaying Product Info in E-commerce Emails #

MailChimp needs fully structured product data to render items in emails—here’s how to make sure that data is flowing correctly:

• Sync Complete Line Item Data: When sending order/cart data to MailChimp, ensure your line_items array includes all required fields. Here’s a quick Drupal Commerce code snippet to pull that data:

  $line_items = [];
  foreach ($order_wrapper->commerce_line_items as $line_item_wrapper) {
    $product = $line_item_wrapper->commerce_product->value();
    // Pull product image URL (adjust field name if your product uses a different image field)
    $image_uri = $product->field_product_image[LANGUAGE_NONE][0]['uri'] ?? '';
    $image_url = $image_uri ? file_create_url($image_uri) : '';
  
    $line_items[] = [
      'id' => (string) $line_item_wrapper->line_item_id->value(),
      'product_id' => $product->sku,
      'product_title' => $product->title,
      'product_url' => url('node/' . $product->nid, ['absolute' => TRUE]),
      'image_url' => $image_url,
      'quantity' => (int) $line_item_wrapper->quantity->value(),
      'price' => [
        'currency_code' => 'USD', // Match your store's currency
        'value' => $line_item_wrapper->commerce_unit_price->amount->value() / 100,
      ],
    ];
  }
  

• Use MailChimp’s E-commerce Merge Tags: In your email template, replace static content with MailChimp’s dynamic tags for product data, like:
  • *|ECOMMERCE_ITEMS:PRODUCT_TITLE|* for the product name
  • *|ECOMMERCE_ITEMS:IMAGE_URL|* for the product image
  • *|ECOMMERCE_ITEMS:PRODUCT_URL|* for the product link
    Start with MailChimp’s pre-built e-commerce templates to ensure these tags are properly configured.

3. Keeping Cart Data Sync Stable (Post Soft Reset) #

Since deleting cart data fixed the initial sync issue, the problem likely stemmed from malformed or orphaned cart records. To prevent this from recurring:

• Add Data Validation: Before sending any cart data to MailChimp, validate that critical fields (email, line items, price values) are present and formatted correctly. For example, check that the email is a valid format and line item quantities are positive integers.
• Log API Requests/Responses: Use Drupal’s watchdog() function to log every MailChimp API call, including the request body and response status. This will help you debug sync failures quickly:

  $response = drupal_http_request($mailchimp_api_url, [
    'method' => 'POST',
    'headers' => ['Authorization' => 'apikey ' . $api_key],
    'data' => json_encode($cart_data),
  ]);
  watchdog('mailchimp_sync', 'Cart sync response: @status - @body', [
    '@status' => $response->code,
    '@body' => $response->data,
  ], WATCHDOG_INFO);
  

• Sync Cart Updates: Don’t just send cart data once—hook into commerce_cart_update to trigger a PATCH request to MailChimp whenever the user modifies their cart (adds/removes items, updates quantity). This keeps MailChimp’s cart record in sync with Drupal’s.

If you run into specific errors (like API error codes) or need help with a particular hook implementation, feel free to share more details!

内容的提问来源于stack exchange，提问作者yasaranilsansak