iMacros to auto input price by quary data from excel

Support for iMacros. The iMacros software is the unique solution for automating every activity inside a web browser, for data extraction and web testing.
Forum rules
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information:CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
Post Reply
Hijotech
Posts: 14
Joined: Tue Sep 26, 2017 5:54 pm

iMacros to auto input price by quary data from excel

Post by Hijotech » Mon Oct 09, 2017 7:05 pm

Google Chrome:61.0.3163.100
Os: Windows 7 x64
iMacros: 8.4.4
I will like iMacros to bid a price of product online automatically by quary data from excel base on the shoe size such as the following: For Example

I have created list of shoes product and their cost base on sizes excel:

Dorothy's Ruby Red Shoes size
1. 206 --------- $35
2. 207 --------- $40
3. 507 --------- $48
4. 701 -------- $56
5. 800 -------- $80
6. 805 --------- $95

Now if iMacros click on the Shoe size, I want iMacros to automatically quary the excel data to locate the exact bid price of the shoe i specified in the excel file and input it into the price box on the web.
TAG POS=1 TYPE=INPUT:NUMBER ATTR=ID:inputPrice CONTENT="*"
If the iMacros select the Dorothy's Ruby Red Shoes size that are not on the excel file iMacros should skip to the next line of code which is:
Wait Seconds:840
Please help
Post Reply