This script allows you to input items and their prices on a google spreadsheet and check their price regularly. It is intended to be run periodically, and if anything is found matching the criteria another spreadsheet will be updated and an email will be sent to you UpdateML.py is a tool to update the items you already have quicker
1-Download the repository
2-You'll need a google service account. It that can be created by following the steps in this link. https://gspread.readthedocs.io/en/latest/oauth2.html#enable-api-access
3-Put the .json file you downloaded in the previous step in the same directory you have the scripts and replace %service_account.json% in all python files with the name of the downloaded one.
4-Open the json file and look for the service account's email. It should look something like this: [email protected]
5-Open and save the .xlsx that came with the scripts in Google spreadsheets. Share them with the email from the last step. If you don't change the names, you shouldn't have any problems with the calls.
6-If you are from other countries other than Argentina, you need to change the site code from the API link. If you are from Brazil for example, replace MLA with MLB.
(Optional)If you don't want to use the email feature, just leave the send_mail() call commented.
7-Set up the send_email method to receive a notification via email. Replace %from%, %password% and %to% with your personal information from your google account. You can either use a secondary account to send the emails or send them to yourself.
1-Fill the ItemsML sheet with the searches you want to make. The item field is the textual search in MercadoLibre, the low_price is the price the script will below, and the floor_price is the lower limit of the search, in case you need one. The required and forbidden words camps are meant for words that must or must not appear in the title, and are used to narrow the search parameters to the items intended. Condition takes either "new" or "used" (without quotation marks) or nothing if all results are desired. Forbidden ids takes publication ids (MLA854535947, for example) in case you want to exclude a specific publication. All the parameters are optional except for low price. Here's an example:
2-Find a way to keep the script running periodically. Daily, hourly, as you wish. I can recommend a free account on pythonanywhere.com that allows you to schedule 1 task daily in the cloud.
3-If the script finds anything, it will appear in ResultsML with its link. The results will appear this way:
These scripts are completely optional and are meant to speed up the process of deleting old results and updating the prices.
DeleteOldFiles will delete all the publications in the Results spreadsheet whose attribute "status" is different from "active", meaning it isn't available anymore
UpdateML will search for the lowest prices of each item regardless of the set price, and store the three lowest. If the difference between the previously set price and the lowest search price is higher than the 25% of the lowest price or lowest than the 5%, it'll update the price to to the 90% of the lowest price. Once the process is done, it'll download a "unupdate.xlsx" excel file to the directory where you'll be able to see which items have been changed and which were the used results.
Thank You
(5/5/20)1.1: Changed variable names and comments for readability
(6/5/29)1.2: Fixed an error with smtplib encoding by changing some strings to f strings
(8/5/20)1.3: Added MethodsML.py file to use as a module, instead of having the methods on SearchML.py. Corrected minor mistakes and added variables.
(6/6/21)2.0: Almost complete rewrite and reorganization of the code. Added requirements.txt. Added new parameter, condition.
(14/9/21)3.0: Added the DeleteOldResults and UpdateML support scripts. The code now supports multiple forbidden and required words per item, separated by space (" "). Added the option to block particular publications from the search by Id.