Integration with DEAR Inventory systems
complete
Mathieu Crete
Auto update Tracking Number in WooCommerce when new tracking number is added to orders from DEAR inventory systems
Zorem
complete
The Dear integration is available in the AST PRO fulfillment manager https://www.zorem.com/products/woocommerce-advanced-shipment-tracking/
Zorem
in progress
Zorem
planned
T
Trond Aasen
I am also using dearsystems.com to handle orders and stock, inside DEAR I add the shippingprovider and trackingnumber. This is connected via REST API.
Trackingnumber string is set and shippingprovider string is set:
tracking_number
tracking_provider
All the info reaches my Woo orderpage and is transfered from DEAR to Woo as it should.
I can see the trackingnumber and shipmentprovider inside Woo orderpage.
The thing that is not happening is that the info is not added to AST and therefore not added to the “order completed email”.
I have to go inside the order and manually copy the info, add it to the AST widget and then send the info again.
As requested from Zorem I have put my request here in the feature forum. DEAR did not want to do any changes at this point.
zorem (@zorem)
1 hour, 54 minutes ago 10.06.2021
Hi, We can check the if we can add integration with Dear to the Advanced Shipment Tracking Pro on our end and to identify their API calls and auto-Complete the orders that they update from the API (change to Shipped). You can request this features on the AST features board.
Zorem
Trond Aasen: Can you share image of the Tracking Info display on the order page, is that in the order notes?
T
Trond Aasen
Zorem: See attached screenshot from Woo order page, you can see the tracking_number is there and tracking_provider as well. This info is sendt by DEAR to Woo. On the Left you have the AST widget (SPORING), the info does not automatic go there, today I have to manualy copy the number and choose delivery company.
Hope this helps, if anything else you need I will help.
Zorem
Trond Aasen: on the left side its our meta fields after you add the tracking manually, I need to see how they update the order notes with the tracking, this panel is closed in your screenshot.
T
Trond Aasen
Zorem: Hi, can we do a shared screen so you can see and get all the info you need?
Zorem
Trond Aasen: We have this features board for that.
T
Trond Aasen
Zorem: Ok. got it. But the metafields on the left side where it says tracking_number and next colum 70722150652521670 and below tracking_provider Bring is not manually added, they are transfered from DEAR to Woo. It is those I then copy and add to the SPORING field on the right.
Zorem
Trond Aasen: Please see my request on the order notes, this is very simple, I need to see the order notes panel open to see how the Dear inventory update the order notes with the tracking.
T
Trond Aasen
Zorem: Just did :-)
T
Trond Aasen
Zorem: Hi, any news on this request? Something else you need from me?
Zorem
Trond Aasen: Since I see they update the order notes with tracking info but its in a language I can't understand, the next step will be to identify how they update the WooCommerce API. You can try to install a plugin that logs all the API calls on your store (https://wordpress.org/plugins/wp-rest-api-log/), then print a label with Dear and check the API log for this order, find out the one they update the order notes with the tracking info and share the complete API call so we can find out how to grab the tracking number / provider from their API call..
T
Trond Aasen
Zorem: Here you go, I have only deleted customer contact information.
RESPONSE BODY
{
"data": {
"id": 42798,
"parent_id": 0,
"status": "completed",
"currency": "NOK",
"version": "5.4.1",
"prices_include_tax": false,
"date_created": "2021-06-16T14:39:11",
"date_modified": "2021-06-16T14:45:15",
"discount_total": "0.00",
"discount_tax": "0.00",
"shipping_total": "0.00",
"shipping_tax": "0.00",
"cart_tax": "168.00",
"total": "840.00",
"total_tax": "168.00",
"customer_id": 132,
"order_key": "wc_order_OSL9VCTaF0uyQ",
"billing": {
"first_name": "",
"last_name": "",
"company": "",
"address_1": "",
"address_2": "",
"city": "",
"state": "",
"postcode": "",
"country": "",
"email": "",
"phone": "+"
},
"shipping": {
"first_name": "",
"last_name": "",
"company": "",
"address_1": "",
"address_2": "",
"city": "",
"state": "",
"postcode": "",
"country": ""
},
"payment_method": "",
"payment_method_title": "",
"transaction_id": "",
"customer_ip_address": "",
"customer_user_agent": "",
"created_via": "admin",
"customer_note": "",
"date_completed": "2021-06-16T14:45:15",
"date_paid": "2021-06-16T14:41:15",
"cart_hash": "",
"number": "42798",
"meta_data": [
{
"id": 386549,
"key": "_new_order_email_sent",
"value": "true"
},
{
"id": 388149,
"key": "tracking_number",
"value": "70722150656203206"
},
{
"id": 388150,
"key": "tracking_provider",
"value": "Bring"
}
],
"line_items": [
{
"id": 853,
"name": "Granberg 111.0300 Chemstar kjemikaliehansker vinyl/pvc - 8",
"product_id": 7088,
"variation_id": 7091,
"quantity": 24,
"tax_class": "",
"subtotal": "672.00",
"subtotal_tax": "168.00",
"total": "672.00",
"total_tax": "168.00",
"taxes": [
{
"id": 1,
"total": "168",
"subtotal": "168"
}
],
"meta_data": [
{
"id": 7737,
"key": "pa_storrelse",
"value": "8",
"display_key": "Stu00f8rrelse",
"display_value": "8"
},
{
"id": 7738,
"key": "wcpoa_order_attachment_order_arr",
"value": {
"wcpoa_attachment_ids": [
"7buy985tfq1o0",
""
],
"wcpoa_attachment_name": [
"Datablad 111.0300",
""
],
"wcpoa_att_order_description": [
"",
""
],
"wcpoa_attachment_url": [
"6788",
""
],
"wcpoa_attach_type": [
"file_upload",
"file_upload"
],
"wcpoa_order_status": "wc-all",
"wcpoa_expired_date_enable": [
"no",
"no"
],
"wcpoa_order_attachment_expired": [
"",
""
]
},
"display_key": "wcpoa_order_attachment_order_arr",
"display_value": {
"wcpoa_attachment_ids": [
"7buy985tfq1o0",
""
],
"wcpoa_attachment_name": [
"Datablad 111.0300",
""
],
"wcpoa_att_order_description": [
"",
""
],
"wcpoa_attachment_url": [
"6788",
""
],
"wcpoa_attach_type": [
"file_upload",
"file_upload"
],
"wcpoa_order_status": "wc-all",
"wcpoa_expired_date_enable": [
"no",
"no"
],
"wcpoa_order_attachment_expired": [
"",
""
]
}
},
{
"id": 7745,
"key": "_reduced_stock",
"value": "24",
"display_key": "_reduced_stock",
"display_value": "24"
}
],
"sku": "111.0300 8",
"price": 28,
"parent_name": "Granberg 111.0300 Chemstar kjemikaliehansker vinyl/pvc"
}
],
"tax_lines": [
{
"id": 854,
"rate_code": "NO-MVA-1",
"rate_id": 1,
"label": "MVA",
"compound": false,
"tax_total": "168.00",
"shipping_tax_total": "0.00",
"rate_percent": 25,
"meta_data": []
}
],
"shipping_lines": [],
"fee_lines": [],
"coupon_lines": [],
"refunds": [],
"date_created_gmt": "2021-06-16T12:39:11",
"date_modified_gmt": "2021-06-16T12:45:15",
"date_completed_gmt": "2021-06-16T12:45:15",
"date_paid_gmt": "2021-06-16T12:41:15",
"currency_symbol": "kr"
},
"headers": {
"Allow": "GET, POST, PUT, PATCH, DELETE"
},
"status": 200
}
T
Trond Aasen
Some more info BODY CONTENT:
{"id":42798,"status":"completed","meta_data":[{"key":"tracking_number","value":"70722150656203206"},{"key":"tracking_provider","value":"Bring"}]}
T
Trond Aasen
Zorem: Hi, did you get what you needed? Anything else I need to provide?
Zorem
Trond Aasen: Hi, This is the info we needed in order to know how they update the WooCommerce API, they use the orders endpoint and create custom order meta for the tracking_number and tracking_provider and we will need to develop a process that knows to pick this info into the AST meta fields when they do updates. we are releasing a version of the AST PRO in the next days and we will check if we can add it for the following version of the AST PRO.
T
Trond Aasen
Zorem: Hi, sounds great! If you want me to BETA test I can do as well.
Zorem
Trond Aasen: Ok, sure, I will reach out as soon as we develop to get your help with beta. But it will also help if you get the PRO and become our customer, it will be an incentive for us to prioritize this task :)
T
Trond Aasen
Zorem: Hi, off cource! When this works I will absolutely buy the PRO version :-). Need it on two sites that is connected to DEAR.
Zorem
Trond Aasen:Sure, This integration is in the queue for one of the next versions, depending on priority, you will get a notification here once there is any news.
T
Trond Aasen
Zorem: Great, then I wait for it and in the meanwhile just do as before - copy and paste :-)
Mathieu Crete
Zorem: Same here, I'll buy the PRO version for 5 sites if this work. I can beta test it as well!