订单API的转化来源参数,部分订单值缺失
同一个商城的订单,用订单接口进行相同的参数请求,有些订单能获取到订单的转化来源——
举例子:下面标记蓝色的是转化来源,
#LOX1021 products/vibration-9-mode-clip-suction-penis-pump?omnisendContactID=60a169811215fa09e6489c8d&utm_campaign=campaign: LZY-Miwantshop-lovesexs-toys20-review-2022.6.24 (62b524ad89d66d0019d2cef0)&utm_medium=email&utm_source=omnisend
select * from shopify_database.table_shopify_order where alias_name = ‘#LOX1021’;
select * from shopify_database.table_shopify_hook_orders where shopify_orderid =‘5029427871905’;
有些订单无法获取到转换来源,如下订单
#LOX1012 无
select * from shopify_database.table_shopify_order where alias_name = ‘#LOX1012’;
select * from shopify_database.table_shopify_hook_orders where shopify_orderid =‘5026761113761’;
#LOX1024 无
select * from shopify_database.table_shopify_order where alias_name = ‘#LOX1024’;
select * from shopify_database.table_shopify_hook_orders where shopify_orderid =‘5031200981153’;