Guides

Connectors: supplier prices and product matching

Excel import, supported website refreshes, source history and semantic matching, kept separate from 1C accounting records.

Discover the available commands

An extension describes its tools, inputs and effect: reading or changing data. The agent finds the relevant command and loads its exact schema. Installing executable extensions requires operator trust; a file from an unknown source should not automatically gain access to a working server.

Inspect the spreadsheet layout

Before importing Excel, inspect sheets, headers, columns, sections and units. Supplier, SKU, name, price, stock, currency and date may appear in different places. Previewing and mapping help avoid importing a category header as a product or treating an empty cell as zero stock.

Keep offer provenance

The supplier catalog is separate from the 1C database. A repeated SKU needs to be distinguished from a new product. Comparisons need supplier, source, upload date and freshness. Matching names from two suppliers do not establish one accounting item. A source date explains where a price came from.

Find candidates, then verify

Example: “Find a pipe matching the customer’s wording, then compare our stock with supplier offers.” Semantic search proposes candidates; dimensions, material, unit and SKU still need verification. Creating an offer in 1C requires matching your own products and authorization to write. A scanner supports a particular resource, not every website; its refresh can be scheduled and checked in the run log.

Ready to connect your database?

Sign in, link an issued key or submit an access request. Download the package after approval.