商品价格策略接口

参数名称 参数值
应用编码 product
应用版本 v1
接口名称 查询价格策略接口
接口编码 getProductPriceStrategy
接口URL https://openapi.waiqin365.com/api/product/v1/getProductPriceStrategy/{ openid }/{ timestamp }/{ digest }/{ msg_id }
请求信息 参数 类型 必填 说明
page_number INT 页码默认1,每页默认1000条
page_length INT 每页记录条数,默认最大是1000条,可以根据业务数据的大小自行优化调整
start_create_date TIMESTAMP 创建时间开始,格式:“yyyy-MM-dd HH:mm:ss”
end_create_date TIMESTAMP 创建时间结束,格式:“yyyy-MM-dd HH:mm:ss”
start_modify_date TIMESTAMP 修改时间开始,格式:“yyyy-MM-dd HH:mm:ss”
end_modify_date TIMESTAMP 修改时间结束,格式:“yyyy-MM-dd HH:mm:ss”
响应信息 参照表响应信息格式
msg_id String 消息ID
return_code int 响应编码:0成功 1失败
return_msg String 响应说明
response_data 响应数据体[{......}]
price_strategy_id VARCHAR(32) 规则id
status VARCHAR(1) 0:已删除,1:正常
creator_id VARCHAR(32) 创建人
create_time TIMESTAMP 创建时间,格式:“yyyy-MM-dd HH:mm:ss”
modifyier_id VARCHAR(32) 修改人
modify_time TIMESTAMP 修改时间,格式:“yyyy-MM-dd HH:mm:ss”
title VARCHAR(200) 标题
start_time TIMESTAMP 有效期开始时间,格式:“yyyy-MM-dd HH:mm:ss”
end_time TIMESTAMP 有效期结束时间,格式:“yyyy-MM-dd HH:mm:ss”
trade_type VARCHAR(2) 销售对象:1、客户,2、经销商,3、门店
trade_range VARCHAR(2) 销售范围:1、指定客户范围 2、指定具体客户
is_enable VARCHAR(2) 是否可用
product_type VARCHAR(2) 1:按商品,2:按同价码
basPdPriceStrategyCusFields(按范围设置)
basPdPriceStrategyCusFields.cus_field_id VARCHAR(32) id
basPdPriceStrategyCusFields.status VARCHAR(1) 0:已删除,1:正常
basPdPriceStrategyCusFields.creator_id VARCHAR(32) 创建人
basPdPriceStrategyCusFields.create_time TIMESTAMP 创建时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategyCusFields.modifyier_id VARCHAR(32) 修改人
basPdPriceStrategyCusFields.modify_time TIMESTAMP 修改时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategyCusFields.field_code VARCHAR(200) 范围类型编码
basPdPriceStrategyCusFields.field_name VARCHAR(200) 范围类型编码名称
basPdPriceStrategyCusFields.selected_item text 选择的范围类型对应的id(外勤365id)
basPdPriceStrategyCusFields.selected_code text 选择的范围类型对应的code(外勤365code)
basPdPriceStrategyCusFields.selected_item_text text 选择的范围类型对应的名称
basPdPriceStrategyProducts(按商品设置)
basPdPriceStrategyProducts.price_strategy_product_id VARCHAR(32) id
basPdPriceStrategyProducts.status VARCHAR(1) 0:已删除,1:正常
basPdPriceStrategyProducts.creator_id VARCHAR(32) 创建人
basPdPriceStrategyProducts.create_time TIMESTAMP 创建时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategyProducts.modifyier_id VARCHAR(32) 修改人
basPdPriceStrategyProducts.modify_time TIMESTAMP 修改时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategyProducts.pd_id VARCHAR(32) 商品id
basPdPriceStrategyProducts.pd_code VARCHAR(100) 商品code
basPdPriceStrategyProducts.pd_name VARCHAR(256) 商品name
basPdPriceStrategyProducts.input_unit VARCHAR(32) 录入单位id
basPdPriceStrategyProducts.input_unit_name VARCHAR(100) 录入单位name
basPdPriceStrategyProducts.sale_price numeric(15,8) 销售策略价
basPdPriceStrategyProducts.base_unit VARCHAR(32) 基本单位id
basPdPriceStrategyProducts.base_unit_name VARCHAR(100) 基本单位name
basPdPriceStrategyProducts.min_base_unit_num numeric(28,8) 起订量(录入数量转化成基本单位的数量)
basPdPriceStrategyProducts.min_num numeric(28,8) 起订量
basPdPriceStrategyProducts.max_base_unit_num numeric(28,8) 限订量(录入数量转化成基本单位的数量)
basPdPriceStrategyProducts.max_num numeric(28,8) 限订量
basPdPriceStrategyProducts.price_up numeric(28,8) 策略价上浮动
basPdPriceStrategyProducts.price_down numeric(28,8) 策略价下浮动
basPdPriceStrategySameCodes(按同价码设置)
basPdPriceStrategySameCodes.price_strategy_same_code_id VARCHAR(32) id
basPdPriceStrategySameCodes.status VARCHAR(1) 0:已删除,1:正常
basPdPriceStrategySameCodes.creator_id VARCHAR(32) 创建人
basPdPriceStrategySameCodes.create_time TIMESTAMP 创建时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategySameCodes.modifyier_id VARCHAR(32) 修改人
basPdPriceStrategySameCodes.modify_time TIMESTAMP 修改时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategySameCodes.same_price_code varchar(32) 同价码
basPdPriceStrategySameCodes.input_unit_name VARCHAR(100) 录入单位name
basPdPriceStrategySameCodes.sale_price numeric(28,8) 销售策略价
basPdPriceStrategySameCodes.min_base_unit_num numeric(28,8) 起订量(录入数量转化成基本单位的数量)
basPdPriceStrategySameCodes.min_num numeric(28,8) 起订量
basPdPriceStrategySameCodes.max_base_unit_num numeric(28,8) 限订量(录入数量转化成基本单位的数量)
basPdPriceStrategySameCodes.max_num numeric(28,8) 限订量
basPdPriceStrategySameCodes.price_up numeric(28,8) 策略价上浮动
basPdPriceStrategySameCodes.price_down numeric(28,8) 策略价下浮动
basPdPriceStrategyCuss(按客户设置)
basPdPriceStrategyCuss.price_strategy_cus_id VARCHAR(32) id
basPdPriceStrategyCuss.status VARCHAR(1) 0:已删除,1:正常
basPdPriceStrategyCuss.creator_id VARCHAR(32) 创建人
basPdPriceStrategyCuss.create_time TIMESTAMP 创建时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategyCuss.modifyier_id VARCHAR(32) 修改人
basPdPriceStrategyCuss.modify_time VARCHAR(32) 修改时间,格式:“yyyy-MM-dd HH:mm:ss”
basPdPriceStrategyCuss.cm_id VARCHAR(32) 客户id
basPdPriceStrategyCuss.cm_code VARCHAR(32) 客户code
basPdPriceStrategyCuss.cm_name VARCHAR(100) 客户name

