Integration of Salesforce with Shopify Application

Integration of Salesforce with Shopify Application

Hi All,

This Blog gives a small demonstration  on how the process happens in integration of Shopify app with Salesforce. We can use SOAP API or REST API based on your requirement.

Here I am using REST API for integration.

For integration with Shopify app we cannot use Oauth authentication. As shopify does not allow Oath as an authentication mechanism hence we can not use Oauth here.

Shopify app is mainly used for selling the products it is similar like Amazon. To sell the products in shopify we need to have a store in shopify. Integration between salesforce and shopify will be possible if we have a store in shopify.

What is a store? Store is a place where we can sell our products exclusively. To create store in shopify visit this link https://www.shopify.in/online-store Here there are mainly two versions one is a free version which you can use for testing this functionality and the second one is a paid one.

Shopify store image is displayed below.

To fetch data from shopify app we need to have an Access token and Password. To Generate an Access Token and Password we need to create a private app in shopify to access our store data.

Creating Private App:

Click on the tab “Apps”

Click on Private Apps button on the top right corner then private app page will be seen.

Click on ‘Create Private App’ button and the private app creation page will be opened.

Fill the Title field with any name the title will be your app name and email is an optional field on filling the details click on Save app. Then private app detail page is opened.

On the above image you can see API Key and Password. Example URL in the above image is used in HTTP requests to fetch the data from the shopify app.

The Example URL format: https://apikey:password@hostname/admin/data.json

Place your shopify store URL in “Remote site settings” in Salesforce.

Go to salesforce and click on setup-> Security Controls -> Remote Site Settings. Click on New Remote Site and give any name and paste the shopify store URL and click on Save.

To fetch the data from shopify app we need to create a certificate in salesforce org.

Why to create a salesforce certificate? Shopify will connect with the trusted sites and to make salesforce as trusted site we need to create a certificate.Certificate is added with a HTTP header and sent as a request. Then shopify accepts the certified requests and send us the data.

How to Create a Certificate:

Go to salesforce and click on setup-> Administrative setup section-> security Controls-> Certificate & Key Management->create self signed certificate. Fill the label and save it.

Here for integration with shopify app i used a VF page and controller. On clicking the button in VF page, the whole shopify data is fetched into the salesforce org by using HTTP requests. Here we are hitting shopify with the Example URL , API key and password. The method used in HTTP Requests is GET method. So it will fetch the data from the shopify and the certificate we created on the top is used as “req.setClientCertificateName(‘Shopify’)” .

Shopify in the above line is the certificate name which i created and you need to give the certificate name that you created.

The data that is fetched from HTTP requests are in JSON format. To convert JSON format to normal format we use json.deserialize() method. Once you receive the data from deserialize method we can map it to the salesforce objects. So once you complete the whole process, data from shopify will be fetched and you can use this data in salesforce.

The functionality may change a bit if we are integrating with other apps but the HTTP Callouts and the deserializing functionality will be same for integration with any third party application.

To know more about HTTP request visit this link: https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_classes_restful_http_httprequest.htm%23apex_System_HttpRequest_methods

This is the Visualforce page and Controller code:

[sourcecode language=”java”]

// Visualforce Page code

<apex:page controller=”shopifycontroller”>
<apex:form>
<apex:commandButton value=”getShopifyData” action=”{!retrieveGoogleAccessToken}”/>
</apex:form>
</apex:page>

//Controller Code

