the Outcome: Once the return or exchange is complete, the CNfans team will update the spreadsheet again (e.g., “Replacement Shipped to Warehouse” or “Refund Processed”). You can then review the new QC photos (if it’s a replacement) and repeat the approval process.
This structured follow-up process, anchored by the CNfans spreadsheet, ensures that no detail falls through the cracks. It also provides a clear paper trail of all QC-related communications, which is invaluable if there are any disputes with the seller or the agent later on.
Optimizing Shipping Plans via CNfans Spreadsheet
After approving the QC photos for all your shoes, the next step is to arrange international shipping—and the CNfans spreadsheet can help you optimize this process to save time and money. Shipping is often the most expensive part of the shoe procurement process, so careful planning here can lead to significant savings.
Step 1: Listing Shipping Preferences in the Spreadsheet
First, add a new section to your CNfans spreadsheet dedicated to shipping. This section can include columns like:
Item Name/Link: A quick reference to the shoe (to avoid confusion).
Weight (kg): The weight of the shoe (with or without the shoebox—CNfans will provide this info after QC).
Volume (cm³): The volume of the shoe (length × width × height—again, CNfans will provide this).
Shipping Line Preference: The shipping line you want to use (e.g., EMS, DHL, Tax-Free Air Cargo).
Declared Value (USD/CNY): The value you want to declare for customs (this affects customs fees and the risk of seizure).
Special Packaging Requests: Notes like “Remove shoebox to reduce volume” or “Vacuum-seal to protect from moisture”.
By listing these preferences in the spreadsheet, you can easily share them with the CNfans team. For example, if you’re shipping three pairs of shoes to the UK, you might note: “Use Tax-Free Air Cargo, declare $50 total, remove all shoeboxes”. This clarity ensures the team follows your instructions exactly.
Step 2: Calculating Shipping Costs and Comparing Options
The CNfans spreadsheet also lets you compare shipping costs across different lines to find the best deal. Most shipping lines charge based on either actual weight or volumetric weight—whichever is higher. To calculate volumetric weight, use the formula:
Volumetric Weight (kg) = Volume (cm³) ÷ Divisor
The divisor varies by shipping line (e.g., 5000 for EMS, 6000 for DHL).
Add a column to the spreadsheet labeled “Volumetric Weight (kg)” and another labeled “Chargeable Weight (kg)” (the higher of actual weight and volumetric weight). Then, use CNfans’ shipping rate chart (available on their website) to estimate the cost for each shipping line. For example:
Item Name
Actual Weight (kg)
Volume (cm³)
Volumetric Weight (kg)
Chargeable Weight (kg)
EMS Cost (CNY)
DHL Cost (CNY)
Nike Air Max
0.8
30×20×10=6000
6000÷5000=1.2
1.2
150
220
Adidas Ultraboost
0.7
28×18×9=4536
4536÷5000=0.9072
0.9072
130
200
By comparing these costs in the spreadsheet, you can see that EMS is cheaper for both items—saving you 70 CNY compared to DHL.
Step 3: Consolidating Orders to Reduce Shipping Costs
One of the biggest advantages of using the CNfans spreadsheet is its ability to help you consolidate multiple orders into a single shipment. Consolidation reduces the total chargeable weight (since you’re not paying for multiple packages) and can cut shipping costs by 30-50%.
To consolidate effectively:
Add a “Warehouse Arrival Date” column to the spreadsheet. This lets you see when each shoe will arrive at the CNfans warehouse.
Wait until all items you want to consolidate are at the warehouse (use the spreadsheet to track this).
List all consolidated items in the shipping section of the spreadsheet and calculate the total chargeable weight. For example, if you have two shoes with chargeable weights of 1.2 kg and 0.9072 kg, the total chargeable weight for a consolidated shipment is 2.1072 kg—cheaper than shipping them separately (150 + 130 = 280 CNY for separate EMS vs. 250 CNY for consolidated EMS).
The spreadsheet makes it easy to track which items are ready for consolidation and calculate the potential savings—ensuring you get the best possible shipping deal.
Tips for Finding Trusted Sellers to List in CNfans Spreadsheet
The quality of your shoes depends entirely on the seller you choose—and the CNfans spreadsheet can help you organize and vet sellers to ensure you’re getting high-quality items. Here are some tips for finding trusted sellers to list in your spreadsheet:
- Use Online Communities to Find Seller Recommendations
As mentioned earlier, communities like Reddit’s r/spreadsheet_Reps/ and Facebook’s replica sneaker groups are goldmines for trusted seller links. When you find a seller recommendation, add their name, Weidian/Taobao link, and a brief note to a “Trusted Sellers” tab in your CNfans spreadsheet. For example:
Seller Name
Platform
Link
Notes
SneakerMaster
Weidian
High-quality Nike replicas, fast shipping
ShoeKing
Taobao
Great Adidas batches, responsive customer service
This tab becomes a reference tool—so you don’t have to search for sellers every time you want to place an order. - Check Seller Ratings and Reviews
Before adding a seller to your spreadsheet, verify their reputation:
Weidian: Look for sellers with a “Good” or “Excellent” reputation (star rating) and a positive review rate of 95% or higher. Avoid sellers with low ratings or frequent complaints about quality.
Taobao: Check the seller’s “heart” or “diamond” rating (more hearts/diamonds = more established). Also, read the “Recent Reviews” section—look for comments like “good quality” or “as described”.
Add a “Seller Rating” column to your spreadsheet to track this info. For example: “SneakerMaster: 4.8/5 stars, 97% positive reviews”. - Test Sellers with Small Orders First
If you’re unsure about a seller, start with a small order (e.g., one pair of shoes) before adding them to your “Trusted Sellers” tab. Use the CNfans spreadsheet to track the order:
Add the seller’s info to the main order sheet.
Include detailed remarks (e.g., “Check for logo accuracy”) to ensure the QC team inspects the shoe thoroughly.
After receiving the shoe, add a “Seller Feedback” column to the spreadsheet (e.g., “Quality is excellent, shipping fast—add to trusted sellers”).
This “test order” approach reduces the risk of buying low-quality items from untrustworthy sellers.
Common Issues with CNfans Spreadsheet and How to Fix Them
While the CNfans spreadsheet is a powerful tool, it’s not without its challenges. Here are some common issues buyers face and how to fix them: - Broken or Incomplete Product Links
Issue: The CNfans team can’t find the shoe because the link you pasted is broken or incomplete.
Fix:
Double-check the link before pasting it into the spreadsheet. For Weidian, make sure the link includes “itemID=XXX”; for Taobao, ensure it includes “id=XXX”.
If the link is broken, go back to the seller’s page and copy it again. Avoid shortening links (e.g., using Bitly)—this can break them.
Add a “Link Check” column to the spreadsheet. Before submitting, mark each link as “Working” or “Broken” (test the link in a browser to confirm). - Missing or Incorrect Size Information
Issue: You receive the wrong shoe size because you entered incorrect size info in the spreadsheet.
Fix:
Always convert your size to EU (the standard on Weidian/Taobao) using a reliable size chart. Add a “Size Conversion” note to the spreadsheet (e.g., “US 10 = EU 44”).
Include your insole length (in cm) in the “Remarks” column. For example: “EU 44, insole length 28cm—confirm with QC”.
Before submitting the spreadsheet, cross-verify the size with the seller’s product page (some sellers have their own size charts). - Confusion About Shipping Costs
Issue: You’re surprised by high shipping costs because you didn’t calculate them correctly in the spreadsheet.
Fix:
Add a “Shipping Cost Estimate” column to the spreadsheet. Use CNfans’ shipping rate chart to estimate the cost for each item (or consolidated shipment).
Include a “Volumetric Weight” calculation (as discussed earlier) to avoid unexpected charges.
If you’re unsure about the cost, add a note in the “Remarks” column: “Please confirm shipping cost before shipping”. The CNfans team will then provide a quote before proceeding. - Miscommunication with the CNfans Team
Issue: The agent doesn’t follow your instructions (e.g., they remove the shoebox when you asked to keep it) because your remarks are unclear.
Fix:
Be as specific as possible in the “Remarks” column. Instead of “Keep the shoebox”, write “Do NOT remove the original shoebox—pack it with the shoe”.
Use bold or uppercase letters for critical instructions (e.g., “IMPORTANT: Check for glue stains on the toe box”).
After submitting the spreadsheet, send a follow-up email to the CNfans team highlighting key instructions. Attach the spreadsheet to the email for reference.
Maximizing Savings Through CNfans Spreadsheet Management
The CNfans spreadsheet isn’t just for organization—it’s also a tool to save money. Here are some strategies to maximize savings using the spreadsheet: - Track Price Fluctuations
Many sellers on Weidian/Taobao offer discounts or sales throughout the year. Add a “Price History” column to the spreadsheet to track how the price of a shoe changes over time. For example:
Item Name
Initial Price (CNY)
Date
New Price (CNY)
Date
Savings (CNY)
Nike Air Max
600
2025-01-10
550
2025-02-15
50
By tracking prices, you can wait for a sale to place your order—saving 50 CNY or more per shoe. - Negotiate Bulk Discounts with Sellers
If you’re buying multiple pairs of shoes from the same seller, use the spreadsheet to negotiate a bulk discount. List all the items you want to buy from the seller in the spreadsheet and send it to the seller (via CNfans’ messaging system). For example: “I want to buy 5 pairs of Nike Air Max—can you offer a 10% discount?”
Add a “Negotiated Price” column to the spreadsheet to track the discounted price. If the seller agrees, update the “Price (CNY)” column to reflect the discount—saving you money on the initial purchase. - Avoid Optional Fees When Possible
Optional fees (e.g., detailed QC photos, vacuum sealing) can add up. Use the spreadsheet to track these fees and decide which ones are necessary. For example:
If you’re buying a budget pair of shoes, you might skip detailed QC photos (saving 10 CNY).
If you’re shipping to a dry climate, you might skip vacuum sealing (saving 5 CNY).
Add an “Optional Fees” column to the spreadsheet and mark each fee as “Necessary” or “Unnecessary”. This helps you avoid overspending on services you don’t need. - Use the Spreadsheet to Plan Hauls
Plan your “hauls” (bulk shipments) using the spreadsheet to take advantage of consolidation savings. Add a “Haul Plan” tab to the spreadsheet where you list items you want to buy and their expected warehouse arrival dates. For example:
Item Name
Seller
Expected Arrival Date
Nike Air Max
SneakerMaster
2025-03-01
Adidas Ultraboost
ShoeKing
2025-03-05
Puma RS-X
SneakerPro
2025-03-10
By waiting until all items are at the warehouse, you can consolidate them into a single shipment—saving 30-50% on shipping costs compared to shipping them separately.
Conclusion
The CNfans spreadsheet is more than just a document—it’s a comprehensive tool that streamlines every step of the shoe procurement process, from sourcing links to optimizing shipping. By using the spreadsheet to organize orders, track costs, follow up on QC, and plan hauls, you can save time, avoid mistakes, and get the best possible value for your money.
Whether you’re a beginner buying your first pair of overseas sneakers or an experienced collector building a large collection, the CNfans spreadsheet is your key to success. With the tips and strategies outlined in this guide, you’ll be able to master the spreadsheet and take your shoe procurement to the next level.