Product spreadsheet update and image resizing/renaming

Visit manufacturer's website and add missing information for my product spreadsheet. Locate and copy HTML code for each products Ensure proper SEO-friendly HTML for each product (see extended notes). Resize all product images to create both large and thumbnail images. Rename all images to be SEO-friendly. ## Deliverables Brief Description Visit manufacturer's website and add missing information for my product spreadsheet. Locate and copy HTML code for each products Ensure proper SEO-friendly HTML for each product (see extended notes). Resize all product images to create both large and thumbnail images. Rename all images to be SEO-friendly. Spreadsheet Instructions-Left to right NOTES: I have included instructions for each section below under the area labeled NOTES. Please ensure 100% accuracy in following the instructions I have given as inputing incorrect information into this spreadsheet will keep the needed information from being uploaded correctly to my website. Further, the information in this spreadsheet will serve as a master document with which I will make updates to the entire site; therefore, please double check your work and make sure it 100% correct. Formatting * This is an e-commerce website therefore, SEO (search engine optimization) and SMO (social media optimization) is critical to the financial success of the website. * DO NOT use bold fonts for any words in row 1 of the spreadsheet. * Please ensure that **Product_Code Column** **NOTES:** * Use the product code/item code as contained in the Wise Company, Inc. Drop Ship Wholesale Pricing, 2011 data sheet. * Ex. 05-501 **Product_Name Column** NOTES: Use the following instructions only for products 05-501 to 05-706. * Use the document: Wise Company, Inc. Drop Ship Wholesale Pricing 2011 * Visit [[login to view URL]][1] , search for and start with the first product on the list: Item No. 05-501, 6 Case Pack - Cheesy Lasagna (2 servings packs) * Remove any information about cases or packs * Rename each product to start with the phrase Food Storage Meal followed by the name of the actual meal. For example: The first product on the drop ship document is Item No. 05-501 6 Case Pack - Outdoor Cheesy Lasagna (2 Serving Pouch) Rename it to: Food Storage Meal - Outdoor Cheesy Lasagna For products 05-510 to 01-184, please keep the names as they are listed in the pricing sheet. For products 40-40240 to 40-44320 please keep the names for both products and images exactly as they are found in the pricing sheet; however, for all images, please use the following notes. **Image column** General Notes: * To help with the SEO and SMO, please use dashes between image names; for example: * For SEO value, please use dashes to separate each word in the image name. * Each image must have the product name included in it along with either of these phrases as they fit with the type of product: [login to view URL] [login to view URL] * Again, to help with search engines, please use the first naming convention with any food storage packages and the second naming convention with any individual meals. Large Images Height: 200px Width: 200px After you've re-sized the images to be 200px X 200px, please copy and paste the image file name after the words: /images/products/ into the spreadsheet column labeled Image. Here's an example: /images/products/[login to view URL] **Thumbnail** NOTES: All thumbnail images must be the following size: Height: 100px Width: 100px * After you've re-sized the images to be 100px X 100px, save the new file with -tn (thumbnail) after the file name. * Here's an example: [login to view URL] * Place all thumbnail images into a separate folder than the larger images so I can keep them separate. * Just as with the larger images, copy and paste the image file name after the words: /images/products/ into the spreadsheet column labeled Image. Here's an example: /images/products/[login to view URL] **Manufacturer column** NOTES: Use Wise Co. as the information for this column. **Category_Code column** NOTES: Please leave alone. **Parent_Category column** NOTES: Please leave alone. **Featured_Product column** NOTES: Use a zero in this field for each product. **Retail_Price column** NOTES: Do not use the $ symbol; only use numbers. **Sale_Price column** NOTES: Do not use the $ symbol; only use numbers. **Cost column** NOTES: * Use the pricing found in the Drop Ship Pricing 2011 document column labeled Case Pack Cost * Do not use the $ symbol; only use numbers. **Weight column** NOTES: * All weights must be copied here. DO NOT INCLUDE THE LBS. symbol. * Use the weight listed in the Drop Ship Pricing 2011 document under the column Wt. **Shipping_Price column** NOTES: In this column, please input the word Active for each product that you've worked on. **Description column** NOTES: * Use the document: Wise Company, Inc. Drop Ship Wholesale Pricing 2011 * Visit [[login to view URL]][1] , search for and locate the first product Item No. 05-501, 6 Case Pack - Cheesy Lasagna (2 servings packs) * Look at the source html code for each product, select the coding which describes the product and paste it into the spreadsheet in this field. * If needed, please change the html source code for each product to match the following format: <h1>Product name</h1> <h2>product tagline</h2> <h3>Product Description/Items</h3> <li>product contents/features</li> **Keywords column** * View the html source code for each product * Find the keywords used for that product and copy them into this column * Separate each keyword or keyword phrase using a comma. * If a product doesn't have any keywords, please research and include the top 8-10 keywords most relevant fo this product as found on Google. **Case_Amount column** NOTES: * Input the Case amount as found in the Drop Ship document. **Case_Dimension1 column** NOTES: * Input the number found in the column labeled L **Case_Dimension2 column** NOTES: * Input the number found in the column labeled H **Case_Dimension3 column** NOTES: * Input the number found in the column labeled W