25 / 28 · The import from your systems
- 1Welcome to Transpareo1 min 12 s
- 2Your digital product passport0 min 44 s
- 3What your customers see1 min 10 s
- 4The signature check0 min 44 s
- 5The version history1 min 23 s
- 6Campaigns1 min 7 s
- 7Access to protected data1 min 12 s
- 8Access for suppliers1 min 35 s
- 9Opening the Application Manager0 min 39 s
- 10The Application Manager2 min 4 s
- 11Import from a spreadsheet2 min 2 s
- 12Asking suppliers1 min 56 s
- 13Components in one place0 min 36 s
- 14What the passport requires0 min 58 s
- 15One model, many variants0 min 54 s
- 16Documents and certificates0 min 47 s
- 17Tasks1 min 3 s
- 18History and restore0 min 31 s
- 19A batch keeps what was made1 min 57 s
- 20From draft to published0 min 48 s
- 21QR codes and RFID1 min 5 s
- 22Team and permissions1 min 13 s
- 23Lifecycle events1 min 18 s
- 24Scan data0 min 36 s
- 25The import from your systems2 min 40 s
- 26Automation with AI0 min 46 s
- 27Your branding1 min 7 s
- 28Try it for free0 min 31 s
Import product data from your systems
An n8n workflow reads a CSV file from one of your systems, here the ERP, and creates 66 products and 56 signed product passports in Transpareo through its interface.
Through Transpareo Connect, your own systems control every function of the Application Manager, whether an enterprise resource planning system (ERP), a product information system (PIM) or an Asset Administration Shell (AAS). In the film, the automation platform n8n takes two steps: the first creates two models in four colours and seven sizes each in a single import, the second reads the same file again and creates the passports with trade item number (GTIN) and batch number, each signed by you and by us.
An import holds up to 100,000 rows, and for each connected system you set how many rows per minute it may upload. The ERP integration playbook shows how to connect your ERP in two weeks, and Workflows that know whose turn it is how n8n workflows assign tasks and ask for reviews. The API documentation describes every endpoint.
Transpareo offers a powerful API for connecting your ERP, your PIM and other systems, such as an asset administration shell built on the AAS standard. Every function you see in the Application Manager can be controlled and automated from outside. We do not know which systems you use.
So we show it in two steps with n8n, an automation platform connected to our API. In the first step, your ERP delivers product data to Transpareo. Here we simulate this with a CSV file.
The example has 66 rows. The file holds two models in four colours and seven sizes each, with their GTINs. First the products are created, in a single import.
Each row finds its record by your own number. Then the passports, created from your PIM through our API. For this, the second step of our example reads the same file again and builds a smaller CSV file from it, holding only the details for the product passports: 56 sizes with GTIN and batch number.
This step shows that several systems can feed information into individual products. A later upload could, for example, add images to existing products as soon as your photo studio has finished the shoot. Each passport is an official document.
That is why many checks run, and that takes some time. Each passport is signed twice, once by you and once by us. An import holds up to 100,000 rows.
Your system asks through our API when it is finished. The summary counts the products and passports created, changed and failed. Here, that is 66 new products and 56 passports.
In the Application Manager, both imports are listed with their numbers. Models, colours and sizes have arrived as one product tree. For each connected system, you set how many rows per minute it may upload.
Small uploads go through at once. Large ones Transpareo works through at the set pace, even when several arrive at the same time.
An import of 10,000 products takes about half an hour. Passports go through at 250 per minute. In the product overview, the two new models now stand beside your other products.
Try it yourself
Open our demo account without signing up and try every step yourself. In your own account the data is yours: try it free for eight days, no credit card.