Help for a novice

RonTon · March 3, 2022

I volunteer with the WRAP (Wheelchair Ramp Accessibility Program), https://wrapiowa.org/. WRAP provides free labor to install wheelchair ramps to provide home access for those that need it. I order to provide accurate material cost estimates we manually copy prices from https://www.menards.com/main/ into an excel spreadsheet. I would like to automate this process with am AutoIt script but how to do it is over my head. I want to take a file with a list of 31 SKU’s and lookup and save the price in a file. Anyone out there that could help with this? Thanks! Ron

Nine · March 3, 2022

@RonTon Welcome to AutoIt forum. Unfortunately, we do not provide scripts on demand here. We are trying to teach people how to program and help them when they face a problem. However, since it is for a good cause, I will try to narrow your apprentissage to the best solution we have around. But for that I will need a bit more information. Can you show (screen capture) the list you are copying from the web site to excel ? Do you know if we could download a file or do we need to scrape the page to get the prices ? If you could also provide the DOM of the page you are accessing when you copy prices, it would greatly help us. Finally, we will need the exact URL you are using when you access the price list.

orbs · March 3, 2022

siding with @Nine above, i believe it would be helpful if you can confirm my understanding of your workflow:

1) you open your browser to https://www.menards.com/main/

2) you manually type an SKU number (or copy&paste from Excel) in the search box, then you press "Enter" or click the search button

3) you are redirected to the product page

4) you observe the price

5) you type the price in your Excel sheet

then you repeat steps 2-5 for each SKU number in your list.

if this is correct, then using the WebDriver UDF should provide you with all the automation you need. it does have a setup process and a learning curve; but once you get it running you'll find it very powerful.

if i somehow missed your intention, please describe your workflow in a more detailed fashion.

also, can you provide a few examples for SKU numbers from your list? i see the URL of a product page can accept SKU for a more direct access, which might come in handy.

RonTon · March 3, 2022

Thank You, that's exactly what I want to do. I took a look at the link you listed and it is over my head.

I have attached a text file containing the SKU numbers I am after.

SKU.txt

Edited March 4, 2022 by RonTon

junkew · March 4, 2022

Add them all 1 time to your basket then you can allways view the basket and have all information on 1 page

Automating the about 32 items is probably not worth the effort if you are a starter in programming

But maybe this logic helps could be you have to tweak some if they are not in building materials

Edited March 4, 2022 by junkew

Block all input without UAC	Save/Retrieve Images to/from Text	Monitor Management (VCP commands)
Tool to search in text (au3) files	Date Range Picker	Virtual Desktop Manager
Sudoku Game 2020	Overlapped Named Pipe IPC	HotString 2.0 - Hot keys with string
x64 Bitwise Operations	Multi-keyboards HotKeySet	Recursive Array Display
Fast and simple WCD IPC	Multiple Folders Selector	Printer Manager
GIF Animation (cached) Debug Messages Monitor UDF	Screen Scraping Round Corner GUI UDF	Multi-Threading Made Easy Interface Object based on Tag

Sign In

Help for a novice

Recommended Posts

RonTon

Nine

orbs

RonTon

junkew

Create an account or sign in to comment

Create an account

Sign in

Browse

AutoIt Resources

Release

Beta