1. Fix SKU - For Shoes SKU = [ALU Column] from QB file, For Apparel SKU =[UPC column] from QB file
2. Clean up brand names - Standardize word case & spelling for known brands and remove <blank> those cells that are not brands
3. Change the categories for kids shoes based on kids shoe sizes
4. Item Name should be appended to the [end of all products]?? what column are we appending it to ? [Item Description]?
[url removed, login to view] has made changes - you may want to keep those changes