Versions Compared

Key

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

2.9.55 -

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

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

Implemented mechanism spawn a new messages on Memory limit restart

2.9.53 -

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

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 -

  • Individual Cron Group for each cron job

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

2.9.50 -

  • Cron jobs performance

2.9.49 -

  • Individual Cron Group for each cron job

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

2.9.48 -

  • Dependency Queue issue

Fixed Dependency Queue issue

2.9.47 -

  • Reindex issue: optimize SQL queries

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

2.9.46 -

  • Delete/Reset record from the queue

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

2.9.45 -

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

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

  • Opportunity owner does not inherit for Lead

Fixed issue with inheriting owner from Lead to Opportunity

2.9.42 -

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

Fixed Country and State synchronization for location Account

2.9.41 -

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

Fixed isuue with re-sync on new queue grid

2.9.40 -

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

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

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

  • Incorrect status for synced Product

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

2.9.36 -

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

Fixed issue with Abandoned Cart sync

2.9.35 -

  • Error 'duplicate value found' in the queue

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

2.9.34 -

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

Created new logic for dependency

2.9.33 -

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

  • Error in Queue during Order and Opportunity reverse sync

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

2.9.30 -

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

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

2.9.28 -

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

  • Error in queue if automatic synchronization is disabled for shipment

Fixed error in queue if automatic synchronization is disabled for shipment

2.9.26 -

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 -

  • Show tnwsforce_order/grid_updates config

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

2.9.24 -

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

  • Refactoring: spl_object_id to spl_object_hash

Changed spl_object_id function to the spl_object_hash

2.9.22 -

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

  • Error during Invoice sync

Fixed issue with synchronization of two and more bundle products

2.9.20 -

  • Accounts are merged when Account names are not equal

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

2.9.19 -

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

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

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

  • Error in queue when manually synchronize invoice or shipment

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

2.9.15 -

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

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

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

2.9.13 -

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 -

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

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

2.9.10 -

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

2.9.9 -

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

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 -

  • Opportunity product does not sync for manually changed opportunity

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

2.9.6 -

  • (Customization) Сhange Opportunity Name

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

2.9.5 -

  • Error during Accounts merging

  • moved company part to the sforceb2b module

Fixed issue with Accounts merging

2.9.4 -

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

  • Description in Opportunity is missing in SF

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

2.9.2 -

  • Shipment sync issue INVALID_QUERY_FILTER_OPERATOR

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

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

  • Shipment sync: Opportunity field sometimes not populating

Added Shipment and Invoice dependencies with Magento order

2.7.206 -

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

Opportunity sync dependencies fixed

2.7.205 -

  • A new products form issue with some php settings

2.7.204 -

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

  • Check module re-install process.

Improved uninstall script. Added our tables/columns delete logic

2.7.202 -

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

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

2.7.201 -

  • Incorrect Abandoned Cart Opportunity Amount for bundle product.

Fixed bundle product amount calculation for Abandoned Cart Opportunity

2.7.200 -

  • Opportunity product does not sync for manually changed opportunity.

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

2.7.199 -

  • Pagination does not work on Magento Stat page.

Fixed Pagination on Magento Stat page

2.7.198 -

  • Change "Synchronize Notes" options label and description.

Changed "Synchronize Notes" options label and description

2.7.197 -

  • Salesforce Invoice description show incorrect price from items.

Fixed issue with Salesforce Invoice description show incorrect price from items

2.7.196 -

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

  • Salesforce Magento Shipment has incorrect description.

Fixed Salesforce Magento Shipment description

2.7.194 -

  • Update file copyrights/strict_types

Added the strict_types declaration to all files

2.7.193 -

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

  • AbandonedCartItem sync issue

Fixed issue when re-sync records related to removed entities

2.7.191 -

  • memory performance

Fixed OOM issue caused by syncing huge products count

2.7.190 -

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

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

Fixed issue when mapping disappears after disabling modules

2.7.188 -

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

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

  • Exception appears after saving mapping

Fixed Exception which appears after saving mapping and expired session

2.7.185 -

  • Never delete converted Leads

"Delete converted Leads" option removed

2.7.184 -

  • Additional indexes for tnw_salesforce_entity_queue.

Added additional indexes for tnw_salesforce_entity_queue

2.7.183 -

  • Order sync does not work for guest customer

Fixed issue with synchronization Sales Rep for Guest order

2.7.182 -

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

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

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

  • Completed records are not cleared from the queue table.

Fixed issue with cleaning records from the queue table

2.7.178 -

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

  • Issue with site speed and webscale.

Improved site speed and webscale

2.7.176 -

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

  • Queue resync automation

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

2.7.173 -

  • Error during installation.

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

2.7.172 -

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

  • Slow Queries

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

2.7.170 -

  • Incorrect Invoice Amount for bundle product

Fixed Issue with Incorrect Invoice Amount for bundle product

2.7.169 -

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

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

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

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

2.7.166 -

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

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

"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

Synchronization of Magento product with Archived product in Salesforce

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

...

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

...

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

...

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

...