General Merchandise Upload Spreadsheet

1. General Merchandise Upload Spreadsheet By Online Catalog Support

2. Overview • Formatting Spreadsheet • Do’s and Don’ts • Contact Information

3. General Merchandise Upload Spreadsheet • Provides product information: • Name • Vendor • Description • Price • Etc.

4. Column A - Parent/Child • P – (Parent) - General Attributes of Product • C – (Child) - Specific Attributes of Product

5. Product Name • Vendor • Description • Skus • Fabric/Origin • Price • Color • Size

6. Column B – Product Sku • Any combination of Numbers or letters • Becomes Product # on website • Must be unique

7. Column C – Product Name • Does not need to be unique • If including vendor: • Please add at the end • avoid this • Ex: Hooded Sweatshirt– Jansport

8. Column D - Vendor Name • Required field • No vendor information enter a “-”

9. Column E – Thumbnail Filename • Name of the image file • “T” in front of the filename • Ex: TIMG_065.jpg • Must be exact as image file sent

10. Thumbnail Filename View – Landing Page • 100 x 130 pixels

11. Column F - Image Filename • Name of the image file • No prefix needed • Ex: IMG_065.jpg • Must be exact as image file sent

12. Image Filename View - Detail Page • 270 x 400 pixels

13. Column G – Large Image Filename • Name of the image file • “L” in front of the image name • Ex: L1085.jpg • Must be exact as image file sent

14. Large Image Filename View • 600 x 600 pixels

15. Column H - Description • Required field • Please state Printed/Embroidered/Etched/etc.

16. Column I - Fabric • Optional • Format: 70% Cotton/ 30% Polyester

17. Column J - Origin • Optional • Enter Imported/Made in USA/Canada

18. Column K - Price • No formatting needed • Do not include “$”

19. Column L – Sale Price • Enter sale price if available • No formatting needed • Do not include “$”

20. Column M – Tax Code • 5-digit Follett code • 61000 Apparel • 76800 Gifts and Accessories • 61050 Infant/Toddler/Youth • Required field

21. Column N – Defining Attribute 1 • Defines the first attribute of your product • Usually Color Code or Size • If no Color or Size available – leave blank

22. Column O – Defining Attribute 2 • Defines the second attribute of your product • Usually Color Code or Size • If no Color or Size available – leave blank

23. Column P – Defining Attribute 3 • Additional attribute to be defined

24. Column Q – Product Category • Category to load item to: • Default category – already created • Custom category – create your own • Must enter category code name: • Ex: t-shirts, enter TShirts • Ex: women’s, enter Womens

25. Column R – Item Sku • Represents the individual skus for each color/size • Must be unique to that of the Product Sku • Required field

26. Column S – Product Sku • Same as Column B • Must be unique to that of the Item Sku • Copy Parent Sku down for each Item Sku

27. Column T – Defining Attribute 1 • Used to define the Color Code/Size • Based on Column N

28. Column U – Defining Attribute 2 • Used to define the Color Code/Size • Based on Column O

29. Column V – Defining Attribute 3 • Used to define the Color Code/Size/Other • Based on Column P

30. Column W - Visibility • Y for Yes, Visible • N for No, Not Visible

31. Column X - Status • Value represents product availability • A (Available) • O (Out of Stock) • B (Backorder) • P (Pre-order)

32. Column Y – Available Date • Optional • When will the item be in-stock

33. New Product – Website View

34. Questions - Who Do I Contact? • PSC • Customer Service/Software Issues/CMC or Accelerator Passwords • (800) 872-9243productsupport@fheg.follett.com • Online Catalog Support • General Merchandise/Spreadsheet • OnlineCatalogSupport@fheg.follett.com • Efollett Support • Marketing Related Projects • Banners/ Featured Products • Contact your efollett Web Specialist: • http://contest.efollett.com/espot_2/contactus.html • Or Group email box: efollettsupport@fheg.follett.com