Catalog Associate

Rotomaker; Hyderabad; On-site; INR 450,000 - 650,000; Full time

Job summary

Rotomaker is seeking a Catalog Associate to transform raw product data into Shopify-ready formats and manage bulk uploads. You will ensure accurate product information, including titles, descriptions, SKUs, and attributes, while maintaining data quality across the catalog.

The role requires 1–2 years in e-commerce catalog management, hands-on Shopify experience, and strong Excel/Google Sheets skills. HTML basics are a plus for clean content formatting.

Qualifications

• 1–2 years of experience in e-commerce catalog management.
• Hands-on experience with Shopify Admin and bulk uploads.
• Strong Excel/Google Sheets proficiency.
• Experience creating and mapping Shopify metafields.
• Basic HTML understanding is a plus.

Responsibilities

• Convert supplier and internal data into Shopify-ready formats.
• Upload and update products in bulk via CSVs and Shopify.
• Create and manage metafields and map supplier attributes.
• Format and standardize product titles, descriptions, and HTML content.
• Perform quality checks to ensure accuracy of catalog data.
• Use Excel/Google Sheets formulas for data mapping and QA.
• Maintain and update the catalog, including categories, tags, and attributes.

Skills

Attention to detail

Analytical skills

Problem solving

Data entry

Data cleaning

Large dataset handling

HTML basics

Tools

Shopify Admin

Shopify Metafields

Job description

Job Description – Catalog Associate Position: Catalog Associate Experience: 1–2 Years Employment Type: Full-Time Department: E-commerce / Catalog Management

About the Role

We are looking for a detail-oriented and technically proficient Catalog Associate with 1–2 years of experience in e-commerce catalog management, preferably with hands‑on experience in Shopify. The candidate will be responsible for converting raw product data from suppliers, vendors, and internal sources into Shopify-uploadable formats, managing bulk product uploads, creating and maintaining metafields, and ensuring product information is accurate, complete, and properly structured.

Key Responsibilities

1. 1. Raw Data Conversion & Catalog Preparation
   Convert raw product data received from suppliers/vendors into Shopify-compatible upload formats.
   Clean, organize, standardize, and validate product data before uploading.
   Identify and correct missing, duplicate, inconsistent, or incorrect product information.
   Work with Excel/Google Sheets to manipulate large product datasets.
   Ensure product titles, descriptions, SKUs, prices, inventory, images, variants, tags, collections, and other attributes are properly formatted.
2. 2. Shopify Bulk Product Uploads
   Perform bulk product imports and updates in Shopify.
   Prepare CSV files according to Shopify's required structure.
   Handle bulk creation, updating, and editing of products and variants.
   Manage product status, inventory, pricing, SKUs, barcodes, collections, tags, and saleschannel availability.
   Troubleshoot errors encountered during bulk imports and resolve data-related issues.
3. 3. Metafields & Product Attributes
   Create, maintain, and update Shopify metafields.
   Map raw supplier attributes to the appropriate Shopify metafields.
   Ensure correct metafield definitions, values, data types, and formatting.
   Maintain structured product information such as:
   Brand
   Manufacturer
   Country of Origin
   Ingredients
   Product specifications
   Dimensions/Weight
   Usage instructions
   Additional product attributes.
4. 4. Product Content Management
   Create and format product titles and descriptions.
   Clean HTML content and maintain consistent formatting.
   Standardize product descriptions across categories and brands.
   Ensure product information follows internal catalog guidelines.
   Check product images, image URLs, alt text, and image-product mapping.
5. 5. Data Validation & Quality Control
   Perform quality checks before and after product uploads.
   Verify that uploaded products display correctly on the Shopify storefront.
   Identify mismatched SKUs, variants, images, prices, inventory, and other catalog information.
   Maintain high accuracy while working with large product volumes.
   Prepare reports and maintain catalog-related trackers.
6. 6. Excel / Google Sheets Operations
   Work extensively with Excel and Google Sheets for catalog processing.
   Use formulas such as:
   VLOOKUP / XLOOKUP
   INDEX & MATCH
   IF / IFERROR
   CONCATENATE
   TEXT functions
   Duplicate checks
   Data validation
   Handle large datasets and perform data mapping between multiple sheets.
   Use filters, sorting, pivot tables, and conditional formatting for catalog QA.
7. 7. Catalog Maintenance
   Regularly update existing Shopify products based on new supplier or internal data.
   Manage discontinued, inactive, or outdated products.
   Update product categories, collections, tags, and attributes.
   Assist in maintaining a clean and standardized product catalog.

Required Skills

• 1–2 years of experience in e-commerce catalog management.
• Hands‑on experience with Shopify Admin.
• Good understanding of Shopify product CSV / bulk import process.
• Experience working with Shopify Metafields.
• Strong knowledge of Excel and Google Sheets.
• Good understanding of product variants, SKUs, inventory, collections, tags, and product types.
• Strong data-entry and data-cleaning skills.
• Good attention to detail and accuracy.
• Ability to work with large product datasets.
• Basic understanding of HTML is preferred.
• Good problem-solving and analytical skills.