Online selling
Make a product catalog index for a small shop
An index gives each product one code, one canonical name and one set of source facts, with a note on where each listing lives. When a detail changes, update the index first and then every listing, so channels do not drift apart.
Item code: [ ] Canonical name: [ ] Variant: [ ] Dimensions: [ ] Materials: [ ] Included items: [ ] Source of these facts: [ ] Date facts last verified: [ ] Current listing location: [ ] Other channels carrying this item: [ ] Name used on each channel: [ ] Conflicting spec found (rows or channels involved): [ ] Decision and who made it: [ ] Code shared with another product: [ ] Resolution: [ ] Rows with no stated source: [ ]
Shared codes and conflicting specs
Look for two different products given the same item code, which can send the wrong stock or details to a buyer. Look also for one product whose dimensions, materials or included items differ between listings. Each conflict needs a decision from whoever holds the real item, not from the draft. Check that variants have their own rows rather than being folded into the base product. Confirm each row names where its source fact came from, such as a supplier sheet or a measurement, and mark rows without a source as unverified.
Scan this catalog index for two products that share one item code and for any single product whose specs conflict between rows or channels. List each case with the rows involved and the conflicting values. Then list every row that has no stated source for its facts. Do not choose between conflicting values.
Resolve conflicts, then use the index
Settle each flagged conflict by checking the physical item or supplier record, and write the answer into the index. Correct the listings that disagree. From then on, change the index first whenever a product changes and update listings from it. Review the index when you add a product or variant so codes stay unique.