TNW_SForceEnterprise Module Release Notes

2.9.55 - 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.8.54 - Aug 8, 2023

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

Implemented mechanism spawn a new messages on Memory limit restart

2.9.53 - 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.9.52 - 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.9.51 - 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.9.50 - Jul 18, 2023

• Cron jobs performance

2.9.49 - 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.9.48 - Jul 14, 2023

• Dependency Queue issue

Fixed Dependency Queue issue

2.9.47 - Jul 13, 2023

• Reindex issue: optimize SQL queries

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

2.9.46 - May 31, 2023

• Delete/Reset record from the queue

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

2.9.45 - 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.9.44 - 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.9.43 - May 24, 2023

• Opportunity owner does not inherit for Lead

Fixed issue with inheriting owner from Lead to Opportunity

2.9.42 - May 2, 2023

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

Fixed Country and State synchronization for location Account

2.9.41 - May 1, 2023

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

Fixed isuue with re-sync on new queue grid

2.9.40 - 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.9.39 - 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.9.38 - 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.9.37 - Apr 26, 2023

• Incorrect status for synced Product

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

2.9.36 - Apr 25, 2023

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

Fixed issue with Abandoned Cart sync

2.9.35 - Apr 25, 2023

• Error 'duplicate value found' in the queue

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

2.9.34 - Apr 21, 2023

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

Created new logic for dependency

2.9.33 - 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.9.31 - Mar 31, 2023

• Error in Queue during Order and Opportunity reverse sync

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

2.9.30 - 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.9.29 - Mar 22, 2023

• Errors during the sync of StockNotification
  Fixed issue with the sync of StockNotification

2.9.28 - Mar 22, 2023

• SF -> M Error in SF Magneto queue when sync Contact without address
  Fixed error in queue if sync Contact without address SF -> M

2.9.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.9.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.9.25 - Feb 17, 2023

• Show tnwsforce_order/grid_updates config

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

2.9.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.9.23 - Feb 14, 2023

• Refactoring: spl_object_id to spl_object_hash

Changed spl_object_id function to the spl_object_hash

2.9.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.9.21 - Feb 8, 2023

• Error during Invoice sync

Fixed issue with synchronization of two and more bundle products

2.9.20 - Jan 31, 2023

• Accounts are merged when Account names are not equal

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

2.9.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.9.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.9.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.9.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.9.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.9.14 - Dec 29, 2022

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

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

2.9.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.9.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.9.11 - Dec 13, 2022

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

2.9.10 - Dec 13, 2022

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

2.9.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.9.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.9.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.9.6 - Nov 21, 2022

• (Customization) Сhange Opportunity Name

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

2.9.5 - Nov 14, 2022

• Error during Accounts merging

• moved company part to the sforceb2b module

Fixed issue with Accounts merging

2.9.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.9.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.9.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.9.1 - Oct 17, 2022

• Synchronization does not work on Starter module version

FIxed Issue with consumers on Starter module version

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

• Shipment sync: Opportunity field sometimes not populating

Added Shipment and Invoice dependencies with Magento order

2.7.206 - Oct 6, 2022

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

Opportunity sync dependencies fixed

2.7.205 - Oct 5, 2022

• A new products form issue with some php settings

2.7.204 - 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.7.203 - Sep 2, 2022

• Check module re-install process.

Improved uninstall script. Added our tables/columns delete logic

2.7.202 - Sep 2, 2022

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

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

2.7.201 - Sep 1, 2022

• Incorrect Abandoned Cart Opportunity Amount for bundle product.

Fixed bundle product amount calculation for Abandoned Cart Opportunity

2.7.200 - 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.7.199 - Sep 1, 2022

• Pagination does not work on Magento Stat page.

Fixed Pagination on Magento Stat page

2.7.198 - Sep 1, 2022

• Change "Synchronize Notes" options label and description.

Changed "Synchronize Notes" options label and description

2.7.197 - Aug 31, 2022

• Salesforce Invoice description show incorrect price from items.

Fixed issue with Salesforce Invoice description show incorrect price from items

