Kakobuy Shoe Deal Record Cleanup: Updating and Cross-Checking Website Spreadsheet with Google Sheets

The most common problem with shoe deal records isn't a lack of deals—it's the same shoe being recorded multiple times, old prices lingering, or different sizes and use cases being incorrectly merged. This directly affects whether it's worth ordering, whether to wait for updates, and the final budget assessment. 👟

This article focuses on one specific task: taking shoe deal leads found in the kakobuy website Spreadsheet, organizing them into Google Sheets, and cross-checking them by product identity, deal conditions, and update time. By the end, you should be able to perform a traceable record cleanup and mark entries as keep, pending confirmation, or expired.

This method is not for scenarios requiring real-time confirmation of inventory, final international shipping costs, destination country taxes, or the seller's current shipping capability. The spreadsheet only helps you manage leads; it cannot replace the product page, checkout page, or kakobuy customer service for confirming current conditions.

First, Identify What Decision Problems Duplicate Records Cause

Duplicate records typically manifest in three ways: the same product appears in multiple rows; the same product is mistakenly treated as different products due to different coupons or sizes; old and new deals coexist without indicating their applicable timeframes.

They cause the following decision errors:

• Mistakenly thinking there are multiple independent deals and double-counting potential savings.

• Using an expired price as the current ordering budget.

• Ignoring size, color, style, or inventory conditions and incorrectly comparing two shoes that are not exactly the same.

• Only comparing product prices while overlooking the cost of shipping from the mainland China seller to the kakobuy warehouse, international shipping, and possible customs declaration fees.

• Being unable to determine whether to order, continue observing, or re-verify due to conflicts between old and new records.

Therefore, the goal of cleanup is not simply deleting similar rows, but keeping one record that clearly states product identity, deal conditions, update time, and verification status. 🧾

How Candidate Information from kakobuy Website Spreadsheet Serves as Raw Leads

kakobuy's platform positioning is as a Chinese product purchasing agent, freight forwarder, and quality inspection service. The website Spreadsheet can serve as a candidate source for shoe deals, but candidates are not the same as confirmed transaction terms.

When organizing, first treat each candidate record as a raw lead and retain at least the following:

• Original product name.

• Complete identifier from the product page or source page.

• Shoe category, color, size, and applicable use.

• Displayed product price and currency.

• Coupon, threshold discount, limited-time conditions, or other deal details.

• Date the record was found and last updated.

• Current verification status.

Don't just copy a simplified product title. Shoe titles may lack color, version, or size information, making it difficult later to determine if two records refer to the same product. If the page is inaccessible, the product name is unclear, or there is only an image without sufficient text information, mark it as pending confirmation rather than adding it directly to the valid deal set.

Platform information shows that the total purchasing agent fee usually consists of product cost, international shipping, and customs declaration fees. The product cost may also include mainland China shipping from the seller to the kakobuy warehouse. Therefore, the product deal price shown in the Spreadsheet cannot be directly taken as the final landed price.

kakobuy's warehouse inspection mainly checks appearance information such as style, quantity, color, size, and model, and screens for prohibited items. For shoes, this means the record should retain fields like size, color, and model; you cannot use only "sneakers" or "casual shoes" as the sole identity. 🔍

How to Set Up Product, Deal, and Update Time Fields in Google Sheets

Field design in Google Sheets should revolve around "can I determine whether these two records are the same?" The following fields are recommended:

For the price field, store only the numeric value and record the currency separately. Don't mix text like "¥", "free shipping", "limited time offer" into the price cell, as it will blur the lines between product price, seller's domestic shipping, and post-deal price when comparing later.

If using exchange rate estimates for budgets in other currencies, save both the exchange rate used and the estimation date. Existing platform info provides a reference exchange rate of 6.22, but this data changes and cannot be treated as a guaranteed rate at settlement. Before publishing or ordering, re-check the actual amount on the payment page.

Update time should be split into at least two concepts: record update time and page verification time. The former indicates when you modified the spreadsheet; the latter indicates when you reopened the source page to confirm the product and deal. They must not be conflated.

Compare Two Approaches to Identify Duplicate or Expired Deal Records

The first approach is strict identity matching. Only when the product page, item number, or other explicit identifier matches, and color, version, and size conditions also match, can records be considered the same candidate. This approach has fewer erroneous merges and is suitable for shoes with complex specifications or significant differences in deal conditions.

The second approach is hierarchical comparison. First group by product identifier, then compare color, size, version, deal conditions, and update time. If identifiers match but deals differ, don't immediately delete one; determine whether they correspond to different validity periods, thresholds, or applicable sizes.

You can check in the following order:

1. Does the product name point to the same page or item number?

