轻易云集成平台、旺店通·企业版通过接口配置数据对接

数据源平台:轻易云集成平台
使用全界面可视化配置集成流,快速应对企业的集成需求使得系统与系统之间的数据接口一站式的快速集成能力,构建企业数据通道,解决数据孤岛问题。快速构建企业元数据标准、主数据标准、业财数据标准,完成数据的采集、统一、分发、清洗、归集等,帮助企业建立高质量的数据中台。目前轻易云平台已经支持300+系统,同时具备快速适配新系统的能力,集成海量接口数据。无论是对接ERP还是MES、OA、CRM、WMS、OMS等等系统,都可以通过接口相互集成。
对接目标系统:旺店通·企业版
旺店通是北京掌上先机网络科技有限公司旗下品牌,国内的零售云服务提供商,基于云计算SaaS服务模式,以体系化解决方案,助力零售企业数字化智能化管理升级。为零售电商企业的订单管理及仓储管理提供解决方案,致力于帮助企业实现数字化转型,企业规模化发展
数据对接方案
数据集成平台对应的配置轻易云集成平台与旺店通·企业版的对接只要三步就能完成两个系统之间的数据对接。第一步根据轻易云集成平台的接口参数要求记录在轻易云集成平台。第二步配置轻易云集成平台与旺店通·企业版之间的字段对应关系(更多方案可借鉴轻易云数据集成社区论坛中找到相关方案信息)第三步完成方案的检查参数设置:传递时间、重试次数、是否启动、前置条件等上线运行。

