Value of Connecting Your SFCC Account with nova
Here’s a quick rundown of what integrating SFCC data with our nova system can unlock
Reporting & Analytics Dashboards
eCommerce analytics reporting - will unlock Marketing KPI, Top Products, and Finance analytics dashboards out-of-the-box (see some screenshots as examples below)
New customers & churned customers
nova Insights AI - chat with your analytics data and leverage generative AI to answer ad-hoc follow-up questions you have about your dashboards (Coming soon)
nova Intelligence Module
Your account team will be able to leverage the following applications:
Customer insights - unlocks a plethora of customer data to understand better who your customers are, what they do, trends, etc.
Forecasts - input channel summaries, historical spending, and budget scenarios and receive immediate forecasts that predict future revenue against spend using a machine learning algorithm
Cohorts analysis - analyze groups of customers who have common traits (ie high AOV, high LTV etc..)
Creative affinity - facilitates in-depth analysis crucial for platforms like Facebook and Instagram, allowing nuanced evaluations of creative performance and identifying the most effective elements in an advertising campaign
Important Constraints to Keep in Mind
For our initial release, there is some information that historically we have made a point to include in our other eCommerce integrations (e.g. Shopify) that will not be available in our SFCC integration:
Refunds data
Product variants information
Inventory information
“Default” address data for customer
Image info for products
How does this impact nova intelligence applications?
Constraint | Impact |
Refunds | Affects LTV, net sales, and total sales used in nova Forecasts, Cohorts Analysis, Creative Affinity |
Product variants information | n/a (as of July 2024) |
Inventory information | n/a (as of July 2024) |
“Default” address data for customer | n/a (as of July 2024) |
Image info for products | n/a (as of July 2024) |
How does this impact any reporting dashboards coming out of nova?
Constraint | Impact |
Refunds | Return fields will be zero in reports and be calculated as zero when it is used in any calculated metrics |
Product variants information | Some SKU information will be some incomplete on some tables in reports |
Inventory information | Inventory dashboard will be empty/incomplete |
“Default” address data for customer | n/a (as of July 2024) |
Image info for products | n/a (as of July 2024) |
Integration Setup Guide
There are 2 ways to integrate your SFCC account with nova:
Option 1
You create a user for us using an email that the Power Digital team will create first following this model business-name@powerdigitalmarketinginc.com. For this user, you will provide a list of permissions/access to that user (listed below).
Account Administrator
API Administrator
Business Manager Administrator
Control Center Administrator
The benefit of this option is we do the entire setup process for you.
Option 2
There are 6 values that we need that are retrieved from within your SFCC account that you have to locate and input yourself into a form that we'll send you.
The benefit of this option is you don't have to give the level of access previously listed in the event that you think it's too much.
In the event that you want to proceed with option 2, see below the setup instructions that will tell you step by step how to find all the values we need. Once you have located them, let your team know and we will send you a link to a form where you can securely input all of the values (so you don't have to send over email or slack to us) and you'll be all set!
Steps for how to retrieve all the fields necessary to complete the Salesforce Commerce Cloud integration within the nova platform:
Finding the Client ID
Login to your account from here: https://account.demandware.com/
Navigate to API client on left navigation
Click Add API Client from the API clients page
Enter a Display Name for the API Client
The recommendation is to set it to “nova_fivetran” but you can name it whatever you like
Enter your Password and then Confirm Password for the new client
Be sure to make a note of the password as this will be the “client secret” value which is required to successfully setup the integration.
Now, in the Organizations section (still on the same page) click Add, select one or more organizations and click Add again
In the Roles section directly below, do the following:
Click Add
Find the Salesforce Commerce API category and Select the Salesforce Commerce API
Click Add again
Then click the filter button
Select an organization
Enter the name for each instance you want to access with the API client
Select each instance and click Add.
Next, in the Allowed Scopes field which is under the OpenID Connect section on the same page, enter the following authenticated access scopes:
sfcc.products
sfcc.promotions
sfcc.customerlists
sfcc.catalogs
sfcc.gift-certificates
sfcc.source-codes
sfcc.orders
In the Token Endpoint Auth Method drop-down menu, select client_secret_post.
See image above
In the Access Token Format drop-down menu, select JWT.
See image above
Click Save.
Now when you go back to the main page you will find the Client ID here (for the row where the display name column matches the display name you set in the setup process)
Finding the Client Secret
This is simply the password you set for the API client you set up in the previous step.
Finding the Organization ID
Login to control center: https://controlcenter.commercecloud.salesforce.com/
You can use the same login credentials you used for the Account Manager portal
Click on the realm (i.e. bdld - na01.XXXXX.demandware.net)
Click on the instance you want to find Organization ID for which will be production
Click on business manager top right
Sign in with account manager credentials
Click on the Administration tab -> Site Development -> Salesforce Commerce API settings
Locate Org ID (Short code there too)
Finding the Short Code
Login to control center: https://controlcenter.commercecloud.salesforce.com/
Click on the realm (i.e. bdld - na01.XXXXX.demandware.net)
Click on the instance you want to find Short Code for which will be production
Click on business manager top right
See image from section 3 Finding the Organization ID for visual.
Sign in with account manager credentials
See image from section 3 Finding the Organization ID for visual.
Click on the Administration tab -> Site Development -> Salesforce Commerce API settings
Locate Short code (org id there too)
Finding the Site ID
Login to control center: https://controlcenter.commercecloud.salesforce.com/
Click on the realm (i.e. bdld - na01.XXXXX.demandware.net)
Click on the instance you want to find Site ID for which will be production
Click on business manager top right
See image from section 3 Finding the Organization ID for visual.
Sign in with account manager credentials
See image from section 3 Finding the Organization ID for visual.
Go to Administration > Sites > Manage Sites.
The value in the ID column is the Site ID.
Finding the Customer List ID
Login to control center: https://controlcenter.commercecloud.salesforce.com/
Click on the realm (i.e. bdld - na01.XXXXX.demandware.net)
Click on the instance you want to find Customer List ID for which will be production
Click on business manager top right
See image from section 3 Finding the Organization ID for visual.
Sign in with account manager credentials
See image from section 3 Finding the Organization ID for visual.
Go to Administration > Sites > Customer Lists.
The value in the ID column is the Customer List ID.
Now you should have all the necessary values to input into the connector card portal and complete your Salesforce Commerce Cloud integration with nova.
Client ID
Client Secret
Organization ID
Short Code
Site ID
Customer List ID