Shopware 6 · AI research · TypeScript

From delivery note
to finished product.

When new stock arrives, every item has to be set up in the online shop, with a title, description, sizes and images. I built this tool so that this no longer has to be done by hand: it reads the delivery list, compares it with the existing range, researches missing details and prepares the images. A product is only created once a person approves it.

In development · running on the test system
INCOMING GOODS SL-4471-020 Sz. M 4 pcs SL-4471-020 Sz. L 3 pcs SL-4471-020 Sz. XL 2 pcs 1 checked against stock 2 categorised 3 researched APPROVAL BY A PERSON Set price · check proposal · approve SHOPWARE · ADMIN API Parent product · 3 sizes · categories · properties inactive, stock 0 until price and quantity are set

How a delivery line becomes a product

The demo shows in seven steps what happens to one line of a delivery list. New details appear in copper-coloured text, discarded ones are struck through.

Station 1 of 7 -

All data in the demonstration is made up. The flow matches the real tool.

Where the data flows

The details come from four sources and reach the shop by a single route. Nothing is written there without approval.

SOURCES Incoming goods file from the merchandise system Shop mirror local copy, read-only AI research web search, costs money Image material B2B portal or own photo PROCESSING Reader encoding, broken columns Duplicate check multi-stage, surest first Categorisation without AI, from the stock House style number, title, description Lock: cost limit DRAFT Product proposal Title · description Product number · sizes Categories · properties Images from the portal Sources · caveats Traffic light per field sits in the review list none of it is final Lock: approval + price TARGET Admin API one call per product shop indexes itself Shopware inactive, stock 0 Lock: test/live waiting for a person reversible There is no way around the locks, and no switch opens all three at once. Writing takes place exclusively via the Admin API, never directly in the shop database. Reading Processing Writing Rollback Lock

On a phone you can scroll this sideways.

The three stages

The work is split into three stages. Only one of them costs money, and only one changes the shop.

Step 1

Read in incoming goods

Each line of the delivery list is compared with the existing range. The tool recognises whether an item is new, partly present or already in the shop.

costs nothingchanges nothing
Step 2

Research

Missing details are researched only for new, selected items. The cost is shown on the button beforehand.

costs moneychanges nothing
Step 3

Create

After a confirmation prompt, each product is created, initially inactive and with zero stock.

costs nothingchanges the shop

Note on the data. This page shows no data from the real stock.

What the tool looks like

The tool runs in the browser. The header always shows where you are in the process.

Interface of the tool: header with the steps Scannen, Wareneingang, Recherche, Prüfen, Hochladen and Im Shop, the pages for maintaining existing products on the right, below it an input field for the product number and a short guide in three columns.
This screenshot was taken without the service running, so it shows no data.

The tool's six pages

PagePurposeAffects
Create Incoming goods, research, review, upload writes to the test system
Titles Review product titles in stock local only
Descriptions Review existing product texts local only
Product numbers Check product numbers local only
Access Brand dealer portals local only
Manual Operation, step by step -

On a phone you can scroll this sideways.

The header also shows whether the test system or the live shop is connected. If that is unclear, the tool writes nothing.

All eleven stations at a glance

The table shows every station from the delivery line to the final check in the shop, and what each one does.

StationWhat happensConsequences
00 · Catalogue copyA local copy of the shop's catalogue is fetched.read-only
01 · Delivery listDamaged files are detected instead of guessing at their content.changes nothing
02 · MatchingEach line is classed as new, partly present or present.changes nothing
03 · CategorisingCategories and attributes are taken from similar products, without AI.changes nothing
04 · ResearchAn AI searches the web for missing details, within fixed cost limits.costs money
05 · ProposalTitle, description and product number are written in the shop's house style.changes nothing
06 · ReviewA traffic light shows for each field whether the value is right.changes nothing
07 · ApprovalA person sets the price and approves.Lock
08 · CreateThe product is created with its sizes, inactive and with zero stock.changes the shop
09 · Post-checkThe result in the shop is compared with the proposal.read-only
10 · RollbackDrafts and jobs can be discarded one by one.reversible

Where the images come from

Images come from the brands' dealer portals or from own photos.

RouteWhat it doesWhen
StandardCrops the image to a square and places it on a white background, without AI.on every image
Deep checkLooks for watermarks and copyright notices.in the review screen
Image editingAn image can be re-cropped by hand.on request
How the tool handles image rights

The tool records where every image comes from. An edited image keeps the rights status of the original. Third-party watermarks block the image and are never removed.

The rules the tool follows

The rules are derived from the shop's existing range. The table only lists what each one decides.

Rule setWhat it decides
Number structureWhat a new product number looks like.
Duplicate checkWhether the product already exists.
CategorisationWhich categories a product belongs to and which sizes and attributes it has.
Number authenticityWhether a number is official or in-house.
House styleHow the title and description are structured.
Image source per brandWhere images come from and which credit goes with them.
Cost limitsHow much a research run may cost.

Further functions

Current status

The core of the tool runs on a test system. It is not yet in use in the live shop.

Import, matching, proposalDone
Creating and undoingDone, on the test system
Images and image checksDone
Title reviewIn progress
Live shopOpen

The tool takes over the typing, but the price is always set by a person. I show it with the consent of Muskelkater Sport Köln and without any data from day-to-day operations.

Who Artikel-Anleger is for

Starting point
Creating products by hand takes long and makes the data inconsistent.
Target group
Shopware retailers with regular deliveries and their own catalogue rules.
Status
The tool is in development and not yet in live use.
Availability
On request I can build a version tailored to your catalogue.

Contact

If you would like to know how Artikel-Anleger is built, why I solved something a certain way or whether it could suit your business, write to me using this form.

Arithmetic check Arithmetic task, shown as an image

Your details are processed in order to answer your enquiry. More in the privacy policy.

No Google captcha, no cookies, no disclosure to third parties. Alternatively by e-mail to info@timobritz.de.