Build an interactive, shareable, inventory control spreadsheet

Budget

$517.24FIXED

Client

Ca Ankit India

Status

AwardedDec 31, 2017
We want to have a simple to use spreadsheet for inventory control that can be used on ipad and android tablet - Google sheets, maybe?

We have around 60 products, which each have from one to six sizes. We purchase the raw product from numerous vendors, and sell within 24 hours. The inventory totals must be updated frequently during the workday. We will have 5,000 to 10,000 items on hand, available for sales to only 2 customers - not to general public.

We need a spreadsheet so that workers can keep track of current inventory, purchase orders pending receipt from vendors, orders from customers pending to fill and ship, and excess stock.

We have started keeping track using a spreadsheet, but this requires physical counts. We use Quickbooks for accounting, but inventory adjustments must be done in the office, not on the work floor, and require exporting to a spreadsheet, and must be formatted to be useful.

Spreadsheet needs to show: 1) pending orders, 2) pending receipts from vendors (purchase orders), 3) stock on hand.

Spreadsheet must be shareable and usable on ipad, android tablet, and windows 10 pc.

Every user must be able to: 1) add inventory, 2) delete inventory (unusable), 3) move inventory from one size to another size.

We use Microsoft Excel.

Skills & Expertise Required

Google Spreadsheets Excel 

Project closed for bidding!



Share this project with your friends



Similar Projects

Google worksheet contract system co...

I have all definition to this project. In a nuthsell we need a system to control contract execution , add products, calculate margin , reports

Fixed, $170.00

VA needed for data entry project, l...

Looking for VA to do data entry for a lead generation project. For the right person, a long-term opportunity is available to manage an email marketing campaign. $4/hour. Must be fluent in English. Fil...read more

Fixed, $16.00

Google sheets db query assistance.

This should be a quick 1-2 hour job for anyone experienced with Google sheets query.

I have a sheet full of survey results, sometimes people will perform the survey twice, and I want to make...read more

Fixed, $20.00

TLO/ LEXISNEXUS --SKIP TRACING

Looking for VA proficient in background checks with using TLO / NEXUS LEXUS/ Various other checking services. I have TLO but it is a GREAT bonus to have access to NEXUS LEXUS or any other comprehensi...read more

Hourly, $9.00

Development of underwriting Process...

We are looking for someone to help with the underwriting and due diligence process for a distressed asset Investment vehicle.

We buy Non Performing Residential Mortgages, and are now wo...read more

Hourly, $27.00

Here are our top professional picks for you to hire

Virtual Assistant|Data Entry|Web Research|Software Engineer
Data Entry Virtual Assistant Web Search 
$1 /hr
India
Professional Writer and Web Developer
Data Entry Research Content Writing 
$3 /hr
Kenya
Business Development (New Client Acquisition)
Lead Generation Market Research Analytics 
$5 /hr
India
Reporting Analyst & VBA Developer
Excel VBA Microsoft Excel Excel 
$5 /hr
India
Virtual Assistant
Administrative Support Social Media Marketing Excel 
$2 /hr
India
Operations Manager
Excel Microsoft Powerpoint Photoshop 
$5 /hr
India
Virtual Assistant
Link Building Photo Editing Data Entry 
$3 /hr
Philippines
Research Analyst
Excel Data Processing Lead Generation 
$10 /hr
India
data analyst
Word Excel Windows 
$0 /hr
India
To view more profile join Toogit

Get Started