TNW_Salesforce 2.4.4 Module Release Notes

2.10.47 - Aug 8, 2023

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

Implemented mechanism spawn a new messages on Memory limit restart

2.10.46 - Aug 7, 2023

  • 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 - Aug 4, 2023

  • Add indexes to tnw_salesforce_entity_queue

Added indexes to tnw_salesforce_entity_queue table

2.10.44 - Jul 25, 2023

  • 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 - Jul 21, 2023

  • SQL optimization: tnw_salesforce_objects

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

2.10.42 - Jul 20, 2023

  • Individual Cron Group for each cron job

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

2.10.40 - Jul 18, 2023

  • 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 - Jul 14, 2023

  • Dependency Queue issue

Fixed Dependency Queue issue

2.10.38 - Jul 13, 2023

  • Reindex issue: optimize SQL queries

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

2.10.37 - Jul 12, 2023

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

Fixed message for skipped records

2.10.36 - Jun 30, 2023

  • 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 - Jun 21, 2023

  • Adobe Commerce 2.4.6 + PHP 8.2 testing

Added compatibility for Magento 2.4.6 PHP 8.2

2.10.34 - Jun 8, 2023

  • Release a new Marketing module

Corrected composer.json file for a new Marketing module

2.10.33 - May 18, 2023

  • Lead Owner does not inherit for Contact after converting

Fixed issue with inheriting Owner from Lead to Contact after converting

2.10.32 - May 16, 2023

  • Contact Owner is Default Account Owner for Bulk sync

Fixed Contact Owner synchonization from Sales Rep dropdawn in Bulk mode

2.10.31 - May 12, 2023

  • Contact Owner is Default Account Owner

Fixed Contact Owner synchonization from Sales Rep dropdawn

2.10.30 - May 3, 2023

  • 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 - Apr 26, 2023

  • 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 - Apr 26, 2023

  • 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 - Apr 21, 2023

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

2.10.25 - Apr 10, 2023

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

2.10.24 - Apr 7, 2023

  • 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 - Mar 31, 2023

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

2.10.22 - Mar 30, 2023

  • 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 - Mar 8, 2023

  • 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 - Mar 7, 2023

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 - Feb 21, 2023

  • 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 - Feb 17, 2023

  • Extra record are added to queue when sync website

Fixed issue with Extra record added to queue when Edit website

2.10.16 - Feb 14, 2023

  • Refactoring: spl_object_id to spl_object_hash

Changed spl_object_id function to the spl_object_hash

2.10.15 - Feb 7, 2023

  • 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 - Feb 3, 2023

  • Performance: memory leak

Fixed memory wasting by consumers

2.10.13 - Jan 30, 2023

  • 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 - Jan 30, 2023

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

Issue fixed . Corrected dependency logic

2.10.11 - Jan 25, 2023

  • 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 - Jan 23, 2023

  • Cabinets module optimization

  • Fixed sync issue for projects with deleted products in database

2.10.8 - Dec 29, 2022

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 - Dec 15, 2022

  • Undefined index - error during the Opportunity sync

Fixed issue : Undefined index - error during the Opportunity sync

2.10.6 - Dec 15, 2022

  • 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 - Dec 14, 2022

  • Call to a member function isStatic

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

2.10.4 - Dec 12, 2022

  • OpportunityItemCleanup and TierPriceCleanup stuck in the Queue - Issue fixed

2.10.3 - Dec 2, 2022

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 - Nov 21, 2022

  • (Customization) Сhange Opportunity Name

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

2.10.1 - Oct 17, 2022

  • Synchronization does not work on Starter module version

FIxed Issue with consumers on Starter module version

2.10.0 - Oct 11, 2022

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 - Sep 20, 2022

