Product Data Migration: City Hive to Shopify

Job ID: 38954327

Budget: $30 – $250 USD

Project Title:

Data Export & Shopify Product Import with Tags and Filters Setup

Project Description:

I need assistance migrating product data from my existing website hosted on City Hive (Happy-Cork.com) to Shopify. City Hive does not have a direct export function, so I need someone to scrape product data and prepare it for import into Shopify, ensuring all relevant details are included.

Key Project Requirements:
1. Data Extraction:
• Scrape or extract product data from the website (including product titles, descriptions, pricing, images, tags, and options/variants).
• Example product page: Legend Vineyard Exclusives LVE Cabernet Sauvignon.
• Ensure that product categories (e.g., Wine, Spirits), brands (e.g., John Legend), and relevant filters (e.g., Cabernet Sauvignon, Red Wine, Napa Valley) are collected.
2. CSV File Preparation for Shopify:
• Format the data according to Shopify’s CSV template.
• Include the following fields:
• Title: Product name.
• Body (HTML): Full product description.
• Vendor: Brand (e.g., John Legend Wines).
• Product Type: (e.g., Wine, Spirits).
• Tags: Relevant product tags for Shopify filtering (e.g., Cabernet Sauvignon, Red Wine, Napa Valley).
• Images: Ensure image URLs are correctly linked or imported.
3. Metafields and Filters:
• Set up Shopify metafields to support product filters (e.g., region, grape type, alcohol percentage).
• Ensure imported products can be filtered correctly by customers using Shopify’s built-in filters.
4. Quality Check:
• Verify that all products display correctly in Shopify after import, with accurate descriptions, images, tags, and filters.

Skills Required:
• Data Scraping & Extraction
• Shopify Product Import via CSV
• CSV Formatting for Shopify
• Familiarity with Shopify Metafields & Filters
• Basic HTML (for product descriptions, if needed)

Deliverables:
1. Scraped product data in CSV format ready for Shopify import.
2. Imported products on Shopify with all details accurately displayed.
3. Shopify collection filters set up using tags and/or metafields.

Additional Information:
• There are approximately 900 products to migrate.
• I can provide access to Shopify admin and any additional details needed.

Timeline:

Looking to complete this within 1-2 weeks

Budget: $200

Please provide a quote or estimate for this project.
Related categories: PHP Data Entry Excel Web Scraping Data Mining