3S Soft Price & Stock Sync for Dropshipzone

Changelog

3.5.1

• SECURITY: Every plugin setting is now validated against its own allowed values instead of one generic text filter, and the sync’s run state can no longer be altered by submitting the settings form.
• FIXED: The sidebar menu and the in-page navigation now always list the screens in the same order, and the navigation fits on one row.

3.5.0

• ADDED: A setup checklist on the dashboard that walks you through connecting your account, setting rules, linking products and running a first sync. It disappears once you are done.
• ADDED: Helpful empty states on Product Mapping and Logs, telling you what to do next instead of showing a blank table.
• ADDED: A dashboard card for Fast Stock Updates showing whether it is on and what it last did.
• CHANGED: The section navigation is now grouped by what you are doing – Setup, Products, Rules, Operations – and the sidebar menu and in-page navigation always agree on order and naming.
• CHANGED: Removed the dark theme toggle. The plugin now always matches the WordPress admin, which is what the mismatched look came from.
• FIXED: Accessibility throughout – screen readers now announce sync progress and notifications, the active section is identified, and dialogs keep keyboard focus.

3.4.1

• FIXED: On hosts where PHP memory is unlimited (the common case), the sync advanced only one product per run and could never finish a large catalogue. The memory check misread an unlimited limit as “almost full”.
• FIXED: Fast stock updates read only the first page of each window, so most stock changes were missed.
• FIXED: Supplier EAN codes are now validated before being written to WooCommerce’s GTIN field – most of the catalogue reports “N/A”, and some values are not valid GTINs.
• FIXED: Products whose supplier brand is filler such as “Does not apply” are no longer filed under that as a brand.

3.4.0

• ADDED: Fast stock updates – an optional pass that asks Dropshipzone which SKUs changed stock since the last check and refreshes only those, instead of re-reading your whole catalogue. Enable it under Sync Control. The full sync keeps running and remains what keeps prices correct.
• ADDED: Supplier EAN and brand now map to WooCommerce’s built-in GTIN field and brands taxonomy where your WooCommerce version provides them.
• ADDED: Auto Import can now filter to on-sale products and to products available for New Zealand.
• FIXED: The In Stock filter in catalogue search was never sent to the API, and the stock filter behind it ran whether or not you selected it, hiding out-of-stock products from every search.
• FIXED: Tracking sync only looked back 14 days and always re-checked the same 100 orders, so slower orders never received tracking. The window is now 90 days and orders rotate.
• CHANGED: The full sync and the fast pass now share one code path, so the two cannot drift apart again.
• REMOVED: Around 570 lines of unreachable duplicate sync code.

3.3.5

• FIXED: Sale prices never started, changed or ended. The scheduled sync returned early when the supplier cost was unchanged, so specials were never applied – and never removed once expired. Sale handling now runs every pass, honours the supplier promotion dates, and clears the sale price when a special ends.
• FIXED: The minimum stock threshold defaulted to 10 in one place and 100 in three others. Unified to 10.
• FIXED: Free Ship, Sale and RRP details in catalogue search read field names that only exist as request parameters, so they never displayed.
• FIXED: Saving new API credentials left the old access token in place until it expired. It is now cleared immediately.
• ADDED: Supplier RRP is stored as product meta during sync.

3.3.4

• FIXED: The sync-completed action was left as dszsync_completed by the prefix rename. It is now dszsync_sync_completed, matching the documented name.
• CHANGED: README rewritten – corrected hook names, removed a link to a deleted file, updated requirements to WordPress 6.2, and documented the upgrade migration.

3.3.3

• CHANGED: Converted the last two product-search queries to the %i identifier placeholder, clearing the final Plugin Check errors.

3.3.2

• CHANGED: Table names in SQL now use the %i identifier placeholder instead of string concatenation, so queries are genuinely prepared rather than annotated as exceptions. Minimum WordPress raised to 6.2, which introduced %i.
• FIXED: Corrected the sniff name in several phpcs annotations, which meant the intended suppressions were never applied.

3.3.1

• FIXED: Escaped two log-summary strings and a permission notice that Plugin Check reported as unescaped output.
• FIXED: Replaced the CSV export stream handling with plain string building, removing direct filesystem calls.
• FIXED: Added missing wp_unslash() before sanitization on several inputs, and moved a translators comment to the line Plugin Check expects.
• FIXED: Documented every direct database call with a specific justification, and annotated read-only admin screen state that needs no nonce.

3.3.0

