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

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





Traceback (most recent call last):
  File "/home/frappe/benches/bench-2017-02-27/apps/erpnext_shopify/erpnext_shopify/", 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/", 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/", 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/", line 148, in sql
  File "/home/frappe/benches/bench-2017-02-27/env/lib/python2.7/site-packages/MySQLdb/", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/home/frappe/benches/bench-2017-02-27/env/lib/python2.7/site-packages/MySQLdb/", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'shopify_description' in 'field list'")

Request Data


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

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

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?

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 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.

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