SmartSheet Data Entry Specialist Needed
Budget: $2 – $8 CAD
• Product listings format for a Bathware company
• Listing products from different stores to compare pricing
• Use information from an Excel source file to implement pertinent information into a Smartsheet sheet (similar format to Excel) – online tool
• Researching on the web per store & including the product information into Smartsheet
• Hyperlinking the codes to the specific webpage
• Validate information on a daily basis to start – to review each product based on store
• To be worked on ASAP **
Assumed time allocated for categories
1. Shower Doors = 9 hours
Home Hardware store = 40 products
Lowes store = 30 products
Rona store = 46 products
Reno-depot store = 37 products
Total products = 153 products
2. Freestanding = 3 hours
Home Depot store = 2 products
Home Hardware store = 11 products
Lowes store = 5 products
Rona store = 5 products
Reno-depot store = 2 products
Total products = 25 products
3. Shower kits = 5 hours
Home Depot store = 7 products
Home Hardware store = 19 products
Lowes store = 7 products
Rona store = 8 products
Reno-depot store = 11 products
Total products = 52 products
4. Bases = 5 hours
Home Depot store = 9 products
Home Hardware store = 6 products
Lowes store = 11 products
Rona store = 16 products
Reno-depot store = 12 products
Total products = 54 products
5. Walls = 6 hours
Home Depot store = 14 products
Home Hardware store = 23 products
Lowes store = 11 products
Rona store = 30 products
Reno-depot store = 12 products
Total products = 90 products
6. Shower = 4 hours
Home Depot store = 2 products
Home Hardware store = 20 products
Lowes store = 5 products
Rona store = 12 products
Reno-depot store = 2 products
Total products = 41 products
Total time assumed to finalize future categories = approx. 32 hours
• Listing products from different stores to compare pricing
• Use information from an Excel source file to implement pertinent information into a Smartsheet sheet (similar format to Excel) – online tool
• Researching on the web per store & including the product information into Smartsheet
• Hyperlinking the codes to the specific webpage
• Validate information on a daily basis to start – to review each product based on store
• To be worked on ASAP **
Assumed time allocated for categories
1. Shower Doors = 9 hours
Home Hardware store = 40 products
Lowes store = 30 products
Rona store = 46 products
Reno-depot store = 37 products
Total products = 153 products
2. Freestanding = 3 hours
Home Depot store = 2 products
Home Hardware store = 11 products
Lowes store = 5 products
Rona store = 5 products
Reno-depot store = 2 products
Total products = 25 products
3. Shower kits = 5 hours
Home Depot store = 7 products
Home Hardware store = 19 products
Lowes store = 7 products
Rona store = 8 products
Reno-depot store = 11 products
Total products = 52 products
4. Bases = 5 hours
Home Depot store = 9 products
Home Hardware store = 6 products
Lowes store = 11 products
Rona store = 16 products
Reno-depot store = 12 products
Total products = 54 products
5. Walls = 6 hours
Home Depot store = 14 products
Home Hardware store = 23 products
Lowes store = 11 products
Rona store = 30 products
Reno-depot store = 12 products
Total products = 90 products
6. Shower = 4 hours
Home Depot store = 2 products
Home Hardware store = 20 products
Lowes store = 5 products
Rona store = 12 products
Reno-depot store = 2 products
Total products = 41 products
Total time assumed to finalize future categories = approx. 32 hours