Need Help Automating The Adding of Products from Sites into WordPress

I need a script or a program (I'm not sure which) to help me gather certain information from sites that sell things and put that information into my WordPress where I will be selling the same product.

There are many specific things that need to be done each time I add a product. It takes me about 5 minutes to add 1 product because of all the things that need to be set.
I need to add over 200 products to my WordPress site.

Thanks for taking the time to look at this, I appreciate any help I can get.
P.S. I was looking into automaters and keyboard and mouse recorders like ReMouse but that doesn't help me with specific information that I need to type in that is different for every product, for example naming different pictures while saving them to the HDD.
I think what I need is an automator that is able to pause what it's doing and let me type something at a specific stage and then have it continue its work afterwards.
I could be totally wrong, again I'd appreciate any help I can get from a professional.

You've already discovered some tools to help you automate, though the complexity of the task is going to come down to what sites you want to scape - and how the data is presented. Is it just static HTML tables, or is loaded via AJAX after a login? (for example).

You can use the screen clicking software, or you can code your own. Coding is typically a better way to go in terms of resilience and ease of automation, but it comes down to your skills/budget.

In terms of getting it into Wordpress, you'll want to scrape the content into a csv (or database) with the different post variables you want to replicate - Title, Post Content, Price, Featured Image (?), etc. Once you have a nicely formatted csv you'll be able to find a plugin to import and parse that data.

Hi,

I'm having 10+ yrs of experience in automating web pages using various automation tools and scripting languages.

For your requirement, I would suggest the following
1. Get a free web automation tool (iMacro / Selenium Based / VBA) to first scrap the data from the site that is selling the items
2. Store the data into a spreadsheet
3. Use the same web automation tool to update your WordPress site

Try yourself with free tools (Record and playback) or you can talk to any automation experienced guys (I can do too )

Thanks for your help guys, I've found someone on this site that's doing pretty much exactly what I'm doing, and has already built a very specific bot for it. So I'm going to buy it from him.
Thanks again

Hi,

Thanks for the update... Good luck

I have a similar tool that gets videos from youtube and add to blogger blog.

Refer my post on the same by searching the below title
Automatic Video Blogging (Blogspot + Youtube)