EN
Inventory and Products

How Do You Prepare a Product Card? A Guide to Required Fields, Naming Standards, Variant Structure, Cost, Low Stock Levels and Completeness Checks

How do you prepare a product card? Required fields, naming standards, variant structure, cost, critical stock and completeness checks: an 8-lesson guide with examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: Why is the product card the foundation of inventory software?
  3. Lesson 2: Which fields should be required on a product card?
  4. Lesson 3: How do you set a standard for product names?
  5. Lesson 4: How do you build the variant structure?
  6. Lesson 5: How do you enter cost and price?
  7. Lesson 6: How do you set the critical stock level?
  8. Lesson 7: How do you bulk import and copy?
  9. Lesson 8: How do you check product card completeness?
  10. What are the most common mistakes when preparing product cards?
  11. How does NetKasam make product card management easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Calculate your catalog's completeness score this week
  14. Frequently Asked Questions About Product Cards

The weekly report shows gross profit of ₺330,000, but the money left in the account is less than expected. The reason is often not in sales but in the product card: the cost of 48 products was never entered, so in the profit calculation these products look as if they were sold at no cost, and profit comes out higher than it really is. Critical stock is also blank on the same cards, so nobody is alerted when a product is running out. The product card is the shared source of inventory, price, profit calculation and marketplace transfer; if the card is incomplete, all of these work incompletely.

This article is not a lecture but an 8-lesson hands-on course. We will answer the question how do you prepare a product card with numbers, using a sample catalog of 300 products: which fields the card should have, the naming standard, variant structure, entering cost and price, the critical stock calculation, bulk import and copying, and checking card completeness. At the end there is a mini quiz with an answer key. Barcodes are covered in a separate article: how to set up a barcode system; here we build the card as a whole.

What will you be able to do by the end of this training?

In short: You will define the required fields of the product card, set a naming standard, build variants correctly, calculate critical stock, and produce the completeness score of your current catalog.

Course mapSix steps to preparing a product card
  1. 01
    FieldsDefine the required fields.
  2. 02
    StandardSet a naming rule.
  3. 03
    VariantsSet up size and color correctly.
  4. 04
    CostEnter cost and price.
  5. 05
    StockCalculate the critical stock level.
  6. 06
    CheckMeasure the completeness score monthly.

The course's 8 lessons: (1) why the product card matters, (2) required fields, (3) naming standard, (4) variant structure, (5) cost and price, (6) critical stock, (7) bulk import and copying, (8) completeness check.

Lesson 1: Why is the product card the foundation of inventory software?

In short: Every field on the product card is used in another process. Cost feeds the profit report, critical stock feeds alerts, category feeds campaigns, and image and name feed marketplace transfer. If the card is incomplete, one link in the chain doesn't work.

Card fieldWhich process does it feed?What happens if it's blank?
CostProfit margin, inventory valueProfit looks higher than it is
Reorder levelAlert before stock runs outThe product runs out with no warning
CategoryCampaigns, reportingIt is left out of category campaigns
BarcodeScanning at the till and in the warehouseThe product is looked up by hand
Image and nameTransfer to marketplaces and your siteThe product doesn't go live or looks weak

For the basic concepts of inventory management, see the article what you need to know about inventory management. The sample business: a retailer with 300 product cards selling in-store and online.

Lesson 2: Which fields should be required on a product card?

In short: Eight fields can be treated as required: product name, stock code, barcode, category, cost, selling price, critical stock and image. If any of these is blank, the card is considered "incomplete."

AreaExampleRule
Product nameBasic T-ShirtFollows the standard, short and clear
Stock codeTSR-BSCUnique, unchanging
BarcodePer variantUnique
CategoryTopsFrom a fixed list
Cost280 ₺Excluding VAT, current
Sale price500 ₺Linked to the price list
Reorder level28 unitsSet by calculation
ImageAt least 1With variant images

In NetKasam, each variant's inventory and image are kept separately; for details, see the inventory management page. Putting the required field list in writing ensures the same quality regardless of who opens the card.

Lesson 3: How do you set a standard for product names?

In short: A naming standard makes products searchable and comparable. Set a fixed order: product type, model, variant attribute. Write variant information on the variant, not in the product name.

WrongCorrectWhy?
t-shirt black m!!!Basic T-Shirt (variant: Black / M)Size and color are kept on the variant
NEW SEASON JEANS SO STYLISHSlim Fit JeansMarketing phrases go in the description, not on the card
Bag 2Leather Shoulder BagA name that describes the product, not a sequence number

Opening the same product a second time under a different name means two separate inventory records and a wrong count. Searching for and checking the existing card before entering a new product prevents duplicate cards. For how to edit names transferred to marketplaces, see the article how to manage products with variants on a marketplace.

