1- We use Shipworks app to pull orders from Amazon and other sales channels.
2- One field is the item number. The format for one company, Fotolia, is 'FOT-12345-24'. FOT is the prefix for Fotolia. 12345 represents the item number. 24 represents the size in inches. There are various sizes, all have two digits.
3- We have other vendors, so we will sort all the Fotolia orders first, from all the NEW orders.
4- We need to REMOVE the 'FOT-", and the '-24' that follows the item number, leaving just the item number. This list of items can be put on a notepad or excel spreadsheet maybe.
5- I want to go to [url removed, login to view], and while logged in to my account, have each item number be added to the shopping cart, with the medium size selected.
6- The macro would run down the list until every item was added to the cart.
7- The macro needs to be able to run down the list of item numbers and not continue to keep the first item.
Can someone do this? I'm looking to have this done ASAP. You will need remote access to my computer at the office once you prove you can do it.
9 freelancers are bidding on average $179 for this job
I have done many such tasks before and i am confident to complete it asap. Also if you see the projects that i have worked on...that will tell you that i can do this.