How Sukoshi Mart Optimized Product Launches and SEO with Clouver's Airtable-Shopify Integration

By: Clouver Team | Published On: Oct 24, 2024

About Sukoshi Mart

Established in 2018, Sukoshi Mart has quickly become a favorite destination for fans of Asian pop culture, beauty products, K-pop merchandise, and licensed anime collectibles. From its humble beginnings as a passion project, the company has grown into a thriving business known for delivering trending products across multiple categories.

Services Used

The Challenge: Manual SEO and Product Management Processes

It was a challenge for Sukoshi Mart’s marketing team to manage over 7,000 SKUs across its eCommerce store. They relied on a manual process to update critical SEO metadata—such as product titles, meta descriptions, and keywords—on Shopify, which was time-consuming and prone to errors.

The lack of a collaborative, streamlined process for managing product metadata between the Warehousing and Marketing teams limited Sukoshi Mart’s ability to effectively optimize product and collection pages for SEO keywords. As a result, they missed valuable opportunities to rank for competitive, transactional keywords, which affected their overall search engine performance.

Clouver’s Solution: Seamless Data Sync Between Airtable and Shopify

Clouver’s Airtable Upsert Integration powered by webhooks helped Sukoshi Mart streamline its product data flow and improve SEO management across teams. Here’s how Clouver made it happen:

Unifying Airtable Data: Sukoshi Mart maintained two separate Airtable bases—one for their Warehousing team and another for their Marketing team. Clouver's integration synced the product data from the warehousing Airtable, containing essential product information like descriptions and live dates, with the marketing Airtable, which housed SEO-related fields such as SEO titles and descriptions.

Automated Data Updates: With Clouver's webhook-to-Airtable upsert solution, Sukoshi Mart was able to automate the synchronization process between these two Airtable databases. Any update made by the Warehousing team was automatically reflected in the Marketing table, ensuring real-time accuracy without manual intervention.

Shopify Sync: In addition to syncing the two Airtable bases, Clouver integrated the marketing Airtable with Sukoshi Mart's Shopify store. This allowed the Marketing team to directly update fields like product titles, meta descriptions, and SEO keywords in Airtable, and those changes were automatically reflected in Shopify.

Bi-Directional Sync: Clouver also ensured that if any product details were updated directly on Shopify by another team member, those changes would sync back to Airtable, ensuring consistency across all platforms.

Managing SEO for Collections: Clouver helped the Sukoshi Mart team manage not only product pages but also collection pages. Collection-specific SEO data could now be synced from Airtable to Shopify, improving the team's ability to implement a cohesive SEO strategy across the site.

The Results: Improved Efficiency and SEO Performance

Thanks to Clouver's integration, Sukoshi Mart’s Marketing team now has a fully automated system to keep product and collection metadata synchronized between Shopify and Airtable. Here’s what Clouver delivered:

Real-Time Data Sync: All product and SEO metadata, including H1s, page titles, descriptions, and SEO keywords, is automatically updated across over 7,000 SKUs, ensuring the latest data is always live on the eCommerce store.

Operational Efficiency: The Marketing and Warehousing teams can now work in parallel without worrying about manual data entry or errors. This has significantly reduced operational overhead and time spent on routine updates.

Enhanced SEO Strategy: With product and collection pages now optimized with the right keywords and meta descriptions, Sukoshi Mart can better target competitive, high-traffic keywords, improving their chances of ranking higher on search engines.

Conclusion

Sukoshi Mart’s success story highlights the power of automation and streamlined data management in scaling eCommerce operations and optimizing SEO efforts. Thanks to Clouver's tailored solution, Sukoshi Mart can confidently manage their growing inventory while maintaining a strong SEO presence.