Woocommerce and woocommerce conector sync problem

eagoweb · July 24, 2020, 8:04pm

Thanks for all the efforts you’ve been giving to support this integration, here I have some troubles, hopefully you may have some way to know what’s going on

Current versions:

ERPNEXT V12.10.1
Frappe 12.8.3
Woocommerce 4.3.1

For now

‘Sync Woocommerce IDs to ERP’ duplicate products in draft in woocommerce every time you sync, ( all items with the sync to woocommerce check selected*).
Sync woocommerce ends in error:

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/woocommerceconnector/woocommerceconnector/sync_products.py”, line 132, in sync_erpnext_items
sync_item_with_woocommerce(item, price_list, warehouse, woocommerce_item_list.get(item.get(‘woocommerce_product_id’)))
File “/home/frappe/frappe-bench/apps/woocommerceconnector/woocommerceconnector/sync_products.py”, line 243, in sync_item_with_woocommerce
sync_item_image(erp_item)
File “/home/frappe/frappe-bench/apps/woocommerceconnector/woocommerceconnector/sync_products.py”, line 270, in sync_item_image
post_request(“products/{0}”.format(item.woocommerce_product_id), image_info)
File “/home/frappe/frappe-bench/apps/woocommerceconnector/woocommerceconnector/woocommerce_requests.py”, line 69, in post_request
r.raise_for_status()
File “/home/frappe/frappe-bench/env/lib/python3.7/site-packages/requests/models.py”, line 940, in raise_for_status
raise HTTPError(http_error_msg, response=self)
requests.exceptions.HTTPError: 400 Client Error: Bad Request for url: https://[[ WEBSITE LINK]]/wp-json/wc/v3/products/169

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File “/home/frappe/frappe-bench/apps/woocommerceconnector/woocommerceconnector/api.py”, line 41, in sync_woocommerce_resources
sync_products(woocommerce_settings.price_list, woocommerce_settings.warehouse)
File “/home/frappe/frappe-bench/apps/woocommerceconnector/woocommerceconnector/sync_products.py”, line 19, in sync_products
sync_erpnext_items(price_list, warehouse, woocommerce_item_list)
File “/home/frappe/frappe-bench/apps/woocommerceconnector/woocommerceconnector/sync_products.py”, line 139, in sync_erpnext_items
make_woocommerce_log(title=e.message, status=“Error”, method=“sync_woocommerce_items”, message=frappe.get_traceback(),
AttributeError: ‘HTTPError’ object has no attribute ‘message’

Also I wanted to ask, is there a way to sync pictures too?

@EnSeal @zerodiscount

lasalesi · July 27, 2020, 7:51am

Are you using the barcode field wo match the items? This is usually a rather stable way and should not give you double products. The bad request error occurs when you are trying to sync stock against an invalid product key in WooCommerce. Please check the WooCommerce Ids stored in ERPNext, you will find an ID that actually is not in WooCommerce (or a product that is set to sync stock but has no WooCommerce-ID).

The image function in WooCommerce is somewhat more powerful than in ERPNext, therefore, a simple sync of the images. However, the first image from WooCommerce should be synced to new items created in ERPNext. Is that what you are looking for (or the other way round)?

eagoweb · July 29, 2020, 2:38am

Yes I am using barcode fields, but is my first sync so I won’t have any products in WooCommerce end, Do I have to make a first product upload first maybe through CSV?

eagoweb · July 30, 2020, 5:21am

Awesome working! I had to match the barcode.

Can we use item_code instead of the barcode?

Also can you point me out in the code where can I add more fields to sync, like tags, item group, item group parent?

lasalesi · July 30, 2020, 5:29am

Great to hear! I guess especially the latest release with the improved error handling should have brought light into this.

We do not use item code because it is used more freely within ERPNext. But you can use any unique code.

Look at the sync_products.py file for the variables on the interface:

github.com

libracore/WooCommerceConnector/blob/master/woocommerceconnector/sync_products.py

from __future__ import unicode_literals
import frappe
from frappe.utils import cstr
from frappe import _
import requests.exceptions
from .exceptions import woocommerceError
from .utils import make_woocommerce_log, disable_woocommerce_sync_for_item
from erpnext.stock.utils import get_bin
from frappe.utils import cstr, flt, cint, get_files_path
from .woocommerce_requests import post_request, get_woocommerce_items,get_woocommerce_item_variants,  put_request, get_woocommerce_item_image
import base64, requests, datetime, os
from frappe.utils import get_datetime
import json

woocommerce_variants_attr_list = ["option1", "option2", "option3"]

def sync_products(price_list, warehouse, sync_from_woocommerce=False):
    woocommerce_settings = frappe.get_doc("WooCommerce Config", "WooCommerce Config")
    woocommerce_item_list = []
    if sync_from_woocommerce:

This file has been truncated. show original

Muzzy · July 25, 2021, 12:46pm

hi @lasalesi

Does WooCommece also sync images? Currently we set images on WooCommerce website not on ERPNext. I get this error in ERPNext WooCom log however sync of all other information is perfectly fine.

Error Title
WooCommerce post error 400

Message
http://XXXXX/wp-json/wc/v3/products/5747?oauth_consumer_key=ck_cf06cbe4b9f0de1827cd4fb9fd2dd30c4f533efd&oauth_timestamp=1627214457&oauth_nonce=b1eb75bf4cab4484f30677db7a704d8fbd41da7f&oauth_signature_method=HMAC-SHA256&oauth_signature=7uTz5FazRywo6Ltb7weDWVBkfZ1L%2BUKCd2%2FiZPl3LnY%3D: {'code': 'woocommerce_product_image_upload_error', 'message': 'Error getting remote image https://woocom.com/files/CP_SMOKEGREEN%202020-10-12%2013:21:42.JPG. Error: cURL error 7: Failed to connect to woocom.com port 443: Connection refused', 'data': {'status': 400}}

Request Data
{"images": [{"src": "https://woocom.com/files/CP_SMOKEGREEN 2020-10-12 13:21:42.JPG", "position": 0}]}

FYI we have not set SSL on WooComm yet but I see that message is showing https instead of http. This error is on all products. Kindly let me know what your thoughts are and where should I start to fix the issue. Thank you.

lasalesi · July 27, 2021, 12:18pm

Hi @Muzzy,

thanks for your message. Yes, images should also be synced from the WooCommerce image to ERPNext (mostly, pictures are rather in WooCommerce than ERPNext). It will only take the first (feature image) image…

github.com

libracore/WooCommerceConnector/blob/77ca7261050167f7c2b1d25a7782a560f356b1ac/woocommerceconnector/sync_products.py#L368


      
                          "price_list": price_list,
                          "item_code": name,
                          "price_list_rate": rate
                      }).insert()
                  else:
                      item_rate = frappe.get_doc("Item Price", item_price_name)
                      item_rate.price_list_rate = rate
                      item_rate.save()
          
          

          
