Importing a supplier spreadsheet into WooCommerce can be fast. Keeping that catalogue consistent after the second or third update is harder. BAO Group prepares product data, reviews category structures and helps build a repeatable update process for small and growing online shops.
We work from the supplier’s actual files and the store’s existing configuration. We do not invent dimensions, stock counts, product origins or customer reviews when the source data does not establish them.
Before editing the catalogue
We start with a sample of the original CSV or XLSX file, the update frequency, the current WooCommerce export and any documents describing product attributes. The objective is to identify a stable key for matching existing items. A supplier may use SKU, EAN, barcode or a separate internal code. These fields should be compared before any import overwrites existing products.
The catalogue workflow
| Stage | Typical checks | Result |
|---|---|---|
| 1. Source inventory | Files, identifiers, row counts, duplicate records, missing fields and variable products | A list of data sources and fields that can safely be trusted |
| 2. Mapping | WooCommerce categories, brands, product variations, images and attributes | An agreed field map and category structure |
| 3. Small test | Import a limited sample and inspect published products | Verified formatting before wider changes |
| 4. Content | Product names, descriptions, confirmed dimensions and image captions | Readable information for shoppers without fabricated specifications |
| 5. Recurring updates | Stock availability, prices, discontinuations and supplier delivery limitations | A repeatable process appropriate to the available feed |
Matching products without creating duplicates
Stable matching is more important than forcing every record into a convenient format. A store may already have human-edited titles and product images. If a new supplier file uses a different identifier or changes a row order, a careless import can create duplicates or replace a correct page with unrelated data.
We inspect SKU, EAN and the supplier’s own catalogue code where available. A shared code on colour variants is not necessarily a duplicate item: each record may need its own variation or a documented variant key. Before changing identifiers, we confirm how the supplier uses them for ordering and stock synchronisation.
Product descriptions and images
Good product information describes the item actually offered. For cookware, a page may need capacity, dimensions and compatible heating surfaces; for clothing, measurements and material composition; for a chess set, board size and king height. The relevant properties depend on the category. When the supplier has not confirmed a measurement, we leave it explicitly unconfirmed rather than copying a speculative figure from another listing.
Image work can include checking whether the product matches the photograph, choosing a sensible primary image, setting accurate ALT text and ensuring thumbnails have consistent proportions. ALT text should reflect what is shown, especially when one photograph is reused across several variants.
Stock and price updates
A supplier’s file might be updated hourly, daily or irregularly. A shop cannot promise live stock when its data arrives only once a day. We review the incoming format and decide what can be automated and what should be checked manually. Pricing rules, delivery costs and currency conversion also need to be documented rather than applied as unexplained bulk formulas.
For recurring tasks see price and stock update file preparation. For initial data mapping see WooCommerce import file preparation.
Product search visibility
WooCommerce structured data should reflect the live product page, including valid identifiers and applicable offer information. Category pages should lead shoppers toward relevant products and practical buying guides. We check for missing fields and unintended duplication between WooCommerce, the SEO plugin and any custom schema module. The availability of Google shopping features depends on Google’s rules and the shop’s eligibility; structured data alone cannot guarantee those placements.
What we need to prepare a quotation
- The website address and an approximate number of products
- A sample supplier file and an explanation of how frequently it changes
- The current import method or plugin, if one is already in use
- Whether products must be translated or need additional confirmed specifications
- Any known problems: duplicate products, wrong categories, missing images or outdated stock
We agree the number of products, the source of truth, the intended output and the test procedure before making bulk changes. A single clean feed requires different work from several supplier catalogues with conflicting identifiers.
Frequently asked questions
Will existing product URLs be preserved?
We aim to retain established URLs where possible. Any required redirects or substantial URL changes must be reviewed before implementation.
Can you automatically fix inaccurate specifications?
Only where a reliable source supports the correction. We can flag unclear records for verification, but should not infer missing product facts.
Can we import without affecting current orders?
The safest process begins with backups, a controlled sample and a review of the store’s dependencies. The exact risks depend on the plugins and data model.
Review your catalogue
Send your catalogue requirements →
Related services: catalogue audit, category descriptions and product description rewriting. Our supplier CSV checklist explains common import pitfalls.