Is this the right software to use to do this?

[Moraha]

I will soon be setting up a website that will sell thousands of products. The problem is that I don't have inventory, I rely on my supplier's stock availability that they have on their website and they don't provide a service to do this for me.

I've been looking for software to use that will allow me to log into my supplier's website, take their stock availability for each item (every item has their own page: /index.php?main_page=product_info&products_id=xxxxx x), put it into a CSV file, and then have it automatically upload to my website to update my stock to match my supplier's stock. Right now, I'm not worried about the uploading part since I don't have my website up yet. I'm just trying to get the information into a CSV file from each URL. Here are the questions I have below:

1. From running an example in the tutorial pages, it seems as if this program is right for me, but I can't find a tutorial that would do something similar as to what I'm trying to do. I created a new task to get into my supplier's website, then log in successfully. After this, I really do not know what to do to be able to go to each product's URL and extract the SPECIFIC data from the page (not a whole table that i've seen the tutorials on here do). I would also like to insert them in specific cells on a CSV file. Can you direct me to a tutorial that shows how to do this?

2. Is it possible to have this program to do things "behind the scenes"? When I got it to go into my supplier's website, it opened Internet Explorer in front of my eyes. Another program that I used did everything behind the scenes which is what I really liked (the ONLY thing I liked though).

3. If it's not possible to do that, is Automation Anywhere really efficient to use to extract data of thousands of products from my supplier's website? I can't imagine how long it would take to actually load thousands of URLs, pull each specific data out, and put it into a spreadsheet.

Any help is appreciated. I really hope this program is the right one for me. Thanks in advance.

[Moraha]

I've been playing with this program out for a few hours trying to see if it could do what I want but I'm having a little bit of a problem with one thing...Extract Data

The webpage I'm trying to extract from is my supplier's website. Here's an example of what I'm trying to extract:

--------------------
Retail: $99.95/ea
Price: $69.99/ea

1312 In Stock
--------------------

The problem I'm running into is the Before Keyword and After Keyword. I can't seem to get the right part extracted. When I do "/ea", it gets confused because it's on there twice.

[forumsupport]

Hello,

In this case, to extract 1312, you can specify before keyword as '/ea' and after keyword as 'In Stock' in Extract Data command of Web Recorder.

Hope that helps.

[Moraha]

Originally Posted by forumsupport

Hello,

In this case, to extract 1312, you can specify before keyword as '/ea' and after keyword as 'In Stock' in Extract Data command of Web Recorder.

Hope that helps.

That's what I did but I got the wrong result. If you notice in the example, there are 2 "/ea" in the section. Instead of extracting only 1312, it extracts:

---------------
Price: $69.99/ea

1312
---------------
because of this: Retail: $99.95/ea

How can I get around this?

[forumsupport]

Hello,

Can you please email us your contact number at http://www.tethyssolutions.com/ask-the-expert.htm and one of our Automation experts will get in touch with you to help you resolve the problem.