I have a datafeed and need something to alter some fields automatically so that it can be converted easily to work with EasyPopulate.
The datafeed contains 10-15k rows.
The following processes need to be automated:
What needs to change in the datafeed:
1) Find & Replace certain characters (a list will be provided for you)
2) Change Categories (Categories from distributor and categories on my site are different - I will provide a list of my categories compared to the datafeeds)
3) Create values based off the Excel "concatenate" formula
4) Finally - Pull information from this changed datafeed to make a new datafeed that works with Zen Cart EasyPopulate addon.
5) Find new items not on previous datafeed, and copy image names so that I can mass grab and upload them to server.
As you can see, steps 1-3 and 5 take too much time to complete manually by myself each week. I need something that can help me automate these steps so that instead of taking an hour, it can hopefully take 10 minutes or less.
Please PM me explaining what you would be creating to help me out.
12 freelancers are bidding on average $149 for this job
Sir, all the changes made in excel file, i can do it. i have software and have 10 years working experienced in e-publishing. i have well known macros of data cleanup jobs.