PIM for retail: catalog management for a range that changes four times a year.
The fall range lands in six weeks. Nine of your twelve vendors have sent a spreadsheet, each in its own shape — one column is Item No, the next SKU, a third packs size and color into one string. Two hundred lines from last season need retiring, the clearance markdown has to start Friday at midnight and end Sunday, and 380 new products arrived with a name, a price and one photo. That is retail: not one migration, but the same operation four times a year on a range that is wide rather than deep. Apimio holds the catalog above your Shopify store — one record per product, a quality score on every listing, and vendor files that import themselves.
Five things that break a retail catalog between seasons
None of these are Shopify faults. They are what happens when a wide range, bought from many vendors, is rebuilt on a calendar with a product editor and a spreadsheet.
The season you are running now
The season on Apimio
The range turns over faster than the data
Four drops a year, four rounds of retirements. New products arrive with a name, a price and one image, then go live anyway — the drop date never moves.
Onboarding becomes a repeatable operation
Catalog Hub holds one record per product with attributes, variants, media and per-store overrides. A new drop joins the same catalog, and retired products stay as records, so a returning line is edited, not re-entered.
Twelve vendors, twelve spreadsheet shapes
Column names change between seasons, one file measures in inches and the next in centimeters, and whoever knows the mapping is the launch bottleneck.
Each vendor is mapped once, then repeats
Supplier Bridge proposes a mapping from the vendor file to your attributes; you correct it once. Saved mappings and scheduled runs are Advanced and Enterprise; one-off CSV import is on every plan.
Markdowns start and end by hand
The event starts Friday at midnight, so somebody stays up. It ends Sunday, and on Tuesday four hundred products are still discounted.
The markdown reverts itself
Sale Scheduler takes the products, the discount and the window, snapshots prices at the start, and restores them at the end (Advanced and Enterprise).
Breadth, not depth — and ten definitions of complete
Furniture needs dimensions, apparel needs fit and fabric, beauty needs ingredients. Nobody can say what is ready to advertise, so the feed carries the gaps.
Complete is defined per category, then enforced
Quality Guard scores each listing out of 100 across 74 rules in four outcome areas, Channel-Ready at 80. In enforce mode Publish Gate syncs a below-bar product as a draft.
The same range has to appear in several places
Storefront, Google Shopping feed, Meta catalog, and the line sheet buyers keep asking for. Each is its own export, each a day old, and wholesale prices sit one column from a public file.
One catalog, several outputs
Store Sync publishes to each connected store, Product Feeds host a feed the channel polls, and Line Sheets build the wholesale view. Wholesale fields are excluded from every public surface by design.
Retail catalog numbers you can check
Plan limits and product thresholds, not projections. Every retail figure below is typical for a catalog of that shape — the ones worth acting on are read off your own store.
The retail catalog year, surface by surface
Retail leans on different Apimio surfaces than a single-brand manufacturer. A brand enriches a narrow range deeply; a retailer moves a wide range quickly, on a calendar.
Catalog Hub — where the range lives between seasons
One record per product, with attribute sets per category so furniture and apparel are not judged by the same fields. Variant Manager handles matrices up to Shopify’s 2,048-variant ceiling, and per-store overrides let an outlet price differ without a duplicate SKU.
Explore Catalog HubSupplier Bridge — twelve vendor formats, one shape
AI column mapping reads a vendor CSV or Excel file and proposes a mapping to your attributes; you correct it once and save it. If onboarding vendor catalogs is the whole job, /for/large-retailer-suppliers goes deeper.
Explore Supplier BridgeScheduled Imports — the vendor file that arrives while you sleep
Recurring unattended imports from a file URL, FTP, S3 bucket, Google Sheet or supplier feed, using the saved mapping. A run history records what ran, changed and failed. Advanced and Enterprise.
Explore Scheduled ImportsQuality Guard and Publish Gate — what ready means
A 0–100 score per product and a Store Health page with six plain-language problem areas. Fix cards state the projected score gain, the effort in hours and the revenue at stake, from your own sales data.
Explore Quality GuardSale Scheduler and Bulk Edit — the price work
Sale Scheduler runs planned price changes with a start and an end (Advanced and Enterprise). Bulk Edit covers the unplanned: a spreadsheet-style grid with variants inline, previewed before anything is written. There is no undo after a save.
Explore Sale SchedulerProduct Feeds and Line Sheets — one range, three audiences
Hosted feed URLs per channel: Google Shopping XML first-class, Meta, Pinterest, TikTok and Bing as templates, Amazon and Walmart as importable TSV. /products/trade-portal builds the wholesale sheet from the same records. There is no live API sync to Amazon, Walmart, WooCommerce or Magento.
Explore Product FeedsHow a new season gets onboarded
The loop that repeats every drop. The first pass takes a week, while the mappings and attribute sets are still being decided. The fourth is mostly a schedule running.
Set the bar per category, before the files arrive
Attribute sets give furniture its dimensions and assembly fields, apparel its fit and fabric, beauty its ingredient list. Quality Guard scores against those definitions, so a sofa is never marked complete for carrying the fields a lipstick needs.
Map each vendor once
Drop each vendor’s first file into Supplier Bridge, correct the column mapping and save it. Twelve vendors is twelve mappings, done once. Every later file lands in the same shape.
Put the recurring files on a schedule
Vendors publishing to a URL, an FTP directory, an S3 bucket or a Google Sheet move onto Scheduled Imports and stop needing a person. The run history records what changed, which matters when a price moves and nobody remembers why. Advanced and Enterprise.
Clear the fix list before the drop date
Store Health ranks what is missing across the new products. Bulk Edit closes structured gaps in a grid; Apimio AI drafts the descriptions, SEO titles and alt text that arrived empty — previewed before saving, metered, and logged.
Publish only what passes
Set Publish Gate to preview first, which reports what would have been held, then to enforce. Products under the bar sync as drafts, so the drop goes live with the range that is ready.
One catalog, four kinds of range
Retail covers ranges with very different definitions of complete, and a mixed retailer carries at least two. One attribute set for the whole catalog stops working.
Furniture and large items
A three-seat sectional can carry 240 variants across fabric, size and leg finish, and it comes back when the dimensions were wrong or absent. Those fields decide the return rate and whether it clears a shopping feed.
Furniture catalogsFashion and apparel
Size and color matrices multiply fast, seasons retire whole blocks of SKUs, and the same garment needs different size vocabulary per market. Onboarding volume per drop is highest here, so retired-but-kept records save the most re-entry.
Fashion catalogsBeauty and wellness
Volume, ingredient lists and claims have to be exact, and the copy is regulated in a way furniture copy is not. Apimio AI drafts are previewed before saving — a person signs off on every claim.
Beauty catalogsHome decor
Wide, low-priced, image-led, and usually the largest SKU count in a mixed retailer’s catalog. The failure mode is images, not depth: one photo, no alt text, dimensions below what Google accepts.
Home decor catalogsA typical 6,400-SKU furniture and home retailer, 12 vendors, four drops a year
These figures are typical for a catalog of this shape, not a measured customer result. Read them as the arithmetic of the operation; check yours in Store Health.
Where the catalog starts
6,400 live SKUs across furniture, lighting and home decor, from 12 vendors. A catalog in this state typically scores in the low sixties against a Channel-Ready bar of 80: roughly 1,800 products with no dimensions, 400 with no category, 900 with a single image.
The season-prep arithmetic
The fall drop adds about 900 new SKUs and retires 700. Twelve vendor files at two to three hours each of column reformatting is a 30-hour week before a description is written, four times a year. Mapping each vendor once moves that cost to the first drop.
The markdown that has to end
The clearance event covers about 2,100 SKUs at five discount bands, Friday 00:01 to Sunday 23:59. By hand that is two late nights and a Tuesday audit. Sale Scheduler snapshots, applies and reverts them (Advanced and Enterprise).
What the feed does with the gaps
The 900 single-image and 1,800 dimensionless products are the ones Merchant Center disapproves. Pre-publish diagnostics flag the checks behind most rejections — title length, availability vocabulary, image dimensions, price mismatch, missing GTIN — before publishing.
What it costs to run
At 6,400 SKUs this retailer sits inside the Advanced plan’s 50,000 and pays $399/month for the feeds, scheduled imports and Sale Scheduler it depends on. A second store — an outlet, say — is $100/month, and stores five through ten are $70 each.
How retailers usually run the catalog, and where each approach stops
Four setups common in retail, compared on the jobs this page is about. Each works for somebody — the question is which stops working at your range width. Wider field at /compare/best-pim-software. Checked 2026-08-28.
| Shopify-native Apimio | Shopify admin + spreadsheets | A feed app | Akeneo / Salsify | |
|---|---|---|---|---|
| Onboarding a season from many vendor files | ||||
| Unattended imports (URL, FTP, S3, Sheets) | ||||
| A quality score that can stop a product going live | ||||
| Scheduled markdown with an automatic revert | Varies / on request | |||
| Hosted Google, Meta, Pinterest, TikTok, Bing feeds | ||||
| Wholesale line sheet from the same records | ||||
| Two-way sync with the Shopify store | ||||
| Published entry price | $199/mo Basic, $399/mo Advanced, from $999/mo Enterprise | Free tools; the cost is hours | Tens of dollars a month | Quote-based — no public price |
What a retail catalog operation looks like a year in
The changes retailers describe once the catalog sits above the store. No percentages — the numbers on your range are the ones Store Health reports.
Season prep stops being a reformatting project
The column work becomes a decision made once per vendor, not once per file. What is left before a drop is reviewing changes and clearing a fix list.
The drop date stops depending on one person
Saved mappings, scheduled runs and a shared run history mean whoever knows a vendor’s format is no longer the bottleneck for the launch.
Incomplete products stop reaching the storefront
Publish Gate holds anything under your bar as a draft. The dining table with no dimensions never goes live, so it is not advertised, disapproved, or returned.
Markdowns end when they were supposed to
Sale Scheduler reverts from the snapshot it took at the start, so Tuesday is not spent hunting products still on sale (Advanced and Enterprise).
Questions retailers ask before changing how the catalog runs
Straight answers, including where Apimio is not the right tool.
Shopify holds products per store and owns inventory and orders. Apimio adds the layer above it: one record per product, attribute sets per category, a 0–100 quality score on every listing, and one source for every store, feed and line sheet. A season gets checked before it publishes, not after customers find the gaps.
Partly. This page covers the whole retail year — range turnover, promotions, breadth, and selling in more than one place. If ingesting vendor catalogs is the dominant job, /for/large-retailer-suppliers goes further. If the problem is one range across several Shopify stores, /for/multi-store-shopify covers it, and /for/shopify-plus covers Plus organizations.
Yes. Sale Scheduler takes the products, the discount and the window. It snapshots current prices when the event begins, applies the sale, and restores the snapshot at the end, syncing both changes to Shopify. Advanced and Enterprise plans. Apimio changes prices, not your theme, so countdown timers stay with the theme.
Retired products stay as records in Catalog Hub after they leave the storefront, so a line that returns next year is edited, not re-entered. New products land through the saved vendor mapping, are scored by Quality Guard against their category attribute set, and are held by Publish Gate until they clear your bar.
No. Shopify owns inventory, locations and orders, and Apimio does not replace that. Apimio owns the catalog — titles, descriptions, images, attributes, variants, categories, prices and translations — and publishes it to your Shopify stores and channel feeds. Stock control and replenishment are a different category of tool.
Yes, on the Advanced and Enterprise plans. Product Feeds generate a hosted feed URL per channel — Google Shopping XML first-class, with Meta, Pinterest, TikTok and Bing as templates — refreshed on a schedule the channel polls, and Apimio maps your categories to Google’s taxonomy. Line Sheets build the wholesale view from the same records.
Basic is $199/month for one store and 10,000 SKUs. Advanced is $399/month for 50,000 SKUs and adds Scheduled Imports, Product Feeds, Sale Scheduler and the API — the plan most multi-vendor retail operations end up on. Enterprise starts from $999/month. Extra stores are $100/month for stores two to four, $70 for five to ten.
Start with the range you are onboarding right now.
Install from the Shopify App Store or start on the web, import your catalog, and read Store Health on your own range in the first session — before the next drop lands. The 14-day free trial runs on the Advanced feature set, so Scheduled Imports, Product Feeds and Sale Scheduler are on while you test.