public class shopifycontroller {
public void retrieveGoogleAccessToken() {
//Local Variables
string ResponseBody;
//Making Callouts using HTTP Requests
Http h = new Http();
HttpRequest req = new HttpRequest();
//Provide URL of the Shopify store to HTTP requests
String url = ‘https://xxxxxx.myshopify.com’;
string endPointValue = url + ‘/admin/orders.json’;
req.setEndpoint(endPointValue);
//Adding certificate to HTTP Requests
req.setClientCertificateName(‘Shopify’);
//Providing Username and Password
String username = ‘xxxxxxxxxxxxxxxxxxxxxx’;
String password = ‘xxxxxxxxxxxxxxxxx’;
Blob headerValue = Blob.valueOf(username + ‘:’ + password);
String authorizationHeader = ‘Basic ‘ +
EncodingUtil.base64Encode(headerValue);
req.setHeader(‘Authorization’, authorizationHeader);
req.setHeader(‘content-type’, ‘application/json’);
//Use get Method as we are retrieving data from shopify
req.setMethod(‘GET’);
try {
HttpResponse res = h.send(req);
ResponseBody = res.getBody();
} catch (exception e) {
System.debug(‘exception’ + e);
}

// Parse entire JSON response.

JSONParser parser = JSON.createParser(ResponseBody);
while (parser.nextToken() != null) {
// Start at the array of Orders.
if (parser.getCurrentToken() == JSONToken.START_ARRAY) {
while (parser.nextToken() != null) {
// Advance to the start object marker to
// find next Order statement object.
if (parser.getCurrentToken() == JSONToken.START_OBJECT) {
Orders ord = (Orders) parser.readValueAs(Orders.class);
// For debugging purposes, serialize again to verify what was parsed.
String serializeData = JSON.serialize(ord);

// Skip the child start array and start object markers.
parser.skipChildren();
}
}
}
}
}
// Inner classes used for serialization by readValuesAs().

public class Orders {
public Double total_price;
public DateTime created_at;
public string email;
public Orders(Double price, DateTime dt, string em) {
total_price = price;
created_at = dt;
email = em;
}
}
}

[/sourcecode]

Please post your comments or inputs if you feel this blog is helpful.

14 thoughts on “Integration of Salesforce with Shopify Application”

  1. I have tried it and it does not work. It is giving an unauthorised & 401 error.
    JSONParser parser = JSON.createParser(s); –> should be responsebody instead of ‘s’

  2. I am geting an Error
    “errors”:”[API] Invalid API key or access token (unrecognized login or wrong password)
    Even though it is working with Browser

    1. Yes it is in real time. Shopify is having a feature called WebHooks. So on different events in Shopify they will call the webhooks related to that event. So they can get the data from salesforce or they can transfer the data to salesforce.

  3. I am getting “Invalid API key or access token [unrecognized login or wrong password]” with this approach. The URL works fine in the browser with given credentials. Ever faced this issue?

  4. Hi, Raviteja. I just followed your post it worked every well. Now I have to implement to get data from shopify using batch apex and scheduled it for every one hour.

  5. I followed the steps provided by you by creating trial account in shopify. I’m getting response as below
    HttpResponse[Status=Unauthorized, StatusCode=401].
    Could you please help me on this.

    1. For username and password i given site username and password.That’s the reason for getting response as unauthorized.
      Now i provided api key and password, it’s working. Thank you.

  6. Hi, I don’t have the refresh button on the Salesforce shopify site with trial version, it’s normal?
    Thank you

  7. Hi i followed th step that you mentioned and i got this error

    System.NullPointerException: null input to JSON parser
    Error is in expression ‘{!retrieveGoogleAccessToken}’ in component in page shopifydemo: Class.System.JSONParser.: line 5, column 1
    Class.System.JSON.createParser: line 23, column 1
    Class.shopifycontroller.retrieveGoogleAccessToken: line 33, column 1

    An unexpected error has occurred. Your solution provider has been notified. (System)

Leave a Comment

Your email address will not be published. Required fields are marked *

Recent Posts

what is salesforce service cloud and how can it help your business
What is Salesforce Service Cloud and how can it help your business?
salesforce manufacturing cloud integration for the seamless sales process
Salesforce Manufacturing Cloud Integration for the Seamless Sales Process
top 5 benefits of using salesforce for high tech industry infographic
Top 5 Benefits of using Salesforce for High-Tech Industry
salesforce world tour essentials dubai
Salesforce World Tour Essentials Dubai | May 16, 2024
simplifying npl the magic of natural language processing
Simplifying NLP: The Magic of Natural Language Processing
Scroll to Top