2.7.196 - 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.7.195 - Aug 31, 2022

• Salesforce Magento Shipment has incorrect description.

Fixed Salesforce Magento Shipment description

2.7.194 - Aug 26, 2022

• Update file copyrights/strict_types

Added the strict_types declaration to all files

2.7.193 - 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.7.192 - Aug 11, 2022

• AbandonedCartItem sync issue

Fixed issue when re-sync records related to removed entities

2.7.191 - Aug 2, 2022

• memory performance

Fixed OOM issue caused by syncing huge products count

2.7.190 - 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.7.189 - Jul 26, 2022

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

Fixed issue when mapping disappears after disabling modules

2.7.188 - Jul 20, 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.7.187 - 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.7.185 - Jul 14, 2022

• Exception appears after saving mapping

Fixed Exception which appears after saving mapping and expired session

2.7.185 - Jul 13, 2022

• Never delete converted Leads

"Delete converted Leads" option removed

2.7.184 - Jul 12, 2022

• Additional indexes for tnw_salesforce_entity_queue.

Added additional indexes for tnw_salesforce_entity_queue

2.7.183 - Jul 11, 2022

• Order sync does not work for guest customer

Fixed issue with synchronization Sales Rep for Guest order

2.7.182 - 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.7.181 - 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.7.180 - 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.7.179 - Jul 1, 2022

• Completed records are not cleared from the queue table.

Fixed issue with cleaning records from the queue table

2.7.178 - Jul 1, 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.7.177 - Jul 1, 2022

• Issue with site speed and webscale.

Improved site speed and webscale

2.7.176 - Jun 24, 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.7.174 - Jun 22, 2022

• Queue resync automation

Created a new cron job, for resetting sync status for the records stuck in non-complete status.

2.7.173 - Jun 20, 2022

• Error during installation.

Fixed issue with modules installation ( bin/magento setup:install)

2.7.172 - Jun 20, 2022

• Invoice Amount does not reflect Tax and Shipping costs

Fixed issue that Invoice Amount does not reflect Tax and Shipping costs. A new SF Invoice package is available with new fields (Sub Total, Tax, Shipping, Discount Amount, Total). Added the default system mappings for the following SF Invoice fields: tnw_invoice_Subtotal__c, tnw_invoice__Discount__c, tnw_invoice__Shipping__c, tnw_invoice__Tax__c, tnw_invoice__Grand_Total__c

2.7.171 - Jun 17, 2022

• Slow Queries

Request speed has been increased. Added indexes to speedup sql requests. Improved filtering by status

2.7.170 - Jun 15, 2022

• Incorrect Invoice Amount for bundle product

Fixed Issue with Incorrect Invoice Amount for bundle product

2.7.169 - Jun 15, 2022

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

Fixed exception when trying to change Magento Admin password if connection to SF is lost (wrong/expired password)

2.7.168 - Jun 14, 2022

• Stop the synchronization of the notes

Implemented new functionality: Added "Synchronize Notes" (Yes/No state) option. This option allows to Turn On/Off synchronization of Notes for Invoice and Shipment

2.7.167 - Jun 13, 2022

• "Advanced" - "Create Opportunity" option has an incorrect description

Added correct description for "Create Order" and "Create Opportunity" options

2.7.166 - Jun 9, 2022

• Incorrect Order sync status on Edit order page

Issue with Incorrect Order sync status on Edit order page Fixed
Issue appeared when "Create Opportunity" Option is set to "No"

2.7.165 - May 30, 2022

• Upgrade modules on Prod

Fixed issue with rewriting Pricebook id's from the removed product in case if Order_item id and existing product id was the same.

2.7.164 - May 20, 2022

"Pending Refresh" Order Grid issue

Fixed issue with incorrect statuses on Order grid after clicking "Refresh Order Grid" button

2.7.163

• Fix Order synchronization error when Product is deleted (name case). - Issue fixed

2.7.162

• Error code in the sync Queue

Added new column “Error code“ on “From Magento“, “From Magento (old)“, “From Magento Stat“ pages

2.7.161

