Shopify Integration - ERPNext app doesn’t exist in Shopify app store?

zia · March 4, 2018, 10:29am

Dear Frappe/ERPNext support team
I’m confused about connecting Shopify with ERPNext;
I have installed Shopify app inside ERPNext, now when I go to shopify setting in ERPNext and provide some necessary data like App Type = ‘public’, Shop URL = ‘ziaakbari.myshopify.com’ and … when I click save, It gives me a popup ‘Access token or Shopify URL missing’, I don’t know what is the meaning of this message.
Do I need to install ERPNext inside Shopify as well? if so; then ERPNext app doesn’t exist in Shopify app store,
Once I connected through App Type = ‘Private’ but I think this is not a reliable way.
Please anyone can help,
Thanks in advance

clarkej · March 4, 2018, 9:36pm

You are following these instructions? ERPNext Shopify Connector

zia · March 5, 2018, 6:41am

Thanks dear @clarkej for replying me
yes exactly i follow those steps. What I face is: ERPNext app doesn’t exist in Shopify app store to install that.
I’m using trial version of both Shopify and ERPNex.
Please help me if there is anyway
Thanks again
zia

clarkej · March 5, 2018, 2:26pm

To add context of your efforts and learnings this last few weeks:
https://github.com/frappe/erpnext/issues/12911

“The Shopify app from the Installer has been discontinued. You need not do it now.”

and this too Connecting Shopify to ERPNext · Issue #12862 · frappe/erpnext · GitHub

“We are merging Erpnext Shopify app into ERPNext itself. But it will take couple of weeks.”

re the message ‘Access token or Shopify URL missing’ that code is here

github.com

frappe/erpnext_shopify/blob/develop/erpnext_shopify/erpnext_shopify/doctype/shopify_settings/shopify_settings.py

# -*- coding: utf-8 -*-
# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and contributors
# For license information, please see license.txt

from __future__ import unicode_literals
import frappe
from frappe import _
import requests.exceptions
from frappe.model.document import Document
from erpnext_shopify.shopify_requests import get_request
from erpnext_shopify.exceptions import ShopifySetupError

class ShopifySettings(Document):
	def validate(self):
		if self.enable_shopify == 1:
			self.validate_access_credentials()
			self.validate_access()

	def validate_access_credentials(self):
		if self.app_type == "Private":

This file has been truncated. show original

Try both develop and production to find one that works. This below may give you ideas whether the access token and url values are reasonable?

github.com

frappe/erpnext_shopify/blob/develop/erpnext_shopify/erpnext_shopify/doctype/shopify_settings/test_shopify_settings.py

# -*- coding: utf-8 -*-
# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
# See license.txt
from __future__ import unicode_literals

import os
import json
import frappe
import unittest
from frappe.utils import cint, cstr, flt
from frappe.utils.fixtures import sync_fixtures
from erpnext_shopify.sync_orders import create_order, valid_customer_and_product
from erpnext_shopify.sync_products import make_item
from erpnext_shopify.sync_customers import create_customer

class ShopifySettings(unittest.TestCase):
	def setUp(self):
		frappe.set_user("Administrator")
		sync_fixtures("erpnext_shopify")
		frappe.reload_doctype("Customer")

This file has been truncated. show original

And of course search the forum for more clues.

Your persistence will pay off - if you get a traceback be sure to post that

zia · March 6, 2018, 7:15am

Ok Thanks @clarkej I got something now and I’m waiting for the merged version.

Amr_El_Masry · February 9, 2019, 8:05pm

I couldnot find ERPNext App on shopify store. Please advise ?

Hejun_Cheng · January 16, 2020, 9:49am

I don’t see a manual sync button.

Rakesh_dev · July 21, 2020, 7:23am

did you find the solution for this, me too facing the same issue @Hejun_Cheng @clarkej

tried in two ways
i) first way i couldn’t find the app in shopify store
ii) second way i couldn’t see the sync button and also a i am unable to change the app type as public

kennethsequeira · July 21, 2020, 7:22pm

The old app has been deprecated. Refer this instead:

https://docs.erpnext.com/docs/user/manual/en/erpnext_integration/shopify_integration

Rakesh_dev · July 22, 2020, 7:48am

refered this doc, shopify sync button is not visible for , any solution

laurence · August 22, 2020, 3:55am

I’m setting this up now on an erpnext Cloud instance, logging what my set up looks like and see how we go.

laurence · August 22, 2020, 6:34am

Filling up the fields in the Shopify integration page is easy enough. Entered most of the fields that I wanted to use. Left empty fields Cost Center, Price List and tax/shipping mapping table.

Saved the information, then clicked Enabled and tried saving again.

Waited a minute or so, then this error pops up:

“(1060, “Duplicate column name ‘shopify_order_id’”)”

on ERPNext: v12.10.1 (version-12)

ERPNext Support: v0.0.3 (master)

Frappe Framework: v12.8.4 (version-12)

Journeys: v0.0.1 (version-12)

laurence · August 29, 2020, 7:31am

OK so the Shopify Settings page is now saving properly. Thanks Frappe for the fix.

It appears the Shopify connector uses Shopify’s product_id when creating new orders. Since product_id is (sort of) a random string, it doesn’t map neatly with our item_code field in ERPNext. This leads to new items being created.

Would it be possible to remap the product_id string in the JSON to pull instead from SKU field when calling data from Shopify?