Depending on the number of products and your technical abilities, you can choose from three possibilities:
Online form: A small number of products or little corrections of the data that is already online: https://psiproductfinder.de/backend/products
Data table: A lot of products, your first import, a large update. Excel knowledge is recommended: https://psiproductfinder.de/backend/import
API interface: A large number of products that you want to enter and update in an automated way. Experience with programming is necessary: https://api-cf.psiproductfinder.de/v1/docs
You can combine these options.
For example, you can import the first set of product data with the data table and then make smaller adjustments and amendments online. For the next update, you should pull a data export (https://psiproductfinder.de/backend/export) and use this file - which contains also the information you changed online.
Alternatively, you enter a few products online and pull the data export then. This way you have your products already in the correct data structure in our table and can use this as a template for the further filling of the data table.
All three options ask for the same product data.
In order to fill out the data table or to use the API, you will also need our code list (https://cdn.psiproductfinder.de/psi-download/PSI_Codes.xlsx) for colour groups, material groups, finishing methods, product certificates, countries of production, made in and product groups.
You can also find a lot of useful tips and explanations in the other articles of our helpdesk.
Please note: The presentation of products in the Product Finder is only possible for PSI Supplier Members.
In the data table: You can enter URLs or the picture file names in the corresponding columns of the table (columns F, I, L, O, R). Each product should have at least one picture.
If you have entered the file names, you need to zip the real image files together with the data table and import the entire zip archive. The pictures and the data table should be together in one folder, without any sub-folders. If you have entered URLs you do not need to zip the file. You can just import the Excel as it is.
You can also combine both options. In this case, you only need to add the pictures of the products where you have entered the file names to the zip-archive.
Please also review the notes on product pictures, which we have compiled in the article "What are the requirements for product pictures?"
Is the number of products limited?
The number of products is not limited. You can enter as many as you like. But please remember to create variants if possible.
For example, if a product is available in several colours, the individual colours sould be displayed as variants and not as separate products.
You can find more information in the following article: What are product variants and why should I create them?
The placement of products in the Product Finder is already included in your membership, there are no additional costs on our part.
The Product Finder is a search engine for promotional products. It is made for PSI Distributors so that they can find products and get in touch with the corresponding PSI Supplier. The distributor wants to find product entries where he can see all the information he needs at a glance.
This is what you should keep in mind when creating your product entries for the Product Finder.
A good product entry contains as many information as possible. The more information you give, the better your product will be found. – And your potential customer can make an informed decision.
The most important information are:
| Product Name | The product title (name) should be descriptive and already contain the most important product attributes. The title is what makes the distributors click on your product entry. |
| Description | Enter a meaningful description of the product. What is it? What can it do? Do not just put one key word after another and use correct wording and spelling. Use different words for the product, e.g. cube and dice or boat and ship etc. Try to use different descriptions for each product (except when you create variants). |
| Tags (search words) | Use sensible keywords in the product name, the description and in the tags. |
| Pictures | A nice picture draws the interest of your potential customer and makes for more clicks. Make sure that the product and maybe its functions are well visible. The product pictures need to be jpg or png files and in RGB color mode. We recommend a size of 1400 x 1400 pixels, resolution 72 dpi. Pictures should not contain your website, e-mail address, postal address, telephone number etc. The only exception are company names that are also brand names. |
| Colors | Combine the free text in “color or color combination” with the color group. The color group ensures that your product will still be found when the search results are filtered by color. |
| Materials | With some products, it is important to know what material they are made of. Give your customers this information directly in the Product Finder! |
| Price | Give your customers an indication of what the product costs. |
| Product Groups | The product groups support the product search and can already be accessed from the homepage of the Product Finder. |
Create variants: The user, i.e. the distributor that you want to get interested in your product, does not want to see the same t-shirt 10 times in a row only because it is available in different colors. When you create variants, the distributor will find your t-shirt as well and has the possibility to look at the different colors in the product details. When you enter each t-shirt for itself, the search results will appear confusing and less attractive for the user.
You can find further information on product variants in the following articles:
What are product variants and why should I create them?
How can I show the different colors of my products in a good way?
Fill the filters in the Prouct Finder: Add color groups, material groups, certificates, countries of production, made in, finishing methods and product groups to your product entries. These make sure that your products will still be found when the distributor filters the search results e.g. for color or clicks on a product category on the Product Finder homepage.
Put yourself in your potential customer’s place. What is he searching? How is he searching? Look at your own behaviour when you are searching something online: What is important for you?
Please keep in mind: We optimize the Product Finder and its search according to the needs of the PSI Distributors who are searching for products. We want them to find the best product entries possible. Therefore, we recommend that you create an appealing entry with nice pictures and as many information as possible.
If you wish to highlight your brand or individual products in a more obvious way, the Product Finder offers several advertising possibilities.
Our media consultants will be happy to advise and help you with this.
You can find their contact data and our media guide here.
New: Now also as video tutorial: https://youtu.be/z_S67h3cjhw
Please note: The presentation of products in the Product Finder is only possible for PSI Supplier Members.
A nice picture draws the interest of your potential customer and makes for more clicks. Make sure that the product and maybe its functions are well visible.
You can show up to 5 pictures per product.
The product pictures need to be jpg or png files and in RGB color mode. We recommend a size of 1400 x 1400 pixels, resolution 72 dpi.
Pictures should not contain your website, e-mail address, postal address, telephone number etc. The only exception are company names that are also brand names.
It is also not necessary to show your contact details in the picture. They are shown in the Product Finder as well. It is best to concentrate on showing your product in the best way possible.
Important: When you use the data table, enter the picture file names in the columns “Product Picture_1“, “Product Picture_2“ etc.
The picture file names you enter in the table must be exactly the same as the actual file names. For example “pen_blue.jpg“. Please do not use special characters in the file names.
You can also enter links to your pictures(URLs) in the table instead of the image files. When using pictureURLs, please note that the pictures are stored on a server that can be accessed without password or other security measures. Dropbox links, for example, do not work.
You can also upload mixed pictures, i.e. you can specify URLs for some products and send the files for the others. In this case please create a zip archive with the table and the pictures.
If you have saved the picture files in subfolders, the name of the subfolder needs to be indicated before the name of the picture file, separated with a slash (/). For example: product_nr-1/1.jpg. In this case the name of the subfolder is “product_nr-1“ and der file name is ”1.jpg“.
With several images per product: The order in the table or in the online form corresponds to the order in the Product Finder. The first picture (Product Picture_1) will be displayed in the search results, the other pictures only on the product detail page.
If you enter your products via the online form, you can change the order of the pictures with the small arrows on the right.
New: Now also as video tutorial: https://youtu.be/B67HP4t43fQ
Please note: The presentation of products in the Product Finder is only possible for PSI Supplier Members.
If you only want to enter a few products or need to make a small update quickly, you can do this fast and easily using the online form.
Go to www.psiproductfinder.de and log in. Then click on “Account“ in the top right corner and then on “Manage product data”.
Click on ”My products“ in the navigation on the left.
There you can see all products you have online at the moment. You can update them or add new products.
Please note that the default language in the Online Form is English. Therefore, please enter always the English product data first (at least Product Number and Name) and save the entry. After saving the English entry you can click on the language field in the top right corner and add the German data.
Data like size, color group, material group etc. will be copied (these fileds are marked with a small globe icon). You just need to translate the free texts. If you want to change anything in the copied data, save the German entry and switch back to English. There you can make the changes, save it again and go back to the German version.
ATTENTION: Please save your entries before switching to the other language version. Your data will not be saved automatically!
You can find tips and advice on how to fill out the data fields by pointing your mouse cursor on the little question marks.
Please note: PSI Product Finder is only updated overnight. Changes, deletions, new products etc. will be visible the next day.
New: Now also as video tutorial: https://youtu.be/SLw99E8KtwE
Please note: The presentation of products in the Product Finder is only possible for PSI Supplier Members.
You can download an empty data table here: https://cdn.psiproductfinder.de/psi-download/PSI_Datatable.xlsx
If you already have product data online in PSI Product Finder, we recommend that you export them from the database (https://psiproductfinder.de/backend/export), edit it and then import this file again.
Please enter the data of each product in two rows (one below the other). The row with the English data needs to be marked with EN in the column “Language”, the German data with DE.
The codes for color, material etc. (https://cdn.psiproductfinder.de/psi-download/PSI_Codes.xlsx) are the same in both language versions. The Product Finder will display the corresponding translation. So it is enough to enter codes in the row for English. The same applies to the picture filenames, prices, measurements etc. The row for the German entry needs only the product number, the language marker ”DE” and the translations in the free text fields (product name, description, tags etc.).
Please put always the English version of the product first into the table and below it the German.
The content of the rows does not have to be identical, i.e. you can leave fields empty in one language that you have filled out in the other.
Important: When you use the data table, enter the picture file names in the columns “Product Picture_1“, “Product Picture_2“ etc. The picture file names you enter in the table must be exactly the same as the actual file names. For example “pen_blue.jpg“. Please do not use special characters in the file names.
Please zip your data table together with the picture files and go to https://psiproductfinder.de/backend/import. You can drag and drop the file or zip folder into the blue box or click on ”select“. Choose the file from your system and confirm it. Then you can click on “Upload” and wait until the system either asks you to confirm the import or gives you a warning/error message.
If you have referenced your product pictures as links and therefore will not import the picture files, you do not need to zip the data table. You can upload it alone.
When using picture URLs, please note that the pictures are stored on a server that can be accessed without password or other security measures. Dropbox links, for example, do not work.
You can also upload mixed pictures, i.e. you can specify URLs for some products and send the files for the others. In this case please create a zip archive with the table and the pictures.
Further information and recommendations on the product pictures can be found in the article "What are the requirements for product pictures?"
You can create your data table in XLSX, XLS or CSV format and import it here: https://psiproductfinder.de/backend/import
New: Now also as video tutorial: https://youtu.be/oWEcf53xje4
Please note: The presentation of products in the Product Finder is only possible for PSI Supplier Members.
Go to: https://psiproductfinder.de/backend/import. Here you will find everything you need to know about importing data for PSI Product Finder.
Once you have prepared your data table and, if necessary, zipped the table and pictures together in a folder, click on "To the import". On the following page, you can either drag the table/zipped folder into the blue box or click on "select" to upload the file or folder from your computer to the Product Finder system.
Then click on "Upload file", stay on the page and wait for further messages from the system.
After uploading, your table will be checked and the import prepared. Depending on the amount of data, this may take a few minutes.
Once the data table has been checked, you will either see on the screen that everything is OK and that you can confirm the data import. Only after your confirmation will the import be started and the data transferred.
Or the system shows you warnings. You can view these: The button "To error list" will show you the first 10 warnings. You can click on "Request full error report" to receive a complete list via e-mail. This report contains the affected product numbers and the fields that triggered the warning. At this point, you can either start the import despite the warnings or cancel it and optimize the data. You should optimize the data in any case. However, if you are also importing pictures, for example, it may make sense to carry out the import first, then download a data export and optimize it. This way you do not have to upload all the pictures again.
Possible warnings can be:
- The new table contains fewer products than previously shown online: Please check whether this is correct. All existing data will be deleted during the import and only what is in the new table will be imported. The table must therefore always contain all the data you want to show in the Product Finder. If you want to add or revise products, first download a Data export and use this table as a basis.
- There are fewer translations than product entries: Check that all product entries have two lines, one for EN and one for DE (column C). They must be placed one below the other for each entry.
- There are duplicate product numbers: Each product number (column B) may only be used once each for an EN and a DE entry.
- There are fewer pictures than products: Check that all products have at least one picture file name or link to a picture. These must be in column F (Product Picture_1). If you want to show more than one picture per product, their file names or links must be in columns I, L, O, R.
- Incorrect color information: The color information in column V can only be displayed in the Product Finder if the color group in column W is also specified. The color group also forms the color filter in the Product Finder. If it is not specified, the product will no longer be displayed in the search results when filtering by color. You can find the codes for the color groups in our Codelist.
- The warning applies to the columns Material Group (X), Product Certificates (Z), Country of Production (AK), Made in (AL), Finishing Method (AP, AS, AV, AY) or Product Groups (BX): Only the codes from our Codeliste may be used here. Other details are not taken into account.
- Individual fields contain too many characters: Most fields have a character limit. If this is exceeded, there is also a warning message. The contents are cut off. You can look up the character limits in the entry “Data Import: Columns, their content and field limits”.
If there is a serious error, the import is canceled. Please be sure to take a look at the error report and have the complete list sent to you. In this case, you must correct your data in any case so that the import can work.
Possible errors can be:
- The column structure of the table has been changed or the header rows are missing or have been changed: Download our Data table for comparison and compare its structure with your table. It must contain all columns and no columns may be added. The 3 header rows must be present and must not be swapped. Please leave the last three columns (BY, BZ, CA) empty or filled in as they are if you are working with a data export.
- Mandatory fields are not filled in: Mandatory fields are the Product Number (column B) and the Product Name (column D). There must always be content here. If you enter prices, the price scale fields (Amount, column BH etc.) or a price specification (Base Price for PSI Distributors or Recommended Selling Price, column BI or BJ etc.) also become mandatory fields. They are mutually dependent.
- Number fields contain letters or special characters: In general, the fields in which numbers are expected may only contain whole numbers and neither letters nor special characters. The only exceptions are the prices (columns BI, BJ etc.). Decimal numbers may of course be used here, but no currency symbol.
- Answers to questions are given as text: The columns “Is this Finishing Method included?” (AQ, AT, AW, AZ) expect a 1 if the answer is “yes”. If the answer is “no”, enter either a 0 or nothing at all. The same applies to the question “Is this product always in stock?” (column BF).
- The delivery time is not conclusive: The number in column “Minimum Delivery Time” (BD) must be lower than in column “Maximum Delivery Time” (BE). In addition, both columns must be filled if you want to make this entry.
Only after your confirmation will the data be processed and imported by the system. For security reasons, you cannot start a new data import or edit your products via the online form during this time (for at least 10 minutes).
The system will inform you if the import was successful. You can check in the My Products area whether the new or edited data is actually available. From the next day, the data will also be available in the Product Finder.
You can find tips and information on how to fill in the individual fields in the following articles:
How can I create an appealing product entry that will be well found in the Product Finder?
Which information should I enter into which field?
Data Import: Columns, their content and field limits
How can I determine whether the data import worked?
Shortly after the successful data import you can see your new products or the changes under "My products". You can find them in the Product Finder from the next day.
There is always only a message that there is an error.
This can have various causes.
Check the table structure: Have you deleted columns? Does your product data start in a row other than row 4? Have you changed the information in row 3? The easiest way is to compare your table with an original table: https://cdn.psiproductfinder.de/psi-download/PSI_Datatable.xlsx
Do all fields have the correct content? The fields in which you can enter numbers may only contain whole numbers and no letters - prices excluded. You may of course use decimal points here. Please convert the affected fields or remove measurement or currency information like mm, €, g etc.
If the data import still does not work afterwards, please send us the table to importe-productfinder@reedexpo.de so we can check it.
No, please don't!
The data import by table must always contain all products. What is not in the imported table is automatically and irretrievably deleted.
The easiest way to update your products depends on how many products you show online in the Product Finder and how much data you want to update.
If you only have a few products online or if you only need to change one small thing, you can do this fast and easily using our online form: https://psiproductfinder.de/backend/products
You can find tips and advice in the article "How can I use the online form?"
If you have many products online or need to change a lot of data, we recommend that you request an export of your data: https://psiproductfinder.de/backend/export
You can edit your product data in the export table and then easily import it again: https://psiproductfinder.de/backend/import
Please note the information in the following articles:
How can I use the data table?
How does the data import work?
No matter whether you use the online form or the data import: Currently, PSI Product Finder is only updated overnight. Your changes, deletions etc. will therefore only be online the next day.
Please note: The data import is always a FULL IMPORT! Always import a table with all products and information that you want to present in the Product Finder! Products that are not included in the table will be automatically and irretrievably deleted.
Please note: Presenting products in the Product Finder is only possible for PSI Supplier Members.
If possible, the product data (pictures and text) should not contain any direct reference to you as the supplier company. So you should not include your company name, website, e-mail address, postal address, phone number etc. in the text or pictures.
The main reason for this is the possibility to create product lists and advertising pages that can be created with the products from the Product Finder and sent by the PSI Distributor to his customers. If the product listings contain direct references to the supplier of the product, the distributor may refrain from using these listings and prefer another supplier.
Your company details and contact information are displayed by default on the product detail pages in Product Finder.
You can also enter company-specific data for color, material and finishing in the corresponding free text fields. For example special colors with your own names, color combinations, material compositions, how many colors are available for the finishing etc. Please note that only the entry of the respective groups (codes in the table, choice in the Online Form) enables the product to be found with the navigation filters. Only completing the free text fields is not enough for this.
Please note that we strongly recommend the entry of the corresponding codes in addition to the free text fields for colors, materials and finishings.
Please note that fields where you put in numbers always expect whole numbers without comma or decimal point (these values are also called ”integer“). The only exception here are the prices. These you can enter with both comma or point.
In the following, you can find a list of all data fields in PSI Product Finder. Under “content” you can find advice on the information you should give in each field.
| Column | Field name | Content |
| A | Master Product Number (to group variants) | The Master Product Number is for internal use in the database to create variants. It is not shown in PSI Product Finder. In the Online Form, it is generated automatically. In the data table, please enter a number series of your choice. To create variants, the Master Product Number has to be identical, also for the English and German version of a product. Individual products must have different Master Product Numbers. For products already online in the Product Finder, the Master Product Number has been generated automatically. Please note that this field is limited to 255 characters. |
| B | Product Number | Enter here the unique product number with which you can identify the product. Each product number may only be used once per supplier (PSI Number). Please note that this field is limited to 45 characters. |
| C | Language: EN = English, DE = German | Enter “EN“ in the row with the English product data, and “DE“ in the row with the German data. Please note that in this version of the data table, each product entry has to be in this order: first EN and then DE. |
| D | Product Name | This is the most important field in PSI Product Finder. Enter here the identifying name first. What product is it? After that, you can enter further information such as material or functions. Of course, you can also enter the special name. For example: "Ballpoint pen Alicante with twist action, made of plastic". Not just "Ballpoint Pen" or only "Alicante". Please note that this field is limited to 255 characters. |
| E | Product Description | Enter here a meaningful description of the product. What is it? What can it do? Do not just put one key word after another and use correct wording and spelling. Try to use different descriptions for each product (except when you create variants). The same content in many product descriptions may influence the ranking in a negative way. |
| F | Product Picture_1 | Enter here the exact name of the picture file including file ending (.jpg, .png) or the URL of the picture on your server. |
| G | Name of the Picture_1 | Repeat the product name in this field. This helps in the background with accessibility. |
| H | Description of the Picture_1 | Describe again shortly what can be seen in the picture. For example: "Ballpoint Pen Alicante, front view." This helps in the background with accessibility. |
| I | Picture_2 | See Product Picture_1 |
| J | Name of the Picture_2 | See Name of the Picture_1 |
| K | Description of the Picture_2 | See Description of the Picture_1 |
| L | Picture_3 | See Product Picture_1 |
| M | Name of the Picture_3 | See Name of the Picture_1 |
| N | Description of the Picture_3 | See Description of the Picture_1 |
| O | Picture_4 | See Product Picture_1 |
| P | Name of the Picture_4 | See Name of the Picture_1 |
| Q | Description of the Picture_4 | See Description of the Picture_1 |
| R | Picture_5 | See Product Picture_1 |
| S | Name of the Picture_5 | See Name of the Picture_1 |
| T | Description of the Picture_5 | See Description of the Picture_1 |
| U | Product Video URL (YouTube) | If you have saved a video of your product on YouTube, you can enter the link here. Please note the respective language versions. |
| V | Color or Color Combination | Here you can enter the color of the product, especially when it is not identical with the name of the color group. Please enter color combinations with a hyphen (-). You can also enter special colors and colors with a company-specific name. For the ideal presentation of your products, you should enter only one color or color combination per product. Please create a variant to show other colors of the same product. This field is limited to 100 characters. |
| W | Color Group | Choose here the suitable color group in which the color of your product belongs. The color group makes sure that your product is found when the customer filters the search results in PSI Product Finder for color. When your product is multi-colored, please enter the suitable color group for each color. In the data table, you separate them with a comma (,) WITHOUT space character. If your product consists of more than two colors, please use the code for "multicolored". Specify this in the field "color or color combination". If you use more than two color codes, the Product Finder will automatically display "multicolored". To prevent this and still show that your product is available in several colors, please create variants. You can find the codes for the color groups in our code list. |
| X | Material or Material Composition | Enter here the material of the product. You can indicate material compositions with a hyphen (-). Plase note that this field is limited to 100 characters. |
| Y | Material Group | Choose here the suitable material group in which the material of your product belongs. The material group makes sure that your product is found when the customer filters the search results in the Product Finder for material. When your product is composed of more than one materials, please enter one suitable material group for each material. In the data table, you separate them with a comma (,) WITHOUT space character. You can find the codes for the material groups in our code list. |
| Z | Product Certificates | Your product is certified? Very good! You can enter it here. Please consider that the indication of certificates is protected and may only be used under certain conditions. Please note that you are responsible for the correct and legally allowed use of a certificate with your product. You can enter up to 5 certificates per product. In the data table, you separate them with a comma (,) WITHOUT space character. You can find the codes for the certificates in our code list. |
| AA | Brand Name | When your product has a registered trade name, you can enter it here. You can enter more than one brand name per product. Please separate several brand names with a comma (,). Here you can also use space characters. Please note that this field is limited to 255 characters. |
| AB | EAN Code | Here you can enter the Global Trade Item Number (GTIN) of your product. |
| AC | Tags | Here you can enter key words related to your product (alternative names, singular, plural etc.). Please limit it to really suitable words. For example: A tin is just a tin. You do not have to list everything that can be put into it. The tag field is limited to 255 characters. Please separate various tags with commas (,). You do not not have to use space characters. |
| AD | Product-Specific Information | Here you can enter e.g. clothing sizes (X, M, L, etc.), memory capacities (2 GB, 4 GB, etc.), the input/output (XXX maH) etc. Please note that this field is limited to 100 characters. |
| AE | Length of the product in mm | This field allows only whole numbers without comma or decimal point and no letters (integer). Please note that this field is limited to 9 characters. |
| AF | Width of the product in mm | This field allows only whole numbers without comma or decimal point and no letters (integer). Please note that this field is limited to 9 characters. |
| AG | Height of the product in mm | This field allows only whole numbers without comma or decimal point and no letters (integer). Please note that this field is limited to 9 characters. |
| AH | Measurements of the product | Alternatively to the above scheme, you can enter here the measurements of the product (L x W x H). Please note that this field is limited to 100 characters. |
| AI | Weight of the product without packaging in gram | This field allows only whole numbers without comma or decimal point and no letters (integer). Please note that this field is limited to 9 characters. |
| AJ | Weight of the product with packaging in gram | This field allows only whole numbers without comma or decimal point and no letters (integer). Please note that this field is limited to 9 characters. |
| AK | Country of Production | Where was the product produced? You can find the codes for countries of production in our code list. |
| AL | Made in | If you want to emphasize that your product was made in Europe or Germany, you can enter this here by using the country codes from our code list.Please consider that the declaration “Made in“ is protected and may only be used under certain conditions. Please note that you are responsible for the correct and legally allowed use of this phrase with your product. |
| AM | Legal Information | Enter here the legally required information for this article, e.g. ingredients of edible articles or material compositions of textiles etc. |
| AN | Target Group | Here you can enter for whom the product is made: e.g. Ladies, Gentlemen, Unisex, Children, Babies etc. Please note that this field is limited to 100 characters. |
| AO | General information on the Finishing of this product | Here you can enter information suitable for all finishing methods available for this product. This field is limited to 255 characters. |
| AP | Finishing Method_1 | Here you can enter the finishing method for your product. The finishing method makes sure that your product is found when the customer filters the search results in the Product Finder for finishing method. You can find the codes for the finishing methods in our code list. |
| AQ | Is this Finishing Method included?_1 | Just check the box in the online tool. In the data table, please use 1 for yes and 0 for no. |
| AR | Further Finishing Information_1 | Here you can enter further information on the indicated finishing, e.g. how many printing colours are possible. Please note that This field is limited to 255 characters. |
| AS | Finishing Method_2 | See Finishing Method_1 |
| AT | Is this Finishing Method included?_2 | See Is this Finishing Method included?_1 |
| AU | Further Finishing Information_2 | See Further Finishing Information_1 |
| AV | Finishing Method_3 | See Finishing Method_1 |
| AW | Is this Finishing Method included?_3 | See Is this Finishing Method included?_1 |
| AX | Further Finishing Information_3 | See Further Finishing Information_1 |
| AY | Finishing Method_4 | See Finishing Method_1 |
| AZ | Is this Finishing Method included?_4 | See Is this Finishing Method included?_1 |
| BA | Further Finishing Information_4 | See Further Finishing Information_1 |
| BB | Minimum Order Amount | This field allows only whole numbers without comma or decimal point and no letters (integer). Please note that this field is limited to 20 characters. |
| BC | Packaging Unit | How many products are in one packaging unit? This field allows only whole numbers without comma or decimal point and no letters (integer). Please note that this field is limited to 10 characters. |
| BD | Minimum Delivery Time | Enter here the minimum delivery time of this product in days. – Only whole numbers without comma or decimal point (integer), 9 characters. |
| BE | Maximum Delivery Time | Enter here the maximum delivery time of this product in days. – Only whole numbers without comma or decimal point (integer), 9 characters. |
| BF | Is this product always in stock? | Enter 1 for “yes“ if you have this product always in stock and 0 for “no“ if it needs to be produced first. In the online tool, you can just check the box. |
| BG | Further Delivery Information | Here you can enter e.g. information on delivery time if it cannot be shown with the above pattern. This field is limited to 255 characters. |
| BH | Amount_1 | Enter here the highest limit of the price scale. – Only whole numbers without comma or decimal point (integer), 45 characters. |
| BI | Base Price for PSI Distributors excl. VAT in €_1 | The prices are shown with only two decimal places. If you import more decimal places via the data table, they are automatically rounded to two places. Please note that this field is limited to 45 characters. |
| BJ | Recommended Selling Price excl. VAT in €_1 | The prices are shown with only two decimal places. If you import more decimal places via the data table, they are automatically rounded to two places. Please note that this field is limited to 45 characters. |
| BK | Amount_2 | See Amount_1 |
| BL | Base Price for PSI Distributors excl. VAT in €_2 | See Base Price for PSI Distributors excl. VAT in €_1 |
| BM | Recommended Selling Price excl. VAT in €_2 | See Recommended Selling Price excl. VAT in €_1 |
| BN | Amount_3 | See Amount_1 |
| BO | Base Price for PSI Distributors excl. VAT in €_3 | See Base Price for PSI Distributors excl. VAT in €_1 |
| BP | Recommended Selling Price excl. VAT in €_3 | See Recommended Selling Price excl. VAT in €_1 |
| BQ | Amount_4 | See Amount_1 |
| BR | Base Price for PSI Distributors excl. VAT in €_4 | See Base Price for PSI Distributors excl. VAT in €_1 |
| BS | Recommended Selling Price excl. VAT in €_4 | See Recommended Selling Price excl. VAT in €_1 |
| BT | Amount_5 | See Amount_1 |
| BU | Base Price for PSI Distributors excl. VAT in €_5 | See Base Price for PSI Distributors excl. VAT in €_1 |
| BV | Recommended Selling Price excl. VAT in €_5 | See Recommended Selling Price excl. VAT in €_1 |
| BW | Additional Price Information | Here you can give additional information about your prices. Please note that this field is limited to 255 characters. |
| BX | Product Groups | Choose the product groups in which your product belongs. In the data table, you separate them with a comma (,) WITHOUT space character. You can find the codes for the product groups in our code list. |
| BY | Product deactivated | Systemic field in the data table, will be filled automatically. |
| BZ | Product created | Systemic field in the data table, will be filled automatically. |
| CA | Product updated | Systemic field in the data table, will be filled automatically. |
You can indicate two different prices.
The "Base Price for PSI Distributors" is the price at which the distributor can purchase the product from you.
"Recommended Selling Price" is your recommendation to the distributor for the price he should quote to his customer.
My prices are not displayed correctly. - My prices have been rounded up.
The Product Finder can only display prices with up to two decimal points.
In the online form you cannot save the product entry if you have entered more decimal points.
The data import works with several decimal points. But in the Product Finder the prices are rounded.
For better readability there are several ways to format your product descriptions in the Product Finder.
In the online form, select the relevant part of the text and click on the desired type of highlighting:
B for bold
I for italics
U for underlined
List symbol for
Line breaks and blank lines are simply created with the Enter key.
When data is exported, this formatting is included in the export file and converted again when the data is re-imported.
In the data table, insert the following HTML codes in the description:
<p> </p> for a blank line or a line break
<strong> </strong> for bold
<em> </em> for italics
<ins> </ins> for uderlined
<ul><li> </li></ul>
The formatting codes must enclose the relevant part of the text.
Please ensure that you do not use any other form of line break in your data table.
You can only specify two color groups for each product. This then means that the product is two-colored.
If your product is multicolored, please select "multicolored".
If your product is available in more than one color or color combination, please create product variants (a separate product entry for each color).
For further information and tips, please read the following article: What are product variants and why should I create them?
And - if you already have products online and want to adjust the colors: How can I subsequently combine my product entries into variants?
You can only specify two colors for each product. This then means that your product is two-colored.
The indication "multicolored" is automatically used by the system for products that contain more than two color groups.
To improve the presentation of your products - and to ensure that they can be found with the color filters - please create product variants with an individual product entry for each color.
You can find further information and tips in the following articles:
How can I subsequently combine my product entries into variants?
What are product variants and why should I create them?
If your product meets the requirements for the “Made in Germany” or “Made in Europe” label, you can easily add this information via the Product Finder backend. Go to https://psiproductfinder.de/backend/products and call up the product. In the “Details” section, you will find the option to enter “Made In”. Select the relevant country and save the product entry. If you have selected a European country, your product will automatically be assigned to the Made in Europe filter.
If you want to make the addition for several products, or if there are a lot of products in your list in the backend, it may be easier to download a data export: https://psiproductfinder.de/backend/export
In the exported table, you can enter the corresponding information in column AL. You can find the codes for the individual countries in our code list: https://cdn.psiproductfinder.de/psi-download/PSI_Codes.xlsx
You can then import the edited table again in the backend: https://psiproductfinder.de/backend/import
In both cases, the products will be available under the Made In filter from the next day.
Please note: There are clear guidelines as to when a product may be labeled as “Made in Germany”, for example. We therefore recommend that you obtain precise information before making such claims. Otherwise you could be in breach of legal regulations - PSI accepts no liability for this.
Please note: The presentation of products in the Product Finder is only possible for PSI Supplier Members.
In the following you will find a list of all fields in our online form. Under "Content" you will find the content expected by the database and under "Field Limit" the maximum number of characters this field may contain including spaces.
If the wrong content was entered in a field (e.g. a number field contains text, a code field contains text, etc.) or if a field contains too many characters, this can cause the data import to abort.
| Field Name | Content | Field Limit |
| Product Number | Letters and numbers | 45 |
| Product Name | Letters and numbers | 255 |
| Product Description | Letters and numbers | 65535 |
| Product Picture | Upload the picture file name or enter the URL | |
| Name of the Picture | Letters and numbers | 255 |
| Description of the Picture | Letters and numbers | 510 |
| Product Video URL (YouTube) | URL to a product video on YouTube | |
| Color or Color Combination | Letters and numbers | 100 |
| Color Group | Choose up to two colours | |
| Material or Material Composition | Letters and numbers | 100 |
| Material Group | Choose from the list | |
| Product Certificates | Choose from the list | |
| Brand Name | Letters and numbers | 255 |
| EAN Code | Letters and numbers | 255 |
| Tags | Letters and numbers | 255 |
| Product-Specific Information | Letters and numbers | 100 |
| Length of the product in mm | Only whole numbers | 9 |
| Width of the product in mm | Only whole numbers | 9 |
| Height of the product in mm | Only whole numbers | 9 |
| Measurements of the product | Letters and numbers | 100 |
| Weight of the product without packaging in gram | Only whole numbers | 9 |
| Weight of the product with packaging in gram | Only whole numbers | 9 |
| Country of Production | Choose from the list | |
| Made in | Choose from the list | |
| Legal Information | Letters and numbers | 65535 |
| Target Group | Letters and numbers | 100 |
| General information on the Finishing of this product | Letters and numbers | 255 |
| Finishing Method | Choose from the list | |
| Is this Finishing Method included? | Check the box if Yes | |
| Further Finishing Information | Letters and numbers | 255 |
| Minimum Order Amount | Only whole numbers | 20 |
| Packaging Unit | Only whole numbers | 10 |
| Minimum Delivery Time | Only whole numbers | 9 |
| Maximum Delivery Time | Only whole numbers | 9 |
| Is this product always in stock? | Check the box if Yes | |
| Further Delivery Information | Letters and numbers | 255 |
| Amount | Only whole numbers | 45 |
| Base Price for PSI Distributors excl. VAT in € | Only numbers, max. two decimal points | 45 |
| Recommended Selling Price excl. VAT in € | Only numbers, max. two decimal points | 45 |
| Additional Price Information | Letters and numbers | 255 |
| Product Groups | Choose from the list |
Please note: The presentation of products in the Product Finder is only possible for PSI Supplier Members.
In the following you will find a list of all columns of our data table. Under "Content" you will find the content expected by the database and under "Field Limit" the maximum number of characters this field may contain including spaces.
| Column | Field name | Content | Field limit |
| A | Master Product Number (to group variants) | Letters and numbers | 255 |
| B | Product Number | Letters and numbers | 45 |
| C | Language: EN = English, DE = German | DE or EN | 2 |
| D | Product Name | Letters and numbers | 255 |
| E | Product Description | Letters and numbers | 65535 |
| F | Product Picture_1 | Picture file name or URL | |
| G | Name of the Picture_1 | Letters and numbers | 255 |
| H | Description of the Picture_1 | Letters and numbers | 510 |
| I | Picture_2 | Picture file name or URL | |
| J | Name of the Picture_2 | Letters and numbers | 255 |
| K | Description of the Picture_2 | Letters and numbers | 510 |
| L | Picture_3 | Picture file name or URL | |
| M | Name of the Picture_3 | Letters and numbers | 255 |
| N | Description of the Picture_3 | Letters and numbers | 510 |
| O | Picture_4 | Picture file name or URL | |
| P | Name of the Picture_4 | Letters and numbers | 255 |
| Q | Description of the Picture_4 | Letters and numbers | 510 |
| R | Picture_5 | Picture file name or URL | |
| S | Name of the Picture_5 | Letters and numbers | 255 |
| T | Description of the Picture_5 | Letters and numbers | 510 |
| U | Color or Color Combination | Letters and numbers | 100 |
| V | Color Group | Code, only two are possible! Separated with comma, without blank space | |
| W | Material or Material Composition | Letters and numbers | 100 |
| X | Material Group | Code, separated with comma, without blank space | |
| Y | Product Certificates | Code, separated with comma, without blank space | |
| Z | Brand Name | Letters and numbers | 255 |
| AA | EAN Code | Letters and numbers | 255 |
| AB | Tags | Letters and numbers | 255 |
| AC | Product-Specific Information | Letters and numbers | 100 |
| AD | Length of the product in mm | Only whole numbers | 9 |
| AE | Width of the product in mm | Only whole numbers | 9 |
| AF | Height of the product in mm | Only whole numbers | 9 |
| AG | Measurements of the product | Letters and numbers | 100 |
| AH | Weight of the product without packaging in gram | Only whole numbers | 9 |
| AI | Weight of the product with packaging in gram | Only whole numbers | 9 |
| AJ | Country of Production | Code | |
| AK | Made in | Code | |
| AL | Legal Information | Letters and numbers | 65535 |
| AM | Target Group | Letters and numbers | 100 |
| AN | General information on the Finishing of this product | Letters and numbers | 255 |
| AO | Finishing Method_1 | Code, only one possible | |
| AP | Is this Finishing Method included?_1 | 1 for Yes, 0 for No | 1 |
| AQ | Further Finishing Information_1 | Letters and numbers | 255 |
| AR | Finishing Method_2 | Code, only one possible | |
| AS | Is this Finishing Method included?_2 | 1 for Yes, 0 for No | 1 |
| AT | Further Finishing Information_2 | Letters and numbers | 255 |
| AU | Finishing Method_3 | Code, only one possible | |
| AV | Is this Finishing Method included?_3 | 1 for Yes, 0 for No | 1 |
| AW | Further Finishing Information_3 | Letters and numbers | 255 |
| AX | Finishing Method_4 | Code, only one possible | |
| AY | Is this Finishing Method included?_4 | 1 for Yes, 0 for No | 1 |
| AZ | Further Finishing Information_4 | Letters and numbers | 255 |
| BA | Minimum Order Amount | Only whole numbers | 20 |
| BB | Packaging Unit | Only whole numbers | 10 |
| BC | Minimum Delivery Time | Only whole numbers | 9 |
| BD | Maximum Delivery Time | Only whole numbers | 9 |
| BE | Is this product always in stock? | 1 for Yes, 0 for No | 1 |
| BF | Further Delivery Information | Letters and numbers | 255 |
| BG | Amount_1 | Only whole numbers | 45 |
| BH | Base Price for PSI Distributors excl. VAT in €_1 | Only numbers, max. two decimal points | 45 |
| BI | Recommended Selling Price excl. VAT in €_1 | Only numbers, max. two decimal points | 45 |
| BJ | Amount_2 | Only whole numbers | 45 |
| BK | Base Price for PSI Distributors excl. VAT in €_2 | Only numbers, max. two decimal points | 45 |
| BL | Recommended Selling Price excl. VAT in €_2 | Only numbers, max. two decimal points | 45 |
| BM | Amount_3 | Only whole numbers | 45 |
| BN | Base Price for PSI Distributors excl. VAT in €_3 | Only numbers, max. two decimal points | 45 |
| BO | Recommended Selling Price excl. VAT in €_3 | Only numbers, max. two decimal points | 45 |
| BP | Amount_4 | Only whole numbers | 45 |
| BQ | Base Price for PSI Distributors excl. VAT in €_4 | Only numbers, max. two decimal points | 45 |
| BR | Recommended Selling Price excl. VAT in €_4 | Only numbers, max. two decimal points | 45 |
| BS | Amount_5 | Only whole numbers | 45 |
| BT | Base Price for PSI Distributors excl. VAT in €_5 | Only numbers, max. two decimal points | 45 |
| BU | Recommended Selling Price excl. VAT in €_5 | Only numbers, max. two decimal points | 45 |
| BV | Additional Price Information | Letters and numbers | 255 |
| BW | Product Groups | Code, separated with comma, without blank space | |
| BX | Product deactivated | Systemic field, will be filled automatically | |
| BY | Product created | Systemic field, will be filled automatically | |
| BZ | Product updated | Systemic field, will be filled automatically |
A variant is for example the second, third, fourth … color of the t-shirt. This means product entries that differ only in the color without changing the price.
Create a variant for each color in order to achieve the best presentation of your products in the Product Finder. Many individual product entries with almost identical content can lead to these products being devalued in the Product Finder ranking.
At the moment, only color groups are shown as variants.
Variants give better order to the search results and make your product entries look more professional. The distributor does not want to see the same t-shirt 10 times in different colors. When he clicks on the product detail page, he will see the different colors and can click on them in order to see the product in the corresponding color – if you have uploaded a picture for each color.
In the data table (https://cdn.psiproductfinder.de/psi-download/PSI_Datatable.xlsx), please enter each product with its own product number and color group (keep in mind: one row English, one row German).
Additionally, a Master Product Number is needed for all products.
For products that are already online in PSI Product Finder, the Master Product Number is generated automatically. If you create new variants, please enter the master numbers in the "Master Product Number" column (A). It can be any number or letter-combination. The most important thing is that they are identical for the products you wish to combine. Master Product Numbers are for internal use in the database to create variants. They do not appear in the Product Finder.
In the online form (https://psiproductfinder.de/backend/products), you simply click on the product you wish to create a variant of and then on “New Variant”. The Master Product Number will be generated automatically.
Please note: For variants, you need to enter the English data first as well. After saving the entry you can also enter the German data.
Note: In the current version of the online form, you must re-enter all product information when creating a variant. There is no copy function yet. We therefore recommend that you maintain the variants using the table. Here you can copy and paste more easily.
New: Now also as video tutorial: https://youtu.be/QmT9WnLF7-g
Please note: The presentation of products in the Product Finder is only possible for PSI Supplier Members.
The best way: As product variants!
Create a variant for every color in which your product is available.
You can look up how to create variants in the article "What are product variants and why should I create them?"
Please note: You can only enter two colors per product entry. These two colors will be shown as color combinations in the Product Finder. If your product has more than two colors, please choose “multi-colored”. If you enter three colors or more (as codes in the table or by clicking on them in the online form), they will be automatically merged to multi-colored.
We recommend that you fill out the column/the field „color or color combination“ as well. The text you enter there appears on the product detail page when the customer puts the mouse indicator on the color button. This way, you can - for example - specify the color combination of more than two colors, use your own color names or show the available colors of custom-made products.
You can also show various possibities of the same basic color:
Example: You enter the color ”yellow“ as code in the table or click on it in the online form. Then you enter ”sunny yellow“ in the field ”color or color combination“. In the next variant of the product you enter “yellow” again as basic color an then add “luminous yellow” as free text etc.
This way, there will be a yellow color button for each of your yellows on the product detail page. When the customer puts the mouse indicator on these buttons, he can see the different kinds of yellow you have entered. And if you did upload different pictures for each variant as well, you have done a really good job with your product variants. Because the pictures change when the customer clicks on the color buttons.
Have you filled in column A? The master number is necessary for the system to know which products to group together.
The simplest solution is here: Pull a data export (https://psiproductfinder.de/backend/export) and enter the same sequence of numbers and/or letters for all products that are to be combined into a variant in column A. It does not matter what this sequence of numbers/letters looks like. But is is important that it is identical for all variants.
Import the updated data table again (https://psiproductfinder.de/backend/import).
When your product is available in different colors, you should group your product entries by color.
Download an export of your online product data: https://psiproductfinder.de/backend/export
Copy the exported file and save it as security backup.
Open the table and sort the product data in such a way that the same products (i.e. those products that differ only in color) are placed one below the other. Usually this can be done quickly by sorting by the product number in column B. Please note here as before that each product number has two lines: EN and DE (column C).
Now enter the same number- and/or letter combination in column A (master number) for all products you wish to combine. You can use any combination of numbers and/or letters, or simply one of those automatically entered by the system.
Since the product variants differ in color, check now in column V (color group) that each product entry has the code for the corresponding color. You can make the color specification more precise with your own short text in column U (color or color combination). This text is displayed in the Product Finder when you point the mouse at the corresponding color circle.
You should also upload a separate picture for each color, if you have not already done so.
Save the edited data table and import it here: https://psiproductfinder.de/backend/import
From the next day your products should be displayed as variants.
Please note: The presentation of products in the Product Finder is only possible for PSI Supplier Members.
Please note: The presentation of products in the Product Finder is only possible for PSI Supplier Members.
In general, you should always create product variants whenever possible. Especially if your product is available in different colours.
However, if the display of the variants is not as you imagined it, for example, because the prices of your variants change, you can undo the variant creation.
Pull an export of your online product data: https://psiproductfinder.de/backend/export
Copy the export file and save it as a backup copy.
Open the table and select the products for which you want to undo the variant creation. Now delete the contents in column A (master number) for these products. Please delete only the contents, not the column.
Please note that each product number has two lines: EN and DE (column C).
Save the edited data table and import it here: https://psiproductfinder.de/backend/import
From the next day on, your products should be displayed individually, not as variants.
If you want to make a large update of the data you have already online, you can export this data in our data table format, use this table directly for your revision and editing and then import it again.
The advantage is that all pictures are already included in the table as URLs. So if you do not want to exchange the pictures, it is sufficient to import the table again. If you want to exchange pictures, you must of course enter the new picture file names or URLs into the table and import the new pictures zipped together with the data table.
You can trigger the export here: https://psiproductfinder.de/backend/export
Click on "Start Data Export" and select the format of the export file: XLSX, XLS or CSV.
Shortly after you will receive an e-mail with a link where you can download the data export in a zip archive. If you do not receive this e-mail within a few minutes, please check your security systems (spam, junk etc.).
New: Now also as video tutorial: https://youtu.be/DAdNX5Yj31c
Please note: The presentation of products in the Product Finder is only possible for PSI Supplier Members.
Of course, you can also completely remove products from PSI Product Finder.
You have two possibilities:
With the Data Table
The best way is to download an export of the online data and simply delete the rows (EN and DE) of the product and/or variant numbers and re-import the data table. All data that is no longer in the table is automatically deleted and will no longer be online in the Product Finder from the next day.
With the online form
In the product overview: Click on the product or variant you wish to delete. Then click on DELETE at the bottom left.
The system asks you whether you want to delete the entire product entry, i.e. all variants, only the variant clicked on or only the translation of this variant. You click on the corresponding variant and then click on "DELETE" again.
The product or variant will no longer be found in the Product Finder from the next day.
All data
If you want to delete all your data from the Product Finder, simply import an empty data table (https://cdn.psiproductfinder.de/psi-download/PSI_Datatable.xlsx). From the next day your products are gone and you can enter them again.
However, we recommend this method only in absolutely exceptional cases. If you think about it, please contact us. We will be happy to advise you on alternative approaches: importe-productfinder@reedexpo.de, +49 211 90191-721
Please note: The presentation of products in the Product Finder is only possible for PSI Supplier Members.
Online form: I can only enter my data in English. - The system only allows English entries. - How can I enter my German data? - There is an error: I can only enter English. - I cannot select German.
This is not an error. The system is designed in such a way that the data for the English Product Finder has to be entered first and only then, after saving the English data, the data for the German version can be entered.
So please fill out the form for the English product data entry first. After saving, you can change the language from EN to DE (German) in the top right corner.
In the template for the German product data entry, you only have to fill in the fields in which you have entered text. All numbers, pictures and answers from the selection menus are automatically transferred to the German version of the Product Finder.
The data table always requires two rows per product. One row for the English product entry and one for the German one.
An import with only the DE rows will not work. The system will report an error in the table.
Importing only with the EN rows means that your products will only appear in the English Product Finder.
Below we describe how you can add a second language fast and easily.
If you currently only have English data in the Product Finder
Now you should have a table in which two rows below each other always contain the same information in column B, with "EN" in column C at the top and "DE" underneath.
Save the edited data table and import it (possibly zipped together with the product pictures) here: https://psiproductfinder.de/backend/import
From the next day your products should be displayed in both language versions of the Product Finder.
You can also use this procedure if, for example, you export the product data from your product database and insert it into our table.
Please make sure that you insert your product data exactly in our table format (https://cdn.psiproductfinder.de/psi-download/PSI_Datatable.xlsx). The column structure must be retained, as must the first three rows of the table. The product data may therefore only start in row 4.
Insert the English and German product data one below the other in the table.
Then use the Excel sorting function. You must have the sorting carried out on two levels. First according to the product number in column B and then according to the language in column C. Here you must choose that the information should be sorted in descending order, i.e. from Z to A.
Now you should have a table in which two rows below each other always contain the same information in column B, with "EN" in column C at the top and "DE" underneath.
Save the data table and import it (possibly zipped together with the product pictures) here: https://psiproductfinder.de/backend/import
From the next day your products should be displayed in the Product Finder.
The product lists are extended watch lists that you can use to create your own advertising pages (landingpages) which you can send to your customers as links.
You can create as many as you like in the backend.
For you as a Supplier Member, this function is interesting, for example, to send information about your product innovations to your distributors.
You can also create product lists that are displayed in your Supplier Finder profile.
To create a product list, click on "Account" in the top right-hand corner of the Product Finder and then on "Product list".
This will take you to the backend for the product lists. Then click on "New list" and select whether you want to create a German-language or English-language product list. The product entries will be displayed accordingly on the advertising page.
Upload a beautiful picture as a key visual and fill in the fields for the internal designation, headline, etc.
You can also enter an individual introductory text for your customers.
If you would like to display this product list in your Supplier Finder profile, please tick the box "Show this product list on your profile in PSI Supplier Finder?”.
If you want to show the products of this product lists as a highlight gallery in your Supplier Finder profile, tick the box "Show the products from this list as picture slider on your profile in PSI Supplier Finder?".
After saving, you can fill the product list. To do this, click on "Add product to list" to access the Product Finder and search for products for your product list.
Once you have found one, either click directly on "Add to product list" in the overview or look at the details first and then click on it in the product details page.
You can also spontaneously create new product lists here.
When you have all the products you want on the product list, go back to the backend and click on "To landingpage" at the top right corner. Your own advertising page will open. If you have previously uploaded your company logo under MyPSI, it will be displayed on the landingpage, as will your company name, key visual, headline and introductory text. - And of course the products!
You can now send the link to your advertising page to your customers. And your customer can send requests for quotes directly to you from the page.
New: Now also as video tutorial: https://youtu.be/tNHThAeDtPU
The Message System is an extension in PSI Product Finder for easy management of quotation and product enquiries.
If a distributor finds an interesting product in the Product Finder, he can request an offer from the corresponding supplier directly from the Finder. The supplier is notified by e-mail about the receipt of the request, can view it directly in the backend and answer it.
All communication between distributor and supplier can therefore take place directly in the Product Finder. If both parties are online at the same time, even as a chat in real time.
Of course, images and PDF files can also be sent via the Message System.
In this way, the distributor keeps track of the requests for quotations and products he has made. And the supplier can see directly who has requested which product from him.
Various marking options and a filter function provide even more clarity.
The Message System can be processed by several people in a company at the same time, it is currently not bound to individual access data.
The Message Center allows PSI Members to communicate via chat. For example, Distributor Members can send quotation requests, which the Supplier Members can answer directly in the system, including attachments.
When a message is sent, the recipient company receives an e-mail with the information that there is a new message in the Message Center and the link to it.
There is a possibility to add additional recipients for these information mails.
The only requirement is that the recipient has access data to the Product Finder (these can be created in the MyPSI area on www.psi-network.de).
Global recipient list in own account, for incoming messages
cc recipient list, for outgoing messages
If you have any questions or comments, please do not hesitate to contact the PSI Product Finder team at any time: importe-productfinder@reedexpo.de and +49 211 90191-721
Please note: The use of the Product Finder and all its functions is exclusive for PSI Members.
The Product Finder is a product search engine in which PSI Distributors can find products from PSI Suppliers, obtain information about them and then contact the suppliers. Distributors want to find attractive product entries where they can see the most important information about the product at first glance.
And it is precisely these criteria that should be the most important when creating product entries.
You can read how to create an attractive product entry that is easy to find in the Product Finder in the following article: How can I create an appealing product entry that will be well found in the Product Finder?
If you would also like to highlight your brand or individual products, the Product Finder offers you a wide range of options for highlighting and advertising.
Our media consultants will be happy to assist you with this.
You can find their contact information and the current media guide here.
Please note: Placing products in the Product Finder is only possible for PSI Supplier Members.
If you wish to highlight your brand or individual products, the Product Finder offers you a wide range of options for highlighting and advertising.
Our media consultants will be happy to assist you with this.
You can find their contact information and the current media guide here.
Please note: Placing products in the Product Finder is only possible for PSI Supplier Members.
There are several reasons why the import of the pictures did not work. Please check the following points:
1. The zip was too big - it must not exceed 500 MB.
2. The picture files were too large. Even if the zip is smaller than 500 MB, too large picture files can cause difficulties. We recommend 1400 x 1400 pixels, 72 dpi.
3. The picture files are in the wrong format. They must be .jpg or .png files, in RGB colour mode.
4. The picture file names do not match those in the table. They must be identical, including the file extension (.jpg or .png).
5. The picture file names are in the wrong column. Please use the columns F (Product Picture_1), I (Picture_2) etc., not for example "Name of the Picture_1" etc.
6. The pictures are in one or more subfolders. In this case, the name of the subfolder must precede the respective picture file name, separated with a /. It is easier and safer if the pictures and the table are on one level in the zip.
If none of the points apply, please send us the table and one or two of your picture files by e-mail to importe-productfinder@reedexpo.de so that we can take a closer look.
Please check the following points:
1. The picture files are too large. Picture files that are too large can also cause difficulties when being uploaded individually. We recommend 1400 x 1400 pixels, 72 dpi.
2. The picture files are in the wrong format. They must be .jpg or .png files, in RGB colour mode.
3. Some of the pictures are only displayed after saving. So please try again: Upload the picture and then click on Submit. If necessary, reload the website.
4. Perhaps the motif is too narrow? For example, if knives or ballpoint pens are shown upright and there is no frame around them, you may get a message when uploading that the picture has the wrong dimensions. In this case it helps if you put a white frame around the motif.
If none of the points apply, please send us one or two of your picture files by e-mail to importe-productfinder@reedexpo.de so that we can take a closer look.
If you want to import a large number of products and pictures, your zip archive may be larger than 500 MB. In this case, please first check whether you can reduce the size of your picture files.
For the Product Finder, a size of 1400 x 1400 pixels at a resolution of 72 dpi is sufficient.
If your picture files are already "small", you can use the following workaround. Unfortunately, this is a little more time-consuming, but it is currently the only non-technical option:
Alternatives to this workaround:
If you have saved the product pictures on a freely accessible server, you can also enter the links to these files in the table instead of the picture file names. It is important that the server is not password protected. Links to WeTransfer, Dropbox etc. unfortunately do not work here.
You can also use our API interface (https://api-cf.psiproductfinder.de/v1/docs). However, this requires programming knowledge on your part.
Did you enter the picture file names into the columns F (Product Picture_1), I (Picture_2) etc.?
Have you imported the pictures together with the table in a zip archive?
If so, please check the following options:
Does the new picture have a different file name or the same as the old one?
If it is the same, please change it and reload the picture (zipped with the table or in the online form).
If the picture file names are identical, the system will not recognize that it is a new picture.
Newly entered/imported products, changes and deletions are always imported into the online database overnight.
Therefore, any changes you have made (new, modified or deleted products) will only be seen from the next day.
However, if you have made changes to the information displayed on the datail page (e.g. description, color, size, prices etc.), they will be shown immediately.
If your new product or changes are not online the next day, please contact us at importe-productfinder@reedexpo.de.
If the data import takes an unusually long time, your zip archive may be too large. Please note that the Zip must not be larger than 500 MB.
To reduce the size of the Zip, check the picture files. They do not have to be of print quality. It is sufficient if they have 1400x1400 pixels and 72 dpi.
If you have reduced the size of the pictures and the zip is still too large please use the workaround described in the article "My picture files are small, my zip is still too big".
If your products are not in the English Product Finder: Is it possible that you have not made any English (EN) product entries in the table?
The system needs these to be able to create a product entry at all.
If your products are not in the German Product Finder: If you wish your products to be in the German Product Finder as well, you need to enter the German (DE) product data into the table.
You can find an explanation on how you can do this fast and easily in the article "How can I add the second language to the data table?"
You can find further information in the following articles:
I only get the data from my system separately in German and English. How can I connect the entries in the table?
Online form: How can I enter German product data?
Have you specified product groups in your product data entries? If so, please check that you have selected the appropriate ones and used the correct codes if you are using the data table.
If you have not indicated any product groups, please complete them. You can do this using the online form (https://psiproductfinder.de/backend/products) or the data table.
The easiest way to do this is to use a data export (https://psiproductfinder.de/backend/export), complete the product groups using our code list (https://cdn.psiproductfinder.de/psi-download/PSI_Codes.xlsx) and import the table again (https://psiproductfinder.de/backend/import).
One reason why products do not go online is that the character limits have been exceeded in one or more fields.
This is most often the case with the field "Product-Specific Information". This field is limited to 100 characters. Please check your product entry and adapt it if necessary.
A list of all field limitations can be found in the article "Online Form: Fields, their content and field limits".
If the reason is not within the field limitations, please contact us (importe-productfinder@reedexpo.de) so that we can check the product more closely.
The PSI Product Finder Team will be happy to help you with any questions.
Please do not hesitate to contact us via e-mail (importe-productfinder@reedexpo.de) or phone: +49 211 90191-721.