Automated Quote Comparison
Compare supplier quotes with spec checks
Automated Quote Comparison
Compare supplier quotes with spec checks
Showcase
Description
# Automated Quote Comparison | Quote Comparison Radar **Compare multiple supplier quotes in one table: only matching specifications are ranked, suspected matches require confirmation, and unit prices are calculated with Excel formulas.** ## Still comparing supplier quotes manually? If you run a wholesale business, stock a store, or handle purchasing, you may often encounter these issues: - Supplier A quotes by the case, supplier B by the dozen, and supplier C by the individual item. - Some prices include tax while others do not, making direct comparisons error-prone. - The same product may have different names and may mix Chinese, foreign-language text, and different decimal formats. - Products that look identical may differ in capacity, dimensions, material, or model. - Quote sheets may contain dozens or even hundreds of rows. Organizing them manually takes time and makes it easy to miss lines. **Quote Comparison Radar organizes multiple supplier Excel quotes into one standardized comparison table that you can check row by row.** The focus is not just on comparing prices, but first determining whether the product specifications are comparable. ## Core features **① Three-level product specification matching** 🟢 Matching specifications: Key specifications meet the requirements and can be included in the price comparison. 🟡 Needs confirmation: Key information is missing or the specifications require further confirmation. The item is temporarily excluded from the lowest-price ranking. 🔴 Conflicting specifications: Key attributes such as dimensions, capacity, or material are clearly different. The item is excluded from the lowest-price ranking for that product. This prevents a lower-priced product with different specifications from being treated as the best quote. **② Automatic packaging quantity conversion** Supports cases, dozens, cards, and multi-level packaging, such as “20 packs × 10 pieces.” Automatically organizes package quantities and pricing units while distinguishing product specifications from minimum order quantities, so quotes for different quantities are not compared directly. **③ Standardized tax-inclusive and tax-exclusive prices** When tax information is clearly provided in the quote, tax-inclusive prices are converted to tax-exclusive prices for a consistent comparison basis. Foreign-currency quotes are marked separately. Exchange rates are not converted automatically, and these quotes are not included in the lowest-price ranking. **④ Tiered pricing support** Tiered prices for different purchase quantities are listed separately. By default, only the starting quantity tier is used for comparison. **⑤ Excel formula calculations for row-by-row checking** Unit prices in the output are calculated with Excel formulas rather than estimated directly by AI. Each row retains the source file and original product number, making it easier to verify product descriptions, package quantities, tax rates, and prices. **⑥ Missing-row prevention and batch processing for large files** At the beginning, the Skill reports the number of rows identified in each file. After output is complete, it performs an item-by-item check and attempts to restore any missing rows. When there are more than 40 rows, the output is automatically split into batches. Reply “Continue” to get the next batch; row numbers remain continuous. **⑦ Supplementary confirmation for suspected products** For example, reply: “B-04 is transparent.” The Skill updates the corresponding entry based on the additional information, so you do not need to reorganize all quotes from scratch. ## How to use **Step 1: Upload at least two supplier Excel quote sheets.** Files are sorted by filename, and the first file becomes the reference supplier. To specify the reference supplier, add `1_` to the beginning of its filename. **Step 2: Wait for product matching and the comparison table.** If the quote contains more than 40 rows, reply “Continue” as prompted until the entire output is complete. **Step 3: Copy the results to Excel.** Paste each batch into Excel cell A1 in order so Excel can calculate the formula results. **Step 4: Filter for the lowest quotes.** Filter for 「参与排名＝是」, group by product, and sort 「未税单价」 from low to high to find the currently lowest comparable quote for each group. **Step 5: Manually verify and confirm suspected products.** Add specification information for 🟡 entries, then ask the Skill to update the corresponding rows. ## Internal test results The final version was tested using self-created fictional quote data: - 4 suppliers and 156 quote rows in total. - The test included case packaging, tax-inclusive quotes, multiple worksheets, Romanian product names, comma decimals, euro quotes, tiered pricing, and entries without prices. - The final version output all 156 rows. - 0 incorrectly matched items entered the lowest-price ranking. - The lowest-price conclusions for all 50 product groups were correct. - After the output was pasted into Excel, no formula errors occurred during testing. These are **test results using fictional internal data**. They are not a real customer case and do not indicate that all real quote sheets will achieve the same accuracy. ## Limitations and notes - Currently supports only Excel quote sheets, not PDFs, images, or WeChat text. - Compares product unit prices only; shipping costs, minimum order quantities, and payment terms are not included in the price comparison. - 🟢 means the provided key specifications match. It does not guarantee the same brand, model, or completely identical product. - Foreign-currency quotes are not automatically converted using exchange rates. - If Excel uses commas as decimal separators, such as `12,50`, mention this when uploading. - Entries missing required tax rates, pricing units, or packaging information must be confirmed before they can be used for a valid comparison. - The Skill does not directly provide a final purchasing decision. You need to filter, sort, and verify the lowest quotes in Excel. - Before purchasing, manually verify key product specifications and supplier quotes. ## Price and credit usage **Launch price: 1,980 credits.** In an internal test with quotes from 4 suppliers and approximately 150 rows, the run used about 224 credits. Actual credit usage depends on the number of files, number of product rows, batch output, and the number of follow-up confirmations. 224 credits is not a fixed fee. ## Who is it for? - Retail store owners who frequently purchase from multiple suppliers - Wholesalers and small trading companies - People responsible for product purchasing and supplier quote requests - Business operators who need to organize multiple Excel quote sheets **Confirm that specifications are comparable before comparing prices.** A price that looks cheaper may not be directly comparable.
Recommended by
淡苍
Why we love this skill
Carefully standardizes multi-supplier quotes with specification matching, confirmation flags, Excel formulas, and traceable handling of packaging, tax, currency, and tiered pricing.
Best for
For retailers, wholesalers, and purchasing staff who organize supplier Excel quotes, verify product specifications, and compare unit costs.
How to use this Skill
Provide your input
Upload at least two supplier Excel quote sheets. If commas are used as decimal separators, mention that as well.
Run the Skill
The Skill organizes product quotes, checks specifications, packaging, tax details, and currencies, then creates a standardized comparison table.
Review your result
Get a row-by-row comparison table ready to paste into Excel, including formula-based fields and items requiring manual confirmation.
Related Skills
View all
Brand Deal Pricing Coach
The hardest part of taking a brand deal isn't finding one—it's knowing what the deal is worth. You spend three days negotiating, then the client says, “That’s the entire budget.” You don’t know whether it’s a firm limit or a negotiation tactic. Quote too high and you may lose the deal; quote too low and you may finish the work after staying up late, only to realize you lost money. This skill brings in the knowledgeable friend who knows the business. Share the basic details of the deal—who the client is, the format, how many deliverables and revision rounds are required, and what price they offered. It will first ask for key missing information, then provide a Brand Deal Pricing Evaluation Report: ✨ Core capabilities 1. Break-even price calculation: Time costs + hard costs + taxes and commissions + revision and payment-term risks, so you can first determine “below what price am I losing money?” 2. Three pricing tiers: Floor price / target price / ideal price, with the reasoning behind each tier and the amount tied to every add-on and discount item 3. Contract checklist: Payment, advance payment, revision limits, licensing scope and duration, exclusivity period, and the right to publish the work as a case study—beginners often lose out more on terms than on price 4. Negotiation scripts: For the initial quote, “the budget is limited,” “let’s test the results first,” exclusivity requests, requests for free trial work, and more. Each scenario includes a ready-to-copy version with tone and risks noted 5. One-page quote letter: Once you reach an agreement, generate a quote letter you can send directly to the client with one click 6. Pricing archive: Remember your past deal prices and minimum hourly rate, becoming more accurate the more you use it 🛡️ Three firm principles · No invented market figures: All amounts come only from the anchors and cost calculations you provide. Estimated ranges are clearly marked as “not the market average” · No sugarcoating: If the price is below your costs, it will tell you directly, “Taking this deal means losing money,” and calculate where the loss comes from · No deciding for you: It provides analysis and supporting reasons; the decision remains yours 📱 Who it’s for Bloggers, creators, and up creators handling brand partnerships, platform deals, or sponsored content; public-account writers; Xiaohongshu and Douyin creators; as well as designers, writers, and podcast hosts taking on projects. 💡 How to use it Simply describe your deal. You can also use /报价 /还价 /条款 /出函 /复盘 /档案 for precise access. Getting one quote right can mean a difference of hundreds or even thousands.
WriteCreator Outreach Pro
SKILL FEATURES Reverse-engineer your creator profile: Start with goals such as promoting a mini program or driving product sales, then determine the creator category, follower range, content format (short video, image-and-text, or livestream), and price range—so you do not start by aimlessly searching for big-name creators. Candidate shortlist: Organize 10–30 candidates using public information, including platform, follower range, category, content style, estimated rate range, recommendation, and official outreach channels (Xingtu homepage, Pugongying creator marketplace, or a publicly listed MCN business email). Rate and budget model: Estimate costs using flat fees, CPM, CPE, and commission (CPS), then show “total budget → creator tier allocation (top-tier 10% / mid-tier 60% / long-tail 30%) → expected impression range,” with platform service fees noted (about 5% for Xingtu and 10% for Pugongying). Tiered outreach script package: Generate four versions—a Xingtu task Brief, a Pugongying brand invitation, an MCN business email, and a first-contact direct message to the creator—each checked for platform-restricted terms. Brief generator: Automatically create a complete Brief covering product benefits, required and prohibited talking points, number of verbal mentions, publishing window, retention period, component linking (shopping cart / LINK / anchor), and data tracking requirements. Three-part compliance check: Check ad identifiability (clearly labeling content as “Advertisement”), platform disclosure rules (mandatory disclosure on Pugongying; disclosure required for product exchanges valued at ¥500 or more), and prohibited absolute claims or efficacy promises. When a risk is found, provide rewrite suggestions. Follow-up CRM sheet: Output fields that can be pasted into a spreadsheet (creator / platform / follower count / rate / outreach date / channel / reply status / script pending confirmation / publish date / acceptance / review data), with support for updating statuses through follow-up questions. Post-campaign review template: Compare views, engagement, conversions, CPM, and CPE with expectations, then build reusable creator whitelists and blacklists. Suggested prompts I want to promote a bookkeeping mini program with a ¥30,000 budget, mainly on Douyin and Xiaohongshu. Create a shortlist and estimate rates. Write a Pugongying brand invitation and post Brief for a low-sugar snack category, and run the three-part compliance check. I have a list of 20 creator accounts. Assess which are worth investing in and how to allocate the budget. For product sales, should I use a flat fee or commission? Compare CPM/CPE estimates for both options. Rewrite this outreach direct message so it does not trigger restricted terms or get treated as spam. How should I review creator content after publishing? Give me a post-campaign data review template and whitelist criteria.
SlidesTableCraft
Turn CSV, JSON, Markdown tables, or pasted cells into clear, editable HTML tables. Ideal for comparing pricing plans, selecting tools, and preparing team weekly reports, with support for seven preset styles and brand colors. Preserve currencies, units, billing cycles, number precision, and sources; missing values stay missing—no filling with 0 or guessing prices. Calculate and verify totals only when conditions allow; flag discrepancies without changing numbers. Split wide tables into column-group pages and repeat key columns; repeat headers for long tables. Never silently remove columns or abbreviate content. A first version is created by default. When the environment supports actual rendering and export, a PNG is also provided; otherwise, complete HTML is provided with an explanation that it was not exported. Try it directly: compare three subscription tiers, organize tool-selection materials, or polish an eight-column team weekly report. For chart-based infographics, use Infographic Maker; for text carousels, use a knowledge card generator.
Information
- Version
- v10
- Last updated
- Runtime credits
- Usage-based
- Models
- Auto
- Use cases
- Research & analysisE-commerce & salesBusiness & strategy
- What you get
- ReportData
