EN
☰

Spreadsheet culture · EDITORIAL ANALYSIS

Pikobuy Spreadsheet Data: Prices, Stock and Update Dates

Distinguish article dates, saved item prices and current stock, with examples showing why a working link or recent edit does not confirm availability.

A product page can load correctly while the desired size is unavailable. An old price can remain visible in a saved list after the seller changes the offer. Neither situation requires a broken website: the information may simply describe different moments.

For Pikobuy spreadsheet readers, data freshness is therefore more specific than a date at the top of a page. The relevant question is which fact was checked, for which option, and where it will be confirmed again.

Separate Facts and Separate Timelines

A product image may remain useful for a long time, while inventory changes after individual sales. A title can identify the design even when a discount expires. One general “updated” label does not guarantee that all these fields were checked simultaneously.

Stock records become less current when sales occur between checks. Shopify discusses this limitation of disconnected spreadsheets; scheduled catalogue imports also leave time between observations. Neither method makes a saved size list a live stock reservation. The important detail for a reader is when that particular availability record was checked.

The category pages display a saved selection with its snapshot date. That date describes the catalogue observation, not a reservation of every listed size.

Reference Values and Current Offers

A currency conversion introduces another distinction. Our USD figures use a fixed 7.2 CNY reference rate. They allow comparisons within the saved selection, but do not track live exchange rates or the platform’s checkout conversion.

Two checks are therefore separate: whether the underlying item price has changed and whether the currency conversion differs. Google’s price guidance similarly distinguishes a consistent current offer from conflicting amounts across a page and checkout. A saved reference should make its conversion basis clear so that the reader can understand such a difference.

Inventory and Link Reliability

An active URL establishes that a page is reachable. It does not establish that a particular colour and size can be purchased. Google likewise treats availability as its own product attribute, separate from price and the existence of a page.

A saved size list is a record of options, not a reservation. The distinction becomes especially important when a product family has several variants: one unavailable size does not necessarily mean every option is gone, and one available option does not prove the whole family is in stock.

When the decision becomes an order, the order confirmation section of the buying guide identifies the current option and charges to verify before the first payment.

Article Dates and Product Check Dates

The shoe-price study on this blog illustrates the date distinction. Its article was published on 6 November 2026, while its 24-record catalogue sample was captured on 5 November. Editing the article’s wording would not refresh those prices. The publication date describes the article; the snapshot date describes the observations used in its analysis.

The same distinction applies to an individual listing. A newly edited title does not demonstrate a new stock check, and a working product link does not confirm the old price. The current selected option on the purchasing platform is the place to resolve price and availability before payment.

Keep a Date Beside the Fact It Actually Describes

Instead of asking whether an entire product page is fresh, ask which parts of the candidate have been confirmed. A saved image, an item-price observation, an available-size list and a published article can each carry a different date. One recent timestamp should not overwrite the context of older observations that the page still displays.

A useful personal record can therefore be small but explicit. Save the observation and its scope, then identify where it will be checked next. “White, size M appeared selectable when checked” says more than “in stock”, because it names the exact choice and the limited observation. It still does not establish that the seller will accept or fulfil a later order.

FieldWhat to recordWhere the next check belongs
Article updateWhen the explanation or analysis was editedThe article and its stated sample dates
Product identityLink, style, selected image and colourThe current selected option
Item priceAmount, currency, quantity and observation dateThe current purchasing offer
Size availabilityThe exact colour-size combination observedThe order destination before purchase
Historical QCThe photographed style, size and available date contextYour own received item when inspected
Shipping estimateDestination, service, contents and packing assumptionsThe measured parcel and selected route
A field-level freshness record for a shopping shortlist

Reconcile a Changed Price Without Guessing the Cause

Begin with identity and quantity. If the current page is showing another style or a multi-piece set, you are not comparing the same offer. Once the item is consistent, compare the original-currency amount and the conversion basis separately. This prevents every currency difference from being described as a seller price increase.

For an invented example, a saved source amount of CNY240 divided by the catalogue’s reference 7.2 gives about $33.33. Suppose the same option later costs CNY252. Keeping the old conversion basis would give $35.00. If the purchasing conversion instead used 7.0 CNY per USD, that source amount would become $36.00 before any other charges.

