Converting a product catalog into a MS Excel spread sheet. The XLS document should have the following rows/categories:
1. Product Category (Type, product line category name)
2. Reference/Part #
3. Description w/ dimensions and rating (power)
3. Unit of Measure (i.e. EA, Set, etc...)
4. Line item cost (w/... see #5)
5. Extra column to have marked up price
6. Include our company logo and manufacturer logos in the header (Hold Fast Industries & US LED)
Next I would like for there to be a second tab with a picture of each line item/product with the related product reference number, including the electrical rating information next to it (easily identifiable). The second attachment is a similar "product" catalog that may be easier to reference. Any questions just ask away!
Thank you,
-Will