Job Posted: 21.11.2021 22:31:30
Hi there, we are a retail company and are currently looking for an excel Whiz that can help us come up with a solution.
Our Problem: We have multiple suppliers who have a range of products that change in price and availability constantly. Our team are spending hours constantly looking line by line to update our pricing excel sheet (we use Vend as our pos system and can export our data list and reimport with changes to update them on the system).
The Solution We Are Looking For: We are looking for a solution to automate our price updates. The simplest way to look at it would be:
Step 1: Have a method to analyse and compare current pricelist to (for example) the pricelist from the week before (by supplier). Identify price changes, and items that have been discontinued (0 stock on hand, or missing line item from previous sheet), and also to identify new products that are added to the list (not on previous sheet but is on the current sheet).
Step 2: Have a system to be able to segment the results (via automated highlighting / other easier method) for simple filtering and data analysis.
Step 3 (Ideally): Have a method to sync price updates (based on rules) into our universal source of truth – our Vend pricing list.
We have roughly 3 or 4 different supplier sheets that we would like this process done with and are happy to discuss further on a zoom call. Thanks for your time!
1 to 3 months
Less than 30 hrs/week
Withdraw money from fiverr, upwork, freelancer, one hour translation, shuttershock, gettyimages etc with Payoneer
Get Paid Directly to Your Local Indian Bank Account in INR at Low Cost – only 2%.
Your clients can now pay you from their credit card or bank account via the Payoneer Billing Service
Free registration. $25 Bonus for signup
When you signup for Payoneer and withdraw $1000 per year, you will get a bonus of $25 just for using it. Use “Register Now” button to receive the bonus.
Work with clients from all over the world
Receive payment easily from any freelancing marketplaces like
Airbnb, Fiverr, Amazon, UpWork and Commission Junction worldwide.
Low Fees and Good Limits in India
Up to 2% – With Payoneer you can easily withdraw funds to your Indian bank account in local currency at excellent rates, giving you more local currency for your hard work!