请求消息体示例:
{
	"page_number":1,
	"page_length":1000,
	"start_create_date":"2018-08-11 00:00:00",
	"end_create_date":"2018-08-13 00:00:00",
	"start_modify_date":"2018-08-11 00:00:00",
	"end_modify_date":"2018-08-13 00:00:00"
}

响应信息示例:
{
    "return_code":"0",
    "return_msg":null,
    "msg_id":null,
    "response_data":[
    {
        "basPdPriceStrategyCusFields":[
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"4979556103081514064",
                "field_code":"dept_id",
                "field_name":"部门",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"5413971904313689661,5954366674468213302",
                "selected_item_text":"12qqq,11qqq",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"8288376007042223235",
                "field_code":"district_level",
                "field_name":"销售区域等级",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"6607275807085210917,8545708648846165721",
                "selected_item_text":"区域一级,区域二级",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"5494965676058802438",
                "field_code":"customer_level",
                "field_name":"客户级别",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"8715900737400193117,8783574560179216331,7287736961434231483",
                "selected_item_text":"A,B,C",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"8187012878749847224",
                "field_code":"type_id",
                "field_name":"客户类型",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"7968458325024557719,7453205613633003407,5956742668490842859",
                "selected_item_text":"柱子类型,美缝店,单点批发",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"9102985683946733927",
                "field_code":"district_id",
                "field_name":"销售区域",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"1,4806549509248390549,9033269349423299426,4752605905626817542,5172862724621820894,7878766441603271576,6785473900023654609,5995859948628215574,9169414679160463659,6773834101348215655,8786682329420901249,6195853786308036891,5372171151167711712,8874372792720561376,7304205221425696595,6960128143568984830,5710399329032315145,4804930406018092418,8489022005741326107,6806984620975186605,7428922093170555232,8533475929045161968,5906712671265363607,5100004136839045131,8284098494790711209,5010101877517354662,7806316745076661229,7138635441227236439,5815041733160833953,6097110251496906764,9025130784836963679,5696174322419711894,8955974180437968647,6747691676937226390,5195849651805980642,7526773239149343454,8740002155359438607,6963848895258915695,6850451088181149271,7065874705002694868,7783048511557988502,8778506838930814321,5823121226032629820,9188459084514376508,8867696563624985803,5865439157473931704,5527404313734044529,7296890691583075142,8930998420006522781,7070655248600579965,4902054486495703934,6801653132571983720,5529179932315498331,6603938152513443422,7872800272962472647,5880045821365020046,8913791271306861573,5151941004870826006,7263594792154791934,8324111440386071455,5077051679792776967,8580182701647580820,5702415534215861612,5238641019005819639,8354853937680199661,8772829059239811248,9144410552198320605,8543725367370187450,6912700714433452061,7632610531119472307,7993184399593192876,8233462514004593793,8717579005028977129,5375541928661155412,8766085005154528319,8727652304406876353,4619163087627090549,7737316096259733246,5441483285055897460,9143955630056285073,7278928503899599098,6586848752069027416,6726552100426717974,8970878233371231519,4955061303843073817,8232091440202415760,6501506605141136894,5063691707131402417,6783830511963156939,5202650038133212212,7039909120009811622,6640209450032675922,7013351736687549262,8138335173189198872,7435766603881487772,6242769196531452572,9093757342451377159,6329989745150292251,8666259690017178880,5951455493630980694,7093517604680735234,8186363579390047200,6919813024558055804,5200946157833865222,4887015100184006472,7432823404565244327,8675068399081760468,5376251103504517480,7642427453514515739,6243295676460430050,5378093492323604697,8073976789933817404,4748559502293929462,5875299345031036024,5493186891473535231,5017015625344217499,6198304780946954807,5725005542041707921,5536261255308539742,6304100798578235756,4680244488935885957,7960492542065255169,7919255442124012067,5405028306500034286,8536347350806976556,4893576777483790104,7480882999482121963,8533528566914743092,5933982033045575488,8389501742623096361,5417420030865051889,8954095507963813713,6198378901073411562,4947095505757021979,6949325417668500852,7435808791924729308,7718963484845585934,8651006405369092938,5569597650914420500,5145761042373974517,4769225561796668182,7763043568847285623,8326937101137054496,5187421991303225224,7978826777595183693,5459497091108394484,8328420616055638504,5358576904327034753,7463377676457570149,8795428034949269387,5382601958084297458,7701725590267631545,7074722888797379064,6429136148696713624,5594042758894180628,6876626278689687372,5722644553629959963,7001430785260730618,7892083307954004979,9070303658142746618,6060087493865710511,7880654964019048592,6875181123275081768,6050289425316521536,9111436306787949301,8811887159084713481,9139017897669033841,5743416740837154954",
                "selected_item_text":"莱阳市,岚山区新玛特,青岛市,即墨大润发,威海海滨,威海国际海水浴场,威海汽车站,潍坊大学城1,李沧区西北,百事,城阳农业大学,莱西利群,日照火车站,日照大润发,日照银座,日照百货大楼,日照新玛特,汤头温泉城,蓝海职业学院,河口公园,莱西市,青岛市南+市北+崂山+李沧区,青岛新增客户用,烟台市莱山区,烟台市福山区,福山天府街,烟台市牟平区,威海市环翠区,烟台市龙口东区,烟台市龙口西区,莱州市,潍坊市奎文区,日照市东港北区,东营西区,东营南区,东营河口区,东营超市配送,青岛火车站,青岛市城阳区,黄岛区,黄岛区胶南,胶南商业街,胶州市,即墨市,平度市,烟台城服商务学院,烟台市芝罘区,烟台南山公园,烟台市开发区,威海市开发区,荣成市,烟台市龙口市乡镇,潍坊市潍城区,日照市东港南区,日照市岚山区,临沂市兰山+河东+罗庄区,东营东区,滨州滨城区,滨州中百,胜利油田盛大超市,青岛海云庵步行街,青岛大学城,青岛台东步行街,东方影城,胶南佳乐家,胶南汽车站,胶州佳乐家,胶州工学院,胶州大润发,向阳路商贸城,即墨佳乐家,金沙滩,湘江路,黄岛大学城,即墨宝龙,长江路,即墨服装城,平度维客,平度利群,平度大润发,莱西利客来,平度汽车站,莱西汽车站,莱西威海路,莱阳大润发,莱阳鲁花,莱阳汽车站,莱阳国货,烟台大学城,烟台第二浴场,烟台鲁东大学,烟台三站街道,万达广场,烟台南大街街道,烟台友谊广场,烟台金沙滩海水浴场,烟台富士康,烟台技术学院,烟台汽车工程学院,永安街振华,福山大润发,烟台西关大街,烟台牟平振华超市,烟台职业学院,昆嵛山景区,威海大世界步行街,威海韩国城,威海山大和哈工大学校,开发区韩乐坊,开发区汽车站,开发区华夏城,开发区海水浴场,荣成步行街,荣成哈理工,石岛步行街,荣城振华超市,龙口南山集团驻地,龙口汽车站,东海大学,博商超市,龙口龙鼎广场,龙口西站,龙口步行街,龙口海边景点,龙口东海大学城,百家福商场,莱州市北关街,莱州府西街,莱州市干休所,潍坊世纪泰华,潍坊歌尔,潍坊学院,潍坊大学城2,白浪河湿地公园,潍坊中百大厦,潍坊火车站,日照万平口景区,日照大学城,日照汽车站,岚山区银座,万德福商场,岚山区田园小区,临沂启阳美食街,临沂大润发步行街,罗庄华五路,东方不夜城,临沂动物园,临沂大学城,东营百货大楼,东营汽车站1,乐活城美食街,东营利群,东营石油大学,油田一中,五十五中,东营汽车站2,金辰美食街,樱花园园,东营职业学院,河口一中,河口银座,河口步行街,滨州学院,滨州五四,滨州职业技术学院,城阳国货,城阳琴岛学院,城阳正阳路",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"7445732441433526198",
                "field_code":"uper_cus",
                "field_name":"",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"7402769540893857974,4640262891423236599,5539558200138420640",
                "selected_item_text":"sck分销经销商,洪庆源,测试导入生成仓库1",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"6443331098049308800",
                "field_code":"exdf_freq_2",
                "field_name":"拜访频率",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"两周1次,三周1次,四周1次",
                "selected_item_text":"两周1次,三周1次,四周1次",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"5153235833903571544",
                "field_code":"exdf_255526",
                "field_name":"订单流向",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"ECC,SFA",
                "selected_item_text":"ECC,SFA",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"4799997507833114611",
                "field_code":"exdf_292834",
                "field_name":"关店时间",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"8:00,8:30,9:30",
                "selected_item_text":"8:00,8:30,9:30",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "cus_field_id":"5906354120252671343",
                "field_code":"exdf_400709",
                "field_name":"开店时间",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"00:00,00:30",
                "selected_item_text":"00:00,00:30",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            }
        ],
        "basPdPriceStrategyCuss":[

        ],
        "basPdPriceStrategyProducts":[
            {
                "base_unit":"5815325918493502423",
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "id":"",
                "input_unit":"7658328476828204462",
                "max_base_unit_num":"0.00000000",
                "max_num":"0.00000000",
                "min_base_unit_num":"0.00000000",
                "min_num":"0.00000000",
                "modify_time":"",
                "modifyier_id":"",
                "pd_code":"10004",
                "pd_id":"8886153687546478293",
                "pd_name":"冰绿茶",
                "price_down":"",
                "price_strategy_product_id":"9002288385045669146",
                "price_up":"",
                "sale_price":"54.00000000",
                "sequ":"",
                "status":"1",
                "strategy_id":""
            },
            {
                "base_unit":"8990464306442485161",
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "id":"",
                "input_unit":"7315285013888868292",
                "max_base_unit_num":"0.00000000",
                "max_num":"0.00000000",
                "min_base_unit_num":"0.00000000",
                "min_num":"0.00000000",
                "modify_time":"",
                "modifyier_id":"",
                "pd_code":"10003",
                "pd_id":"7409269227144953294",
                "pd_name":"冰红茶",
                "price_down":"",
                "price_strategy_product_id":"8093103850531750767",
                "price_up":"",
                "sale_price":"40.00000000",
                "sequ":"",
                "status":"1",
                "strategy_id":""
            },
            {
                "base_unit":"4672182452429575410",
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "id":"",
                "input_unit":"4672182452429575410",
                "max_base_unit_num":"0.00000000",
                "max_num":"0.00000000",
                "min_base_unit_num":"0.00000000",
                "min_num":"0.00000000",
                "modify_time":"",
                "modifyier_id":"",
                "pd_code":"10002",
                "pd_id":"7407531258183844770",
                "pd_name":"雪碧",
                "price_down":"",
                "price_strategy_product_id":"6239722472665744741",
                "price_up":"",
                "sale_price":"3.00000000",
                "sequ":"",
                "status":"1",
                "strategy_id":""
            },
            {
                "base_unit":"8851908411956994717",
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "id":"",
                "input_unit":"8851908411956994717",
                "max_base_unit_num":"0.00000000",
                "max_num":"0.00000000",
                "min_base_unit_num":"0.00000000",
                "min_num":"0.00000000",
                "modify_time":"",
                "modifyier_id":"",
                "pd_code":"1",
                "pd_id":"6831390366898028953",
                "pd_name":"1221",
                "price_down":"",
                "price_strategy_product_id":"8097950472231147547",
                "price_up":"",
                "sale_price":"11.00000000",
                "sequ":"",
                "status":"1",
                "strategy_id":""
            },
            {
                "base_unit":"6076877019412887312",
                "create_time":"2018-08-21 08:33:12",
                "creator_id":"4993053750015187044",
                "id":"",
                "input_unit":"7564562801574625666",
                "max_base_unit_num":"0.00000000",
                "max_num":"0.00000000",
                "min_base_unit_num":"0.00000000",
                "min_num":"0.00000000",
                "modify_time":"",
                "modifyier_id":"",
                "pd_code":"10005",
                "pd_id":"4892238857644646947",
                "pd_name":"红牛2",
                "price_down":"",
                "price_strategy_product_id":"7780340540109719162",
                "price_up":"",
                "sale_price":"82.00000000",
                "sequ":"",
                "status":"1",
                "strategy_id":""
            }
        ],
        "basPdPriceStrategySameCodes":[

        ],
        "create_time":"2018-08-21 08:33:12",
        "creator_id":"4993053750015187044",
        "end_time":"2020-08-15 00:00:00",
        "id":"",
        "is_enable":"1",
        "modify_time":"",
        "modifyier_id":"",
        "price_strategy_id":"5248497830880571426",
        "prod_num":"5",
        "product_type":"1",
        "start_time":"2018-08-21 00:00:00",
        "status":"1",
        "title":"ssz测试",
        "trade_range":"1",
        "trade_type":"2"
    },
    {
        "basPdPriceStrategyCusFields":[
            {
                "create_time":"2018-08-21 15:33:03",
                "creator_id":"4993053750015187044",
                "cus_field_id":"6648068697815115433",
                "field_code":"dept_id",
                "field_name":"部门",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"6293038467202789830,5862256324923875820",
                "selected_item_text":"考勤组织,方便面",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 15:33:03",
                "creator_id":"4993053750015187044",
                "cus_field_id":"7440589558422644015",
                "field_code":"district_level",
                "field_name":"销售区域等级",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"6607275807085210917,8545708648846165721",
                "selected_item_text":"区域一级,区域二级",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 15:33:03",
                "creator_id":"4993053750015187044",
                "cus_field_id":"8454993694742261279",
                "field_code":"customer_level",
                "field_name":"客户级别",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"8715900737400193117,7287736961434231483",
                "selected_item_text":"A,B",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 15:33:03",
                "creator_id":"4993053750015187044",
                "cus_field_id":"8128575266911187982",
                "field_code":"type_id",
                "field_name":"客户类型",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"7453205613633003407,5956742668490842859",
                "selected_item_text":"柱子类型,美缝店",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 15:33:03",
                "creator_id":"4993053750015187044",
                "cus_field_id":"8942593049559607484",
                "field_code":"district_id",
                "field_name":"销售区域",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"9033269349423299426,4752605905626817542,5172862724621820894,7878766441603271576,6785473900023654609",
                "selected_item_text":"滨州滨城区,滨州中百,滨州学院,滨州五四,滨州职业技术学院",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 15:33:03",
                "creator_id":"4993053750015187044",
                "cus_field_id":"7556807878243137592",
                "field_code":"uper_cus",
                "field_name":"",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"8320062286560444570,6590825446466716903,7229839221456283463",
                "selected_item_text":"非直营,上级经销商,直营",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 15:33:03",
                "creator_id":"4993053750015187044",
                "cus_field_id":"8705444525531245507",
                "field_code":"exdf_freq_2",
                "field_name":"拜访频率",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"四周1次,一周1次,两周1次,三周1次",
                "selected_item_text":"四周1次,一周1次,两周1次,三周1次",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 15:33:03",
                "creator_id":"4993053750015187044",
                "cus_field_id":"4644981436119751330",
                "field_code":"exdf_255526",
                "field_name":"订单流向",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"ECC,SFA",
                "selected_item_text":"ECC,SFA",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 15:33:03",
                "creator_id":"4993053750015187044",
                "cus_field_id":"5533730061059534300",
                "field_code":"exdf_292834",
                "field_name":"关店时间",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"8:00",
                "selected_item_text":"8:00",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            },
            {
                "create_time":"2018-08-21 15:33:03",
                "creator_id":"4993053750015187044",
                "cus_field_id":"8308936325666272782",
                "field_code":"exdf_400709",
                "field_name":"开店时间",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"00:30",
                "selected_item_text":"00:30",
                "status":"1",
                "strategy_id":"",
                "table_name":""
            }
        ],
        "basPdPriceStrategyCuss":[

        ],
        "basPdPriceStrategyProducts":[

        ],
        "basPdPriceStrategySameCodes":[
            {
                "base_unit":"",
                "create_time":"2018-08-21 15:33:03",
                "creator_id":"4993053750015187044",
                "id":"",
                "input_unit":"7168931699463297142",
                "max_base_unit_num":"0.00000000",
                "max_num":"0.00000000",
                "min_base_unit_num":"0.00000000",
                "min_num":"0.00000000",
                "modify_time":"",
                "modifyier_id":"",
                "price_down":"1.00000000",
                "price_strategy_same_code_id":"5514868421869174073",
                "price_up":"1.00000000",
                "sale_price":"11.00000000",
                "same_price_code":"aaa",
                "sequ":"",
                "status":"1",
                "strategy_id":""
            },
            {
                "base_unit":"",
                "create_time":"2018-08-21 15:33:03",
                "creator_id":"4993053750015187044",
                "id":"",
                "input_unit":"6809111616638730975",
                "max_base_unit_num":"0.00000000",
                "max_num":"0.00000000",
                "min_base_unit_num":"0.00000000",
                "min_num":"0.00000000",
                "modify_time":"",
                "modifyier_id":"",
                "price_down":"2.00000000",
                "price_strategy_same_code_id":"4680555118409114561",
                "price_up":"2.00000000",
                "sale_price":"22.00000000",
                "same_price_code":"222",
                "sequ":"",
                "status":"1",
                "strategy_id":""
            }
        ],
        "create_time":"2018-08-21 15:33:03",
        "creator_id":"4993053750015187044",
        "end_time":"2023-08-25 00:00:00",
        "id":"",
        "is_enable":"1",
        "modify_time":"",
        "modifyier_id":"",
        "price_strategy_id":"5061081673542762162",
        "prod_num":"",
        "product_type":"2",
        "start_time":"2018-08-21 00:00:00",
        "status":"1",
        "title":"sszTest",
        "trade_range":"1",
        "trade_type":"2"
    },
    {
        "basPdPriceStrategyCusFields":[
            {
                "create_time":"",
                "creator_id":"",
                "cus_field_id":"",
                "field_code":"",
                "field_name":"",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "selected_item":"",
                "selected_item_text":"",
                "status":"",
                "strategy_id":"",
                "table_name":""
            }
        ],
        "basPdPriceStrategyCuss":[
            {
                "cm_code":"",
                "cm_id":"7367170304595826780",
                "cm_name":"",
                "create_time":"2018-08-21 15:38:48",
                "creator_id":"4993053750015187044",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "price_strategy_cus_id":"7272170345546063163",
                "status":"1"
            },
            {
                "cm_code":"",
                "cm_id":"4803878215375374955",
                "cm_name":"",
                "create_time":"2018-08-21 15:38:48",
                "creator_id":"4993053750015187044",
                "id":"",
                "modify_time":"",
                "modifyier_id":"",
                "price_strategy_cus_id":"5585185858935651346",
                "status":"1"
            }
        ],
        "basPdPriceStrategyProducts":[
            {
                "base_unit":"8851908411956994717",
                "create_time":"2018-08-21 15:38:48",
                "creator_id":"4993053750015187044",
                "id":"",
                "input_unit":"8851908411956994717",
                "max_base_unit_num":"0.00000000",
                "max_num":"0.00000000",
                "min_base_unit_num":"0.00000000",
                "min_num":"0.00000000",
                "modify_time":"",
                "modifyier_id":"",
                "pd_code":"1",
                "pd_id":"6831390366898028953",
                "pd_name":"1221",
                "price_down":"",
                "price_strategy_product_id":"7089295218249730501",
                "price_up":"",
                "sale_price":"11.00000000",
                "sequ":"",
                "status":"1",
                "strategy_id":""
            },
            {
                "base_unit":"2",
                "create_time":"2018-08-21 15:38:48",
                "creator_id":"4993053750015187044",
                "id":"",
                "input_unit":"2",
                "max_base_unit_num":"0.00000000",
                "max_num":"0.00000000",
                "min_base_unit_num":"0.00000000",
                "min_num":"0.00000000",
                "modify_time":"",
                "modifyier_id":"",
                "pd_code":"test2",
                "pd_id":"6692513571119135748",
                "pd_name":"测试商品2",
                "price_down":"",
                "price_strategy_product_id":"4915058707947250935",
                "price_up":"",
                "sale_price":"888.80000000",
                "sequ":"",
                "status":"1",
                "strategy_id":""
            },
            {
                "base_unit":"6076877019412887312",
                "create_time":"2018-08-21 15:38:48",
                "creator_id":"4993053750015187044",
                "id":"",
                "input_unit":"7564562801574625666",
                "max_base_unit_num":"0.00000000",
                "max_num":"0.00000000",
                "min_base_unit_num":"0.00000000",
                "min_num":"0.00000000",
                "modify_time":"",
                "modifyier_id":"",
                "pd_code":"10005",
                "pd_id":"4892238857644646947",
                "pd_name":"红牛2",
                "price_down":"",
                "price_strategy_product_id":"4906508095312876540",
                "price_up":"",
                "sale_price":"82.00000000",
                "sequ":"",
                "status":"1",
                "strategy_id":""
            }
        ],
        "basPdPriceStrategySameCodes":[

        ],
        "create_time":"2018-08-21 15:38:48",
        "creator_id":"4993053750015187044",
        "end_time":"2022-08-20 00:00:00",
        "id":"",
        "is_enable":"1",
        "modify_time":"",
        "modifyier_id":"",
        "price_strategy_id":"7203823650724655752",
        "prod_num":"3",
        "product_type":"1",
        "start_time":"2018-08-21 00:00:00",
        "status":"1",
        "title":"ssztest222",
        "trade_range":"2",
        "trade_type":"2"
    }
]


}
                  
