TNW_SForceEnterprise 2.4.4 Module Release Notes

2.10.58 - Aug 8, 2023

  • Sync SQL optimization: improve delete from the Queue dependency

Implemented new "Use extended Queue cleanup logic" option
Old logic ("No" option) - it will delete successful Queue records from the "tail" one-by-one

New logic ("Yes" option) - will delete successful records if it's "child" records are successful too. I.e. could be deleted record from the middle of dependency.

2.10.57 - 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.56 - Aug 2, 2023

  • Performance issue, spikes ~5 min

Added a new conditions, this cron will works only if the both following options enabled:

Refresh grids

Reset Order Sync Statuses

2.10.55 - Jul 21, 2023

CU-86853knw2 - Order sync issue: Call to a member function addData() on null

Fixed order sync issue with virtual products placed as Guest user

2.10.54 - 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.53 - Jul 18, 2023

  • Cron jobs performance

2.10.52 - Jul 18, 2023

  • Individual Cron Group for each cron job

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

2.10.51 - Jul 14, 2023

  • Dependency Queue issue

Fixed Dependency Queue issue

2.10.50 - Jul 13, 2023

  • Reindex issue: optimize SQL queries

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

2.10.49 - Jun 21, 2023

  • Adobe Commerce 2.4.6 + PHP 8.2 testing

Added compatibility for Magento 2.4.6 PHP 8.2

2.10.48 - May 31, 2023

  • Delete/Reset record from the queue

implemented functionality that allows deleting/Reset a record and its dependencies from the queue

2.10.47 - May 30, 2023

  • Sorting by Dependents column on Old From Mangeto grid brokes the page "Attention Something went wrong."

Disabled Sorting by Dependents column on Old From Mangeto grid

2.10.46 - May 25, 2023

  • SF Account and Contact receive incorrect owner from Lead

Fixed issue with inheriting owner from Lead when it was changed on SF side

2.10.45 - May 24, 2023

  • Opportunity owner does not inherit for Lead

Fixed issue with inheriting owner from Lead to Opportunity

2.10.44 - May 2, 2023

  • [Addressbook] Country and State for location Account does not sync

Fixed Country and State synchronization for location Account

2.10.43 - May 1, 2023

  • Product sync stuck in "Scheduled" status if remove product

Fixed isuue with re-sync on new queue grid

2.10.42 - Apr 28, 2023

  • Undefined index: Account

Fixed isuue with Account sync ("Notice: Undefined index: Account in" ) issue could appears if some customer has SalesforceContactId, but doesn't have SalesforceAccountId

2.10.41 - 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.40 - 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.39 - Apr 26, 2023

  • Incorrect status for synced Product

Fixed issue when sync status does not change after clicking on Process link in queue

2.10.38 - Apr 25, 2023

  • Error 'Call to a member function getReservedOrderId() on null' in the queue

Fixed issue with Abandoned Cart sync

2.10.37 - Apr 25, 2023

  • Error 'duplicate value found' in the queue

Fixed issue 'duplicate value found' in the queue with abandoned cart item

2.10.36 - Apr 21, 2023

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

Created new logic for dependency

2.10.35 - Apr 18, 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.34 - Apr 10, 2023

  • [Improvement] Creating new logic for dependency for M-SF sync

New logic for dependency for M-SF sync created

2.10.33 - Apr 5, 2023

  • Reverse synchronization doesn't work, an exception occurs

Fixed issue with reverse synchronization for Magento 246

2.10.32 - Mar 31, 2023

  • Error in Queue during Order and Opportunity reverse sync

Fixed issue with the Opportunity reverse sync on the version 245ce

2.10.31 - 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.30 - Mar 28, 2023

  • Sync does not work for High Volume mode

Fixed issue with sync in Highvolume mode for Magento 246

2.10.29 - Mar 22, 2023

  • Errors during the sync of StockNotification

Fixed issue with the sync of StockNotification

