In order to import individual quote and/or project prices for customers, a separate list with individual access for each customer is required. The preferred file format is as a CSV or TXT file divided by separators (e.g. ‘;’ , ‘,’ , ‘\t‘) with an end-of-line separator \r\n.
| Format | Details |
| CSV / TXT | The usual separators are supported. Important: if separators and line breaks occur within fields, the corresponding fields must be quoted correctly (e.g. delimitation by quotation marks, use of escape characters or doubling of quotation marks in the user text!) |
Your quote/project price list should meet the following criteria
- Field or column headings as the first line
- The list can contain manufacturer projects but also individual quotes from the supplier
- Items can appear in several quotes/projects. If the item is present more than once in a quote/project, then the field projectPosition must be set and must be different. If bundles are involved, BundleId must also be filled in as a mandatory field.
* = Mandatory fields
| Column title | Specification/description | Example |
| * Artikelnummer | Your article number (supplier article number) Note: the article number must not contain any spaces. Max. 32 characters | 2315469 |
| Lieferant Angebot/Projektnummer | Project/quote number of the supplier | AN-2022-1235/AB |
| * Hersteller Projektnummer | The manufacturer’s project number (unique key). In the case of a supplier quote, this is identical to the quote number | HPP16472342 |
| * Preis | Project price (without currency) | 1300 |
| * Menge | Remaining quota | 280 |
| Projekt/Angebots Name | Name of the project/quote | HP printer for Karlsruhe city administration |
| * Herstellername | Name of the manufacturer | HP |
| Endkunde | End customer of the project/quote | Karlsruhe city administration |
| Gültig von | Date from which the project conditions apply. Date from which the quote is valid | 31.12.2021 |
| Gültig bis | Date from which the project conditions become invalid. Date from which the quote expires | 31.12.2023 |
| Gesamtmenge | Agreed quantity within the project scope | 300 |
| Mindestbestellmenge | Minimum order quantity for this project | 10 |
| (*) Projekt Bundle Id | Unique key of the project bundle (can be activated for customers via ITscope test lab). To be set as mandatory field if the list contains bundles | 3421 |
| Projekt BundleName | Name of the project bundle (can be activated for customers via ITscope test lab) | Dell CTO 3421 |
| (*) Positionsnummer | Project line item number (can be activated for all customers via ITscope test lab). To be set as a mandatory field if the item occurs more than once in a quote/project | 1 |
Below you will find all available methods for the individual quote/project price lists:
| Method | Details |
| FTP download | The best and most secure way to include the lists. Password protection possible (recommended). Retrieval takes place in the format ftp://user:password@yourlinktotheprojectpricelist |
| HTTP download | The second way to include the lists. Password protection possible (recommended). Retrieval takes place in the format http://user:password@yourlinktotheprojectpricelist Attention: changes to your project price list can only be detected by the file date if the Last-Modified field is present in the HTTP header and is set to the file date of the project price list |