参数名称 参数值
应用编码 product
应用版本 v1
接口名称 新增修改价格策略接口
接口编码 addOrModifyPriceStrategy
接口URL https://openapi.waiqin365.com/api/product/v1/addOrModifyPriceStrategy/{ openid }/{ timestamp }/{ digest }/{ msg_id }
请求信息 参数 类型 必填 说明
title VARCHAR(100) 价格方案名称
start_date VARCHAR(32) 开始日期 格式必须是yyyy-MM-dd
end_date VARCHAR(32) 结束日期 格式必须是yyyy-MM-dd
channel_type VARCHAR(32) 销售对象 1标准客户 2 经销商 3 终端门店
client_range VARCHAR(32) 客户范围 1 按客户属性设置范围 2 指定具体客户
product_type VARCHAR(32) 商品范围 1 商品 2 同价码
source_code VARCHAR(100) 价格方案第三方系统的唯一标识 source_code price_id 传一个
price_id VARCHAR(32) 价格方案id source_code price_id 传一个
dept_id VARCHAR(32) 部门id 多个逗号分隔
dept_name VARCHAR(100) 部门名称 多个逗号分隔
dept_code VARCHAR(100) 部门编码 多个逗号分隔
dept_source_code VARCHAR(100) 部门第三方系统的唯一标识 多个逗号分隔
customer_level_id VARCHAR(32) 客户级别id 多个逗号分隔
customer_level_source_code VARCHAR(100) 客户级别第三方系统的唯一标识 多个逗号分隔
customer_level_name VARCHAR(100) 客户级别名称 多个逗号分隔
district_level_id VARCHAR(32) 销售区域级别id 多个逗号分隔
district_level_code VARCHAR(100) 销售区域级别编码 多个逗号分隔
district_level_name VARCHAR(100) 销售区域级别名称 多个逗号分隔
type_id VARCHAR(32) 类型id 多个逗号分隔
type_code VARCHAR(100) 类型编码 多个逗号分隔
type_name VARCHAR(100) 类型名称 多个逗号分隔
type_source_code VARCHAR(100) 类型第三方系统的唯一标识 多个逗号分隔
district_id VARCHAR(32) 销售区域id 多个逗号分隔
district_code VARCHAR(100) 销售区域编码 多个逗号分隔
district_name VARCHAR(100) 销售区域名称 多个逗号分隔
district_source_code VARCHAR(100) 销售区域第三方系统的唯一标识 多个逗号分隔
uperCus_id VARCHAR(32) 上级客户id 多个逗号分隔
uperCus_code VARCHAR(100) 上级客户编码 多个逗号分隔
uperCus_source_code VARCHAR(100) 上级客户第三方系统的唯一标识 多个逗号分隔
uperCus_name VARCHAR(100) 上级客户名称 多个逗号分隔
kasys_id VARCHAR(32) ka系统id 多个逗号分隔
kasys_name VARCHAR(100) ka系统名称 多个逗号分隔
dealer_id VARCHAR(32) 经销商id 多个逗号分隔
dealer_code VARCHAR(100) 经销商编码 多个逗号分隔
dealer_name VARCHAR(100) 经销商名称 多个逗号分隔
dealer_source_code VARCHAR(100) 经销商第三方系统的唯一标识 多个逗号分隔
gradation_id VARCHAR(32) 客户层次id 多个逗号分隔
gradation_code VARCHAR(100) 客户层次编码 多个逗号分隔
gradation_name VARCHAR(100) 客户层次名称 多个逗号分隔
cm_id VARCHAR(2000) 经销商或客户id 多个逗号分隔 client_range 为2 cm_id cm_code cm_name cm_source_code必传一个
cm_code VARCHAR(4000) 经销商或客户编码 多个逗号分隔 client_range 为2 cm_id cm_code cm_name cm_source_code必传一个
cm_name VARCHAR(4000) 经销商或客户名称 多个逗号分隔 client_range 为2 cm_id cm_code cm_name cm_source_code必传一个
cm_source_code VARCHAR(4000) 经销商或客户第三方系统的唯一标识 多个逗号分隔 client_range 为2 cm_id cm_code cm_name cm_source_code必传一个
exts
exts[].cm_ext_key VARCHAR(100) 客户信息扩展字段key值,客户信息扩展字段需先在外勤365系统客户管理中创建自定义字段。
exts[].cm_ext_value VARCHAR(4000) 客户信息扩展字段value值对多个选项值,以“,”分隔拼接。
products
products[].id VARCHAR(32) 商品id id code source_code 传一个
products[].code VARCHAR(100) 商品编码 id code source_code传一个
products[].source_code VARCHAR(100) 商品第三方系统的唯一标识 id code source_code 传一个
products[].unit_id VARCHAR(32) 单位id unit_id unit_name传一个
products[].unit_name VARCHAR(100) 单位名称 unit_id unit_name传一个
products[].price VARCHAR(32) 价格 整数位不大于7位
products[].price_up VARCHAR(32) 价格上浮动 整数位不大于7位
products[].price_down VARCHAR(32) 价格下浮动 整数位不大于7位
products[].price_code VARCHAR(32) 同价码 product_type为2 必传
响应信息 参照表响应信息格式
msg_id String 请求消息ID
return_code int 响应编码,0-成功, 1-失败, 其他参照附件错误码
return_msg String 响应说明

