Shopify Connector: OperationalError: (1054, "Unknown column 'shopify_description' in 'field list'")

Frappe Framework Bug
1

After initial setup of Shopify Connector with public ERPNext app from Shopify store, synchronization is failing with Last sync request was failed, check here

Status
Error

Method

sync_shopify_resources

Message

Traceback (most recent call last):
  File "/home/frappe/benches/bench-2017-02-27/apps/erpnext_shopify/erpnext_shopify/api.py", line 32, in sync_shopify_resources
    sync_products(shopify_settings.price_list, shopify_settings.warehouse)
  File "/home/frappe/benches/bench-2017-02-27/apps/erpnext_shopify/erpnext_shopify/sync_products.py", line 18, in sync_products
    sync_erpnext_items(price_list, warehouse, shopify_item_list)
  File "/home/frappe/benches/bench-2017-02-27/apps/erpnext_shopify/erpnext_shopify/sync_products.py", line 336, in sync_erpnext_items
    for item in frappe.db.sql(item_query, as_dict=1):
  File "/home/frappe/benches/bench-2017-02-27/apps/frappe/frappe/database.py", line 148, in sql
    self._cursor.execute(query)
  File "/home/frappe/benches/bench-2017-02-27/env/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/frappe/benches/bench-2017-02-27/env/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'shopify_description' in 'field list'")

Request Data

{}

Environment:
official SaaS
ERPNext: v7.2.27
ERPNext Shopify: v2.0.4
Frappe Framework: v7.2.26

2

Seems custom field shopify_description is missing. If custom field is not available, please add shopify_description field to item master.

3

Thank you for help, Saurabh. I’ve added shopify_description field and then other fields as well (like shopify_product_id and shopify_variant_id), but now traceback is showing that sync_qty_with_shopify field is missing. I suspect simply adding the checkbox for this field is not enough — there should be some script associated. Am I right?

4

Strange!!! :sweat: The system creates all these custom fields at the time of app installation.

If you are a cloud user, please drop a mail at support@erpnext.com with your domain URL.

If you are open source user, self-hosted, please run bench --site site-name migrate this will recreate all the missing custom fields.

5

I thought the same. We’re on official SaaS subscription, so I’m sending an email to support.
Thanks for help.