Web scraping to sync suppliers' product inventory with ours.
$200-350 NZD
Paid on delivery
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 ([url removed, login to view]), 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.
Project ID: #9115288
About the project
Awarded to:
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 t More
8 freelancers are bidding on average $312 for this job
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 More
Dear Sir, Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requir More
Hi, I have good experience in scrapping web data. Have gone through the requirements. We can do this using php curl and javascript. Thanks, Mohan
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 More