**PLEASE ONLY BID FOR THIS PROJECT IF YOU CAN START WITHIN A FEW HOURS OF ME AWARDING YOU THIS PROJECT AS IT IS URGENT**
**I WILL AWARD THIS PROJECT IMMEDIATELY IF YOU CAN START RIGHT NOW, OFFER GOOD PRICE, HAVE RECENT GOOD FREELANCER FEEDBACK**
This project is to to add some functionality into a basic Excel spread sheet.
We are an online seller in London, we sell on Ebay, Amazon and our Magento website. We mainly sell on [url removed, login to view] but we do have a few listings on other worldwide Ebay sites (and in other currencies)
We have our stock list in XL file each item with unique SKU, we export out of Ebay the active file list.
We need you to build the functionality into our excel spreadsheet, where we import the Ebay CSV active listing file into a new worksheet in our Excel Stock file, and then to perform a few tasks and display the results next to the same SKU in the stock worksheet.
The tasks need performing:
Build functionality into XL to allow import and sorting of the active file which is .CSV from ebay so we can see the information that is required.
Some of our stock codes have 4 zeros, when we look at the Ebay active list it doesn't show the first zeros. We can fix this easily by formatting, and custom and typing a few zeros in, you need to automatically make this change.
As mentioned, we have few ebay listings on non [url removed, login to view] sites and in the active list these international listings are easily seen by the currency in the price tab, so we need the process here to strip out the few international listings and paste them into a new worksheet
We have a few listings which are "bundle" items and not linked to our SKU with a completely different code. We need these bundle listings stripped out of the data and put into separate excel worksheet
We need you to delete few columns of the data from the ebay active .csv list
The reason we need this functionality is so we can check the prices listed on ebay against the sell price in our stock file regularly (so we can then make any change to ebay to adjust prices if needed to). So we also need the spreadsheet to highlight the items that are listed on ebay too high price in one color, and items that are listed on ebay too low priced in another column. We also need to highlight the difference ie the "preferred sell price" from our stock list against "actual ebay sell price"
**Please only bid if you can start this project right away. I will award this project immediately if you offer good price, have some recent feedback, and can start immediately **
Hello from London... Simon
5 freelancers are bidding on average $27 for this job
Hello, ready to start. I work fast and can do it asap. I am concentrated on details and You can rely on my [url removed, login to view] see my portfolio. Best regards.