Foreign Trade Quotation Builder

Problem It Solves

Foreign-trade quotations often need products, images, company details, USD unit prices, and remarks in a sendable Excel file. Manually copying 1688 product data, converting prices, inserting images, and adjusting column widths is error-prone and hard to reproduce. quotation-builder templates the step from product data to quotation file.

How It Works

The core capability is reading ProductDict and CompanyInfo, then calling generate_excel to output an .xlsx quotation. The standard layout suits normal product lists: a company block, a header row, and data rows, with images scaled to a 90px maximum and prices stored as real numeric values using $#,##0.00. The built-in dg-1688 rule supports 1688-style pages with a compact three-column layout, product-name sequencing, color-and-size expansion, and USD pricing derived from CNY.

A typical workflow is: prepare config/company.json and data/local_products.csv; search by SKU or product name with search_csv; pass the product JSON to generate_excel. For web-sourced data, the Skill does not scrape pages by itself; it works with web-access to extract titles, prices, and image URLs. The upper model then applies markup, currency conversion, and builds the ProductDict.

Boundaries and Caveats

It is best suited for structured quotation files, not orders, contracts, or invoices. price must already be the final quote; missing company info returns an error; an empty product list returns an error; failed image downloads use a No Image placeholder. If relying on 1688 page structure or image rules, confirm that the rule package version is compatible with the target page.