How do you organise product data?
How many places hold product information? Prices in accounting, descriptions on the website, measurements in the supplier’s catalogue, stock in another sheet. One change means updating four places. 📦
When product data is scattered, website, marketplace, quotes and invoices disagree: an old price online, missing sizes on the marketplace, a wrong code on a quote.
Short answer: each product needs one master record and one product code; website, marketplace and quotes feed from that record. 🗂️
Four signs of scattered product data
BU BÖLÜMÜN ÖZETİ
- Different prices across channels
- The same product under different names
- Missing information
- Fear of updates
Familiar mismatches. 🔍
Different prices across channels
One price online, another on the marketplace; customers ask. 🏷️
The same product under different names
One name in the warehouse, another online; confusion on orders. 🔀
Missing information
Size, weight, material on one channel, missing on another. 📏
Fear of updates
A price change takes half a day. ⏳
Master product record fields
BU BÖLÜMÜN ÖZETİ
- Identity
- Commercial
- Physical
- Content
Four groups. 🧩
Identity
Product code, barcode, name, variant; one code everywhere. 🏷️
Commercial
Cost, price, tax rate, supplier; the basis of profit. 💰
Physical
Size, weight, volumetric weight, material; essential for shipping and returns. 📦
Content
Description, photos, category; from the same source online and on marketplaces. 🖼️
Product code rules
BU BÖLÜMÜN ÖZETİ
- One code per product
- Variant separation
- Readable codes
- No reuse
Four rules. 🔢
One code per product
Codes don’t change; even if the name changes, the code stays. 🔒
Variant separation
Colour and size at the end of the code; the parent product stays recognisable. 🎨
Readable codes
A category letter and sequence number; warehouse staff understand. 🔤
No reuse
A retired product’s code is never given to a new one. 🚫
Distributing to channels
BU BÖLÜMÜN ÖZETİ
- Website
- Marketplaces
- Quotes and invoices
- Stock
One source to four places. 📡
Website
Description and price from the master record; see the connecting sources guide. 🌐
Marketplaces
Bulk upload or connection; no copying by hand. 🏪
Quotes and invoices
Code and price from the same record; wrong codes end. 🧾
Stock
Stock kept in one place; syncing covered in the connections guide. 📊
Four common mistakes
BU BÖLÜMÜN ÖZETİ
- Editing each channel separately
- Products without codes
- Leaving cost empty
- Skipping physical details
All four create mismatches. 🚧
Editing each channel separately
The same change made four times; one gets forgotten. 🔁
Products without codes
Tracking by name is a source of confusion. ❓
Leaving cost empty
Without cost, product profit can’t be calculated. 🧮
Skipping physical details
Without size and weight, shipping cost is guessed. 📦
What should I do today?
BU BÖLÜMÜN ÖZETİ
- Step 1: choose the master place
- Step 2: check your top ten products
- Step 3: change one price in one place
- If you want help
Three steps, one hour. 🪜
Step 1: choose the master place
Which tool is the true source of product information? One answer. 🗂️
Step 2: check your top ten products
Code, cost, size, description; which is missing? 📋
Step 3: change one price in one place
Does it flow to other channels on its own? Test. 🔄
If you want help
Let us organise your product data together: use the consult your expert form. For your current setup see the digital audit; the bigger picture sits in the data housekeeping roadmap. 🎯
Related reading from the archive: product variations · marketplace connections.
📝 Notes From the Field
A business updated prices separately on its website, marketplace and accounting software; customers wrote that they had seen two different prices. The accounting record became the master source, each product got one code, and website and marketplace fed from it. Price changes became a single step and price complaints stopped.
📖 Short Glossary
Master product record: the single record holding all of a product’s information. Product code: an unchanging identifier. Variant: options such as colour or size. Volumetric weight: shipping weight based on size.
⚡ Quick Summary
Scattered product data creates mismatches across channels. 📦 Each product gets one master record and one unchanging code. The record holds identity, commercial, physical and content information. Website, marketplace, quotes and stock feed from it; no hand copying. Never leave cost and size empty.
🎯 Next Step
Let us organise your product data: use the consult your expert form. Connecting tools sits in the connecting sources guide; for your setup see the digital audit.
Frequently Asked Questions
Sık Sorulan Sorular
With few products, accounting or stock software can be the master source. With many products and channels, a dedicated product information tool is worth considering.
If you use a warehouse, till or marketplaces, they help greatly. Some marketplaces require them; still keep your own internal code.
Product-level profit can only be calculated when cost is known. Storefront, campaign and price decisions depend on it.