2.10.28 - Mar 22, 2023

  • SF -> M Error in SF Magneto queue when sync Contact without Address

Fixed error in SF Magento queue when sync Contact without some address fields. Error cound be fould in M2 logs

2.10.27 - Mar 9, 2023

  • Error in queue if automatic synchronization is disabled for shipment

Fixed error in queue if automatic synchronization is disabled for shipment

2.10.26 - 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.25 - Feb 17, 2023

  • Show tnwsforce_order/grid_updates config

Added new "Reset Order Sync Statuses" option under "Debug and Logging" section

2.10.24 - Feb 16, 2023

  • Required fields are missing: [Product2Id], fields [Product2Id] error when sync deleted product

Fixed problems with orderItem object if product already deleted before sync. Fixed problems with orderInvoicItem sync with deleted product. Added dependencies from the processing step

2.10.23 - Feb 14, 2023

  • Refactoring: spl_object_id to spl_object_hash

Changed spl_object_id function to the spl_object_hash

2.10.22 - Feb 10, 2023

  • On order edit, old order does not get synced

Fixed sync issue when Edit - Submit new order. Previous Opportunity is synced as Closed won. New SF Oreder and SF Opportunity is create for new Magento order version

2.10.21 - Feb 8, 2023

  • Error during Invoice sync

Fixed issue with synchronization of two and more bundle products

2.10.20 - Jan 31, 2023

  • Accounts are merged when Account names are not equal

Fixed Account merging by "company" name in Customer Billing Address

2.10.19 - 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.18 - Jan 24, 2023

  • Required fields are missing: [OpportunityId], fields [OpportunityId] when sync Order without Opportunity

Fixed issue Required fields are missing: [OpportunityId], when sync completed Order without Opportunity

2.10.17 - Jan 19, 2023

  • Some records stuck in Salesforce Update Preparation status

Fixed issue with recirds which stuck in Salesforce Update Preparation status. Removed batches with state 'Queued' and 'InProgress' from caching

2.10.16 - Jan 10, 2023

  • Error in queue when manually synchronize invoice or shipment

Fixed issue when manually sync Invoice and Shipment (Required fields are missing)

2.10.15 - Jan 4, 2023

  • Error REQUIRED_FIELD_MISSING when re-sync order

Fixed Error REQUIRED_FIELD_MISSING when remove Magento ID mappings and re-sync order

2.10.14 - Dec 29, 2022

  • [Improvement] Skip Opportunity synchronization in Closed - Lost status

After receiving Closed - Lost status Opportunity Stage will not be changed

2.10.13 - 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.12 - Dec 14, 2022

  • SF->M Created SF Invoice does not sync to Magento

Added correct error message when try to sync Invoice without product from SF to Magento

2.10.11 - Dec 13, 2022

  • "Refresh Order Grid" button does not work - Fixed issue

2.10.10 - Dec 13, 2022

  • SF -> M "ERROR. Can not create Invoice\nCannot create an invoice without products." when creating invoice - Issue fixed

2.10.9 - Dec 13, 2022

  • Skip Opportunity synchronization in Closed - Won status

Improved Opportunity synchronization in Closed - Won status. Closed - Won status does not change to Draft status

2.10.8 - 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.7 - Nov 25, 2022

  • Opportunity product does not sync for manually changed opportunity

Fixed issue when Opportunity product does not sync for manually changed opportunity

2.10.6 - Nov 21, 2022

  • (Customization) Сhange Opportunity Name

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

2.10.5 - Nov 14, 2022

  • Error during Accounts merging

  • moved company part to the sforceb2b module

Fixed issue with Accounts merging

2.10.4 - Nov 9, 2022

  • Salesforce Account name is not applied from the Customer address "Company" field

Fixed issue when Account name does not apply from Customer address "Company" field

2.10.3 - Oct 31, 2022

  • Description in Opportunity is missing in SF

