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
SEO fields completed
Confirmation upon completion |
