Hi,
I have received this error on my first sync to shopify. Any idea on how to fix this?
Traceback (most recent call last):
File "/opt/bench/erpnext/apps/erpnext_shopify/erpnext_shopify/api.py", line 32, in sync_shopify_resources
sync_products(shopify_settings.price_list, shopify_settings.warehouse)
File "/opt/bench/erpnext/apps/erpnext_shopify/erpnext_shopify/sync_products.py", line 18, in sync_products
sync_erpnext_items(price_list, warehouse, shopify_item_list)
File "/opt/bench/erpnext/apps/erpnext_shopify/erpnext_shopify/sync_products.py", line 338, in sync_erpnext_items
for item in get_erpnext_items(price_list):
File "/opt/bench/erpnext/apps/erpnext_shopify/erpnext_shopify/sync_products.py", line 366, in get_erpnext_items
erpnext_items.extend(frappe.db.sql(item_from_master, as_dict=1))
File "/opt/bench/erpnext/apps/frappe/frappe/database.py", line 209, in sql
self._cursor.execute(query)
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 893, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1103, in _read_query_result
result.read()
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1396, in read
first_packet = self.connection._read_packet()
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 1059, in _read_packet
packet.check_error()
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/opt/bench/erpnext/env/local/lib/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
InternalError: (1054, u"Unknown column 'default_supplier' in 'field list'")