eSagu Amazon 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 amazon 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 SKU, 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:

SKU "0110" Microsoft Excel omits the leading zero which creates a new, unrecognizable SKU 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

ColumnDescription
SKUSKU is the stock keeping unit. The SKU helps eSagu identify your item.
The SKU can be used only once for every item and can have a maximum 40 alphanumeric characters.
Important: Die SKU is the only mandatory column.
MIN_PRICEThe 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_PRICEThe 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_PRICEThe 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_MODEThe 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.

BUY_BOX – Selected items will be optimized with the "easyBox" function. The minimum prices and maximum prices will be used for it.

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_NAMEThe 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_NAMEThe "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.
SHIPPING_COSTS_NAMEThe selected "shipping charges-rule" determines the shipping charges that has to be applied on your items.
Important: For your item to optimize, it is necessary for a template to be chosen.
BUY_BOX_SETTINGS_NAMEThe "easyBox-strategy" decides how your items behave with the “easyBox” function.
Important: Choose the right strategy by its name to optimize your items with the easyBox.
CUSTOM_CODE_SNIPPET_NAMEThe "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_PAYLOADThe "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

ColumnDescription
ASINThe Amazon Standard Identification Number (ASIN) is the ten-digit alphanumeric(al) item-ID, assigned by amazon.
TITLEThe item name. The item name is neither used by eSagu nor by Amazon for identification.
Important: Amazon send us only the first 100 characters of the item's title.
OPTIMIZED_PRICEThe “Optimized-Price”, gives you information about the last calculated price.
AMAZON_PRICEThe current online-price on amazon wihout shipping.
INITIAL_PRICEThe “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”.
FULFILLMENT_TYPEThe “fulfilment-type” is the differentiation between:

MFN – the item will be shipped by you.

FBA – the item will be shipped by Amazon.

FEEDBACK_RATINGThe percentage of positive feedback for your shop.
FEEDBACK_RATINGThe amount of feedback given for your shop.
QUANTITYThe “Quantity” gives information about the current stock of the item.
CHEAPEST_COMPETITOR_SELLER_IDThe “Cheapest competitor seller id” shows you your cheapest competitor, you are competing with. However, competitors listed under the exclusions are ignored here and the system focuses only on your next eligible competitor.
Important: Because of certain exclusion rules, some cheaper competitors will be excluded.
CHEAPEST_COMPETITOR_FULFILLMENT_TYPEThe “Cheapest competitor fulfillment type” shows how the cheapest competitor is dispatching his items. We differentiate between MFN and FBA.
Important: Because of certain exclusion rules, some cheaper competitors will be excluded.
CHEAPEST_COMPETITOR_PRICEThe “Cheapest competitor price” shows the cheapest competitors price in an offer, without the dispatch.
Important: Because of certain exclusion rules, some cheaper competitors will be excluded.
CHEAPEST_COMPETITOR_SHIPPINGThe “Cheapest competitor shipping” shows the shipping costs of the cheapest competitor in this offer.
Important: Because of certain exclusion rules, some cheaper competitors will be excluded.
OFFER_COUNTIn the column “OFFER_COUNT”, you can see how many competitors you are facing in any offer.
Important: The maximum number of 20 is displayed.
BUY_BOX_OWNER_SELLER_IDThe “BUY_BOX_OWNER_SELLER_ID“ shows the current BuyBox owner's seller id.
BUY_BOX_OWNER_PRICEThe “BUY_BOX_OWNER_PRICE“ shows the item-price of the current BuyBox owner.
BUY_BOX_OWNER_SHIPPINGhe “BUY_BOX_OWNER_SHIPPING“ shows the shipping costs of the current BuyBox owner.
BUY_BOX_OWNER_LEAD_TIME_FROMThe shortest possible time required to ship the item of the current BuyBox owner.
Important: The LeadTime is given hours.
BUY_BOX_OWNER_LEAD_TIME_TOThe longest possible time required to ship the item of the current BuyBox owner.
Important: The LeadTime is given hours.
BUY_BOX_OWNER_FULFILLMENT_TYPEThe “BUY_BOX_OWNER_FULFILLMENT_TYPE“ shows the fulfillment method (FBA or MFN) of the current BuyBox owner.
BUY_BOX_OWNER_FEEDBACK_RATINGThe percentage of positive feedback for the shop of the current BuyBox owner.
BUY_BOX_OWNER_FEEDBACK_RATINGThe amount of feedback given for the shop of the current BuyBox owner.
BUY_BOX_OWNER_PRIME_STATEIf the article is shipped with the shipping method MFN-/FBA-Prime, the article is marked with a "YES", otherwise with a "NO".
BUY_BOX_COUNTThe “BUY_BOX_COUNT“ shows the number of available BuyBoxes on an offer.
Important: There can be e.g. one BuyBox for MFN and one for FBA.
AMAZON_IN_TOP_20In the column “AMAZON_IN_TOP_20“ you can see, if Amazon is one of the Top 20 merchants on an offer.
LEAD_TIME_FROMThe shortest possible time required to ship your item.
Important: The LeadTime is given hours.
LEAD_TIME_TOThe longest possible time required to ship your item.
Important: The LeadTime is given hours.
SHIPPING_COSTSYour item's current shipping.
ESAGU_ITEM_IDContains our ID for the item and can be used in conjunction with our REST API.
ITEM_ORDERS_LAST_SEVEN_DAYSSales of this article in the past seven days (excluding today).
ITEM_ORDERS_LAST_FOURTEEN_DAYSSales of this article in the past fourteen days (excluding today).
ITEM_ORDERS_LAST_THIRTY_DAYSSales of this article in the past thirty days (excluding today).
LOWEST_SALES_RANK_DISPLAY_ON_WEBSITEThe SalesRank which is displayed on the Amazon article page.
Important: If the item has multiple SalesRankings, the lowest SalesRank is shown.
LOWEST_SALES_RANK_DISPLAY_ON_WEBSITE_NAMEThe name of the SalesRank displayed on the Amazon item page.
Important: If the item has multiple SalesRankings, the lowest SalesRank is shown.
SALES_RANKINGSContains all SalesRankings (comma separated).
Important: For SalesRankings in subcategories, the first value is the category ID.
PRIME_STATEIf the article is shipped with the shipping method MFN-/FBA-Prime, the article is marked with a "YES", otherwise with a "NO".
MERCHANT_SHIPPING_GROUPName of the Amazon merchant shipping group.

Please note, eSagu does not take any responsibility for any incorrect, inaccurate or incomplete information/data received from Amazon.