def get_item_image(woocommerce_item):
              if woocommerce_item.get("images"):
                  for image in woocommerce_item.get("images"):
                      if image.get("position") == 0: # the featured image
                          return image
                      return None
              else:
                  return None
          
          
def get_item_details(woocommerce_item):
              item_details = {}

The connector will always try to connect with https…

Muzzy · July 27, 2021, 12:41pm

Thank you for the clarification. Now I get it. I have image on ERPNext as well as it is used for quotation and sales invoice print for retail (POS) and B2B sales. WooCommerce is 3rd sales channel.

So i guess the error is due to image already existing in ERPNext and image also coming in from WooCommerce site.

I guess the error message needs to be more self explanatory

We are in testing phase that’s why no domain yet or SSL. We are using IP. In production we will set domain and SSL.

One more issue we find is that if Item is ticked first without WooCommerce sync occuring and WooCommerce ID not being set then stock transfer to WooCommerce warehouse is not getting through. So we sync to get ID then it works fine. Else we make sure stock is transferred, price and description is set and then tick the 2 WooCommerce fields.

SmartSelect_20210727-152450_WhatsApp|690x220

Muzzy · July 28, 2021, 10:41pm

I see this in my Error Log on every sync. Sync works fine. Checked everything, not able to make anything of it.

            `tabItem`.`name`, 
            `tabItem`.`item_code`, 
            `tabItem`.`item_name`, 
            `tabItem`.`item_group`, 
            `tabItem`.`description`,
            `tabItem`.`woocommerce_description`, 
            `tabItem`.`has_variants`, 
            `tabItem`.`variant_of`, 
            `tabItem`.`stock_uom`, 
            `tabItem`.`image`, 
            `tabItem`.`woocommerce_product_id`,
            `tabItem`.`woocommerce_variant_id`, 
            `tabItem`.`sync_qty_with_woocommerce`, 
            `tabItem`.`weight_per_unit`, 
            `tabItem`.`weight_uom`
        FROM `tabItem`, `tabItem Price`
        WHERE `tabItem Price`.`price_list` = 'WooCom' 
        AND `tabItem`.`name` = `tabItem Price`.`item_code`
        AND `tabItem`.`sync_with_woocommerce` = 1 
        AND (`tabItem`.`disabled` IS NULL OR `tabItem`.`disabled` = 0) AND `tabItem Price`.`modified` >= '2021-07-29 01:00:58.378009' ```

olamide_shodunke · January 20, 2023, 7:49am

Good day everyone

I keep getting the error message below when connecting ERPNext to a particular woocommerce site

/wp-json/wc/v3/settings: {‘code’: ‘woocommerce_rest_cannot_view’, ‘message’: ‘Sorry, you cannot list resources.’, ‘data’: {‘status’: 401}}

Has anyone else experienced this ? I have succesfully integrated a number of woocommerce sites to ERPNext, but this particular site is a pain.

Regards

wojosc · February 17, 2023, 7:41am

I am also getting this error. It did work at some point and then suddenly stopped. Maybe connected to a newer version of ERPNext. We really can’t identify that right now.

Leo_Sarmiento · February 23, 2023, 4:31pm

Check the connection credentials in Woocommerce and in the connector.

wojosc · February 23, 2023, 4:42pm

thanks for the input. We have recreated the tokens/keys and reset URL to. No change

Muzzy · February 24, 2023, 12:08pm

Mainly issue is from WooCommerce. Never could find which version works best. Have seen latest version to be fine while older version giving random issues which we never understood.