Python Programmer - Scrape Info to Google Sheets and Export to Shopify -- 2
Budget: $750 – $1,500 USD
Preview
In summary, the job is to import online product listing data to Google Sheets from Etsy (primarily) to then (independently) Export information from the same table to Shopify (product name, price, description, picture, reviews, etc.).
Linked below are tutorial videos on YouTube that should guide your realization of this job. Although, any significant and articulable improvement on my ideas or those from the tutorials will be rewarded if approved by me and then successfully implemented by you.
Ideally, you have experience with Shopify to make the program result in the best way possible. Ideally (but not necessary), you agree with the business's mission to provide ethical and healthy household product alternatives to current market offerings that are unethically sourced or unhealthy; this would increase the likelihood of gaining a more steady position with this startup. There are many more similar tasks to come!
Details
Accomplish the following steps for an existing Google Sheet data table:
Scrape data specified by each column header that corresponds (by row) to the given links of the URL column (and any future links), including the following: Product Title, Supplier Name, Sale Price, Inventory, Shipping (free, flat rate, calculated, etc.), First Picture, Pasted Feature Set (color, size, material, etc.), Rating, # Reviews, Pasted Reviews. Make this automatically update every 12 hours.
Export data from the Google Sheets table to our Shopify store and make the store update every 6 hours, or once a change to the Google Sheets table has been detected, whichever comes first. Start your job application/response with the word attention in all caps.
Make the above two bulleted tasks independent functions from each other; that way, the programmed table can be used to export data to alternative or additional locations in the future (e.g., save PDFs for backup).
Links to Tutorial Videos:
Web Scraping with Python: youtube.com/watch?v=nCuPv3tf2Hg
Optimize scraping speed: youtube.com/watch?v=qQDB6SE0a9c&t=203s
Google Sheets as database to web scraper: youtube.com/watch?v=ct0xvw_Z0tU
Move Google Sheets product info to Shopify: youtube.com/watch?v=wldIh2tB64E
In summary, the job is to import online product listing data to Google Sheets from Etsy (primarily) to then (independently) Export information from the same table to Shopify (product name, price, description, picture, reviews, etc.).
Linked below are tutorial videos on YouTube that should guide your realization of this job. Although, any significant and articulable improvement on my ideas or those from the tutorials will be rewarded if approved by me and then successfully implemented by you.
Ideally, you have experience with Shopify to make the program result in the best way possible. Ideally (but not necessary), you agree with the business's mission to provide ethical and healthy household product alternatives to current market offerings that are unethically sourced or unhealthy; this would increase the likelihood of gaining a more steady position with this startup. There are many more similar tasks to come!
Details
Accomplish the following steps for an existing Google Sheet data table:
Scrape data specified by each column header that corresponds (by row) to the given links of the URL column (and any future links), including the following: Product Title, Supplier Name, Sale Price, Inventory, Shipping (free, flat rate, calculated, etc.), First Picture, Pasted Feature Set (color, size, material, etc.), Rating, # Reviews, Pasted Reviews. Make this automatically update every 12 hours.
Export data from the Google Sheets table to our Shopify store and make the store update every 6 hours, or once a change to the Google Sheets table has been detected, whichever comes first. Start your job application/response with the word attention in all caps.
Make the above two bulleted tasks independent functions from each other; that way, the programmed table can be used to export data to alternative or additional locations in the future (e.g., save PDFs for backup).
Links to Tutorial Videos:
Web Scraping with Python: youtube.com/watch?v=nCuPv3tf2Hg
Optimize scraping speed: youtube.com/watch?v=qQDB6SE0a9c&t=203s
Google Sheets as database to web scraper: youtube.com/watch?v=ct0xvw_Z0tU
Move Google Sheets product info to Shopify: youtube.com/watch?v=wldIh2tB64E