Web scraping to sync suppliers' product inventory with ours.
$200-350 NZD
Selesai
Dibuat lebih dari 8 tahun yang lalu
$200-350 NZD
Dibayar ketika dikirim
Job Description:
- We are an online store, runs osCommerce.
- We login to store Admin and update our inventory manually.
- We login to suppliers' website to look at inventory level, and manually sync our inventory with theirs.
- Provide solution to sync inventory automatically, on command (not autonomous).
- We can manually login to store's Admin and Suppliers' website, then the script takes it from there.
- After login, with the proposed script we push a start button and the script goes down a list of SKU/product_id (in txt input file) and sync the inventory level, one SKU at a time.
- The script may be implemented in python with Selenium, Beautiful soup, mechanize libraries:
- The script extracts inventory level per SKU from supplier's website:
- 3 variables per SKU: Size, colour, and quantity (in discrete levels: In stock, Low Stock, On Order, Indent, blank-not available).
- Ability to replace discrete levels with preset values:
- In Stock - we will update our database with number 9.
- Low Stock - update with 1.
- On Order, Indent, and blank - with 0
- Clear code documentation/comments so that when supplier made changes to their website, we can easily modify the script.
- The script saves the extracted data to a text file (output file).
- The script then reads the output file, and enters data using existing osCommerce web interface ([login to view URL]), or a custom php file.
- The script verify the data entry. Pass/Fail.
- The script moves on to the next SKU.
- The script loops through the SKUs, and finally displays "Done".
- There are two suppliers to sync from.
- In the interest of protecting our customers' privacy, we will perform the work over TeamViewer sessions on my Windows PC.
- I intent to record the sessions for documentary purposes.
I've experience in Python, BeautifulSoup and some Scrapy. I can do this in around 5 days. If required I can do the UI integration too or build a UI from scratch using Python/Flask.
Flask is a very simple framework that can be easily learned and maintained. Scrapy is very feature rich and its possible to have quite intelligent solution with Scrapy.
$305 NZD dalam 5 hari
4,9 (4 ulasan)
3,8
3,8
7 freelancer menawar dengan rata-rata $317 NZD untuk pekerjaan ini
Hi there,
I have a lot of experience implementing this type of web scraper in Python. Your project should be very straightforward. I do have a couple of questions, however:
1. What hours are you available to work on this via TeamViewer? I'm US based, so I'm hoping we can find a schedule that works for both of us.
2. Which version of Python are you using? (This doesn't really matter, it just helps guide what I do)
Thanks for considering my bid, and please let me know if you have any questions.
Hi, expert web/data scraper here with over 17 years experience in programming and RDBMS - please see my reviews.
I'm using Python for this kind of jobs.
I'm able to extract data fast.
Hello,
I'm a Sr. Data Analyst with 3 years experience at large tech companies in Silicon Valley. I'm a native English speaker specializing in data aggregation and modeling. I'm a fluent user of Excel, SQL, Tableau, and Python. I believe I would be a perfect fit for your project. Normally, my rates aren't this low, but I am new to Freelancer and I want to make a name for myself.
I look forward to the opportunity!
Best,
Brandon