eSagu Cdiscount RePricing "CSV-file format"

With our CSV-data you can access your data record quickly and effectively. You can update your prices on eSagu and Cdiscount simultaneously.

Click on "CSV FILES" option in the menu (on the left) to customize your CSV-template.

Eg. You can create a template named "price rules" with the columns SELLER_PRODUCT_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).

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
EAN “European Article Number” a individual article number for products.
MIN_PRICE The minimum price is the lowest-price limit, under which eSagu will not put your sales price. Regardless of the price, the competitor has. Therefore, it is up to you to decide on the lowest price that you would like to sell your items for.
Important: For optimization, the fixed price must be between the minimum price and the maximum price. The minimum price has to have two decimal places.
MAX_PRICE The highest price over which eSagu cannot/ will not put your sales price. Regardless of the price the competitor. Therefore, it is up to you to decide on the highest price that you would like to sell your items for.
Important: For optimization, the fixed price must be between the minimum price and the maximum price. The minimum price has to have two decimal places.
FIXED_PRICE The Optimization is omitted for the items with a fixed price.
Important: For optimization, the fixed price must be between the minimum price and the maximum price. The minimum price has to have two decimal places.
PRICE_MODE The price mode decides how your items behave during the optimization. Here you have several possibilities:
OPTIMIZATION – Selected items will be optimized based on the competitors information and the minimum prices and maximum prices determined by you.
FIXED_PRICE – Selected items are offered at your predetermined fixed price.
DISABLED – Selected items will be marked with the status "Deactivated". There will be no price adjustment on these items.
CUSTOM_CODE – Selected items will be optimized with the "CustomCode" function. The minimum prices and maximum prices will be used for it.
PRICE_GAPS_NAME The selected "price gaps name" is the strategy that the optimization should follow. Here you can choose to go lower, higher or catch up with your competition.
Important: For your item to optimize, it is necessary for a template to be chosen.
EXCLUSION_CRITERIA_NAME The "exclusion criteria name" excludes the competitors of your choice from competing with you.
Important: For your item to optimize, it is necessary for a template to be chosen.
CUSTOM_CODE_SNIPPET_NAME The "customCode-snippet" decides how your items behave with the “customCode” function.
Important: Choose the right strategy by its name to optimize your items with the customCode.
CUSTOM_CODE_PAYLOAD The "customCode-payload" are additional data which can be used during the customCode price optimization.
Important: A payload can contain a maximum of 140 characters.

Info columns

Column Description
PRODUCT_ID A unique identifier for the product, assigned by Cdiscount.
SELLER_PRODUCT_ID A unique identifier for the product, assigned by the seller.
PARENT_PRODUCT_ID The product id of a variants parent.
VARIATION_TYPE The variation type of the article.
STANDARD – A standard type article.
VARIANT – A variant type article.
NAME The item name.
SIZE The “Size” gives information about the size of the item.
COLOR The “Color” gives information about the color of the item.
BRAND_NAME The “Brand” of the product.
QUANTITY The “Quantity” gives information about the current stock of the item.
LOGISTIC_MODE The way the shipping is done.
MARKETPLACE - Stored at the sellers Warehouse, shipped by seller.
FULFILMENT - Stored at Cdiscounts Warehouse, shipped by Cdiscount.
FULFILMENT_ON_DEMAND - Stored at the sellers Warehouse, shipped by Cdiscount.
CONDITION The “Condition” gives information about the current condition of the item.
  • NONE
  • LIKENEW
  • VERYGOODSTATE
  • GOODSTATE
  • AVERAGESTATE
  • REFURBISHED
  • NEW
QUANTITY The “Quantity” gives information about the current stock of the item.
INITIAL_PRICE The “Initial-Price” imported by eSagu RePricing when the tool/software was first activated. It can be used to determine your minimum prices and maximum prices.
Important: You cannot edit or change the “initial-price”.
BEST_SHIPPING_CHARGES The best shipping charges compared to competing articles.
SHIPPING_DELAY The number of days until the execution of the shipment.