Content maintenance: the Maintenance Hub, bulk exports, and exception lists

Supplier One's Maintenance Hub covers changes to items that already exist. For bulk content work, export a maintenance spreadsheet of the items you need — Product Content & Site Experience for online content — up to 5,000 items at a time, edit the attributes in Excel, and re-import. The Activity Monitor reports the result per item. Keep the untouched export as your before-snapshot, and change only the columns you intend to change.

Every comparison between your source and Walmart's export needs a key that exists in both and is unique in each: usually the GTIN or the Walmart item number. Before comparing anything, check the key itself — are any values missing on either side, and are any duplicated? A duplicated key returns a match that may be the wrong row; a missing key returns nothing, which is not the same as "no difference".

Compare like for like: the same attribute, the same unit, the same packaging level. Convert units before comparing (mL to mL, inches to inches) and keep the conversion visible. Sort the results into three buckets:

1. Match — no action.
2. Mismatch — both sides have a value and they differ.
3. Missing — one side has no record or no value.

Buckets two and three need different actions: a mismatch is a correction, a missing record is an investigation.

The output of maintenance work is an exception list: one row per difference with the item reference, the field, the current value, the intended value, and the source that supports the change. It feeds the next import directly, and it is the record you show a merchant or support when a value is disputed. A vague "some capacities are wrong" is not an exception list.