Versions Compared

Key

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

2.9.45 -

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

Implemented mechanism spawn a new messages on Memory limit restart

2.9.44 -

  • 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.9.43 -

  • Add indexes to tnw_salesforce_entity_queue

Added indexes to tnw_salesforce_entity_queue table

2.9.42 -

  • 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.9.41 -

  • SQL optimization: tnw_salesforce_objects

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

2.9.40 -

  • Individual Cron Group for each cron job

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

2.9.38 -

  • 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.9.37 -

  • Dependency Queue issue

Fixed Dependency Queue issue

2.9.36 -

  • Reindex issue: optimize SQL queries

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

2.9.35 -

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

Fixed message for skipped records

2.9.34 -

  • 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.9.33 -

  • Release a new Marketing module

Corrected composer.json file for a new Marketing module

2.9.32 -

  • Lead Owner does not inherit for Contact after converting

Fixed issue with inheriting Owner from Lead to Contact after converting

2.9.31 -

  • Contact Owner is Default Account Owner for Bulk sync

Fixed Contact Owner synchonization from Sales Rep dropdawn in Bulk mode

2.9.30 -

  • Contact Owner is Default Account Owner

Fixed Contact Owner synchonization from Sales Rep dropdawn

2.9.29 -

  • 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.28 -

  • 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.27 -

  • 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.26 -

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

2.9.25 -

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

2.9.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.9.23 -

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

2.9.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.9.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.9.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.9.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.9.18 -

  • Extra record are added to queue when sync website

Fixed issue with Extra record added to queue when Edit website

2.9.16 -

  • Refactoring: spl_object_id to spl_object_hash

Changed spl_object_id function to the spl_object_hash

2.9.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.9.14 -

  • Performance: memory leak

Fixed memory wasting by consumers

2.9.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.9.12 -

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

Issue fixed . Corrected dependency logic

2.9.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.9.10 -

  • Cabinets module optimization

  • Fixed sync issue for projects with deleted products in database

2.9.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.9.7 -

  • Undefined index - error during the Opportunity sync

Fixed issue : Undefined index - error during the Opportunity sync

2.9.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.9.5 -

  • Call to a member function isStatic

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

2.9.4 -

  • OpportunityItemCleanup and TierPriceCleanup stuck in the Queue - Issue fixed

2.9.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.9.2 -

  • (Customization) Сhange Opportunity Name

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

2.9.1 -

  • Synchronization does not work on Starter module version

FIxed Issue with consumers on Starter module version

2.9.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.7.135 -

[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.134 -

  • Implement the consumers restart logic

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

2.7.133 -

  • Check module re-install process.

Improved uninstall script. Added our tables/columns delete logic

2.7.132 -

  • 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.7.131 -

  • Update file copyrights/strict_types

Added the strict_types declaration to all files

2.7.130 -

  • 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.129 -

  • AbandonedCartItem sync issue

Fixed issue when re-sync records related to removed entities

2.7.128 -

  • memory performance

Fixed OOM issue caused by syncing huge products count

2.7.127 -

  • Account duplicates

Fixed issue when Account could be duplicated using Bulk sync mode

2.7.126 -

  • Error during the Account sync

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

2.7.125 -

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.124 -

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

Fixed issue when mapping disappears after disabling modules

2.7.123 -

  • 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.122 -

  • 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.121 -

  • Additional indexes for tnw_salesforce_entity_queue.

Added additional indexes for tnw_salesforce_entity_queue

2.7.120 -

  • 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.119 -

  • 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.118 -

  • Error during closing order (Deadlock issue)

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.118 -

  • Error during closing order (Deadlock issue)

Fixed Deadlock issue appears on admin panel.
Now all record first apears in presueue than in queue

2.7.117 -

  • Issue with site speed and webscale.

Improved site speed and webscale

2.7.114 -

  • Error during installation.

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

2.7.113 -

  • 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.112 -

  • Slow Queries

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

2.7.111 -

  • 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.110 -

  • Company admin user synced with incorrect Contact owner

Fixed issue with incorrect synchronization of Contact owner for Company administrator. 'Retain Owner from Existing Account' option worked incorrectly

2.7.109

  • Error code in the sync Queue

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

2.7.108

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

2.7.107

  • Log miss xml tags - Issue fixed

2.7.106

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

2.7.105

  • 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 “Skip blank values“ (Yes/No)

2.7.104

  • Salesforce side bar menu has incorrect view if enable a lot modules - Issue fixed

2.7.103

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

2.7.102

  • Misspelled word in 'Salesforce integration is disable' message - Issue fixed

2.7.101

  • Returns Configuration page is available when Salesforce integration is disabled - Issue fixed

2.7.100

  • Incorrect LastSync date on the sync Queue pages - Issue fixed

2.7.99

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

...