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