Reactivating store stock to boost click & collect

Products on the shelf, missing from the website

Teract, a major player in French retail (Gamm Vert, Jardiland), runs a dense network of stores and a constantly changing catalog.

Yet many SKUs available in store were in neither the PIM nor the national repository. Without a product page, they could not be shown on the e-commerce website or offered for click & collect.

The result: lost online visibility, a gap between the stores’ actual stock and what the website offered, and a click & collect flow performing below its potential.

A 5,000-SKU pilot, starting from partial data

The first batch covered eight families, from regional produce to gardening and pet food. At the start, 1,856 products had a BAN label and 1,538 had supplier information.

Upsellr was brought in to automate the whole chain, in four steps:

1. 1

   Retrieve : product information from the available sources: the web, manufacturer websites, partner databases.

2. 2

   Structure : the missing data in the format expected by the Teract PIM and the e-commerce feeds.

3. 3

   Generate : product names, descriptions, technical attributes, visuals and FAQs.

4. 4

   Standardize : the metadata to the feed format, so that the online offer matches the stores’ offer.

Two SKUs out of three found

Finding a product from a bare label is the hardest step. Of the pilot’s 5,000 SKUs, the agents identified 3,367, and the rate climbs when a BAN label was available at the start.

overall identification rate

67.3%

with a BAN label

80.5%

without a BAN label

59.5%

Revenue lying dormant in stores

In one month, Upsellr delivered 2,972 enriched and approved products. Of these, 1,749 had until then only been listed locally: as far as the website was concerned, they did not exist.

units of stock involved in Jardiland stores

128,000

in estimated latent revenue

€100,000

2,950 products can now go back on click & collect, without the central PIM teams having to step in: the range visible online now reflects what the stores actually offer.

Toward full industrialization

The pilot turned a product data gap into a competitive advantage. Three projects are now under way:

• industrialize the approach across other departments and other Teract banners;
• extend it to the whole “local store” catalog;
• add structured attributes for visibility in generative engines.