Treat the category list as part of the naming standard as well. A short, fixed list such as "Tops," "Bottoms" and "Accessories" lets you speak the same language in campaigns, reporting and marketplace matching. As the number of categories grows, defining campaign scope gets harder; a list of more than twenty usually signals too much detail. New categories should be opened only with one person's approval; otherwise, the same group multiplies under three different names.

Lesson 4: How do you build the variant structure?

In short: For products with sizes and colors, a single parent card is opened, each combination becomes a variant, and inventory is kept on the variant. Shared information sits on the parent card and distinguishing information on the variant.

InformationWhere is it kept?
Product name, category, descriptionParent card
Size, colorVariant
Inventory quantityVariant
BarcodeVariant
ImageVariant (by color)
CostOn the parent card if shared; on the variant if it differs between variants

In NetKasam, you can define unlimited variants. For products sold by the case, box or sack, wholesale selling is done with set definitions and tiered pricing. For separating wholesale and retail price lists, the article how to prepare wholesale and retail price lists is a good complement.

Lesson 5: How do you enter cost and price?

In short: Cost is never left blank. A blank cost looks like a cost-free sale in the profit calculation and inflates the profit report. Enter cost excluding VAT and keep it current; update the card when the supplier's price changes.

ChartGross profit shown in the report ₺330,000, real gross profit ₺240,000
  1. Gross profit shown in the report₺330,000
  2. Real cost of the 48 products without a cost entered−₺90,000
  3. Real gross profit₺240,000

Prepared with sample values. Monthly sales ₺600,000: 60% cost on ₺450,000 of sales with cost entered (₺270,000); real cost of 60% on ₺150,000 of sales with blank cost (₺90,000), but 0 in the report.

Calculation: total sales ₺600,000; revenue from products with cost entered is ₺450,000 with a cost ratio of 60% → ₺270,000. Gross profit shown in the report = 600,000 − 270,000 = ₺330,000 (55%). Revenue from the 48 products with blank cost is ₺150,000, their real cost is 150,000 × 0.60 = ₺90,000; real gross profit is 330,000 − 90,000 = ₺240,000 (40%). The report shows profit 15 points too high. For cost calculation methods, see the article how to calculate inventory cost, and for margin, how to calculate profit margin.

Recommended ReadingHow Do You Calculate Inventory Cost?

Set a rule when entering the price too: the selling price should be derived from cost and target margin, not written by gut feeling. If a product costing ₺280 has a target margin of 44%, the price is about ₺500; when the price changes, the margin is visible on the card right away. If you need different prices by channel, factor in commission and shipping costs separately; you can use the profit margin calculator for this.

Lesson 6: How do you set the critical stock level?

In short: Critical stock = average daily sales × supply lead time (days). When stock falls to this level, the system alerts you, so you can order before the product runs out.

FormulaFour formulas for checking product cards
  1. Field fill rate = Cards with the field filled ÷ Total cards × 100
  2. Completeness score = Average of the field fill rates
  3. Critical stock = Average daily sales × Supply lead time (days)
  4. Profit effect = Revenue from products with blank cost × Real cost ratio

Prepared with sample values.

Example: for a product that sells 4 units a day on average and that the supplier delivers in 7 days, critical stock is 4 × 7 = 28 units. When stock falls to 28, an alert comes in, an order is placed, and the remaining 28 units cover sales until the new goods arrive. Critical stock is kept high for products with long lead times and fast sales, and low for easy-to-source, slow-moving products. To add a safety margin, see the article how to calculate safety stock. In the sample catalog, the critical stock field is only 58% filled; for 126 of the 300 products, the alert never works.

Lesson 7: How do you bulk import and copy?

In short: Instead of opening hundreds of cards one by one, import them with Excel and create similar products by copying. Before importing, check that stock codes and barcodes are unique.

MethodWhen?Note
Import with ExcelMoving to a new system, many new products at onceUnique stock code and barcode
Copy from a similar productA new model in the same familyChange the copied name, code and barcode
Import via XMLSupplier listMap the fields, check the product
Manual entryA small number of special productsApply the required field list

When moving from another program, you can import your products with Excel and then enter the opening stock for warehouses and branches through a count. For a migration checklist, see the article how to transfer data when switching accounting software, and for importing supplier lists, how to set up an XML integration.

Lesson 8: How do you check product card completeness?

In short: Export the catalog and calculate the fill rate for each required field; their average is the completeness score. Complete the lowest field first.

AreaShare of filled cardsIncomplete cards
Product name%1000
Stock code%1000
Sale price%993
Category%9612
Barcode%9127
Image%8739
Cost%8448
Reorder level%58126
ChartField fill rate: critical stock and cost are the weakest fields
  1. Product name and stock code100%
  2. Selling price99%
  3. Category96%
  4. Barcode91%
  5. Image87%
  6. Cost84%
  7. Critical stock58%