• COMPAT: Declared support for WordPress 7.0 and WooCommerce 10.9; cleared PHP 8.4+ nullable-parameter deprecation notices.
• CHANGED: Renamed to “3S Soft Price & Stock Sync for Dropshipzone” (slug: 3s-soft-price-stock-sync-for-dropshipzone), matching the name suggested by the review team.
• CHANGED: Widened the code prefix from dsz_ to dszsync_ to meet the four-character minimum, with a one-time migration so existing settings, mappings and schedules carry over.
• CHANGED: Contributors now lists the WordPress.org account that owns the submission.
• SECURITY: The resync handler now sanitizes client-supplied product data before use.
• SECURITY: API password input constrained to a scalar string (never output; encrypted at rest).

3.2.0

• CHANGED: Added a vendor prefix to the plugin name while keeping the trademark in the trailing “for Dropshipzone” position.
• FIXED: Escaped two remaining output paths flagged by Plugin Check (an admin notice class attribute and a translated string containing a link).

3.1.0

• CHANGED: Plugin renamed to “Product Sync for Dropshipzone” (slug: product-sync-for-dropshipzone) so the trademark appears only in the trailing “for Dropshipzone” position, per WordPress.org plugin directory guidelines. The text domain changed to match.
• NEW: External Services disclosure documenting every request sent to the Dropshipzone API and what data it carries.
• SECURITY: Product data posted back from cached catalogue search results is now fully sanitized before import instead of being decoded and used directly.
• FIXED: Removed debug error_log() calls from the database migration routine.
• FIXED: Corrected the Plugin URI, removed an inaccurate claim of official affiliation, and updated stale readme content.

3.0.0

• NEW: Tracking Number Sync. Twice-daily cron pulls tracking numbers and order status from Dropshipzone into WooCommerce orders, with optional auto-complete.
• NEW: Bulk Order Submission. Orders-list bulk action plus a chunked “Submit Pending Orders” tool.
• NEW: Auto-Submit Orders. Optional automatic submission when an order reaches processing.
• NEW: Profit Calculator. Estimated item profit on orders and a margin column on the products list.

2.9.0

• NEW: Advanced Price Rules. Ordered rules matching on category, supplier ID or SKU prefix, overriding the global markup.
• NEW: Supplier cost tracking for profit reporting.
• CHANGED: Unified pricing engine across sync, import and resync paths.

2.8.0

• NEW: Developer Hooks. The documented dsz_calculated_price and dsz_calculated_stock filters and dsz_sync_completed / dsz_price_updated actions now exist across all sync/import paths.
• NEW: Daily Maintenance Cron. Log retention (default 30 days), orphaned mapping cleanup, and expired DSZ transient purging.
• NEW: Supplier Blacklist. Exclude up to 50 supplier IDs from Auto Import (using native API exclude_supplier_ids).
• NEW: Import Filter Templates. Save, apply, and delete named filter presets on the Product Import page.
• NEW: Mappings CSV Export. Export all product mappings from the Product Mapping page.
• CHANGED: Database Indexes. Added composite index on the mapping table (schema v3) for faster sync batch queries.

2.7.0

• NEW: New Zealand shipping support. Added flat-rate shipping for NZ destinations (standard scheme nz key), bypassing AU postcode mapping.
• NEW: Treat $0 Rates as Unavailable. Added an opt-in shipping method setting to use the fallback rate if the API returns a $0 rate for a zone, preventing unintended free shipping.
• NEW: Negative Caching. Added a 5-minute transient back-off cache on API failures (postcode mapping and zone rate requests) to prevent hammering the API during checkouts.
• CHANGED: Batched mapping queries. Refactored cart checking to use a single batched query mapping product/variation IDs to SKUs, improving checkout load times.
• FIXED: Validate and trim AU postcodes (4 digits) before calling the API.
• FIXED: Correctly resolve variation-level mappings using variation IDs before falling back to parent product IDs.

2.6.6

• FIXED: Unified the root folder name inside all ZIP packages to always be dropshipzone to prevent WordPress from deactivating the active plugin with a “Plugin file does not exist” error upon updating.

2.6.5

• FIXED: Fixed a bug in build.ps1 where the generated ZIP package contained the wrong root plugin folder name (dropshipzone instead of dropshipzone-price-stock-sync).

2.6.4

• FIXED: Fixed a bug where a successful “Test Connection” would obtain a token but fail to persist the API email and password.

2.6.3

• NEW: Added an opt-in dark theme toggle in the admin header, persisted via localStorage.

2.6.2

• IMPROVED: Cleaned up admin UI inline styling and refactored components to use class-based CSS utilities.
• FIXED: Excluded the doc directory from the distribution ZIP package.

2.6.1

• FIXED: Fixed .agents directory being included in distribution zip.

2.6.0

• NEW: Batch Auto-Mapping. Auto-map by SKU now processes in batches of 500 with a 20-second time guard, preventing timeouts on large catalogs.
• NEW: Sync Batch Locking. Transient-based lock prevents concurrent sync batches from overlapping.
• NEW: Schema Version Gate. Mapping table migration now checks a stored schema version, avoiding an information_schema query on every page load.
• CHANGED: Credentials encryption now uses per-encryption random IVs instead of a static IV.
• IMPROVED: Refactored admin interface with cleaner layouts and improved JavaScript interactions.
• FIXED: Derived stock availability from stock_qty when API omits in_stock.
• FIXED: Category parsing for hierarchical paths containing commas.
• FIXED: Added secondary ID sort to product mapping queries for deterministic pagination.

2.5.1

• NEW: Allow empty search to browse the full product catalog.
• NEW: Added detailed skip counters for auto import troubleshooting.
• FIXED: Auto import defaults changed to be less restrictive.
• FIXED: Removed API in_stock filter to rely on PHP-side filtering for 0-stock products.
• IMPROVED: Improved product search UI with default in-stock filter.
• IMPROVED: Added cache-busting for realtime metrics display.

2.5.0

• NEW: Auto Product Import – Scheduled automatic import of new products from Dropshipzone API.
• NEW: Configurable filters: New Arrivals, In Stock, Free Shipping, Min Stock Qty (default 100).
• NEW: Auto Import Metrics – Track import runs with 7-day and 30-day statistics.
• NEW: Import history table showing date, imported/skipped/errors, and status.
• IMPROVED: Compact Import Products search bar with inline layout.
• IMPROVED: Added “Auto Import” tab to plugin navigation.

2.4.0

• NEW: Shipping Zones – WooCommerce shipping method using DSZ zone mapping and per-product rates.
• NEW: Supports free shipping threshold, handling fees, and undeliverable zone detection.
• UPDATED: readme.txt and README.md with new features and roadmap.

2.3.2

• FIXED: WordPress.org compatibility – 15 unescaped output issues fixed with esc_attr().

2.3.1

• NEW: Granular resync buttons – Refresh Images, Refresh Categories, or Refresh All Data separately.

2.3.0

• NEW: Scan Unmapped Products – Check WC products against DSZ API, link found products, mark unfound as non-DSZ.
• FIXED: Resync Never Synced button was not working (wrong JavaScript variable name).

2.2.9

• FIXED: Missing return statement in ajax_resync_all() now properly exits after early return.
• FIXED: ajax_resync_never_synced() now batch fetches SKUs (100 at a time) instead of individual API calls.
• FIXED: Added frontend debouncing to prevent overlapping resync operations.
• IMPROVED: Memory limit protection for never-synced resync.
• IMPROVED: Enhanced logging for batch operations.

2.2.8

• ADDED: Resync Never Synced button – bulk resync all never-synced products.
• ADDED: Never Resynced stat box on Product Mapping page.
• FIXED: Improved last_resynced column migration reliability.
• FIXED: Migration now runs on plugin load, not just activation.

2.2.7

• ADDED: Complete API integration – all Dropshipzone endpoints now implemented.
• ADDED: get_categories() – Fetch all DSZ product categories.
• ADDED: get_zone_mapping() – Map postcodes to shipping zones.
• ADDED: get_zone_rates() – Get shipping rates per SKU per zone.

2.2.6

• ADDED: Submit orders to Dropshipzone API for fulfillment.
• ADDED: “Dropshipzone Order” meta box on WC order edit page.
• ADDED: Order tracking database table for DSZ serial numbers.
• ADDED: Australian state code mapping (NSW→New South Wales).
• NOTE: Orders created as “Not Submitted” – login to DSZ to pay.

2.2.5

• ADDED: Last Resynced column on Product Mapping page (tracks full data resync separately from price/stock sync).
• ADDED: Resync filter dropdown (Never, Today, Last 7 Days, Last 30 Days, Older).
• ADDED: Database upgrade to add last_resynced column.

2.2.4

• ADDED: API Load Balancer with smart adaptive delays.
• ADDED: Request statistics tracking (total requests, waits, avg wait time).
• ADDED: Skipped products count in resync completion message.
• IMPROVED: Resync now skips products already inactive (draft + out of stock).
• IMPROVED: API requests processed sequentially for rate limiting.
• IMPROVED: Proactive throttling based on API usage percentage.
• IMPROVED: Minimum 0.5s delay between requests prevents bursting.

2.2.3

• FIXED: In Stock filter now works correctly.
• IMPROVED: Cleaner Product Import page UI.
• IMPROVED: Better quick filter card styling.

2.2.2

• FIXED: Category loading from API now handles different response formats.
• ADDED: Better logging for category API calls.

2.2.1

• NEW: Product badges on import cards (Sale, Free Shipping, New Arrival).
• NEW: Dual price display showing Cost and RRP.
• NEW: Specs display with weight and brand info.
• IMPROVED: Better visual styling for already-imported products.
• IMPROVED: Lazy loading for product images.

2.2.0

• NEW: Auto-Republish on Restock – Draft products automatically republish when stock is restored.
• NEW: Stock Rules setting to enable/disable auto-republish behavior.
• IMPROVED: Logging for republish events.

2.1.2

• IMPROVED: Redesigned Logs page with stats cards and modern list view.
• NEW: Clickable filter cards showing counts by log level.
• NEW: Color-coded log items with collapsible context details.
• NEW: Relative timestamps (e.g., “5 minutes ago”).

2.1.1

• FIXED: “Refresh All Product Data” now batch-fetches from API for faster performance.
• FIXED: Properly updates images, descriptions, prices, stock, and categories.
• ADDED: Memory limit check to prevent server timeouts.
• ADDED: Detailed logging for resync operations.

2.1.0

• NEW: Unified “Sync Center” page – all sync actions in one place.
• NEW: Three action cards: Link Products, Update Prices & Stock, Refresh Product Data.
• IMPROVED: Cleaner Product Mapping page focused on manual mapping.
• IMPROVED: Inline schedule settings on Sync Center page.

2.0.9

• IMPROVED: Clearer sync button labels (“Update Prices & Stock”, “Link Products by SKU”, “Refresh All Product Data”).
• IMPROVED: Better descriptions explaining what each action does.
• IMPROVED: Reorganized Product Mapping page with separate “Link” and “Maintenance” sections.

2.0.8

• IMPROVED: Full WordPress.org plugin repository compatibility.
• IMPROVED: Plugin renamed to “DropshipZone Sync” for clarity.
• ADDED: Languages folder with POT template for translations.
• ADDED: Future roadmap section in README.

2.0.7

• IMPROVED: Modernized Sync Control UI with card-based dashboard.
• IMPROVED: Real-time progress visualization and status indicators.

2.0.6

• ADDED: Auto-deactivation of products not found in the Dropshipzone API.
• IMPROVED: Catalog synchronization accuracy.

2.0.5

• ADDED: Advanced search filters (Category, Stock, Promotion, Free Shipping, New Arrivals)
• ADDED: Sorting by price
• IMPROVED: Search logic using API-native keywords for better accuracy

2.0.4

• IMPROVED: Reordered navigation for better user workflow
• IMPROVED: Import cards now show category, stock status, and description preview
• Changed import icon and label for clarity

2.0.3

• FIXED: Product categories not importing (API uses ‘Category’ field with capital C)
• Categories now create proper hierarchical structure (e.g., “Appliances > Air Conditioners”)
• Added update_categories option to resync functionality

2.0.2

• FIXED: Product descriptions not importing (API uses ‘desc’ field not ‘description’)
• Added debug logging for description import tracking

2.0.1

• NEW: API Rate Limiting – Smart throttling to comply with Dropshipzone API limits (60/min, 600/hour)
• NEW: Auto-Deactivate Products – Products not found in Dropshipzone API are automatically set to Draft
• Added Rate_Limiter class for proactive API throttle management
• Added “Deactivate Missing Products” option in Stock Rules settings
• Improved logging for rate limit and deactivation events

2.0.0

• New Product Import feature: Search and import products directly from Dropshipzone API
• Core Product Importer class for automated product creation and image sideloading
• Dynamic rule application (Price & Stock) during product import
• Automated Product Mapping for all imported items
• Enhanced Admin UI with dedicated Product Import dashboard and grid layout results

1.0.0

• Initial release
• Price sync with percentage/fixed markup
• Stock sync with buffer support
• GST calculation (include/exclude)
• Price rounding options
• Scheduled sync (hourly/twice daily/daily)
• Manual sync with progress indicator
• Batch processing for large catalogs
• Comprehensive logging system
• Modern admin UI