• Fix Order synchronization error when Product is deleted. - Issue fixed

2.7.160

• Correct Upset/Insert column on the SFOrder/Opportunity Status mapping pages

SFOrder/Opportunity/Return/B2BQuote Status mappings removed Upset/Insert states. Now Status mappings could be set in Enable/Disable states only

2.7.159

• Guest order from the second website is synced if only Default (General) group is allowed for this website - Issue fixed

2.7.158

• Dependency for every Queue record

Added ability to Build Graph for Dependency for every Queue record Not only for whole page

2.7.157

• Sync Order Status become red exclamation mark when click 'Save and Sync Order' button - Issue fixed

2.7.156

• SF -> Magento Account sync - change to existing Company Administrator (exception) - Execption message fixed to correct error message

2.7.155

• Error during sync of customers. 'SOAP-ERROR: Encoding: object has no 'leadId' property' - Issue fixed

2.7.154

• inappropriate error message appears when try to change Website for System mapping - Issue fixed

2.7.153

• SF Opportunity does not receive "Converted Opportunity Status" status - Issue fixed

2.7.152

• All options are hidden when "Automated Synchronization" for "Customers" is set to "No" - issue fixed

2.7.151

• Manually changed opportunity link does not sync with Salesforce - Issue fixed

2.7.150

• Shopping Cart - Configurable Products option description has misspelled words - Issue fixed

2.7.149

• Filter does not work for "Synchronization attempt count" columns in "From Magento Stat" grid . "Attention Something went wrong." message appears - Issue fixed

2.7.148

• Need to move 'Manage Mappings' item on SF Side bar form 'Modules' to 'Tools' section - Issue fixed

2.7.147

• 'Leverage Salesforce Leads' option has incorrect description - Issue fixed

2.7.146

• There is Misspelled word in 'Convert Opportunity' option description - Issue fixed

2.7.145

• Salesforce - Field Mappings - Product grid has incorrect name 'Mapping List: Product2 - Issue fixed

2.7.144

• Opportunity Status mapping and Order Status mapping does not have check on "Active" state - Issue fixed

2.7.143

• "Standard" Lead Assignment Rule is duplicated in "Lead Assignment Rule" drop-down list - issue fixed

2.7.142

• Add 'Default Owner' dropdown for Abandoned Card configuration

Implemented new functionality:

'Default Owner' dropdown is be added to the Salesforce - Abandoned Cart configuration to determine which Owner should be used on Salesforce Opportunity page

2.7.141

• 'Lead Assignment Rule' option does not take effect - issue fixed

2.7.140

• Error on modules config page. An error has happened during application run. See exception log for details.

Fixed exception on modules configuration pages. The issue appears when try to open config pages and Salesforce password was expired or incorrect

2.7.139

• Salesforce issue: composite status

Fixed issue during the installation of Salesforce Started version from Marketplace.

2.7.138

• Closed Opportunity Date is equal to sync date

2.7.137

• Cannot sync contact with Magento

Added Account mapping processing for the reverse sync: SF➝M

2.7.136

• Sync from M to SF starting immediately after syncing from SF to M containing empty values - Issue fixed

2.7.135

• Products bulk synced From Salesforce to Magento don't sync IDs. - Issue fixed

2.7.134

• Use Invoice date as close date" - "No" option does not work - Issue fixed

2.7.133

• Salesforce - Configuration - Orders - "Update Order Info (Yes/No)" option does not take any effect

option was removed

2.7.132

• Issue: Please select Order Product for selected Order, fields [tnw_shipment__Order_Item__c]

added shipping synchronization to queue as child of invoice synchronization queue.

2.7.131

• Salesforce "Email Opt Out" checkbox is always unmarked - Issue fixed

2.7.129

• customer Lead Error 'Required fields are missing: [Company], fields [Company]'

Added trim "spaces" in Company name field - > Customer address if company name is empty

2.7.128

• Products bulk synced From Salesforce to Magento don't sync IDs. - Issue fixed

2.7.127

• All Price book Id are doubled when create tier price - Issue fixed

2.7.126