Prepared with sample values. Average fill rate (100 + 100 + 99 + 96 + 91 + 87 + 84 + 58) ÷ 8 = 89.4%.

ChartCompleteness of 300 cards: 112 have all eight fields filled
  • Complete card (nothing missing)₺11237.3%
  • 1 field missing₺10434.7%
  • 2 fields missing₺5819.3%
  • 3 or more missing₺268.7%

Prepared with sample values.

Prioritize by financial impact: the 48 cards with blank cost distort the profit report by ₺90,000; the 126 cards with blank critical stock carry a risk of stockouts. Missing categories and images don't distort the report but affect sales and visibility. Run the check monthly; you can use the reports screen to keep the results as a saved report and export them to Excel.

Takeaways from the exampleFour numbers from the sample catalog
  • 89.4%average completeness score
  • 112 / 300fully completed cards
  • 126products with blank critical stock
  • ₺90,000cost not reflected in the profit report
When?What to do?Who?
Every new productNot put on sale until required fields are filledProduct manager
When the supplier's price changesCost is updatedPurchasing
MonthlyThe completeness score and weakest field are reportedManagement
Start of the seasonCritical stock levels are refreshedPurchasing
YearlyUnused cards are reviewedManagement
Recommended readingHow to Calculate Safety Stock?

What are the most common mistakes when preparing product cards?

  1. Leaving cost blank. Profit looks higher than it is.
  2. Not entering critical stock. The product runs out with no alert.
  3. Writing variant information in the product name. Many cards are created for the same product.
  4. Opening a product a second time as a duplicate card. Inventory is split across two places.
  5. Importing without checking uniqueness. Duplicate codes and barcodes are created.
  6. Not updating cost. Margin calculations rely on the old price.
  7. Never checking the cards. Gaps pile up unnoticed.

How does NetKasam make product card management easier?

  • Unlimited variants. For products with sizes and colors, each variant's stock and image are kept separately (inventory management).
  • Multiple barcodes. You can assign more than one barcode to a product.
  • Critical stock alerts. A critical quantity is set, and an alert comes in when stock falls to it.
  • Excel and copying. Existing products are imported with Excel; a new product is copied from a similar one.
  • Sets and tiered pricing. Wholesale selling is done in units such as cases, boxes and sacks.
  • Cost and turnover. Inventory cost calculation and turnover rate are reported.
  • Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan (pricing).

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. Cost is filled on 170 of 200 cards. What is the fill rate of the cost field?
  2. What is the critical stock for a product that sells 6 units a day and is delivered in 5 days?
  3. If the fill rates of four fields are 100%, 90%, 80% and 70%, what is the completeness score?
  4. Why does a blank cost inflate the profit report?
  5. Why is size and color information written on the variant rather than in the product name?

Answer key:

  1. 170 ÷ 200 × 100 = %85.
  2. 6 × 5 = 30 units.
  3. (100 + 90 + 80 + 70) ÷ 4 = %85.
  4. If cost is blank, no cost can be deducted from that product's sales amount; revenue looks almost entirely like profit.
  5. Because inventory and barcodes are kept per variant, many sizes and colors are managed from a single parent card; multiple cards aren't opened for the same product.

Frequently Asked Questions About Product Cards

How do you prepare a product card?

You define the required fields (name, code, barcode, category, cost, price, critical stock, image), set a naming standard, build variants correctly, and complete the cards before they go live.

Is a product with variants kept on a single card?

Yes. Shared information is kept on the parent card, and size, color, inventory, barcode and image are kept on the variant. In NetKasam, there is no limit on the number of variants.

What happens if I don't enter a cost?

If cost is left blank, the profit calculation looks higher than it really is; so cost should be entered before the sale.

How is critical stock calculated?

Average daily sales are multiplied by the supply lead time. In the example, 4 units × 7 days = 28 units.

How do I import my existing products?

You can import your product list from Excel; before importing, check that stock codes and barcodes are unique.

Should I enter a similar product from scratch?

No. When entering a new product, you can copy a similar one and change only the fields that differ.

Can I sell by the case or as a set?

Yes. Wholesale selling is possible with set definitions and tiered pricing.

How is card quality measured?

The fill rate is calculated for each required field and then averaged; this is called the completeness score.

Conclusion: Calculate your catalog's completeness score this week

The product card may look boring, but it is the foundation of inventory, profit and sales speed. This week, export your catalog, calculate the fill rate of the eight required fields and start completing from the lowest field. Closing the cost and critical stock fields first immediately fixes both your profit report and your inventory safety. Then make it a rule that every new product is completed with the same eight fields before it goes on sale; that way quality doesn't drop as the catalog grows, and the monthly check stays short.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeInventory Tracking

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools