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.

Common errors

Error (code)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 SKU found

Since SKU is our identifier for the products. You cannot upload a file with the same 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 SKUs that are duplicates will be highlighted, and you can easily remove them or change them accordingly.

File is corruptedIf 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.

Maximal row count exceeded

A single CSV file in eSagu may contain a maximum of 500,000 lines.

Price settings incompleteThis error occurs when there are no price modes set up. You need to add another column in the file named PRICE_MODE.
Price Settings InvalidThis error occurs when the Min, Max and Fixed price are not within the desired range. Max price always needs to be higher than the min price and fixed price needs to be either equal to or within min_max.
No SKU found

If there are SKUs 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 Amazon.