Need iMacro for Firefox or Chrome to extract UPS shipping
- loops through an Excel/CSV file on local drive (C:/….) that contains a list of UPS tracking numbers ( File fields: Tracking_Number, Is_UPS(Y/N), Delivered (Y/N),Delivery_Date)
- if Delivery_Date is blank in CSV file for the Tracking_nos
- Submits the tracking_no. on ups.com.
-if tracking number is not a UPS number/junk than update CSV.Is_UPS field with 'N'
- if tracking number is valid
- update CSV.Is_UPS field with 'Y'
-Extract the 'Activity' and 'Date' value from the 'Shipment Progress' section
- if ‘Activity’ = “Delivered”, update [url removed, login to view] field with 'Y', else ‘N’
- If 'Activity' = "Delivered" then populate the CSV.Delivery_Date field with the
- basic error handling
Sample file attached
5 freelancers are bidding on average $143 for this job
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi