A Product Catalog That Runs Faster Than Your Website
Running a local electronics and components store means your catalog is always in motion. RAM prices shift weekly. Stock on a specific SSD model goes from twenty units to zero in a weekend. A customer calls asking whether you have a specific Wi-Fi adapter in stock, and you're standing in the storeroom trying to remember which shelf, while your website's backend takes thirty seconds to load on the shop's aging router.
The eight-field structure here — photo, name, description, sale price, stock quantity, availability boolean, product link, and seller — is the leanest viable product record. No redundancy. Every field earns its position. That's the discipline that makes a catalog actually usable in a high-velocity retail environment versus a record-keeping exercise you stop maintaining after two weeks.
The Fields That Carry the Operational Load
stokMiqdarı (stock quantity) and məhsulMövcudluğu (product availability boolean) run in tandem, and the distinction matters. Quantity tells you exactly how many units you have. The availability boolean is the customer-facing status — it answers the binary question a caller is actually asking. A product might have a quantity of three but availability set to false because those three units are committed to pending orders. Or quantity might show zero but availability is true because a shipment arrived this morning and hasn't been individually counted yet. Having both fields means the catalog reflects both warehouse reality and sales-floor truth simultaneously.
satışQiyməti (sale price) in a hardware retail context is not a stable number. Azerbaijan's electronics market prices in USD equivalents that track exchange rate fluctuations. Thermal paste, memory modules, SSDs — their AZN sticker prices drift with the manat rate. A catalog that only records a static price becomes inaccurate within days. The value of having this as a dedicated currency field is that you can sort the entire database by price, identify where your margins are thinnest, and do a batch price-update pass when a significant rate shift happens. Filtering for all items with quantity greater than zero and sorting by price descending gives you your highest-value in-stock items in one view.
məhsulLinki (product link) is the connector to the supplier or manufacturer page. When a customer asks for the spec sheet on a specific GPU cooler or wants to verify compatibility with their socket type, you pull the record and tap the link. No browser search, no fumbling through bookmarks. The link is co-located with the price and stock data. For products with detailed technical specifications that don't fit in the description field — clock speeds, thermal design power, memory bandwidth — the product link is how you answer the technical question without having memorized the datasheet.
The Moment the Availability Toggle Matters Most
It's Saturday afternoon and someone walks in off the street asking specifically for an Arctic MX-6 thermal compound. You have two tubes on the back shelf. But you already promised both to a customer who paid a deposit Friday and said he'd collect Monday. The stokMiqdarı shows 2. You flip the məhsulMövcudluğu to false.
The walk-in customer searches your public listing, sees "unavailable," and doesn't wait. The Monday customer picks up his order. You reorder and flip availability back to true when the new stock arrives. That single boolean, toggled accurately and immediately, prevents a customer service problem that would have taken fifteen minutes to resolve and might have ended in a refund dispute.
The SATICI (seller) field — currently set to alfastore.az as the single option — is the placeholder for multi-vendor expansion. When you add a second sales channel, or when a partner stocks items under a shared catalog, you add options to that choice list and every record becomes attributable to a specific seller. Filtering by seller gives each partner their clean inventory view without needing separate databases.