Bringing a ceramic-coatings brand's listings, files and product videos under its own roof.
The situation
Diamond ProTech sells ceramic coatings and detailing products on Amazon and through its Shopify store. In mid-2026 three things needed doing at once: the Amazon catalog needed a full flat-file rebuild for Amazon's partner listing team, the company's files sat across 14 shared drives on an account that was about to be closed, and the store's product pages depended on YouTube embeds the company wanted to bring in-house.
What took place
Amazon catalog and flat file
Bulk changes on Amazon run through the flat file: the category listings report downloaded from Seller Central, edited offline and uploaded back by Amazon's partner listing team. The coating range alone is 32 ASINs, each listed twice as an FBA and an FBM offer, so every change had to land on 64 rows at once. Working directly with Amazon's listing contact, the file was rebuilt across 11 parent product families: variation families built the way Amazon's product types allow, item names held to the 75-character limit, duplicate ASINs caught, and brand and manufacturer fields locked to one spelling.
Each round was scripted rather than hand-checked. Validation passes flagged character limits, duplicates and required fields still empty, and the count of required cells left blank fell from 4,230 to 472 over three rounds, about 4,500 corrections in all. The last pass caught 30 safety-data-sheet cells carrying two links each, seven of them on parent rows that would have blocked whole families at upload. Every round shipped with its own change log, and the final file was checksum-verified before Amazon's team took it.
File migration onto the company's own drive
All 14 shared drives were inventoried. Before access ended, all twelve document drives and part of the marketing video library were captured, audited file by file and copied to an external drive delivered to the owner: 29,670 files and 1.21 TB. The company's own shared drive was then rebuilt in the old folder structure, with a short guide so the owner can work from it directly.
Product videos onto Shopify
The 36 videos the storefront was pulling from YouTube were downloaded and verified. 26 were hosted directly on Shopify and 24 product galleries swapped over, with the theme's product tabs reading from a metaobject, so all 45 product pages now load without a single YouTube iframe.
What came out
A listing file Amazon's team could upload, the company's records on a disk the owner holds, and a storefront that no longer depends on a third-party video host. Every account stayed in the company's name throughout; the work ran on invited access only.