Project Summary: Home Decor eCommerce Product Listing &
Organization
📌 Project Title:
Home Decor Product Listing & Optimization for eCommerce Store
BY: Chukwumuanya E. Nwankwo
🎯 Objective:
To create a mock product listing catalog for 25 home decor items, structured for a Shopify-style eCommerce store.
The goal was to showcase skills in product categorization, pricing, tagging, and content structuring using standard
tools and SEO principles.
Tools Used:
ï‚·
ï‚·
ï‚·
ï‚·
Google Sheets (for spreadsheet layout)
CSV formatting (for product import/export preparation)
ChatGPT (for content creation and formatting support)
Shopify (image URL structure reference)
SCREENSHOTS
1. Product Spreadsheet with Title, Description, Tags, Prices, Categories
A well-organized spreadsheet containing 25 home decor items, each with a compelling product title, vivid
description, SEO-optimized tags, realistic pricing, and categorized by decor type for streamlined filtering and
upload.
2. Tag Optimization Section
A dedicated table showcasing 5–7 relevant, search-friendly tags per product to enhance discoverability and
filterability on platforms like Shopify or Etsy. Tags include themes, materials, usage, and design styles.
3. Shopify-Style Image URLs
Placeholder image URLs are formatted to Shopify CDN links, giving the appearance of a live product catalog.
Useful for testing visual presentation and layout before uploading actual images.
4. Filter Dropdown in Action (e.g., filter by "In Stock")
Dynamic filters (e.g., by category, price range, or stock status) are enabled in the spreadsheet to demonstrate
usability and real-world functionality of product data management.
5. File Export or "Save As CSV"
Illustrates the ability to save the final spreadsheet as a CSV file for seamless upload into an eCommerce platform
like Shopify, WooCommerce, or Etsy.
Challenges Solved:
ï‚·
ï‚·
ï‚·
ï‚·
ï‚·
Ensured SEO-relevant tags (5–7 per product) to improve product visibility.
Wrote clear, vivid, and compact product descriptions for online display.
Organized products by category, pricing, and image URLs in a scalable format.
Structured Shopify CDN image links for realistic store integration.
Created data cleanly formatted for CSV upload (no line breaks or extra spacing).
💠Reflection: What Did I Learn?
This project helped me sharpen my skills in product listing optimization, particularly in using search-relevant
tags, clean descriptions, and structuring content suitable for import into platforms like Shopify or
WooCommerce. I also learned the importance of organizing mock data with real-world eCommerce
standards, which will help me confidently support store owners and online sellers in the future.