libracore / WooCommerceConnector

Integration App for ERPNext to connect to WooCommerce
Other
85 stars 149 forks source link

InternalError(1054, "Unknown column 'barcode' in 'where clause'"), #26

Closed gsarunk closed 4 years ago

gsarunk commented 4 years ago

Getting the error while doing 'Sync Woocommerce Id to ERP'. Error: image

Actual Place of Dump image

Possible reason: field name 'barcode' should be replaced with 'barcodes' image

Your response and fix awaited and Much appreciated

lasalesi commented 4 years ago

ERPNext has dropped the tabItem.barcode field in v12. Earlier installations will still have this.

To correct this, simply add (using Menu > Customize) a barcode field again to the Item doctype. You can fill this from e.g. the first line of the barcodes table (optionally).

I will make a note to add the barcode field in the item customisations for compatibility.

lasalesi commented 4 years ago

This should be included in the app customzation now (b200df5)

You can run bench update and this should be resolved