Ecommerce Inventory Tracker

Module 1GENERAL INFORMATION ON INPUT REQUIREMENTS
Unit 1Read First
Unit 2Download This
Module 2OVERVIEW OF SHEETS
Unit 1Sheets Snapshot
Unit 2Overview of All Items Sheet
Module 3USING THE SHEETS
Unit 1Excel Table Settings
Unit 2How to Input Items - All Items List
Unit 3How to Delete Columns and Add Dynamic Columns
Unit 4How to Input New Inventory Purchases
Unit 5How to Input Sold Inventory
Unit 6How to Add Bundles and Multipacks
Unit 7How to Use and Read Inventory On-Hand
Unit 8How to Speed Up Input with Fill Series and Copy Cells Down
Module 4CUSTOMIZING THE SHEETS
Unit 1Excel Basics In a Nutshell
Module 5APPLICATIONS DEMONSTRATED
Unit 1How to Create Custom Seller SKU
Unit 2How the Amazon Lookup Works
Unit 3How to Use Barcode Scanner to Speed Up Input
Unit 4How to Import Beginning Inventory - Amazon Demonstration
Unit 5How to Copy and Paste All Items from CSV - Amazon Demonstration
Unit 6How to Import Sales, Copy & Paste, Find Monthly Sales and COGS
Unit 7How to Record Amazon Returns and Re-List on Another Platform
Unit 8How to Figure Beginning Inventory, Purchases, and Ending Inventory