[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 - Sep 5, 2022

  • Implement the consumers restart logic

Implemented the consumers restart logic. Added a new "Restart consumers" button to the "General" config page

2.8.20 - Aug 30, 2022

  • Orders not getting put in queue.

Fixed issue when Orders was not added to the Queue correctly until any of the Customers (or their Orders, Invoices, etc) without a Website are present in Prequeue

2.8.18 - Aug 15, 2022

  • Forbid the B2BQuote sync if the latest version is present

Removed 'Create Opportunity Items for the status' logic. Improved B2BQuote synchronization - Forbid the B2BQuote sync if the latest version is present

2.8.17 - Aug 11, 2022

  • AbandonedCartItem sync issue

Fixed issue when re-sync records related to removed entities

2.8.16 - Aug 2, 2022

  • memory performance

Fixed OOM issue caused by syncing huge products count

2.8.15 - Jul 28, 2022

  • Account duplicates

Fixed issue when Account could be duplicated using Bulk sync mode

2.8.14 - Jul 28, 2022

  • Error during the Account sync

Fixed issue "Account ID: id value of incorrect type"

2.8.13 - Jul 26, 2022

DateTime sync

Fixed issue with date/dateTime fields type synchronization. If Time ones in Magento and SF Org user are the same date/dateTime is identical

2.8.12 - Jul 26, 2022

  • Check the module:disable and module:enable cases for all our modules.

Fixed issue when mapping disappears after disabling modules

2.8.11 - Jul 22, 2022

  • Product prices in Magento and SF do not match in some cases

New mappings options are added for the following entities:
OrderItem
OpportunityItem
B2BOpportunityItem
B2BQuoteItem
Abandoned Cart Item

2.8.8 - Jul 14, 2022

  • Inherit AccountOwner from the Lead Owner

Corrected sync Logic for the Account and PersonAccount objects. Account Owner is Inherited from the Lead Owner

2.8.7 - Jul 12, 2022

  • Additional indexes for tnw_salesforce_entity_queue.

Added additional indexes for tnw_salesforce_entity_queue

2.8.6 - Jul 8, 2022

  • Create events for SF ID save.

Added the following events:

tnw_salesforce_objects_save_before
tnw_salesforce_objects_save_after
tnw_salesforce_objects_delete_before
tnw_salesforce_objects_delete_after

2.8.5 - Jul 7, 2022

  • Sync disable config doesn't take affect to cron jobs

Fixed issue with cron jobs. After disabling module configuration any cron-based work or consumers does not run if the sync is off.

2.8.3 - Jul 5, 2022

  • Error during closing order (Deadlock issue)

Fixed Deadlock issue appears on admin panel.
Now all record first appears in pressure than in the queue

2.8.2 - Jul 5, 2022

  • Issue with site speed and webscale

Improved site speed and webscale

2.8.1 - Jun 29, 2022

  • Error when sync order with Zero Grand Total

Fixed issue when synchronizing order with Zero Grand Total

2.8.0 - Jun 22, 2022

  • Added support of our modules for Magento 2.4.4 and php 8.1

Issues fixed:

  • RabbitMQ synchronization error

  • Tiered product price reverse sync exception

  • Incorrect error message on Contact reverse sync with empty required fields

  • Product entries sync error

  • The guest order does not sync

  • Lead sync error

  • Exception on the Edit order page

  • Exception on General - B2B Features - B2B Quotes (extended) configuration page

  • Error on the Company page

  • Error on Salesforce tab on the Order page

  • Lead link does not remove after conversation

  • Last synchronization date does not match date on PC

  • QuoteItem and OpportunityItem does not sync

  • Order Sync error with deleted product

  • Order Sync error with deleted product (product synced before)

  • B2B Quote - Opportunity sync error

  • Unable to edit b2b quote

  • Discount does not apply on b2b quote at first save

  • B2B quote versionization does not work

  • The product became disabled after reverse sync

  • Opportunity Customer Role drop-down list is truncated

  • Error when creating new Quote from Order

  • The quote could not be created. Please try again later. For a company without sales rep

  • B2B Quote does not sync automatically

  • B2B versionization does not work. Quote created from order

  • Incorrect Invoice Amount for bundle product

  • Bulk sync does not work

  • An exception occurs when using the Quick Order button on the SF side

  • Email for b2b quote does not contain information about the product

  • An exception occurs when trying to change Magento Admin password if the connection to SF is lost