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