The approximately $2.67 difference from $33.33 to $36.00 has two components in this example: about $1.67 from the changed source amount and $1.00 from the changed conversion basis. It is not evidence of an unexplained $2.67 fee. A real transaction needs its own amounts, conversion and charge breakdown; these inputs are deliberately hypothetical.

ObservationSource amountConversion basisIllustrative USD amount
Saved referenceCNY2407.2 CNY / USD$33.33
Changed item amount, same conversionCNY2527.2 CNY / USD$35.00
Changed item amount and conversionCNY2527.0 CNY / USD$36.00
Illustrative reconciliation · invented current amounts and conversion, not a live exchange rate

Recheck at the Decision Point, Not on Every Page View

Reopening every saved link continuously is not a practical way to browse. A better approach is to connect a check to the decision it supports. Early discovery can use a dated reference to narrow candidates. Moving a candidate into an order calls for more current information about the selected option and its price.

Consider a hypothetical timeline. On 5 November you save a black size M top with a reference amount. On 7 November the family page still loads, but only blue size L is selectable. The link remains useful for identifying the product family, while the particular candidate needs a new availability check. The later working URL has not refreshed the earlier option observation.

  1. During discovery, retain the observation

    Save the candidate’s image, option labels, reference amount and date. Do not turn an old observation into a current claim when you copy it into your personal notes. The record should help you return to the same candidate later.

  2. Before ordering, reselect the option

    Confirm the design, colour, size, quantity and current amount at the purchasing destination. If anything differs from your saved candidate, identify the difference before deciding whether to proceed. A page that merely loads is not enough for that check.

  3. On warehouse arrival, switch to the actual item

    Historical QC helped frame the question. The photographs, labels and any requested measurements attached to your received item now supply the relevant order-specific evidence. Keep the two records separate so an older attractive image does not replace an observation about your own goods.

  4. At parcel submission, refresh packing assumptions

    A shopping-stage item weight and an early shipping estimate can remain useful background, but the actual parcel may have different contents and outer dimensions. Compare the current packing arrangement and route quote rather than carrying the original estimate forward as a fixed cost.

Questions About Update Dates and Working Links

The important distinction is between keeping a useful historical record and claiming that every part of that record describes the current offer.

Does today’s article update mean the product prices were checked today?

Only if the article explicitly says those observations were refreshed. A revised explanation, a corrected sentence and a new product-price observation are different changes. This blog keeps the dated shoe sample distinct from the article’s editorial update, so expanding the article does not silently change the date or meaning of its original analysis.

How old is too old for a shortlist entry?

There is no single age that makes every field useless. An image may still identify the intended design while a size observation needs checking again. Use the entry for the decision its evidence supports, then recheck changing fields when you are ready to act. A recent date is context, not a substitute for a matching current option.

Should I delete an item when the saved link stops working?

Keep enough information to identify the candidate if you still want it: the selected image, model or design description and option labels. Then decide whether to look for a current destination. Do not assume a visually similar replacement has the same seller, construction, included pieces or price simply because it resembles the old image.

What if the current offer is still unclear after I recheck?

Record exactly what remains unresolved and ask at the place handling the offer or order. The useful question might be whether a size can be purchased, which option a price applies to or what a charge includes. Leaving the candidate pending preserves the distinction between known information and a guess made to finish the comparison.

Sources & editorial notes

Researched and rewritten by the Piko Finds editorial team. References checked 7 Nov 2026. Published facts, catalogue observations and illustrative examples are distinguished in the article; no personal purchasing or physical product test is claimed.

  1. Shopify — Inventory systems and spreadsheet limitations

    Supports the general difference between disconnected manual stock records and inventory updated through sales workflows. No technology relationship with Pikobuy is implied.

  2. Google Merchant Center — Price attribute

    Supports consistency between a merchant offer, landing page and checkout. Our estimates are discussed as discovery records rather than guaranteed checkout offers.

  3. Google Merchant Center — Availability attribute

    Supports treating stock availability as a separate and current product fact. This article is consumer-facing analysis, not a merchant setup tutorial.

PRODUCT DISCOVERY

More Pikobuy Finds

Explore more finds ↗