Shopify orders does not sync

hariskadir · October 16, 2017, 12:11pm

Hi,

My Shopify connector stop syncs my order to the SO and SI. It does sync the item and customer.

No error is showing up. Can anyone please help?

Thanks in advance.

vinhnguyent090 · March 8, 2018, 3:19am

I have error my system can’t syns orders correct ( Shopify and ErpNext use Timezone +08:00) . So I find the root error is timezone from updated_at_min when get json /admin/orders.json

So I edit code change use timezone to utc and It run, pls check, and update code thanks.

utc_dt = timezone_abbr.astimezone (pytz.utc)
return 'updated_at_min="{0}"'.format(utc_dt.strftime("%Y-%m-%d %H:%M:%S"))

erpnext_shopify/erpnext_shopify/shopify_requests.py

Original code

def get_filtering_condition():
	shopify_settings = get_shopify_settings()
	if shopify_settings.last_sync_datetime:

		last_sync_datetime = get_datetime(shopify_settings.last_sync_datetime)
		timezone = pytz.timezone(get_time_zone())
		timezone_abbr = timezone.localize(last_sync_datetime, is_dst=False)
		return 'updated_at_min="{0} {1}"'.format(last_sync_datetime.strftime("%Y-%m-%d %H:%M:%S"), timezone_abbr.tzname())
	return ''

Fixed code

def get_filtering_condition():
	shopify_settings = get_shopify_settings()
	if shopify_settings.last_sync_datetime:

		last_sync_datetime = get_datetime(shopify_settings.last_sync_datetime)
		timezone = pytz.timezone(get_time_zone())
		timezone_abbr = timezone.localize(last_sync_datetime, is_dst=False)

		utc_dt = timezone_abbr.astimezone (pytz.utc)
		return 'updated_at_min="{0}"'.format(utc_dt.strftime("%Y-%m-%d %H:%M:%S"))

	return ''

zia · March 27, 2018, 6:10am

Dear @vinhnguyent090 I don’t have in the path ‘erpnext_shopify/erpnext_shopify/shopify_requests.py’ the function def get_filtering_condition():

please tell me what to do

vinhnguyent090 · March 27, 2018, 6:41am

Hi pls check again,

github.com

frappe/erpnext_shopify/blob/develop/erpnext_shopify/shopify_requests.py

from __future__ import unicode_literals
import frappe
from frappe import _
import json, math, time, pytz
from .exceptions import ShopifyError
from frappe.utils import get_request_session, get_datetime, get_time_zone

def check_api_call_limit(response):
	"""
		This article will show you how to tell your program to take small pauses
		to keep your app a few API calls shy of the API call limit and
		to guard you against a 429 - Too Many Requests error.

		ref : https://docs.shopify.com/api/introduction/api-call-limit
	"""
	if response.headers.get("HTTP_X_SHOPIFY_SHOP_API_CALL_LIMIT") == 39:
		time.sleep(10)    # pause 10 seconds

def get_shopify_settings():
	d = frappe.get_doc("Shopify Settings")

This file has been truncated. show original

zia · March 27, 2018, 6:47am

See @vinhnguyent090 if I reset last sync date to last date, it works. means order syncing
is it that problem?

vinhnguyent090 · March 27, 2018, 6:49am

Hi @zia

yes. you can check again and next sync (after 1 hour)

zia · March 27, 2018, 12:24pm

Dear @vinhnguyent090 I’v done what you said but it didn’t solve the problem
now even if I change the time to past does not sync the created order
can you please tell me what is wrong at all

vinhnguyent090 · March 27, 2018, 12:44pm

Hi @zia
Current I don’t know why your app can’t sync orders.
Or you can test access link to get order json. It return orders or not. Link get order json you can check in shopify app.

zia · March 28, 2018, 9:53am

Thanks a lot its fixed now!!!

vinhnguyent090 · March 28, 2018, 10:06am

Hi you can share what problem with your app. And how you can fix it. Thanks.