WooCommerce Salesforce Connector
Table of Content
WooCommerce Salesforce Connector connects your online store with Salesforce CRM to reduce manual data entry.
This WooCommerce Salesforce integration brings store data into your CRM so sales teams can work with customer order information.
Bidirectional sync is included in the module, with support for variation products as well as simple products.
For B2B and B2C stores, field mapping helps send customer details to the right Salesforce records.
Follow this guide to install the plugin and map your fields before you turn on real-time sync.
WooCommerce Salesforce Connector Features
- Bring store data into Salesforce to help teams respond to customer queries.
- Sync data between WooCommerce and Salesforce with included bidirectional synchronization.
- Run synchronization in the background when exporting records.
- Use the connector with the Salesforce Lightning experience.
- Export records in bulk from WooCommerce to Salesforce.
- Map WooCommerce order statuses to Salesforce order statuses and/or opportunity stages.
- Review error and success logs when importing or exporting records.
- Sync individual tax rates to Salesforce fields when exporting WooCommerce orders.
- Sync WooCommerce users as Business Accounts or Person Accounts in Salesforce.
- Add or remove field mappings for users, products, and orders.
- Enable or disable real-time sync from WooCommerce to Salesforce for users, products, categories, and orders.
- Manually sync WooCommerce users, products, categories, and orders to Salesforce.
- Open Salesforce records by clicking their Salesforce IDs in the connector.
- Sync product and category images to Salesforce notes, attachments, or folders.
- Sync product prices to your selected Salesforce price book.
- Sync simple products and variation products between WooCommerce and Salesforce.
- Connect through the Salesforce REST API using OAuth 2.0 authentication.
You receive the production version by default, while a development version costs extra. Email support@webkul.com to ask about either version.
Compare the connector plans, features, and pricing to choose the option that suits your store.
Before You Set Up the Salesforce Integration
Once you install “eShopSync For WooCommerce” from AppExchange. Go through the links mentioned below to update the required settings.
Update Field Accessibility: Learn to update field accessibility
If you want to avail Salesforce Lightning experience, you need to register your domain first.
Domain Registration: How to Register Domain in Salesforce
How do I find my Salesforce Security Token: Check Steps Here
WooCommerce Salesforce Integration Setup Video
Configure WooCommerce Salesforce Connector
Install the WooCommerce Salesforce Connector Plugin
Go to Plugins | Add new as shown below in the snapshot.
Then click on the Upload Plugin button.
Now, upload the ZIP file of the WooCommerce Salesforce Connector plugin.
When the package installation is done. Go to the Plugin option and Activate the connector.
Connect WooCommerce to Salesforce
The steps to establish a connection are as follows with snapshots. Follow the process carefully:
-
- When installed and activate the plugin will show on the left navigational panel.
- Click on the desired button to connect it with your Salesforce Org.
-
- You did not need to enter the Salesforce Org Credentials. It would fetch from the browser.
-
- In the Connection Settings tab, users can refresh the connection, disconnect the account & reset the mapping, and delete the logs from these tabs.
-
- Open the Category and Product tab, configure the toggles as required, and then click on the Save button to save the settings.
-
- Click on Account and Contact tab, configure the toggles as required, and then click on the Save button to save the settings.
-
- In the Order and Opportunity tab, configure the toggles as required and then click on the Save button to save the settings.
-
- Go to Advanced Settings tab, and click on the Account option. Then match the fields as per the data entry you want. It must contain at least one mapped field.
- After that, click on the Save button to save the settings.
-
- In the Advanced Settings tab, click on the Contact option. Then match the fields as per the data entry you want.
- It must contain at least one mapped field. After that, click on the Save button to save the settings.
- In the Advanced Settings tab, click on the Product option. Then match the fields as per the data entry you want.
- It must contain at least one mapped field. After that, click on the Save button to save the settings.
You can set Matching Criteria to prevent duplicate records to be created in Salesforce.
You can match the records from both platforms based on different fields and the records will only sync if the values in these fields match.
View Synced Products, Customers, Orders, and Categories
Products
The product list below shows how product records appear in the connector.
Note- The same functionalities can be performed in other entities as per their availability.
Users
Review the user list below to see customer records in the connector.
Orders
Order records appear in the connector as shown in the following screenshot.
Categories
Your store categories appear in the list shown in the screenshot below.
Map WooCommerce Fields to Salesforce Fields
Account and Contact Field Mapping
Map WooCommerce meta fields to Salesforce custom fields, then activate the mapping to sync those values.
Once the data has synced, you can find the mapped values in the linked Salesforce records.
Similarly, you can proceed with the Product and order field mapping.
Product Field Mapping:
Order & Opportunity Field Mapping:
Click here to Map the WooCommerce Order Stage to the Salesforce Order Status.
Click here to Map the WooCommerce Opportunity Status to the Salesforce Opportunity Status
Set Up Bidirectional Sync Between WooCommerce and Salesforce
Entering the same data in both systems adds manual work and can leave teams working with different information.
Bidirectional sync is part of WooCommerce Salesforce Connector, so supported records can move between your store and CRM.
The setup below shows how to configure the connection and check real-time product sync in both directions.
Configure Bidirectional Sync in Salesforce
After installing the WooCommerce Salesforce connector on the Salesforce. First, click on the gear icon and go to setup.
In the Quick Find box, search for Named Credentials. Click on it to open the Named Credentials setup page.
Once inside Named Credentials, click on the External Credentials tab, then click New to create your external credentials.
After clicking New, enter the Label and Name, select the Authentication Protocol (only choose No Authentication or Basic Authentication), and finally click the Save button.
- Next, go back to Named Credentials
- Choose your Label.
- Enter the Name.
- Select your previously created External Credentials.
- Under Managed Package Access, set the access using this name: webkul_wws.
Note: Make sure your Woocommerce Site Name and Named Credential name are the same.
Further, add your site to the Picklist Value Set. Again go to the Search Bar and find Picklist Value Set. Click on the wk Site Detail.
Scroll down and edit the value from there.
Enter the Label and API name and click on the Save button. Remember, the label name and API name should be the name of your WooCommerce site name.
Open WooCommerce Salesforce Connector and press the new button to add a new site.
In this new window add the site details like Site Name and Site URL.
Meanwhile, generate Consumer Secret and Consumer Key from your WooCommerce Store dashboard.
Go to your WooCommerce dashboard under the Settings section>Advance>Rest API. Click on the Add Key button.
Further, enter the key details as in the image below and click on the Generate API key.
Finally, copy and paste the key when adding a new site in Salesforce.
Thereafter, check if the bi-directional sync has been successfully activated or not. To check that, go to the WooCommerce Connector on the left side of the dashboard.
Click on the Configuration option. Now, you can see in the image below that the site is connected and the bi-directional sync is activated.
Add WooCommerce Site Synced Field In Salesforce Objects
Another key point is adding a “WooCommerce Site Synced To” field in Salesforce Object to get bi-directional synchronization.
The purpose of adding this field is to enable businesses to sync their customer’s data from their different sites.
Businesses may have multiple stores and syncing their data from multiple stores to Salesforce requires this multi-site feature.
To add the field, first Go to the Gear Icon and click on Setup. Now Shift to the Object Manager tab.
Let’s add the field for Product in Salesforce. Search for Product in the search bar then click on the product.
Next, go to Page Layouts under the Product Section.
Click on the edit in the dropdown section.
Press the “WooCommerce Site synced To” field, then drag it below in the field section.
Lastly, click on the save button to save changes.
Thereafter, you can check the added field in the Connector under Product and check if the bidirectional feature is working.
Click on New to add a new product.
Next, enter the details related to the products. You can see that the “WooCommerce Site Synced To” field has been successfully added.
Here you can choose your preferred site to sync the data between Salesforce and WooCommerce.
After saving the product details, Shift to Related to add the Standard Price for the product as shown in the image.
Finally, save the Price Book Entry.
Now, go to the WooCommerce Store. You can see that the Product has been successfully synced automatically in real-time.
Moreover, let’s also see if the product syncs to Salesforce automatically when we add the product to WooCommerce.
To do that, go to the WooCommerce dashboard under Products then click on Add New Product.
After successfully adding a product on Woocommerce, go to the Salesforce dashboard and refresh your Product section. You can see that the product synced successfully in real time.
We have shown that the Bi-directional sync feature is working fine on the connector. Make sure to follow all the steps as shown above for a successful implementation.
Note: To enable the bi-directional feature on all the objects such as Account, Contact, Orders, and Opportunity, add the “WooCommerce Site Synced To” field in all objects as shown above.
Additionally, you can check the Record Mapping for the synced data from WooCommerce.
To do that, click on the dots on the left side of your Salesforce Org and search for “WooCommerce Field Mapping”.
When you come to the new window, select All from the drop-down section and see the same synced product information that we had created on WooCommerce.
You can see that the product name and WooCommerce Record ID is synced for the same product.
Frequently Asked Questions
Question: What is the best way to test the purchased connector file?
Answer: Install the connector on your WordPress site and connect it to Salesforce Sandbox to test your configuration.
Finally, sync your data to see the functionality of the connector.
Question: Why choose the paid connector installation service?
Answer: With the paid setup service, our team installs the plugin and sets it up once you share the required details.
Installation can begin once the team has the complete details needed for setup.
Question: What will be covered by Installation fees?
Answer: The paid service covers the plugin install and setup on your WooCommerce store.
The team also installs eShopSync For WooCommerce in Salesforce if it is not already installed.
We will sync a test record on each object to make sure that synchronization is working fine. Further, you may proceed with synchronization on your own.
Question: What are the required details mandatory to share for the Installation procedure?
Answer: You need to share the following details to proceed with the installation and setup of the connector:
- Would be preferable to install it in the Development site first in connection with Salesforce Sandbox, so create a Dev site and share the details accordingly.
- WooCommerce Admin URL of the concerned site with login credentials.
- Salesforce login credentials
- SFTP/FTP Details such as Host Name, Port, User, and Password.
NOTE: Mandatory to share SFTP/FTP details and all of the concerned sites such as Host Name, Port, User, and Password.
If we experience any issue while connector installation due to any plugin conflict.
Question: When do I need to pay installation fees?
Answer: If you need our team to install or configure the connector, pay the installation fee and share the required setup details.
To pay the Installation fees: Click Here
NOTE: We have already provided helpful links and video tutorials to install and set up the connector.
Question: When you can avail benefits of free support?
Answer: Free support starts once you have installed the plugin and set it up correctly.
Help to install the plugin and set it up falls under the paid setup service.
If you need the team to handle setup, the installation fee applies before that work begins.
Share the required setup details after payment so the team can start the work.
Question: What will be covered under the Free 3 months of support availed with connector purchase?
Answer: The three months of free support cover data sync issues once the plugin is installed and set up correctly.
You may find steps to resolve the issue under the Frequently Asked Questions section as per the error received.
Else, you may create a ticket on the link mentioned under the Support section with steps to reproduce and provide all required login details.
Question: What are the details mandatory to be shared to debug the issue?
Answer: You need to share the following details to investigate the issue:
- WooCommerce Admin URL of the concerned site with login credentials.
- SFTP/FTP Details such as Host Name, Port, Username, and Password.
- Salesforce login credentials. Or, you may grant login access for Salesforce as well: How to Grant Login Access
NOTE: Mandatory to share SFTP/FTP details and all of the concerned sites such as Host Name, Port, User, and Password if required while investigating.
Question: What if you can’t share SFTP/FTP details or Login credentials of WooCommerce and Salesforce due to privacy/security concerns?
Answer: Our team needs access to WooCommerce and Salesforce, plus SFTP/FTP details, to look into the issue.
Without having complete details, we can’t proceed any further.
Question: Can you provide support on screen sharing sessions via any medium like Team Viewer/ GoToMeeting/ etc?
Answer: No, we don’t provide any support on any of the screen-sharing sessions like Team Viewer/GoToMeeting/etc.
Please share the required access details so the support team can investigate your issue.
Question: Does WooCommerce Salesforce Connector include bidirectional sync and product variations?
Answer: The module includes two-way sync, with support for simple products and product variations.
Once set up, products can sync in real time in both directions. You can also sync products and categories by hand.
Question: What if you can’t share asked details on the support ticket to debug the issue and want a full refund?
Answer: In this case, the refund will process as per the Refund Policy: Check Refund Policy Here
Questions: What are the other options to get support if you have privacy concerns sharing Live Site details?
Answer: You need to provide a development environment (complete replica of the Live site) with the following details:
- Steps to reproduce
- Login credentials
- SFTP/FTP details such as Host Name. Port, User, and Password
We will debug the issue and provide a proper resolution on the Development site. Upon successful testing, you can implement it on the Live site.
Question: Error FIELD_INTEGRITY_EXCEPTION: There’s a problem with this country, even though it may appear correct. Please select a country/territory from the list of valid countries.
Answer: It seems that you have “enable” the feature of State and Country/Territory Picklists in your Salesforce Org.
WooCommerce Salesforce Connector doesn’t support the sync feature with this enabled feature.
You need to disable* State and Country/Territory Picklist in Salesforce by the following path Go To Setup | Data Management | State and Country/Territory Picklist | Click Disable | Save it.
Then try to sync the user and it should be working fine.
- *NOTE: Make sure to get confirmation from your Salesforce team prior to disabling this State and Country/Territory Picklists feature. It might be used internally in your Salesforce processes.
- You can raise customization requests for WooCommerce Salesforce Connector to sync data with State and Country/Territory Picklists feature enabled.
- You need to share your custom requirement on the link mentioned under the Support tab below.
Q: Error FIELD_INTEGRITY_EXCEPTION: AccountId, ContractId – account mismatch
A: This occurs after switching the sync type from Single Account to Individual Account.
To resolve it:
-
First, sync users after updating the sync type.
-
Next, delete the “WooCommerce” account from Salesforce (this will also remove its related orders and contracts).
-
Then, re-sync orders — they’ll now link correctly to the respective accounts.
-
Lastly, no changes are needed for guest users, as their functionality remains the same.
Question: Error API_DISABLED_FOR_ORG: API is not enabled for this Organization or Partner.
Answer: You need to enable API in your Salesforce Org. For the Enterprise edition & up, you get the “API enable” by default.
To verify follow the steps: From Setup | Users | Profiles | Choose the specific Profile of the User | Scroll down to Administrative Permissions | Check mark API Enable”
option: https://qsnapnet.com/snaps/76f7fwl3rk65hfr
Note: For Professional Edition, you have to get Professional Edition (with the “API enable” option) to avail of connector Sync features.
Question: Error INVALID_FIELD_FOR_INSERT_UPDATE: bad field names on insert/update call
Answer: Ensure the fields are visible to the concerned profile: Setup → Object → Fields → Field Name → Field Accessibility → Mark as Visible for the profile → Save.
- Repeat this for each field mentioned in the error.
- Follow this step for all the fields with the concerned object thrown in error.
Question: Error while installing eShopSync For WooCommerce: (Order.Woo_Order_Status__c) Entity not available. The Entity ‘Order’ was not found. Contact the vendor for more details.
Answer: Follow the below path to enable Orders in order to avoid this error
Go to Setup | Customize | Order | Order Settings | Checkmark ” Enable Orders ” then Save
Once you enable Orders, try to install eShopSync For WooCommerce and it will install successfully.
Question: How many Salesforce User is allocated eShopSync For the WooCommerce module license?
Answer: By default, the allocation of a module license per Org is only 1 Salesforce User. An additional module license is chargeable.
Feel free to contact us to get more licenses (One-time payment only).
Question: Error : webkul_wws: Too many query rows: 50001
Answer: Check the existing version of eShopSync For WooCommerce, it should be 1.13 and up.
You may verify the installed version by the following path: Setup| In the quick find, Search for Installed Packages and Select it | Check eShopSync For WooCommerce: Version Number.
If it is below 1.13.0 then Click here to Upgrade eShopSync For WooCommerce
After installation, follow the steps mentioned below to make some required changes:
- Go to eShopSync For WooCommerce from the App Menu drop-down | Click on the Customers section | Copy the web link from the address bar to force.com | Paste this link in the Remote site settings section guided in 2 steps.
- Go to Setup | In quick find, search for Remote Site settings and select it | Click New Remote site | Enter details as guided here: https://qsnapnet.com/snaps/yz23zeza9vzvkj4
Now, proceed WooCommerce-Salesforce Connector tab and verify the records. It should be working fine.
Question: Document Error: No document folders are selected in the options.
Answer: Make sure that you have selected a folder in WWS Connector | Settings | Choose Document Folder. Select a folder to store category and product images in Salesforce.
Question: While Clicking on Orders under the WooCommerce Salesforce Connector tab getting the error: Attempt to de-reference a null object.
Answer: Field Level permission is missing in the Order field. Follow the path to update accessibility.
Go to Setup | Customize | Orders | Fields | Click PO Number | Click Set Field-Level Security | Check Mark Visible for desired Profiles | Click Save
Now, go to the Orders section and it should be working fine.
Support
For help with the connector, raise a ticket or email support@webkul.com with details of your issue.
For custom WordPress development services, contact our team or explore our WooCommerce extensions for your store.