Shopify Product Upload Brief Objective: To bulk upload a full product range to our existing Shopify store using the attached Excel spreadsheet. This includes uploading product data, images, and applying SEO-friendly titles.
1. Product Data Upload Method: Bulk import using Shopify's CSV format.
Source File: Attached spreadsheet titled: Attributes - All Product PLB - October 2024.xlsx Main sheet: ATTRIBUTES- October2024
Key Fields to Include in the Upload:
Product Title: Use the DESIGN column and ensure it's SEO friendly (e.g. "Abstract Burst Grey Rug – Melrose Interiors")
SKU: Use Melrose Stock Code
Vendor: Brand
Type: Use COLLECTION or Construction
Price: Use RRP as the retail price
Compare at price: Optional, use Customer Price Valid until 31-12-24 if applicable
Description: Use the Description column
Material, Construction, Origin, Backing, Pile Height: To be added to the product description or as metafields if available
Tags: Include Indoor/Outdoor, Anti-Slip Advised?, and other relevant attributes
2. Image Upload Image Requirements:
Each product must include at least one image.
Freelancer to locate and assign the correct image for each SKU. If images are not yet uploaded to Shopify, they must be uploaded and matched by Melrose Stock Code.
Images to be named clearly using SKU or DESIGN names.
Note: Let us know if you need access to image files or if these should be sourced from a shared folder or Dropbox link.
3. SEO Titles & Meta Descriptions Titles:
Pull from the DESIGN and COLLECTION columns.
Optimise with keywords such as “rug”, “interior”, “contemporary” etc.
Meta Descriptions:
If Shopify allows, use the first sentence or two from the Description column, with light editing for readability and keyword inclusion.
4. Additional Notes All products marked as Website Current in the STATUS column are to be uploaded
Variants (e.g. same design with different sizes) can be grouped where relevant using Shopify’s variant system
Pile height and backing information should be visible to the customer
Deliverables Products uploaded and visible in the Shopify backend
Image files properly matched and uploaded
One test product submitted for review before batch upload
Google Sheets Project Tracker Creation Category: Automation, Data Analysis, Data Entry, Data Visualization, Excel, Google Sheets, Project Management, Visual Design Budget: $30 - $250 USD
16 Jul 2025 03:52 GMT
BPMN Workflow Automation Specialist Category: Agile Development, Automation, Business Analysis, Data Management, Process Automation, Project Management, Software Development, Technical Documentation Budget: $30 - $250 USD
Social Media Manager & Video Editor Category: Adobe Premiere Pro, Content Creation, Facebook Marketing, Instagram Marketing, Social Media Management, Social Media Marketing, Twitter, Video Editing Budget: $250 - $750 USD
Cartoon Character 3D Models Category: 3D Design, 3D Modelling, 3D Printing, 3D Rendering, Blender Budget: $30 - $250 USD
16 Jul 2025 03:48 GMT
Modern Corporate Hack & Game Day Logo Category: Animation, Branding, Corporate Identity, Creative Design, Event Planning, Graphic Design, Logo Design, Photoshop Budget: $30 - $250 USD
16 Jul 2025 03:48 GMT
Health and Wellness Blog Writing Category: Article Writing, Blog Writing, Content Writing, Copywriting, Editing, Ghostwriting, Research, SEO Budget: $30 - $35 USD
Custom Poster Design Web Template Category: Bootstrap, CSS, Graphic Design, HTML, JavaScript, JQuery, User Interface / IA, Web Application, Web Design Budget: ₹1500 - ₹12500 INR
16 Jul 2025 03:42 GMT
Social Media Marketing Campaign Category: Content Creation, Content Marketing, Digital Marketing, Facebook Marketing, Instagram Marketing, Internet Marketing, Social Media Management, Social Media Marketing, Twitter, Twitter Marketing Budget: ₹600 - ₹1500 INR
