Altrix Web technical work sample · e-commerce CSV comparison and browser-based workflow
Supplier inventory and price files frequently use different column names and can contain duplicate SKUs, unexpected price changes or missing records. This supplier CSV stock and price comparison case study shows how Altrix Web designed a local review workflow for comparing supplier data with an existing store export before anyone imports changes into WooCommerce.
Project type: Altrix-developed standalone application, not a commissioned client project. Technology model: local HTML/JavaScript browser application. Public documentation: Supplier Stock & Price Update Assistant.
The problem: a supplier CSV is not automatically a safe store update
A supplier may report a new stock quantity, a revised unit cost or a new regular price. The merchant’s WooCommerce export may contain a different set of SKUs, historical products or variations. Importing an entire unreviewed file creates avoidable questions: Which changes are intended? Which SKUs do not match? Does a missing supplier record mean zero stock? Is a large price increase genuine?
The goal of this project was to make those differences visible, keep ambiguous entries out of approved updates and leave the merchant in control of the final import.
The solution: local SKU matching with review before export
Altrix Supplier Stock & Price Update Assistant compares two suitable delimited files: the current store export and the latest supplier file. The user maps identifiers and selected numeric columns, then reviews findings by status rather than treating every supplier row as an instruction to update the store.
- SKU-based matching: compare records using a unique SKU for each sellable item or variation.
- Clear status categories: Changed, Review, Unchanged, Supplier only and Store only findings.
- Visible exceptions: duplicate or blank SKUs, invalid numbers, unmatched items and large price changes are held for review.
- No automatic stock-out assumption: a SKU absent from the supplier file is left unchanged rather than set to zero.
- Local operation: the downloaded application processes selected files in the user’s browser, without requesting store credentials or connecting to a live catalog.
What the Free Trial and Pro editions do
The Free Trial supports local comparison, filters and an audit CSV for files up to 50 data rows and 2 MB each. It is useful for evaluating a small sample, but it does not include approved WooCommerce stock and price update exports.
The documented Pro edition supports up to 100,000 rows and 20 MB per file, selected WooCommerce regular-price and stock CSV exports, optional cost-based pricing rules, minimum-margin and price-change checks, stock buffers and saved mapping profiles. Actual processing depends on the user’s computer and file quality.
These are published edition capabilities, not claims that any specific store has already completed a successful import.
Example: a three-SKU review
| SKU | Observed difference | Review decision |
|---|---|---|
| AL-001 | Regular price changes from 29.00 to 32.00 | Check the source and approve only if intended |
| AL-002 | Supplier stock changes from 4 to 0 | Verify zero stock is genuine before import |
| AL-004 | Regular price rises from 39.00 to 90.00 | Hold for review against price-change rules |
Illustrative sample data from the product workflow, not an actual merchant’s catalog or measured customer outcome.
Technical design decisions
Make exceptions explicit rather than silently correcting them
Blank identifiers, duplicate SKUs and invalid numeric cells need human attention. If a product is missing from the supplier export, the application treats it as a separate Store only finding instead of interpreting absence as a stock adjustment.
Keep comparison separate from store changes
The application does not write to WooCommerce, call store APIs, synchronize supplier inventory or automatically import CSVs. Pro generates separate approved import files for eligible regular-price and stock changes; the store operator reviews and imports those files through WooCommerce after a small test.
Scope platform compatibility honestly
Suitable generic data files can be compared by SKU, but the ready-made update exports described for this version target WooCommerce. The generic changes report is not a Shopify, marketplace or hosting-platform import template. Excel files must first be saved in a supported delimited format.
Suggested validation process for agencies and catalog teams
- Back up the current store data and export a representative group of products, including variations where relevant.
- Check that both files use consistent SKU definitions, quantities, currencies and tax bases.
- Run a comparison; investigate duplicate IDs, unexpected changes and Store only records.
- Use the Free Trial to assess the review workflow; use Pro only when approved WooCommerce export files are needed.
- Test a small WooCommerce import with verified SKUs before proceeding with a larger set of changes.
What this work sample demonstrates
This product illustrates how Altrix Web approaches catalog-data mapping, exception handling, approval workflows and locally processed business tools. It supports conversations about customized supplier data processing, WooCommerce catalog maintenance and scoped automation projects. It does not establish a measured time saving, error reduction or client return on investment; those would require verified client data.
See the documented workflow: Supplier Stock & Price Update Assistant. Related reading: Product CSV Checker and Shopify & WooCommerce catalogue management services.
Need help with supplier CSVs or WooCommerce product updates?
Send Altrix Web a short description of your supplier file format, approximate SKU count, destination platform and most frequent import problems. We can propose a small paid pilot—for example, a sample mapping, a reviewed import-ready WooCommerce CSV or a defined exception-handling workflow—before discussing broader automation.
Request a scoped catalog-data project quote · Explore agency partnership options · See the Migration Comparison Tool
Work-sample disclosure: Built and documented by Altrix Web. No actual client sales, time savings or import success rate is claimed. Edition capabilities and requirements should be checked against the current product page.
