eSagu RePricing for Kaufland "CSV-file format"
With our CSV-data, you can access your data record quickly and effectively. You can update your prices on eSagu and Kaufland simultaneously.
Click on "CSV FILES" option in the menu (on the left) to customize your CSV-template.
E.g. You can create a template named "price rules" with the columns ESAGU_ITEM_ID, MIN_PRICE and MAX_PRICE.
We recommend you use the freeware OpenOffice / LibreOffice for editing the CSV-files. Select Encoding: UTF8 and Delimiter: semicolon. Ensure that you save the prices with two decimal places. You can use a comma(12,34), point (12.34) or no separator (1234).
If you edit your CSV-File on Microsoft Excel, ensure that all columns are formatted as "text". Otherwise, the following errors might occur:
ESAGU_ITEM_ID "0110" Microsoft Excel omits the leading zero which creates a new, unrecognizable ESAGU_ITEM_ID number "110".
A price of 10.10 could be interpreted by Excel as a date like "10th Oct.".
Below you will find a table with all selectable columns and their description.
You can email us any time on support@esagu.eu if you have any questions concerning the CSV files and if you need help editing them.
Editable columns
| Column | Description | |
|---|---|---|
| ID_OFFER | The ID_OFFER is a numeric identifier assigned by Kaufland to the current listing. It is used to uniquely identify your offer. Important: ID_OFFER is mandatory. |
Editable columns
| Column | Description |
|---|---|
| MIN_PRICE | The minimum price defines the lower boundary below which eSagu RePricing cannot and will not set your sales price, regardless of any competitor’s pricing. You decide the minimum amount at which you want to sell your products. Important: For optimization to work, the fixed price must lie within the minimum and maximum price. The minimum price must include two decimal places. |
| MAX_PRICE | The maximum price defines the upper boundary above which eSagu RePricing cannot and will not set your sales price, regardless of any competitor’s pricing. You decide the maximum amount at which you want to sell your products. Important: For optimization to work, the fixed price must lie within the minimum and maximum price. The maximum price must include two decimal places. |
| FIXED_PRICE | A fixed price bypasses optimization; products are offered at the predefined fixed price. Important: To offer products at a fixed price, it must lie within the minimum and maximum price. The fixed price must include two decimal places. |
| STRATEGY | The strategy defines how a price-optimization process is composed. A strategy can consist of multiple components, such as one or more price-distance rules, one or more exceptions, as well as additional settings that allow the optimization process to be customized. |
Info columns
| Column | Description |
|---|---|
| ESAGU_ITEM_ID | The ESAGU_ITEM_ID is an identifier assigned by eSagu. It standardizes and simplifies different identifiers. |
| ID_PRODUCT | “ID_PRODUCT” is the unique product identifier on Kaufland. |
| ID_UNIT | “ID_UNIT” refers to a specific unit of your offer in the inventory, meaning a unit you created on the marketplace. |
| TITLE | Your product name for a specific product. The title is not used by eSagu or Kaufland for identification. |
| AMOUNT | “Amount” provides the current information about the initial quantity for the respective product. |
| LISTING_PRICE | The “listing price” is the current price at which the product is listed on Otto. It can be used to automate the setting of your minimum and maximum prices. |
Common errors
| Error | Description |
|---|---|
| Number formatting not clear | When you get this error you need to check your min, max and fixed prices. The prices need to be formatted by number and double decimal. Another reason could be the delimiter of your CSV file. The CSV file separator of eSagu is a semicolon! |
| Double Item IDs/SKUs found | Since Item IDs/SKUs is our identifier for the products. You cannot upload a file with the same Item ID/SKU listed more than once. In order to remove the duplicates in Microsoft Excel follow the steps: Select the SKUs column (for ex: Coulmn A) From the Home Menue, click on Conditional formatting > Highlight cell Rules > Duplicate Values and select OK on the dialog box. This was any Item IDs/SKUs that are duplicates will be highlighted, and you can easily remove them or change them accordingly. |
| File is corrupted | If this error occurs, that means that some of the column’s title is not in accordance with the eSagu CSV Format. |
| Skipped | If you upload the same file two or more times, eSagu will skip the upload. Therefore, make sure that the content of the file is different from the content of the previous upload. |
| No Item ID found | If there are Item IDs in the file that are unknown to our system, this error may occur. This can happen e.g. an inactive listing. However, the system will update prices for all other active products. |
| Download error | We could not download your CSV file. Is the URL correct, please check once in your browser. If authentication is used, are the username and password are present in the URL? * Are our servers triggered a bot protection when downloading? |
Please note, eSagu does not take any responsibility for any incorrect, inaccurate or incomplete information/data received from Kaufland.
Example CSV files
Here are a few sample files that might be helpful to you: