Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

2.10.47 -

  • Consumers optimization: spawn a new messages on Memory limit restart

Implemented mechanism spawn a new messages on Memory limit restart

2.10.46 -

  • Sync SQL optimization: remove unnecessary queries

Added a new "Use pre-check" config - it's responsible for extra sql query we run for the sync process.

2.10.45 -

  • Add indexes to tnw_salesforce_entity_queue

Added indexes to tnw_salesforce_entity_queue table

2.10.44 -

  • Optimization: salesforce_refresh_grids cron job

Set need_refresh_grids to 0 in module configuration to disable cron grid refresh by default arter module installation

2.10.43 -

  • SQL optimization: tnw_salesforce_objects

Changed ORDER BY statement and added indexes for all columns from the sql query. Created PR.

2.10.42 -

  • Individual Cron Group for each cron job

created individual Cron Group for each command to be able enable/disable them individually

2.10.40 -

  • Contact Group must be specified to save the Tiered Price record

Fixed issue with Not Loogged in Customer groupd sync. Reason in entity_id = "0" and straight types of the data for customer group filter existing.

2.10.39 -

  • Dependency Queue issue

Fixed Dependency Queue issue

2.10.38 -

  • Reindex issue: optimize SQL queries

Reindex issue: optimized SQL queries. changed sub-select to the LeftJoins

2.10.37 -

  • Misspelled message \"was skipped, data is Salesforce matches the data in Magento

Fixed message for skipped records

2.10.36 -

  • PricebookEntry stuck in Scheduled status if sync product in bulk mode with archived product

Changed bulk sync logic to avoid stuck records in queue if error occurs

2.10.35 -

  • Adobe Commerce 2.4.6 + PHP 8.2 testing

Added compatibility for Magento 2.4.6 PHP 8.2

2.10.34 -

  • Release a new Marketing module

Corrected composer.json file for a new Marketing module

2.10.33 -

  • Lead Owner does not inherit for Contact after converting

Fixed issue with inheriting Owner from Lead to Contact after converting

2.10.32 -

  • Contact Owner is Default Account Owner for Bulk sync

Fixed Contact Owner synchonization from Sales Rep dropdawn in Bulk mode

2.10.31 -

  • Contact Owner is Default Account Owner

Fixed Contact Owner synchonization from Sales Rep dropdawn

2.10.30 -

  • Send message (RabbitMQ) to sync objects from prequeue after enabling synchronization

Added plugin to publish tnw_salesforce.prequeue.process if module was disabled and enabled with MQ mode as RabbitMQ

2.10.29 -

  • Custom date field values on Product become a day earlier on sync SF-> M2

Fixed issue with date field values on Products synchronization

2.10.28 -

  • Account lookup logic

Implemented new Account lookup logic (Create new Account and Contact for customers with the same First and Last name and different emails)

2.10.27 -

  • Creating new logic for dependency for M-SF sync Phase 2

2.10.25 -

  • Creating new logic for dependency for M-SF sync
    New logic for dependency for M-SF sync created

2.10.24 -

  • Account lookup logic
    Implemented new Account lookup logic (Create new Account and Contact for customers with the same First and Last name and different emails)

2.10.23 -

  • Custom customer attributes not syncing
    Fixed issue wirh custom customer attributes synchronization

2.10.22 -

  • Orders are not being synced

Fixed issue related to the "Lookup" logic:

  • if "multicurrency" feature enabled - the SQL query Lookup was incorrect and loads PricebookEntries for all products.

  • If Person account feature enabled - the SQL query Lookup was incorrect and loads BusinessAccount LookuoByName for all customers.

2.10.21 -

  • The default owner is assigned for account/contact in SF even if Sels rep was changed for customer

Fixed isssue with Sels rep sinchronization after changing on Edit Customer page

  • Customer Sales Rap does not apply for order placed from Frontend

Fixed issue when Customer Sales Rap does not apply for order placed from Frontend

2.10.20 -

Modules performance improvement:

  • fixed collection grouping

  • optimized selection

  • OrderItem sync: skip pricebook condition

  • QuoteItem(AbandonedCartItem) sync: skip pricebook condition

  • B2BQuoteItem sync: skip pricebook condition

Implemented new option "Skip PricebokEntry sync". The related Product wouldn't be added to the sync Queue if they are already synced

  • Resync Frozen doesnt work with Realtime

Resync Frozen queue option values changed to minutes

  • Correct Queue datatime filters

Corrected Queue datetime. Server date is saved in database

  • Check memory usage for consumers

Implemented new option "Memory limit for consumer". This option restart consumer when it exceeds memory limit

2.10.19 -

  • duplicate value found: tnw_mage_basic__Website_ID__c error when edit website

Fixed error duplicate value found: tnw_mage_basic__Website_ID__c when edit Website

2.10.18 -

  • Extra record are added to queue when sync website

Fixed issue with Extra record added to queue when Edit website

2.10.16 -

  • Refactoring: spl_object_id to spl_object_hash

Changed spl_object_id function to the spl_object_hash

2.10.15 -

  • Incorrect product displayed in Opportunity Related tab if the order was synced with deleted product

Fixed issue with incorrect product in Opportunity Related tab if the order was synced with deleted product

2.10.14 -

  • Performance: memory leak

Fixed memory wasting by consumers

2.10.13 -

  • Error in the queue when customer synchronization if 'Default owner' field is empty

Fixed issue when sync customer and 'Default owner' field is empty. Owner will be taken from 'SF login user

2.10.12 -

  • "Before creating a custom price, create a standard price." error appears when create product

Issue fixed . Corrected dependency logic

2.10.11 -

  • Fixed deadlock issue for Magento CE

  • Fixed tier price sync issue for Magento CE

  • Implemented new features: Sync of product Scheduled Updates.

  • implemented new features Automatical restart consumers when Store config (any) updated, Magento website updated, Some mapping updated, Scheduled product updates (id unabled)

2.10.10 -

  • Cabinets module optimization

  • Fixed sync issue for projects with deleted products in database

2.10.8 -

Release performance, part 3:

  • Optimize newsletter subscriber load

  • Group parent queues and preload

  • Optimize method \TNW\Salesforce\Model\Queue::dependenceByCode

  • Optimize load from negotiable repository

  • OptimizeTNW_B2BAddressBookSalesforce module

  • Optimize columns selects on collection method

  • Preload Billing and Shipping addresses for orders and order customers

  • Preload order items

  • Optimize negotiable quote cart repository load

  • Optimize load company from cache in TNW_B2BSforce plugin

  • Optimize Order activate LoadByOrderStatus

Issues Fixed:

  • Customer EAV sub-entity does not sync

Fixed Issue when Customer EAV sub-entity does not sync after creating more that 60 custom attributes and mappings for them

  • MariaDB has the same maximum number of 61 tables in a join as Mysq

Fixed issue with SQL: "Too many tables; MariaDB can only use 61 tables in a join, query"

  • REQUEST_LIMIT_EXCEEDED: TotalRequests Limit exceeded. issues

Corrected error messages, added link to Wiki page about this issue

  • Some records stuck in Salesforce Update Preparation status - issue fixed

2.10.7 -

  • Undefined index - error during the Opportunity sync

Fixed issue : Undefined index - error during the Opportunity sync

2.10.6 -

  • MALFORMED_QUERY: OR tnw_mage_basic__Magento_ID__c ^ ERROR at Row:1:Column:807 expecting a right parentheses, found 'OR'

Fixed issue when sync order after deleting customer

2.10.5 -

  • Call to a member function isStatic

Fixed issue with mapping "fake" or non-existing attributes. Call to a member function isStatic

2.10.4 -

  • OpportunityItemCleanup and TierPriceCleanup stuck in the Queue - Issue fixed

2.10.3 -

Release performance, part 2:

  • ProcessQueue Consumer. Entity loader

  • Prequeue Consumer. Optimize selects which run queue creates

  • Incorrect dependency for Non standard Price book entry

  • Prequeue Consumer . Optimize selects which run queue creates

  • Consumers . Implement clean local cache to classes

  • Prequeue Consumer . Optimize queue create calls.

  • Hide columns when the sync is disabled

  • ProcessQueue Consumer. Load customer attributes (For 2000 customers - 4000 times)

  • ProcessQueue Consumer. Customer address entity select (For 2000 customer - 2000 times)

  • Error Fetching http headers. Incorrect SQL request on Lookup

  • Sub-select on Grid pages

2.10.2 -

  • (Customization) Сhange Opportunity Name

A new field added to the mapping page: "Format value"

2.10.1 -

  • Synchronization does not work on Starter module version

FIxed Issue with consumers on Starter module version

2.10.0 -

Huge performance update:

  • Accelerating the \TNW\Salesforce\Model\ResourceModel\Objects::loadObjectIds Method

  • PreQueue Consumer. Optimize buildDependency method

  • ProcessQueue Consumer. Reducing the number of requests to the database when processing the queue tree

  • Prequeue Consumer . Optimize skip rules for all object types.

  • ProcessQueue Consumer. Append cache to method (for 2000 customer sync called 4000 times)

  • ProcessQueue Consumer. Mapping step working very slow.

  • ProcessQueue Consumer. Create multiple save queues.

  • 'Disable sync' option doesn't' work on the product page in Admin Panel - issue fixed

  • Pricebook entry sync error Required fields are missing: [Product2Id], fields [Product2Id] - issue fixed

  • Serialization failure: 1213 Deadlock found when trying to get lock when Sycn Orders (qty 5400)) - issue fixed

  • Opportunity sync error Required fields are missing: [Name, CloseDate], fields [Name, CloseDate] - issue fixed

2.8.22 -

[Improvements] Cleanup command removes only a few records from the Queue

Improved Cleanup command. Added new options:

  • Items count we delete in the Queue in a batch

  • Algorithm to get cleanup candidates (Multy Query, Left Join Query )

2.8.21 -

  • Implement the consumers restart logic

...