2. Are the shoe category and use consistent? For example, running, basketball, casual, or outdoor should not be grouped just under "shoes".

3. Are color, size, and version consistent?

4. Is the product price using the same pricing basis?

5. Does the deal have a threshold, specified size, specified color, or validity period?

6. Was the page accessible at the last verification time and still showing clear product information?

7. Are there conflicts between source page, product page, and checkout conditions?

Expiration judgment cannot rely solely on dates. Even if the deal date has not expired, if the page is inaccessible, product info is empty, deal conditions are removed, or the current spec is out of stock, it should first be marked as pending or expired. Don't skip page verification just to preserve a lower price. ✅

Use a Simple Table to Mark Keep, Pending, and Expired Entries

During cleanup, keep the original records and do not overwrite historical information directly. Use a status field to indicate the current conclusion and note the reason for change in remarks.

If two records point to the same shoe but one has an earlier price and one a newer price, you can keep the historical row while making the newer row the current primary record. Don't disguise historical rows as current deals; status should be clearly set to updated or expired.

After cleanup, add a column "Reason for Keep". For example, "page still accessible, size and deal threshold consistent" is a verifiable reason; "looks cheaper" is not sufficient to support keeping.

Different Shoe Sizes and Uses Cannot Be Mixed into One Deal Conclusion

Shoe deal comparison must separate use and specifications. Running shoes, basketball shoes, casual shoes, outdoor shoes, and kids' shoes may use different sizing systems and have different materials, structures, and applicable scenarios. Even if titles are similar, you cannot conclude they are the same product.

The size field should preserve the expression from the original page and, if needed, note the corresponding sizing system. Don't overwrite original sizes with direct conversions from other regions, and don't assume two sizes are suitable for the same people just because the numbers are the same.

Different colors of the same shoe may correspond to different inventory and deals; different versions of the same product may have different prices. When recording a deal, specify whether it applies to all specs, a specific color, or only a certain size.

If a deal applies only to sizes that don't fit you, you can keep the information in the spreadsheet, but you cannot treat it as your available deal. This preserves the lead while avoiding miscounting inapplicable conditions as actual savings. 👣

When Information Conflicts, Return to Verifiable Pages

When information from the Spreadsheet, Google Sheets, and product page is inconsistent, prioritize checking the currently accessible original product page. Don't override the current page with a lower price from an old spreadsheet, and don't judge material, authenticity, inventory, or quality based solely on product images.

Process conflicts in the following order:

• First confirm whether the page is still accessible and has a clear product name and visible product information.

• Then confirm specs, price, deal threshold, and validity.

• Check whether mainland China shipping from the seller to the kakobuy warehouse is charged separately.

• Record product price separately from international shipping and customs fees.

• Mark unexplained differences as pending.

• If necessary, verify current purchase or warehouse processing conditions with kakobuy customer service.

Platform info shows kakobuy supports payment methods like top-up and credit card, and provides customer service email [email protected]. However, payment methods, fees, and service conditions should be based on the current page or customer service response; don't treat historical records as permanent promises.

If preparing to purchase, also consider warehouse inspection, return/exchange windows, and subsequent shipping. Platform info shows that after warehousing, a 5-day no-reason return/exchange is usually supported within 120 hours, but may not apply to custom items, restricted items, adult products, intimate clothing, food, and products where removal of packaging, tags, or accessories has been requested. Whether shoes fall into special categories should be confirmed before submitting the order.

Pre-Order Action Checklist After Cleanup

After deduplication, don't immediately focus only on the lowest price in the spreadsheet. Perform final checks in the following order:

• Confirm that the product page for kept records is still accessible.

• Verify color, size, version, and use.

• Confirm deal threshold, applicable conditions, and last verification date.

• Separately calculate product price, mainland China shipping, international shipping, and possible customs fees.

• Check current available shipping routes and potential taxes or import restrictions in the destination country.

• Confirm whether the shoe is eligible for warehouse inspection and return/exchange rules.

• Do not publicly share order numbers, payment info, complete shipping labels, or identity documents.

• Keep any unverifiable low-price records as pending.

If you choose combined shipping after cleanup, it may reduce repeated first-weight charges or some handling costs, but it could also increase package volumetric weight, single-package value, and one-time loss risk. If you split shipping, fixed costs may increase, but it might be better for route restrictions, value control, or different handling conditions for different shoes. Therefore, don't conclude "combined shipping is cheaper" without comparing actual weight, volume, package value, and available routes.

Final savings should be calculated based on the verified price difference and indicate whether added shipping or other fees are deducted. This is more suitable for buyers with multiple records, clear specs, and the ability to update the spreadsheet regularly; it is not suitable for those who cannot confirm product pages, cannot determine size and use, or only want to order immediately based on a single historical low price.