• Mapping settings 'Website' drop-down list should be hidden

“Website' drop-down hidden on edit mapping page

2.7.124

• Add pricebook validation

Implemented new functionality:

Possible to assign only a unique pricebook for each Website. Added validation for that.

Skip Order/Opportunity/PricebookEntry sync if the related website pricebook is not defined

Added warning message if the related website pricebook is not defined

2.7.123

• 'Salesforce Pricebook ID' link is missing in Salesforce tab on Product edit page - Issue fixed

2.7.122

"duplicate value found: tnw_mage_basic__Magento_ID__c" error when sync archived product

Added correct error in “From Magento“ queue with a link on an article about archived product

https://technweb.atlassian.net/wiki/spaces/IWS/pages/3240394753

2.7.121

• Magento customer account information will be synchronized with Salesforce when 'Disable sync' option is set to 'Yes' - Issue fixed

2.7.120

• Lead id will be created for Newsletter subscriptions even if 'Leverage Salesforce Leads' is set to No - Issue fixed

2.7.119

• Create sql patch to change for Magento to SF

When TNW_SForceEnterprise module is installed "owner" mappings are “insert Only'
When TNW_SForceB2B module is installed all "owner" mappings are changed to “Upsert”

2.7.118

Incorrect link for 'Salesforce Product ID' on product page - Issue fixed

2.7.117

• Implement functionality of updating if values in the FROM platform are NULL

Implemented new functionality:

Added a new configuration setting at a field mapping level
Name: “Skip blank values” values (Yes/No)

2.7.116

• "Delete converted Lead"=> "Yes" option does not remove "Salesforce Lead Id" link from customer page - Issue fixed

2.7.115

• "Enable Contact Roles" - "No" option does not work for Orders - Issue fixed

2.7.114

• New configuration setting for disabling tracking numbers sync

Implemented new functionality:

added new setting Salesforce - Shipments - "Enable tracking numbers Synchronization" - values Yes/No

2.7.113

• Orders with Zero Grand Total are always synchronized - Issue fixed

2.7.112

• Abandoned Cart mappings are hidden

Fixed issue when Abandoned Cart mapping becomes hidden after disabling “Create Opportunity” option

2.7.111

• Website column on Abandoned Carts grid

Added “Website“ column on Sales - Abandoned Carts grid

2.7.110

• Newsletter Subscribers will be Synchronized for guest user when 'For registered customers only' option is selected - Issue fixed

2.7.109

• Newsletter Subscription does not create new Salesforce Contact if qty of registered customers in Magento is less than qty of created Subscriptions - Issue fixed

2.7.108

• Abandoned Cart does not sync automatically in Bulk mode - Issue fixed

2.7.107

• New products synchronizing only with one pricebook and this pricebook is wrong - Issue fixed

2.7.106

Tracking numbers are not synced in Bulk mode queue - Issue fixed

2.7.105

• 'Synchronize Salesforce' button does not work on 'Currency rates' page - Issue fixed

2.7.104

• Abandoned carts mass action sync issue - Issue fixed for Magento CE version

AR: SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'where clause', query was: SELECT main_table.entity_id FROM quote AS main_table WHERE (`` IN('136818'))

2.7.103

• "NOT LOGGED IN" customer group is missing in Sync All Groups - Customer group list - Issue fixed

2.7.102

• Default Owner option for Customer account does not take effect - Issue fixed

2.7.101

• Error in Staging related to powersync - Issue fixed

Clients mapping will be added to “Fields mappings extra“ menu

2.7.100

• 'Create deleted products in Salesforce (Yes/No)' option does not take any effect

The “Create deleted products in Salesforce” option was removed

2.7.99

• Opportunity status does not change to "Closed - Won" when order was paid. Status is "Committed" - issue fixed

2.7.98

• Customers from not selected customer groups are synchronized - issue fixed

2.7.97

• Error during order sync from second website

Fixed error when synchronizing an order from the second website with a product that belongs to both websites

2.7.96

• "Lead Source" value does not update - issue fixed

2.7.95

• Exception appears when visit Magento admin users page

Fixed error when visiting All Users page in admin panel when integration is disabled

2.7.94

• Leads Default Owner option has incorrect description - issue fixed

2.7.93

• Move mappings from the menu to the own page

All the mappings are moved to the Manage Mappings page which is in the Configuration section. All “mapping links” are removed from all other menus (eg. sales, products, etc)

2.7.92

• PricebookEntry custom field not syncing

Fixed issue with synchronizing of Pricebook Entry custom field

2.7.91

• Consumer produce error in system.log

Fixed issue with an error when Data Sync Volume is set to "High Volume"

2.7.90

• Customer sync with error 'duplicate value found: tnw_mage_basic__Magento_ID__c duplicates value on record with id:'

An error occurred in sync queue after syncing with Salesforce when creating a Lead first in Salesforce and then on Magento Frontend

2.7.88

• Exception appears when create or update mapping - issue fixed

2.7.87

• Error "pricebook entry is in a different pricebook" in queue when create order from second website.

2.7.86

• Wrong Currency Code on Abandoned Carts page - issue fixed

2.7.85

• Empty menu item is present in "Abandoned Cart Status" and "Default Opportunity Draft Status" drop-down lists

Removed empty menu item from “Opportunity Stage Name“ drop-down lists for Abandoned Cart, Default Opportunity Draft Status (Orders), Default Opportunity Status (B2B quote)

2.7.84

• Salesforce ID and Sync with Salesforce button are missing on Shopping Cart tab - Issue fixed

2.7.83

• Separate consumer for the Bulk check result. Added new consumers to separate Bulk queue

2.7.82

• Create & expose new mappings - Added some custom mappings

2.7.81

• Improvement Country/State Code sync

2.7.80

• Custom QuoteItem (Abandoned cart item) mapping does not work - Fixed mapping from Magento Attribute “Quote item: <items>”

2.7.79

• Custom OpportunityLineItem mapping does not work - Fixed mapping from Magento Attribute “Product: <items>”

2.7.78

• Tracking Number is removed automatically when Automatic Shipment Synchronization is disabled - Issue fixed

2.7.77

• Shipment Item sync error: Missing value for required field(s): Order

Fixed issue with synchronization of Shipment Item (RMA items) in case turned off Order synchronization (Salesforce - Orders - Advanced - Create Order - No)

2.7.75

• Wrong created_in field value on sync (SF -> Magento), created_in field cannot be mapped

Added reverse sync for next fields:

1. created_in with the "Created From" label

2. store_id with the "Create In" label

2.7.74

• Required fields are missing [Product2id]" error when sync order with deleted product - Issue fixed

2.7.73

• Change Get to POST on the Queue page.

POST requests are changed to GET on the “From Magento queue“ page

2.7.72

• Country/State "-" symbol issue.

Non-alphabetic and non-numeric symbols are trimmed from Stare code when sync with Salesforce

2.7.71

• Standard pricebook is not updated correctly.

Implemented new logic: When a product is synchronized we only create new Standard Pricebook entries if do not exist. But not modify/Update them.

2.7.70

• Opportunity sync errors - made some improvements

2.7.69

• Abandoned Carts grid does not open on Magento CE version - Issue fixed

2.7.68

• Upgrade Integration

Fixed issues with tier prices synchronization (multiple websites and currencies)

• SF Order and opportunity subtotal has an incorrect value in case of "Which currency should be used - Base store currency" option"

Fixed issue when SF Order and opportunity subtotal received value from the currency selected by the customer instead of base store currency

2.7.67

• Configurable products issue 

Fixed issue with reverse synchronization of Configurable products. (Child products become visible on Frontnend, Parent product become out-of-stock and lost all child products)

2.7.66

• Tier prices are not synchronized.

Fixed issue Tier prices are not synchronized. "Magento Website: id value of incorrect type: a025f000004ntz7..."

• Error with Invoice and Shipment sync for Guest checkout.

Fixed issue in sync queue for Guest checkout

Required fields are missing: [tnw_invoice__Billing_Contact__c, tnw_invoice__Shipping_Contact__c], fields [tnw_invoice__Billing_Contact__c, tnw_invoice__Shipping_Contact__c]