// 请求消息体示例:
{
	"title": "测试1111111",
	"start_date": "2019-03-18",
	"end_date": "2019-03-31",
	"channel_type": "3",
	"cm_code": "KH1Q1019576A",
	"client_range": "2",
	"product_type": "2",
	"source_code": "aaassss",
	"operate_type": "1",
	"dept_id": "5027924547848612557,7243837410903640238",
	"gradation_code": "KH1Q1008146A",
	"kasys_name": "家乐福",
	"exts": [{
		"cm_ext_key": "需要配送",
		"cm_ext_value": "是"
	}],
	"products": [{
		"code": "10002",
		"price_code": "B111",
		"unit_name": "箱",
		"price": "100",
		"price_up": "120"
	}]
}


// 正常响应信息示例:
{
    "msg_id": "PRD00001",
    "return_code": "1",
    "return_msg": "新增成功!"
}

// 异常响应信息示例:
{
    "msg_id": "PRD00001",
    "return_code": "0",
    "return_msg": "客户不存在!"
}
                  
参数名称 参数值
应用编码 product
应用版本 v1
接口名称 删除价格策略接口
接口编码 removePriceStrategy
接口URL https://openapi.waiqin365.com/api/product/v1/removePriceStrategy/{ openid }/{ timestamp }/{ digest }/{ msg_id }
请求信息 参数 类型 必填 说明
price_id VARCHAR(32) 价格方案id price_id source_code 传一个
source_code VARCHAR(100) 价格方案第三方系统的唯一标识 price_id source_code 传一个
响应信息 参照表响应信息格式
msg_id String 请求消息ID
return_code int 响应编码,0-成功, 1-失败, 其他参照附件错误码
return_msg String 响应说明

// 请求消息体示例:
{
    "price_id":"565656565",
}
// 正常响应信息示例:
{
    "msg_id": "PRD00001",
    "return_code":"0",
    "return_msg":"删除成功!"
}

// 异常响应信息示例:
{
    "msg_id": "PRD00001",
    "return_code": "1",
    "return_msg": "删除失败,价格方案不存在!"
}