-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathProduct_Scrape.py
131 lines (111 loc) · 5.04 KB
/
Product_Scrape.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
from selenium import webdriver
import time
from openpyxl import Workbook
from openpyxl.styles import Font
wb = Workbook()
nos=0
with open("input.txt", "r") as a_file:
for line in a_file:
item,page_number=line.split(":")
nos+=1
ws1 = wb.create_sheet(str(nos)+"Alibaba")
ws2 = wb.create_sheet(str(nos)+"Indiamart")
row1 = ws1.row_dimensions[1]
row2 = ws2.row_dimensions[1]
row1.font = Font(bold=True)
row2.font = Font(bold=True)
ws1['A1']='product_Name'
ws1['B1']='product_Price'
ws1['C1']='product_Quantity'
ws1['D1']='seller_Name'
ws1['E1']='seller_Rating'
ws1['F1']='number_Of_Ratings'
ws2['A1']='product_Name'
ws2['B1']='product_Price'
ws2['C1']='seller_Name'
class BoT:
def __init__(self):
self.driver = webdriver.Firefox()
def closeBrowser(self):
self.driver.close()
def DoIt(self):
drive = self.driver
products_Page=drive.get("https://www.alibaba.com/trade/search?fsb=y&IndexArea=product_en&CatId=&SearchText=" + item)
time.sleep(1)
temp=2
for j in range(int(page_number)):
itera=j+1
drive.execute_script("window.scrollTo(0,document.body.scrollHeight)")
time.sleep(3)
products_List=drive.find_elements_by_xpath("//*[@class='organic-gallery-title__content medium']")
products_Price=drive.find_elements_by_xpath("//*[@class='gallery-offer-price medium']")
products_Quantity=drive.find_elements_by_xpath("//*[@class='gallery-offer-minorder medium']")
seller_Name=drive.find_elements_by_xpath("//*[@class='organic-list-offer__seller-company']")
seller_Rating=drive.find_elements_by_xpath("//*[@class='seb-supplier-review__score']")
number_Of_Ratings=drive.find_elements_by_xpath("//*[@class='seb-supplier-review__review-count']")
k=temp
for i in products_List:
ws1.cell(k, 1, i.text)
k+=1
k=temp
for i in products_Quantity:
ws1.cell(k, 3, i.text)
k+=1
k=temp
for i in seller_Name:
ws1.cell(k, 4,i.text)
k+=1
k=temp
for i in seller_Rating:
ws1.cell(k,5 , i.text)
k+=1
k=temp
for i in number_Of_Ratings:
ws1.cell(k,6 , i.text)
k+=1
k=temp
for i in products_Price:
ws1.cell(k, 2, i.text)
k += 1
temp=k
nxt = drive.get("https://www.alibaba.com/products/" + item + ".html?spm=a2700.galleryofferlist.0.0.79812f4034Fl8f&IndexArea=product_en&page=" + str(itera))
print("The number of items so far are "+ str(temp))
class bOt:
def __init__(self):
self.driver = webdriver.Firefox()
def closeBrowser(self):
self.driver.close()
def LeGo(self):
drive = self.driver
time.sleep(1)
products_Page=drive.get("https://dir.indiamart.com/search.mp?ss= "+ item)
time.sleep(4)
temp1=2
for j in range(1):
drive.execute_script("window.scrollTo(0,document.body.scrollHeight)")
time.sleep(2)
drive.execute_script("window.scrollTo(0,document.body.scrollHeight)")
time.sleep(2)
drive.execute_script("window.scrollTo(0,document.body.scrollHeight)")
time.sleep(2)
products_List1=drive.find_elements_by_xpath("//*[@class='fs18 ptitle']")
products_Price1=drive.find_elements_by_xpath("//*[@class='prc cur']")
seller_Name1=drive.find_elements_by_xpath("//*[@class='lcname']")
k=temp1
for i in products_List1:
ws2.cell(k, 1, i.text)
k+=1
k=temp1
for i in seller_Name1:
ws2.cell(k, 3,i.text)
k+=1
k=temp1
for i in products_Price1:
ws2.cell(k, 2, i.text)
k += 1
temp1=k
print("The number of Items so far are "+str(temp1))
BoT().DoIt()
time.sleep(3)
bOt().LeGo()
wb.save("Product Listings.xlsx")