2.7.65

• SF queue in Magento. Fixed issue when SF queue stops after one error

2.7.64

• Delete tracking numbers in Salesforce - option does not work.

Fixed the “Delete tracking numbers in Salesforce“ option. Now removed tracking numbers on the Magneto Shipment page will be removed on the Salesforce Shipment page too

2.7.63

• New Abandoned Cart logic

Implemented new logic for Cart/Quote sync process by time limit:

1. Created a new config page for Abandoned cart sync under Admin panel - Salesforce - Abandoned carts

2. Updated Order config page: Added the "Opportunity Record type" dropdown config.
   3. Updated Negotiable quotes config page: Added the "Record type" dropdown config.

3. Added the RecordType mapping items

4. Created a new Magento cron job: it runs every 5 minutes

5. Created a new MQ consumer.

6. Created a new grid page: admin panel - Sales - Abandoned cart

7. Improved the Customer page: Added the "Opportunity link" and "Sync with Salesforce" button to the "Shopping cart" tab

8. Removed old logic where we start Cart sync on the checkout page.

2.7.62

• Not all fields are synced - Issue fixed

• Telephone not syncing - Issue fixed

2.7.61

• Not all fields are synced - Issue fixed

2.7.60

• B2BQuote sync problem: multicurrency 

We implemented multicurrency support for the B2BQuote sync.

Also, we added the "Which currency should be used" config options and it helps you control the price currency you need to send to the Salesforce

2.7.59

• Invoice Grid does not show sync ID - Fixed issue with Salesforce Sync ID was not shown on Invoice grid

2.7.58

• Configurable and bundle products do not send Magento Shipment Item. Fixed issue when Configurable and bundle products were not synchronized with Salesforce Magento Shipment Item and shown on the Detail tab

2.7.57

• Creating products in Magento from SF/FB proceeds in the wrong way- Issue fixed

2.7.56

• Automatic sync order issue - issue fixed

2.7.55

• Guest order customer group sync issue. Fixed the "Not logged in" customer group sync issue

2.7.54

• Customer configuration page is slow - Issue fixed

2.7.53

• Account SalesRep Reverse Sync

Fixed issue when Account updates are not being synced in Magento when changes are made in SF

2.7.52

• Product creation SF->M2 doesn't send the Magento ID back to SF - Issue fixed

Added new option “Sync Magento ID“ in Salesforce General Configuration - Advanced menu

could be set to Yes/No - When a record is created in Salesforce, should Magento sync the new ID back after the Magneto record is created.

2.7.51

• Configurable Product Options Aren't Syncing on Order. - Issue fixed

Implement sync logic for both product option types: Custom Options and Super Attributes

2.7.50

• fix stuck with the "Processing Update Results" status

• fix orderOpportunityActivate Required fields are missing: [Name, CloseDate]

2.7.49

• Invoice sync is failing - Issue foxed

2.7.48

• Order Contact ID mapping to Opportunity and Order line items

Added new customization: Send Order Contact ID (Salesforce contact ID) from Magento to a Salesforce Opportunity Line Item and Order Product

• Add new system mapping for Magento Order Number

Added new customization: Send Magento Order Number from Magento to a Salesforce Order

2.7.47

• Order status mappings issue

2.7.46

• Ability to sync a custom field

implemented a new feature:

1. Provide the ability to map product PricebookEntry fields.

2. Added new field mappings under Admin panel -Salesforce - Field mappings Extra - Pricebook Entry

2.7.45

• Shipment is automatically synchronized when submitting an invoice but automated synchronization is turned off - Issue fixed

implemented a new feature:

1. Enable (invoice/shipment) Synchronization - No = skip sync when the record is created, skip sync when the record is updated/created, hide manual sync button

2. Enable (invoice/shipment) Synchronization - Yes = a new "Enable Automatic Synchronization " dropdown appears.

3. Enable Automatic Synchronization - Yes = pull record to the queue when the record is created or updated, sync button - add the record to a queue

