Skip blank values

Owned by Yurii Perevuznyk (Deactivated)
Last updated: May 24, 2022
4 min read

Default Value vs Empty mapped source field

1 Case: Skip blank values set to Yes

There are situations when mapped fields should be cleared. But Salesforce still contains old data. In such cases, you could use the “Default Value” field to populate Salesforce with correct data

Let’s see an example with some custom mapping

  • Go to Magneto Admin panel - Salesforce - Field Mappings - Product

  • Click the “Add New Mapping“ button

  • For example select

    • Magento Attribute as Product: Weight

    • Salesforce Attribute as Product Description

    • Skip blank values set to Yes

  • Click the Save Mapper button

 

  • Go to Magento Admin panel - Catalog - Products - Add a new product

  • Fill all required fields

  • Fill Weight field for example “8“

  • Save product

  • Select the Salesforce tab and click on the “Salesforce Product ID“ link

  • Check the “Product Description” field

“Product Description” field will contain weight value

  • Now Go to Magento Admin panel - Catalog - Products - Edit product

  • Delete the value in Weight files and Save the product

  • Go back to Salesforce Product Page and refresh it

Value in the “Product Description” field will do not change to empty

  • Go to Magneto Admin panel - Salesforce - Field Mappings - Product -Edit custom mapping

  • Fill “Default Value“ field with “0“

  • Save Mapper

  • Go to Magento Admin panel - Catalog - Products - Sync product with Salesforce

  • Go back to Salesforce Product Page and refresh it

Value in the “Product Description” field will contain “0“ - mapping Default Value

2 Case: Skip blank values set to No

There is another workflow where blank values are not skipped. Let’s modify created mapping for Product Weight.

  • Open created mapping

  • Skip blank values set to No

  • Click the Save Mapper button

  • Go to Magento Admin panel - Catalog - Products - Edit product

  • Delete the value in Weight files and Save the product

  • Sync edited product

  • Go back to Salesforce Product Page and refresh it

Value in the “Product Description” field is empty - Skip blank value is enabled

In the situation when we use blank value (Skip blank values set to No) and the default value is set as well, the default value will be synced to Salesforce.

  • Open created mapping

  • Skip blank values set to No

  • Default value set to 1

  • Click the Save Mapper button

  • Sync edited product

  • Go back to Salesforce Product Page and refresh it

Value in the “Product Description” field will contain “1“ - mapping Default Value.

The reverse synchronization from Salesforce to Magento works in the same way. If ‘Skip blank values’ is set to No after deleting the value in Salesforce and re-sync, the value in Magento will be reset.

  • Open created mapping

  • Clear Default value

  • Skip blank values set to No

  • Click the Save Mapper button

 

  • On Salesforce Product page clear Product Description field

 

  • Click Sync with Magento button

  • Go to Magento Admin panel - Catalog - Products - Edit product

Value in the “Weight” field is empty - we passed empty value from Salesforce (Skip blank value is set to No.