Efficient Website Management for one of the biggest Australia based Photography and Videography camera supplier based on Shopify platform
- 3k products updated every month
- 400+ man hours saved every month by automation
Client Overview:
Project Scope:
Key responsibilities included:
- Creating a customized template for product uploads
- Processing and organizing product information provided by the client
- Searching for product details based on vendor SKU or product titles when needed
- Bulk uploading product information to Shopify’s backend
Challenges and Solutions:
Handling Complex Product Data: Client provided product data through various sources, including email and a Google staging sheet. Managing different data formats and ensuring consistency required meticulous attention. Faith’s team designed a structured template that captured essential details like product titles, SKUs, prices, and descriptions in a unified format, streamlining the process for bulk uploads.
Accurate Product Listing: One challenge was ensuring that all product information—such as SKUs, variant prices, and descriptions—was accurately reflected on Shopify. The Faith team adopted a systematic approach:
- Verifying vendor SKUs and other key product identifiers.
- Ensuring all descriptions and features adhered to the client’s specifications, using appropriate HTML tags for correct formatting on the Shopify frontend.
- Removing any unnecessary or repetitive content to maintain a clean product display.
Optimizing Images for Product Listings: To enhance the product listings, high-quality images were essential. The Faith team edited and optimized product images, ensuring they met the client’s requirements (e.g., 1000×1000 px dimensions, no shadow, white background). When necessary, the team adjusted the product focus (e.g., blurring out unrelated objects like cameras) to showcase the main product clearly.
Ensuring Shopify Backend Accuracy: Once the product data was processed, it was crucial to ensure the accuracy of both frontend and backend listings on Shopify. The Faith team meticulously checked that each field, from pricing to inventory status, was correctly uploaded and displayed. Fields like product status, published scope, and variant inventory were adjusted as per client instructions to align with Georges’ business goals.
Results:
- Time Efficiency: The Faith team successfully uploaded all required products within the project timeline, thanks to the well-structured template and streamlined workflow.
- Product Accuracy: By ensuring all product details, including descriptions, images, and prices, were accurately uploaded, client was able to expand their online store with minimal revisions required.
- Seamless Backend Integration: The careful coordination between product data and Shopify’s backend allowed client to maintain control over inventory and pricing without disruption.