4. Enable Automatic Synchronization - No = don't add to the queue when the record is created/updated, add a record to the queue if sync is triggered through our manual sync button only.

• System mapping issue - Fixed issue when System mapping become non-system after saving

2.7.43

• EXCEEDED_ID_LIMIT: record limit reached. cannot submit more than 200 records into this call

Fixed issue when synchronization of more than 200 products stops with an error

2.7.41

• Undefined index: OpportunityLineItem - Issue fixed

2.7.40

• Queue sync issue: stuck with Salesforce Update Preparation - Fixed issue when Salesforce queue stuck with Update Preparation status

2.7.39

• When the Opportunity sync is fully done

We implemented a new feature: "Default Opportunity Draft Status" - this status detects the current Opportunity update is in progress. Once all Opportunity data is sent - we change status according to the mapping

2.7.38

• Cyclic dependency in catalog_product_edit.xml - Issue fixed

2.7.37

• JS Conflict with AvaTax - Issue fixed

2.7.36

• Tracking numbers are not coming to SF - Issue fixed

2.7.35

• Newly configured SF->M2 error: Column 'status' cannot be null - Issue fixed

2.7.34

• M+SF Sync order sync issue (products) - Issue fixed

Opportunity line items were duplicated when placing an order. At that moment the Cart was already synchronized, but the Cart products were not yet.

2.7.33

• Newly configured SF->M2 error: Column 'status' cannot be null - issue fixed

2.7.32

• Correct dependencies parse logic

2.7.31

• Past order sync max_input_vars

• Address Location Remap to Enable Processing East/Fraud - added “Convert Opportunity” (Yes/No) Option

• Order from deleted website sync

2.7.29

• 1408219410 B2B Quote sync issue (If not additional information is defined for the B2BQuote - it causes the next error: No such entity with quote_id = 1246 [] [])

2.7.28

• SF-M product sync issue (skip product sync is not linked to configured Magento pricebook and only sync products with Magento if there is at least one pricebook entry linking this product to at least one website).

2.7.27

• SF-M Product sync: detect assigned websites by the Pricebooks

The latest module version has a new "Sync with all Pricebooks" config option, the default value is "Yes".

If we talk about SF->M sync logic, it has the following effect

• Yes - products will be synchronized with all pricebooks linked to every Magento website.

• No - products will ONLY be synchronized with pricebooks from the websites the product is available for (recommended).

2.7.26

• Opportunity sync - empty Account - issue fixed

2.7.25

• The opportunity amount is $0.00, deleting items that should NOT be deleting - issue fixed

2.7.23

• Lead conversion feature (config): new config setting
  Lead conversion feature (config): logic

2.7.22

• Item cleanup fatal - issue fixed

2.7.21

• "Required fields are missing: [OpportunityId]" - issue fixed

2.7.20

• State picklist - issue fixed

2.7.19

• Fix di issue

2.7.18

• Improvement: Country/State picklist code automatic detection

2.7.17

• Subscriber sync issue (Email: invalid email address) - issue fixed

2.7.16

• Items not added to the sync queue from the order page (shipment is not automatically added to the sync queue.) - issue fixed

2.7.15

• Deleted entities sync issue (This problem appears with the "Bulk/System scheduler/High Volume" sync mode) - issue fixed

• Sync issue: delete action error in the new code EXCEEDED_ID_LIMIT - issue fixed

2.7.14

• Realtime sync attempt count - issue fixed (Re-sync failed records 5 times logic.)

2.7.12

• B2BQuote Item/Contactrole sync issue - issue fixed

• Reverse sync issue fix - issue fixed

2.7.11

• M->SF Sync issues

  • The New Queue page doesn't show Order items sometimes

  • Some Order items fail with the "Incorrect Pricebook" error.

  • Shipment/Invoice sync fails with the error about missed required Contact field data

