Woman wearing rings and layered necklaces by a pool, her fingers at her lips

2023–2024

Meierotto Jewelers

We connected Meierotto Jewelers’ ERP exports to Shopify with a custom AWS application that matches product records and updates the online catalog automatically.

View live siteView live site

/ services

/ Industry

/ Partners & Stack

About the Brand

Founded in 1979, Meierotto Jewelers is a family-owned jewellery and watch retailer in North Kansas City, Missouri. Its showroom and online store offer fine jewellery, diamonds and watches, supported by custom design, repairs and specialist aftercare.

The Challenge

The ERP exported product data as CSV files on AWS, but Shopify needed each record matched to the right item. Meierotto Jewelers required a connection that could apply those updates to its online catalog automatically.

Gold and steel wristwatch on a light background

The Solution

We built an application to read the ERP’s CSV exports on AWS, match records to Shopify products and update their attributes through the Admin API. This connected the existing product data to the store’s catalog maintenance.

Diagram of ERP products synced to Shopify products with attribute mapping, plus smart collections

One-Way Product Data Sync

Updates flow from the ERP into Shopify, keeping the internal system as the source of product attributes. The mapping layer connects each incoming record to the store item it should update. Smart collections support browsing and filtering across that catalog.

Flow from an ERP system to CSV files to a custom app on AWS to the Shopify store

Keep Your Catalog in Sync

Product data already lives in your ERP. We can match those records to your Shopify catalog and build an application to keep it updated. Let’s discuss the systems you need to connect.

Contact us

Related works

Great Commerce projects are just one short message away

By submitting this form you agree to the processing of your personal data in line with the privacy policy.