WP-Lister for Amazon Version 2.7.6 – April 1st, 2025

Bug Fixes

Database Encoding Issue for International Merchants

• Problem: French and other international merchants experienced database errors when processing Amazon feed results, with messages stating “Processing the value of the results field failed. The provided value may be too large or contain invalid data.” Products remained stuck in “Submitted” status.
• Impact: Prevented merchants selling in EU marketplaces with non-English characters from successfully listing products on Amazon.
• Solution: Replaced deprecated utf8_encode() function with mb_convert_encoding() to properly handle international characters and special symbols in feed responses from Amazon.
• (Ticket #69806)

UTF8 Conversion Tool Crash

• Problem: Running the “Convert tables to utf8mb4” tool on the Tools > Developer page resulted in a fatal error: “Object of class stdClass could not be converted to string.”
• Impact: Merchants unable to upgrade their database to support extended character sets, which is necessary for handling emoji and international characters.
• Solution: Fixed error handling in the database conversion utility to properly process database table structures.
• (Ticket #69978)

Duplicate Stock Log Entries

• Problem: WooCommerce’s stock logging feature recorded duplicate entries when Amazon orders were imported, showing inventory being reduced twice for the same order.
• Impact: Confusing stock logs and potential inventory tracking issues for merchants monitoring stock changes.
• Solution: Prevented wc_update_product_stock() from being called twice with the same stock quantity during order import.
• (Ticket #70031)

Amazon Report API Error Handling

• Problem: When Amazon’s SP API returned errors during report generation or retrieval, the plugin did not properly check for or display these errors, leading to silent failures.
• Impact: Merchants might see “Report requested successfully” messages even when reports failed to generate, causing confusion about why data wasn’t importing.
• Solution: Added comprehensive error checking for getReport() API calls across all report pages (Import, Reports, and background processes), with clear error messages displayed to users.

Improvements

Ireland Marketplace Support

• Enhancement: Added missing Marketplace ID (A28R8C7NBKEWEA) for Amazon.ie (Ireland) to the endpoint configuration.
• Impact: Merchants selling on Amazon Ireland can now properly connect and manage their listings through the plugin.

Technical Changes

• Improved character encoding compatibility across all EU marketplaces
• Enhanced error reporting for Amazon SP API operations
• Updated marketplace endpoint mappings for complete EU coverage