Beginner Spreadsheet Tutorial

Getting started with the oopbuy spreadsheet is simple: Step 1: Visit the oopbuy spreadsheet page through the main portal. The spreadsheet is accessible without registration. Step 2: Familiarize yourself with the main tabs. The spreadsheet typically has tabs for: - All Products (complete database) - By Category (filtered by product type) - By Country (filtered by shipping destination) - Trusted Sellers (top-rated sellers only) - Sales and Coupons (current deals) Step 3: Understand the column structure. Common columns include: - Product Name and Category - Seller Name and Trust Score - Base Price and Shipping Cost - QC Rating and Photo Availability - Shipping Lines Available - Coupon Codes Step 4: Use the search bar to find specific products or brands. The search supports partial matches and category filtering. The spreadsheet loads quickly and works on both desktop and mobile browsers.

Mastering filters is the key to finding great products: Price Filtering: 1. Locate the price filter controls at the top of the spreadsheet 2. Set your minimum and maximum price range 3. The spreadsheet automatically updates to show only products in your range 4. Tip: Start with a wide range and narrow down as you browse Category Filtering: 1. Click the category dropdown menu 2. Select one or more categories (Shoes, Hoodies, T-Shirts, etc.) 3. The spreadsheet shows only products from selected categories 4. Tip: You can select multiple categories to compare options Country Filtering: 1. Select your destination country from the country dropdown 2. The spreadsheet highlights sellers who ship to your country 3. Shipping cost estimates update automatically for your country 4. Tip: Always filter by country before comparing prices Sorting: 1. Click any column header to sort by that column 2. Click again to reverse the sort order 3. Popular sorts: Price (low to high), Trust Score (high to low), QC Rating (high to low) These filters can be combined. For example, filter by Germany, Shoes, and price under 50 EUR simultaneously.

Understanding seller data helps you make safe purchases: Trust Score Column: - 95-100: Excellent seller, highly recommended - 90-94: Trusted seller, good performance - 80-89: Average seller, some caution advised - Below 80: New or risky seller, research carefully QC Rating Column: - 4.8-5.0: Excellent QC photos and inspection - 4.5-4.7: Good QC, adequate for most purchases - 4.0-4.4: Average QC, check photos carefully - Below 4.0: Poor QC, avoid for valuable items Germany Rank Column: - This shows the seller's ranking specifically for German deliveries - Rank 1-10: Best sellers for Germany - Rank 11-30: Good sellers for Germany - Rank 31+: Adequate but not optimized for Germany Shipping Lines Column: - Shows which shipping lines each seller supports - Look for DHL Express and DHL Ecommerce for best Germany performance - Germany Direct is a bonus for German buyers Customs Risk Column: - Low: Safe for German customs - Medium: Usually safe, occasional delays - High: Risky, may encounter customs issues

The shipping cost calculator helps you estimate total costs: Step 1: Select your destination country from the dropdown Step 2: Select your preferred shipping line Step 3: Enter the product weight (if known) or use the estimated weight from the spreadsheet Step 4: The calculator shows: - Base shipping cost - Estimated VAT for your country - Potential customs fees - Total delivered cost Example Calculation for Germany: - Product: 35 EUR - Weight: 1.5kg - Shipping (DHL Ecommerce): 18 EUR - VAT (19%): 10.07 EUR - Total: 63.07 EUR Tip: Compare total costs across multiple sellers. Sometimes a higher base price with lower shipping or a coupon results in a lower total. The calculator updates automatically as you change filters, showing real-time cost estimates.

Once you have found a product, here is how to proceed: Step 1: Click the product link in the spreadsheet. This opens the seller's page. Step 2: Review the product details on the seller's page. Confirm size, color, and specifications. Step 3: Check if the seller offers any additional coupons not listed in the spreadsheet. Step 4: Add the product to your cart and proceed to checkout. Step 5: Select your shipping line based on the spreadsheet's recommendations for your country. Step 6: Enter the coupon code from the spreadsheet if available. Step 7: Complete the order and save your order confirmation. Step 8: Wait for QC photos. The seller will send photos within 24-72 hours. Step 9: Review QC photos and approve or request changes. Step 10: Once approved, the seller ships your product. Use the tracking number to monitor delivery. The oopbuy spreadsheet includes seller contact information for any questions during the process.