def writeToExcel(): wk = openpyxl.Workbook() sheet = wk.create_sheet() sheet.append(['仓库id', '仓库名', '买家展示名', '仓库图片']) from merchant_pc.getCookie import getCookies Cookie = getCookies() headers = { 'Accept': 'application/json, text/plain, */*', 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36', 'Host': 'www.shop2cn.com', 'Connection': 'keep - alive', 'Cookie': Cookie } '''设置请求数据''' requestData = {"pageIndex": 1, "pageSize": 100} urllib3.disable_warnings() data = requests.post( 'https://www.shop2cn.com/service/order/api/depot/getDepotList', json=requestData, headers=headers, verify=False) response = data.text depotList = json.loads(response)['data']['depotList'] for item in depotList: buyerName = item['buyerTitle'] depotTitle = item['depotTitle'] depotId = item['depotId'] picUrl = item['picUrl'] sheet.append([depotId, depotTitle, buyerName, picUrl]) wk.save('D:\python\study\仓库信息.xlsx') # 文件名重复的时候会报错,路径下文件删了重新执行就可以了
def __init__(self): from merchant_pc.getCookie import getCookies Cookie = getCookies() self.headers = { 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36', 'Cookie': Cookie }
# Cookie = getCookies() headers = { 'Accept': 'application/json, text/plain, */*', 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36', 'Host': 'www.shop2cn.com', 'Connection': 'keep - alive', 'Cookie': Cookie } '''设置请求数据''' requestData = {"pageIndex": 1, "pageSize": 100} urllib3.disable_warnings() data = requests.post( 'https://www.shop2cn.com/service/order/api/depot/getDepotList', json=requestData, headers=headers, verify=False) response = data.text if json.loads(response)['data']['total'] != 0: depotId = json.loads(response)['data']['depotList'][0]['depotId'] # print('仓库编号:'+depotId) return depotId else: return json.loads(response)['data']['total'] # 返回仓库总数:0 if __name__ == '__main__': from merchant_pc import getCookie print(getDepot(getCookie.getCookies()))
def getSectionList(Cookie, sectionType): # sectionType 1:限时抢,2:秒杀 # from merchant_pc.getCookie import getCookies # cookie获取提取到方法外,调用该方法必须穿cookie # Cookie = getCookies() headers = { 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng, */*', 'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.80 Safari/537.36', 'Host': 'www.shop2cn.com', 'Connection': 'keep - alive', 'Cookie': Cookie } '''设置请求数据''' urllib3.disable_warnings() data = requests.get( f'https://www.shop2cn.com/service/mgmt/api/marketing/sectionList?pageIndex=1&pageSize=20§ionType={sectionType}', headers=headers, verify=False) response = data.text sectionList = json.loads(response)['data']['list'] # print(sectionList) return sectionList if __name__ == '__main__': from merchant_pc.getCookie import getCookies # cookie获取提取到方法外,调用该方法必须穿cookie Cookie = getCookies() getSectionList(Cookie, 1)
def createXsq(): from merchant_pc.getCookie import getCookies # cookie获取提取到方法外,调用该方法必须穿cookie Cookie = getCookies() headers = { 'Accept': 'application/json, text/plain, */*', 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36', 'Host': 'www.shop2cn.com', 'Connection': 'keep - alive', 'Cookie': Cookie } from merchant_pc.getTime import getAddMinutesTime2, getAddDaysTime2, getAddDaysTime3, getAddMinutesTime3 beginTime = getAddMinutesTime3() endTime = getAddDaysTime3() promotionBeginTime = getAddMinutesTime2() promotionTimeEndTime = getAddDaysTime2() '''设置请求数据''' requestData = { "name": "py测试", "promotionTime": [promotionBeginTime, promotionTimeEndTime], "limitType": 1, "limitNum": "", "previewTime": 0, "preTime": "", "beginTime": beginTime, "endTime": endTime, "productList": [{ "productId": "p7084378", "catalogList": [{ "catalogId": "c43699135", "buyingPrice": 0, "salePrice": 0.1, "stockNum": 100, "realStock": 100, "virtualStock": 0, "propertyValue": "白色", "sku": None, "barcode": None, "counterPrice": 0, "marketAmount": 0, "activityRealStock": 0, "activityStock": 0, "discount": "5.6", "discountPrice": "0.06" }, { "catalogId": "c43699134", "buyingPrice": 0, "salePrice": 0.2, "stockNum": 200, "realStock": 200, "virtualStock": 0, "propertyValue": "黑色", "sku": None, "barcode": None, "counterPrice": 0, "marketAmount": 0, "activityRealStock": 0, "activityStock": 0, "discount": "5.6", "discountPrice": "0.11" }] }, { "productId": "p7084377", "catalogList": [{ "catalogId": "c43698270", "buyingPrice": 0, "salePrice": 0.1, "stockNum": 100, "realStock": 100, "virtualStock": 0, "propertyValue": "白色", "sku": None, "barcode": None, "counterPrice": 0, "marketAmount": 0, "activityRealStock": 0, "activityStock": 0, "discount": "5.6", "discountPrice": "0.06" }, { "catalogId": "c43698269", "buyingPrice": 0, "salePrice": 0.2, "stockNum": 200, "realStock": 200, "virtualStock": 0, "propertyValue": "黑色", "sku": None, "barcode": None, "counterPrice": 0, "marketAmount": 0, "activityRealStock": 0, "activityStock": 0, "discount": "5.6", "discountPrice": "0.11" }] }], "discountType": 0, "stockType": 0, "activityId": "", "activityType": 1, "sectionId": "4" } urllib3.disable_warnings() data = requests.post( 'https://www.shop2cn.com/service/mgmt/api/marketing/createEditPromotion', json=requestData, headers=headers, verify=False) response = data.text # depotId = json.loads(response)['data']['depotList'][1]['depotId'] print(response) return response