added out of the box Description mapping for the :
Order➝ SFOrder
Order ➝ SFOpportunity

2.10.2 - Oct 20, 2022

  • Shipment sync issue INVALID_QUERY_FILTER_OPERATOR

FIxed issue with reverse shipping synchronization (Changing status in Magento, INVALID_QUERY_FILTER_OPERATOR:)

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.32 - Oct 7, 2022

  • Shipment sync: Opportunity field sometimes not populating

Added Shipment and Invoice dependencies with Magento order

2.8.31 - Oct 6, 2022

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

Opportunity sync dependencies fixed

2.8.30 - 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.29 - Sep 2, 2022

  • From Magento Queues does not show records for some Statuses.

Added mew column "Composite status" on "From Magento Stat" page

2.8.28 - Sep 1, 2022

  • Incorrect Abandoned Cart Opportunity Amount for bundle product.

Fixed bundle product amount calculation for Abandoned Cart Opportunity

2.8.27 - Sep 1, 2022

  • Opportunity product does not sync for manually changed opportunity.

Fixed issue when Opportunity product does not sync for manually changed opportunity

2.8.26 - Sep 1, 2022

  • Pagination does not work on Magento Stat page.

Fixed Pagination on Magento Stat page

2.8.25 - Sep 1, 2022

  • Change "Synchronize Notes" options label and description.

Changed "Synchronize Notes" options label and description

2.8.24 - Aug 31, 2022

  • Salesforce Invoice description show incorrect price from items.

Fixed issue with Salesforce Invoice description show incorrect price from items

2.8.23 - Aug 31, 2022

  • Some shipment options are not hidden when disabling Shipment Synchronization.

Fixed issue with some shipment options are not hidden when disable Shipment Synchronization

2.8.22 - Aug 31, 2022

  • Salesforce Magento Shipment has incorrect description.

Fixed Salesforce Magento Shipment description

2.8.21 - Aug 19, 2022

  • Error in queue: Required fields are missing, when syncing invoice

Fixed Error in queue: Required fields are missing, when syncing invoice

2.8.20 - Aug 18, 2022

  • Order 'purchase date' changed to one day ago after reverse sync.

Fixed issue when Order 'purchase date' changed to one day ago after reverse sync

2.8.19 - 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.18 - Aug 11, 2022

  • AbandonedCartItem sync issue

Fixed issue when re-sync records related to removed entities

2.8.17 - Aug 2, 2022

  • memory performance

Fixed OOM issue caused by syncing huge products count

2.8.16 - 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.15 - 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.14 - 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.13 - 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.12 - Jul 14, 2022

  • Exception appears after saving mapping

Fixed Exception which appears after saving mapping and expired session

2.8.11 - Jul 13, 2022

  • Never delete converted Leads

"Delete converted Leads" option removed

2.8.10 - Jul 12, 2022

  • Additional indexes for tnw_salesforce_entity_queue.

Added additional indexes for tnw_salesforce_entity_queue

2.8.9 - Jul 11, 2022

  • Order sync does not work for guest customer

Fixed issue with synchronization Sales Rep for Guest order

2.8.8 - Jul 8, 2022

  • Shipment Item mapping: SF Product ID not available

Added ability map here next properties for Shipment item: Product attributes, Order item fields, Shipment fields

Added ability map here next properties for invoice item: Product attributes, Order item fields, Invoice fields

2.8.7 - 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.6 - 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.5 - 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.4 - Jul 5, 2022

  • Issue with site speed and webscale

Improved site speed and webscale

2.8.3 - Jul 5, 2022

  • Completed records are not cleared from the queue table

Fixed issue with cleaning records from the queue table

2.8.2 - Jun 29, 2022

  • Error when sync order with Zero Grand Total

Fixed issue when synchronizing order with Zero Grand Total

2.8.1 - Jun 27, 2022

  • Modifying products via M2 import file does not put records in queue

Fixed issue when imported file with products does not put records in queue

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