轻易云集成平台接口明细
- 接口:OpenCallback
- 接口名称:开放式的回调方法
- 接口方法:POST
响应参数
字段 | 名称 | 类型 | 描述 |
bad_reason | bad_reason | string | autoFillResponse |
batch_no | batch_no | string | _autoFillResponse |
block_reason | block_reason | string | autoFillResponse |
buyer_message | buyer_message | string | _autoFillResponse |
calc_post_cost | calc_post_cost | string | autoFillResponse |
calc_weight | calc_weight | string | _autoFillResponse |
checker_name | checker_name | string | autoFillResponse |
checkouter_id | checkouter_id | string | _autoFillResponse |
cod_amount | cod_amount | string | autoFillResponse |
consign_status | consign_status | string | _autoFillResponse |
consign_time | consign_time | string | autoFillResponse |
consigner_id | consigner_id | string | _autoFillResponse |
created | created | string | autoFillResponse |
cs_remark | cs_remark | string | _autoFillResponse |
currency | currency | string | autoFillResponse |
custom_type | custom_type | string | _autoFillResponse |
customer_id | customer_id | string | autoFillResponse |
customer_name | customer_name | string | _autoFillResponse |
customer_no | customer_no | string | autoFillResponse |
delivery_term | delivery_term | string | _autoFillResponse |
details_list | details_list | string | autoFillResponse |
discount | discount | string | _autoFillResponse |
ebill_status | ebill_status | string | autoFillResponse |
employee_no | employee_no | string | _autoFillResponse |
error_info | error_info | string | autoFillResponse |
examiner_id | examiner_id | string | _autoFillResponse |
examiner_name | examiner_name | string | autoFillResponse |
examiner_no | examiner_no | string | _autoFillResponse |
fenxiao_nick | fenxiao_nick | string | autoFillResponse |
fenxiao_type | fenxiao_type | string | _autoFillResponse |
flag_id | flag_id | string | autoFillResponse |
flag_name | flag_name | string | _autoFillResponse |
freeze_reason | freeze_reason | string | autoFillResponse |
fullname | fullname | string | _autoFillResponse |
goods_count | goods_count | string | autoFillResponse |
goods_total_amount | goods_total_amount | string | _autoFillResponse |
goods_total_cost | goods_total_cost | string | autoFillResponse |
goods_type_count | goods_type_count | string | _autoFillResponse |
has_invoice | has_invoice | string | autoFillResponse |
id_card | id_card | string | _autoFillResponse |
id_card_type | id_card_type | string | autoFillResponse |
invoice_content | invoice_content | string | _autoFillResponse |
invoice_id | invoice_id | string | autoFillResponse |
invoice_print_status | invoice_print_status | string | _autoFillResponse |
invoice_title | invoice_title | string | autoFillResponse |
invoice_type | invoice_type | string | _autoFillResponse |
is_allocated | is_allocated | string | autoFillResponse |
lock_id | lock_id | string | _autoFillResponse |
logistics_code | logistics_code | string | autoFillResponse |
logistics_id | logistics_id | string | _autoFillResponse |
logistics_name | logistics_name | string | autoFillResponse |
logistics_no | logistics_no | string | _autoFillResponse |
logistics_print_status | logistics_print_status | string | autoFillResponse |
logistics_template_id | logistics_template_id | string | _autoFillResponse |
logistics_type | logistics_type | string | autoFillResponse |
md5_str | md5_str | string | _autoFillResponse |
modified | modified | string | autoFillResponse |
nick_name | nick_name | string | _autoFillResponse |
note_count | note_count | string | autoFillResponse |
operator_id | operator_id | string | _autoFillResponse |
operator_name | operator_name | string | autoFillResponse |
order_no | order_no | string | _autoFillResponse |
order_type | order_type | string | autoFillResponse |
order_type_name | order_type_name | string | _autoFillResponse |
outer_no | outer_no | string | autoFillResponse |
pack_score | pack_score | string | _autoFillResponse |
package_cost | package_cost | string | autoFillResponse |
package_fee | package_fee | string | _autoFillResponse |
package_id | package_id | string | autoFillResponse |
packager_id | packager_id | string | _autoFillResponse |
packager_name | packager_name | string | autoFillResponse |
packager_no | packager_no | string | _autoFillResponse |
paid | paid | string | autoFillResponse |
pay_time | pay_time | string | _autoFillResponse |
pick_error_count | pick_error_count | string | autoFillResponse |
pick_score | pick_score | string | _autoFillResponse |
picker_id | picker_id | string | autoFillResponse |
picker_name | picker_name | string | _autoFillResponse |
picker_no | picker_no | string | autoFillResponse |
picklist_no | picklist_no | string | _autoFillResponse |
picklist_print_status | picklist_print_status | string | autoFillResponse |
picklist_seq | picklist_seq | string | _autoFillResponse |
platform_id | platform_id | string | autoFillResponse |
pos_allocate_mode | pos_allocate_mode | string | _autoFillResponse |
post_amount | post_amount | string | autoFillResponse |
post_cost | post_cost | string | _autoFillResponse |
post_fee | post_fee | string | autoFillResponse |
post_weight | post_weight | string | _autoFillResponse |
pre_charge_time | pre_charge_time | string | autoFillResponse |
print_batch_no | print_batch_no | string | _autoFillResponse |
print_remark | print_remark | string | autoFillResponse |
printer_id | printer_id | string | _autoFillResponse |
printer_name | printer_name | string | autoFillResponse |
printer_no | printer_no | string | _autoFillResponse |
raw_goods_count | raw_goods_count | string | autoFillResponse |
reason_id | reason_id | string | _autoFillResponse |
receivable | receivable | string | autoFillResponse |
receiver_address | receiver_address | string | _autoFillResponse |
receiver_area | receiver_area | string | autoFillResponse |
receiver_city | receiver_city | string | _autoFillResponse |
receiver_city_code | receiver_city_code | string | autoFillResponse |
receiver_country | receiver_country | string | _autoFillResponse |
receiver_district | receiver_district | string | autoFillResponse |
receiver_district_code | receiver_district_code | string | _autoFillResponse |
receiver_dtb | receiver_dtb | string | autoFillResponse |
receiver_mobile | receiver_mobile | string | _autoFillResponse |
receiver_name | receiver_name | string | autoFillResponse |
receiver_province | receiver_province | string | _autoFillResponse |
receiver_province_code | receiver_province_code | string | autoFillResponse |
receiver_ring | receiver_ring | string | _autoFillResponse |
receiver_telno | receiver_telno | string | autoFillResponse |
receiver_zip | receiver_zip | string | _autoFillResponse |
refund_status | refund_status | string | autoFillResponse |
remark | remark | string | _autoFillResponse |
reserve | reserve | string | autoFillResponse |
salesman_name | salesman_name | string | _autoFillResponse |
salesman_no | salesman_no | string | autoFillResponse |
sendbill_print_status | sendbill_print_status | string | _autoFillResponse |
sendbill_template_id | sendbill_template_id | string | autoFillResponse |
shop_name | shop_name | string | _autoFillResponse |
shop_no | shop_no | string | autoFillResponse |
shop_remark | shop_remark | string | _autoFillResponse |
sorter_id | sorter_id | string | autoFillResponse |
src_order_id | src_order_id | string | _autoFillResponse |
src_order_no | src_order_no | string | autoFillResponse |
src_order_type | src_order_type | string | _autoFillResponse |
src_tids | src_tids | string | autoFillResponse |
src_trade_no | src_trade_no | string | _autoFillResponse |
status | status | string | autoFillResponse |
stock_check_time | stock_check_time | string | _autoFillResponse |
stockout_id | stockout_id | string | autoFillResponse |
stockout_no | stockout_no | string | _autoFillResponse |
stockout_reason | stockout_reason | string | autoFillResponse |
stockout_receiver_dtb | stockout_receiver_dtb | string | _autoFillResponse |
subtype | subtype | string | autoFillResponse |
tax | tax | string | _autoFillResponse |
tax_rate | tax_rate | string | autoFillResponse |
to_deliver_time | to_deliver_time | string | _autoFillResponse |
trade_id | trade_id | string | autoFillResponse |
trade_no | trade_no | string | _autoFillResponse |
trade_status | trade_status | string | autoFillResponse |
trade_time | trade_time | string | _autoFillResponse |
trade_type | trade_type | string | autoFillResponse |
unknown_goods_amount | unknown_goods_amount | string | _autoFillResponse |
warehouse_id | warehouse_id | string | autoFillResponse |
warehouse_name | warehouse_name | string | _autoFillResponse |
warehouse_no | warehouse_no | string | autoFillResponse |
warehouse_type | warehouse_type | string | _autoFillResponse |
watcher_id | watcher_id | string | autoFillResponse |
weight | weight | string | _autoFillResponse |
wms_status | wms_status | string | autoFillResponse |
tid | tid | string | _autoFillResponse |
kuaidi100Data | kuaidi100Data | object | autoFillResponse |
kuaidi100Data.message | message | string | _autoFillResponse |
kuaidi100Data.nu | nu | string | autoFillResponse |
kuaidi100Data.ischeck | ischeck | string | _autoFillResponse |
kuaidi100Data.com | com | string | autoFillResponse |
kuaidi100Data.status | status | string | _autoFillResponse |
kuaidi100Data.data | data | string | autoFillResponse |
kuaidi100Data.state | state | string | _autoFillResponse |
kuaidi100Data.condition | condition | string | autoFillResponse |
kuaidi100Data.routeInfo | routeInfo | string | _autoFillResponse |
kuaidi100Data.isLoop | isLoop | string | autoFillResponse |
kuaidi100Data.tid | tid | string | _autoFillResponse |
旺店通·企业版接口明细
- 调用接口:trade_push
- 接口名称:创建调拨入库单
- 方法:POST
请求参数
字段 | 字段名称 | 类型 | 配置值 |
tid | 原始单号 | string | {{tid}} |
trade_status | 平台状态 | string | _function case when '{{kuaidi100Data.state}}' in ('301','302','303','304','3','501') then '70' else '{{trade_status}}' end |
pay_status | 支付状态 | string | {{pay_status}} |
delivery_term | 发货条件 | string | 3 |
trade_time | 下单时间 | datetime | {{trade_time}} |
pay_time | 支付时间 | datetime | {{pay_time}} |
fenxiao_type | 分销类别 | string | |
purchase_id | 采购单ID | string | |
fenxiao_nick | 分销商id | string | |
buyer_nick | 客户网名 | string | {{buyer_nick}} |
buyer_email | 买家email | string | |
pay_id | 支付单号 | string | |
pay_account | 支付账号 | string | |
receiver_name | 收件人 | string | {{receiver_name}} |
receiver_address | 地址详情 | string | {{receiver_address}} |
receiver_province | 省份 | string | {{receiver_province}} |
receiver_city | 城市 | string | {{receiver_city}} |
receiver_district | 区县 | string | {{receiver_district}} |
receiver_mobile | 手机 | string | {{receiver_mobile}} |
receiver_telno | 电话 | string | {{FLINKPHONE}} |
receiver_zip | 邮编 | string | |
logistics_type | 物流方式 | string | -1 |
invoice_kind | 发票类别 | string | |
invoice_title | 发票抬头 | string | |
invoice_content | 发票内容 | string | |
remark_flag | 客户备注标旗 | string | |
buyer_message | 买家备注 | string | {{FNote}} |
seller_memo | 客服备注 | string | {{FCustId_FName}} |
seller_flag | 标旗 | string | |
post_amount | 邮费 | string | {{post_amount}} |
cod_amount | 货到付款金额 | string | {{cod_amount}} |
ext_cod_fee | 货到付款买家费用 | string | {{ext_cod_fee}} |
other_amount | 其它收费 | string | {{other_amount}} |
paid | 已付 | string | 1.0000 |
is_auto_wms | 自动流转模式 | string | |
warehouse_no | 仓库编号 | string | {{warehouse_no}} |
order_list | 订单货品明细节点 | array | details_list |
order_list.oid | 子订单编号 | string | {{details_list.src_oid}} |
order_list.num | 数量 | string | {{details_list.num}} |
order_list.price | 单价 | string | {{details_list.price}} |
order_list.status | 状态 | string | {{status}} |
order_list.refund_status | 退款状态 | string | {{refund_status}} |
order_list.goods_id | 平台货品ID | string | {{details_list.goods_id}} |
order_list.spec_id | 平台规格ID | string | {{details_list.spec_id}} |
order_list.goods_no | 货品编码 | string | {{details_list.goods_no}} |
order_list.spec_no | 规格编码 | string | {{details_list.spec_no}} |
order_list.goods_name | 货品名称 | string | {{details_list.goods_name}} |
order_list.spec_name | 规格名称 | string | {{details_list.spec_name}} |
order_list.adjust_amount | 调整 | string | |
order_list.discount | 优惠 | string | |
order_list.share_discount | 分摊优惠 | string | |
order_list.remark | 备注 | string | {{details_list.FAllAmount}} |
order_list.cid | 类目 | string | |
order_list.trade_list | trade_list | array | |
order_list.shop_no | shop_no | string | 005 |
order_list.switch | switch | string | 1 |
数据对接效果
将传统的统计分析转变为预测分析,从被动分析到主动分析,从非实时分析转变为实时分析,从结构化的数据变成多元化的数据。精准查询数据流同步状况,实时监管队列任务以及数据资产的有序管理。为业务赋能,降本增效,让企业能够更加合理的布局团队;结合业务需求实现与OA,CRM,WMS等系统之间的数据交流与同步,为企业定制自定义的数据管理方案,用技术拓展商业边界,为新业务、新部门提供成长空间。
