To use the Cnfans spreadsheet, you simply paste a product link from Taobao, Weidian, or 1688 into the designated 'Item Link' column. The sheet automatically fetches the product's name, photo, price, and domestic shipping fee. After reviewing the details and adding any specific requests in the 'Remarks' column, your order is ready for our purchasing team to process once you submit it.
Table of Contents
- What Exactly is the Cnfans Spreadsheet?
- How Do I Get My Cnfans Spreadsheet?
- Understanding the Spreadsheet's Layout
- Placing Your First Order: A Step-by-Step Process
- How Are Costs and Fees Calculated?
- How Do I Submit My Completed Order?
- What Occurs After My Order is Submitted?
- Power-User Tips for a Smoother Experience
- Why Use the Cnfans Automated Sheet?
- Common Questions About the Spreadsheet
What Exactly is the Cnfans Spreadsheet?
The Cnfans spreadsheet tutorial is designed to get you started with our dynamic ordering tool, which is built on the familiar Google Sheets platform. Think of it not just as a list, but as your personal shopping assistant. It has been engineered to bridge the gap between you and Chinese marketplaces like Taobao, Weidian, and 1688. Its primary function is to automate the most tedious parts of international shopping.
When you paste a product URL, the sheet's built-in scripts instantly pull critical data directly from the seller's page. This includes the product’s name, a thumbnail image for visual confirmation, its price in Chinese Yuan (CNY), and the seller's domestic shipping fee. This automation eliminates manual data entry, significantly reduces the chance of errors, and saves you a tremendous amount of time. It provides a centralized, organized, and transparent platform for managing all your potential purchases before committing.
How Do I Get My Cnfans Spreadsheet?
Accessing your personalized shopping spreadsheet is a straightforward, one-time process. Upon signing up for the Cnfans service, you will be provided with a unique link to your own private Google Sheet. This sheet is exclusively yours; no one else can see or edit your orders. It is a persistent document, meaning you will use this same sheet for all your future shopping hauls.
For maximum convenience, we strongly recommend bookmarking this spreadsheet link in your web browser. This ensures you can instantly access your order sheet whenever you discover a new item you want to add. There is no need to request a new sheet for every order; this single, dynamic document will serve as your ongoing Cnfans shopping hub.
Understanding the Spreadsheet's Layout
At first glance, the spreadsheet might seem complex, but it's organized logically to make ordering intuitive. Each column has a specific purpose designed to capture all necessary information for a smooth purchase. Understanding these key columns is the most important part of mastering the tool.
Here is a breakdown of the essential columns and their functions:
| Column Name | Function | User Action Required |
|---|---|---|
| Item Link | The input field for the product URL. | Paste the full product link here. This is the only mandatory manual input. |
| Item Photo | Automatically displays a thumbnail image of the product. | Visually confirm it's the correct item. |
| Item Info | Automatically populates the product's name and original price. | Review for accuracy. |
| Price (CNY) | The item's cost in Chinese Yuan, fetched from the source. | Verify this matches the seller's listed price. |
| Domestic Shipping (CNY) | The fee to ship the item from the seller to our warehouse. | Automatically calculated and displayed. |
| Total (CNY) | A calculated sum of the item price and domestic shipping. | No action needed; this is for your reference. |
| Remarks | A critical field for your specific needs. | Enter size, color, or any special requests for the agent here. |
Placing Your First Order: A Step-by-Step Process
Adding items to your sheet is incredibly simple. This three-step process is the core workflow for using the Cnfans spreadsheet. Once you do it once, you'll be able to add new items in seconds.
Step 1: Find and Copy Your Product Link
Navigate to the product page on Taobao, Weidian, 1688, or another supported marketplace. Highlight the full URL in your browser's address bar. This link contains all the information our system needs. Right-click and select "Copy," or use the keyboard shortcut (Ctrl+C or Cmd+C).
Step 2: Paste the Link into the Sheet
Open your personal Cnfans spreadsheet. Find the next available empty row. Click on the cell under the "Item Link" column (typically Column B). Paste the link you copied (Ctrl+V or Cmd+V). Once you press Enter, you will briefly see a "Loading..." message as the sheet's script goes to work.
Step 3: Review the Autofilled Information
Within seconds, the adjacent columns—Item Photo, Item Info, Price, and Domestic Shipping—will populate automatically. Your job is to perform a quick check. Does the photo match what you want? Is the price correct? Most importantly, use the "Remarks" column to specify mandatory details like your desired size (e.g., "Size: Large" or "Size: 44"), color ("Color: Black"), or any other notes for the purchasing agent.
How Are Costs and Fees Calculated?
Transparency is a core principle at Cnfans. Your spreadsheet clearly breaks down the initial costs associated with each item. The main formula you'll see is for the item subtotal, which is automatically calculated for you. This calculation is: (Item Price in CNY + Domestic Shipping in CNY).
A service fee, which covers our costs for purchasing, quality control, and warehouse storage, is also applied. This fee is clearly stated and added to your order total. It's important to understand that the initial total does not include international shipping. The cost to ship the parcel from our warehouse to your home country is calculated separately, once all your items have arrived and you are ready to have them dispatched.
How Do I Submit My Completed Order?
Once you have added all the items to your spreadsheet, reviewed the details, and filled in the "Remarks" column for each one, you are ready to proceed with the purchase. Submitting your order is not an action performed within the spreadsheet itself. The sheet serves as your order list.
To finalize the order, you will need to ensure your Cnfans account has sufficient balance to cover the total cost of the items listed in your sheet. After topping up your account via our website, you will then formally submit the order through your Cnfans user dashboard. This action notifies our purchasing team to access your spreadsheet and begin acquiring the items on your behalf.
What Occurs After My Order is Submitted?
After you have funded your account and submitted your order, our professional purchasing agents take over. The process is designed to keep you informed every step of the way. First, an agent will review your spreadsheet and purchase each item from the respective sellers based on the links and remarks you provided.
As each item arrives at our warehouse, it undergoes a quality control (QC) check. We take detailed photographs of your items, which are then uploaded to your user account. You can review these QC photos to ensure the items are correct and meet your quality expectations. From there, you can approve them for international shipment or request a return or exchange, if the seller's policy allows.
Power-User Tips for a Smoother Experience
While the basics are simple, a few extra tips can make your shopping experience even more efficient and cost-effective.
- Be Specific in Remarks: Never assume the agent knows the default color or size. Always specify your exact requirements in the "Remarks" column to avoid any ambiguity. For example, instead of just "shoe," write "Men's shoe, Size EU 43, Color: White."
- Consolidate Store Orders: If you plan to buy multiple items from the same Taobao or Weidian store, add them to your sheet consecutively. This helps our agents place a single order with the seller, often saving you money on domestic shipping fees.
- Check for Errors: If an item link fails to load data automatically, double-check that you copied the complete, correct URL. If it still fails, you can manually fill in the item details and leave a note in the "Remarks" column for the agent to handle it.
Why Use the Cnfans Automated Sheet?
The primary advantage of the Cnfans automated spreadsheet is the fusion of simplicity and power. It's a system designed to deliver a superior shopping experience through several key benefits.
First is speed and efficiency. The automation script eliminates the need to manually copy and paste product names, prices, and shipping fees. This saves a significant amount of time, especially for large hauls. Second is accuracy. By pulling data directly from the source page, the sheet minimizes the risk of human error from mistyping a price or product detail. Finally, it offers unmatched convenience and organization. Your entire shopping list, complete with images, prices, and personal notes, is available in one clear, easy-to-manage location that you can access from anywhere.
Common Questions About the Spreadsheet
New users often have a few common questions. Here are quick answers to the most frequent inquiries.
What if the item information doesn't load after pasting a link?
This can happen occasionally. First, ensure the link is correct and from a supported site. Try deleting the link and pasting it again. If it still fails, it may be a non-standard product page. You can manually fill in the item's name and price, and add the link in the "Remarks" column with a note for our agent.
How do I remove an item I decided not to buy?
Simply delete the entire row for that item. Right-click on the row number on the far left of the sheet and select "Delete row." This will remove it from your order list before you submit it for purchase.
Can I edit the price if a seller offers a discount?
Yes. If you have negotiated a different price with a seller, you can manually override the automatically fetched price in the "Price (CNY)" column. It is crucial to leave a note in the "Remarks" column explaining the price change so our purchasing agent understands the situation.