Import price updates via Excel file
Questions:
- How can I import a supplier file?
Description:
Have you received a new price list from your supplier and want to enter it into TYRIOS quickly? No problem!
In this article, we'll show you how to update sales prices via bulk import - simply using the EAN or the article ID.
What is this import for?
This process is your best friend if you need to make price changes (e.g. annual price adjustments by a manufacturer).
Your advantages:
-
No manual searching: You don't have to search out your internal item IDs. The EAN (barcode) from the supplier list is sufficient.
-
Clean data: Thanks to a special setting, we prevent new, incomplete articles from being created by mistake. Only existing items are updated.
-
Simplicity: You only need a very simple CSV or Excel file with a few columns.
Solution:
Step 1: Prepare the CSV file
Use the standard product importer for the price update. You have two options for how TYRIOS should recognise your articles in the file:
Option A: Matching via the EAN (ideal for supplier lists) This is the most common case. So that TYRIOS knows that you are searching by EAN, you need an Identification key column that contains the value "EAN" in each row.
Required columns:
-
Identification key (value must be EAN)
-
EAN (The barcode of the item)
-
Net sales price (Your new net sales price)
-
Update only (Important: Must be set to 1)
Your table should look like this:
Identifikationskey;EAN;Netto-VK;Nur Update EAN;4012345678901;19.99;1 EAN;4012345678902;24.50;1
Option B: Synchronisation via the article ID If you already have your internal TYRIOS IDs to hand, you do not need the identification key. The system automatically accepts the ID if it is missing.
Required columns:
-
Article ID
-
Net sales price
-
Update only (must be set to 1)
Your table should look like this:
Item-ID;Net-Sales;Update only 12345;19.99;1 67890;24.50;1
Step 2: Import file
-
Go to the article overview in your TYRIOS interface and select the standard product importer for the import.
-
Upload your prepared CSV file. Alternatively, you can also import the file in Excel format
-
Make sure that the separator (usually semicolon ;) and the encoding (usually UTF-8) are set correctly when you process it as a CSV.
-
Start the import.
Step 3: Quick check
After the import, take a random look at 2-3 items to make sure that the new net sales have been transferred correctly.
Tips and Tricks:
-
Why is the "Update only" column so important? By entering a 1 everywhere here, you are telling the system: "Only change items that you know. If you can't find an EAN, ignore it." Without this setting, TYRIOS would try to create unknown EANs as new (and often empty) articles.
-
One thing at a time: Please do not mix EANs and article IDs in a single file. Decide on one way for each file (option A or option B). This avoids errors when assigning.
-
No unnecessary columns: You don't need any product names, descriptions or stocks in this file. The 3 to 4 columns mentioned above are completely sufficient for the pure price update. Less data means fewer sources of error! The standard importer only overwrites values that it finds in the new file. All other values remain unchanged.