• Configuration section UX changes:

  • Configuration > TNW Salesforce > General Configuration (section) change the "General" section label to "Extensions & Information"

  • Rename "Synchronization" Section to "Advanced"
    Add a new dropdown setting here

  • Integration Mode Values: “Magento to Salesforce (only)” (Default) and “Bi-directional”

    • Magento to Salesforce (only) - The data will only flow from Magento to Salesforce. If any data comes from Salesforce, it will be ignored.

    • Bi-directional - The data will flow in both directions per your configuration on both platforms.

  • Move "Developer Mode" dropdown “Advanced” this section

  • Remove "Last CRON execution dates" for old corn jobs we are no longer using

  • Change the "Synchronization Type" label to "Data Volume"

  • Change the field description to "Set this to High Volume if you are struggling to stay within Salesforce daily API limits or if you prefer to leverage Salesforce Bulk API."

  • Change "System Scheduled" to "High Volume"

  • Change "Realtime" to "Standard"

  • Change "State and Country Picklists" section label to "General"

  • Move "Message Queue" to to "General" section

  • Change "Enabled" to "State & Country Picklists"

  • Change "Yes" to "Enabled"

  • Change "No" to "Disabled"

  • Change the description to "Check with your Salesforce Administrator if you need to enable or disable this setting."

• One-way mode (changes)

  • Configuration > TNW Salesforce > General Configuration > Advanced (tab).

    • If "Integration Mode" = "Bi-directional" - keep everything as-is.

    • If "Integration Mode" = "Magento to Salesforce (only)" - implement the following changes:

      • Configuration > TNW Salesforce > Customers (section) - Hide "From Salesforce" section completely

      • Configuration > TNW Salesforce > Orders (section) - Hide "From Salesforce" section completely

      • In Magento, Salesforce (main menu) - Hide "From Salesforce" link under "Queues" section

      • For all mapping list pages - Hide "Sf to Magento" column from the grid

      • For all "new" and "edit" mapping pages - Hide "Salesforce -> Magento Settings" section

• Move RabbitMQ feature to the SForceEnterprise version

• SF->M sync issue

2.7.10

• Queue entities relation save - issue fixed

2.7.9

• Show item status "Pending" - SyncStatus classes
  Show item status "Pending"
  Show item status "Pending": Newsletter Subscribers grid fix
  Show item status "Pending": Refactoring
  Show item status "Pending": Order Grid refresh
  Inherit order owner from the Account record
  Show item status "Pending": Order Grid refresh

2.7.8

• Disabling configuration for a specific store

2.7.7

• Cleanup dependencies in the Queue: Order-Customer dependencies
  Notice: Undefined offset for OpportunityItemCleanup - fixed

2.7.5

• Order Calculations changing upon sync with Salesforce

2.7.4

• B2BQuoteItem sync fix: check if item deleted - issue fixed

2.7.3

• Sync Queue (redesign): Add the composite_status field

• Sync Queue (redesign): Display records with the same code

• Sync Queue (redesign): Tree-grid columns changes

• Sync Queue (redesign): Blocked status issue

• B2BQuoteItem sync fix: check if item deleted

2.7.2

• amqp fix rabbit mq issue

2.7.1

• SFM-9: Sync queue grid hierarchy redesign

• SFM-9: Status icons

• Sync Queue (redesign): visualization changes

• Sync Queue (redesign): Get relatives grid data

• Sync Queue (redesign): Two Sync Queue variants

• Sync Queue (redesign): Dropdown select options in the filter

• Sync Queue (redesign): Relation visualization

• Sync Queue (redesign): Fix relationship inversion

• Sync Queue (redesign): Sort Queue grid items by sync order

• Sync Queue (redesign): Grid redesignSync Queue (redesign): Clean up first expand level

• Sync Queue (redesign): Relation changes for Shipment and for Invoice

• Sync Queue (redesign): Zero-level status

• bulk run moved to MQ

• Sync Queue (redesign): Add zero-level partial-error status

• Sync Queue (redesign): Status filter issue

• Sync Queue (redesign): Remove redundant child records

• Sync Queue (redesign): New statuses

• Sync Queue (redesign): Remove mockup

• Remove SF JOB cache because in the async mq process it causes an issue: Failed to create batch since the Job is not Open. The current job state is 'Closed'