eSagu RePricing for Amazon "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.
E.g. 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
| Column | Description |
|---|---|
| SKU | SKU 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_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 options: 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_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 |
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. |
| SHIPPING_COSTS_NAME | The 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 |
The "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 |
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. |
| BUSINESS_PRICE_SETTINGS |
The name of the business price rule for the item. |
| REFERRAL_FEE |
The name of the referral fee rule to use for referral fee / margin calculation, we try to match up the names as described here amazon.co.uk or here amazon.de for example. |
| WHOLESALE |
The "wholesale price" column contains the cost at which a product is purchased by a retailer, which serves as the basis for calculating the profit margin. |
| TARGET |
The "target margin" defines the minimum margin you want to achieve by selling this item. |
| SELLING_COSTS |
The name of the selling costs used when calculating the profit margin. |
| FULFILLMENT |
The item's Amazon FBA fulfillment program. Here you have several options: FBA_CORE – The standard Amazon fulfillment network. FBA_SNL – FBA_EFN – Cross-border European Fulfillment Network. |
Info columns
| Column | Description |
|---|---|
| ASIN | The Amazon Standard Identification Number (ASIN) is the ten-digit alphanumeric(al) item-ID, assigned by amazon. |
| TITLE | The 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_PRICE | The “Optimized-Price”, gives you information about the last calculated price. |
| AMAZON_PRICE | The current online-price on amazon wihout shipping. |
| 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”. |
| FULFILLMENT_TYPE | The “fulfilment-type” is the differentiation between: MFN – the item will be shipped by you. FBA – the item will be shipped by Amazon. |
| FEEDBACK_RATING | The percentage of positive feedback for your shop. |
| FEEDBACK_RATING | The amount of feedback given for your shop. |
| QUANTITY | The “Quantity” gives information about the current stock of the item. |
| CHEAPEST_COMPETITOR |
The “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 |
The “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 |
The “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 |
The “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_COUNT | In 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 |
The “BUY_BOX_OWNER_SELLER_ID“ shows the current BuyBox owner's seller id. |
| BUY_BOX_OWNER |
The “BUY_BOX_OWNER_PRICE“ shows the item-price of the current BuyBox owner. |
| BUY_BOX_OWNER |
he “BUY_BOX_OWNER_SHIPPING“ shows the shipping costs of the current BuyBox owner. |
| BUY_BOX_OWNER |
The shortest possible time required to ship the item of the current BuyBox owner. Important: The LeadTime is given hours. |
| BUY_BOX_OWNER |
The longest possible time required to ship the item of the current BuyBox owner. Important: The LeadTime is given hours. |
| BUY_BOX_OWNER |
Shows the fulfillment method (FBA or MFN) of the current BuyBox owner. |
| BUY_BOX_OWNER |
The percentage of positive feedback for the shop of the current BuyBox owner. |
| BUY_BOX_OWNER |
The amount of feedback given for the shop of the current BuyBox owner. |
| BUY_BOX_OWNER |
If the article is shipped with the shipping method MFN-/FBA-Prime, the article is marked with a "YES", otherwise with a "NO". |
| BUY_BOX_COUNT | The “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_20 | In the column “AMAZON_IN_TOP_20“ you can see, if Amazon is one of the Top 20 merchants on an offer. |
| LEAD_TIME_FROM | The shortest possible time required to ship your item. Important: The LeadTime is given hours. |
| LEAD_TIME_TO | The longest possible time required to ship your item. Important: The LeadTime is given hours. |
| SHIPPING_COSTS | Your item's current shipping. |
| ESAGU_ITEM_ID | Contains our ID for the item and can be used in conjunction with our REST API. |
| ITEM_ORDERS |
Sales of this article in the past seven days (excluding today). |
| ITEM_ORDERS |
Sales of this article in the past fourteen days (excluding today). |
| ITEM_ORDERS |
Sales of this article in the past thirty days (excluding today). |
| LOWEST_SALES_RANK_DISPLAY |
The 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 |
The name of the SalesRank displayed on the Amazon item page. Important: If the item has multiple SalesRankings, the lowest SalesRank is shown. |
| SALES_RANKINGS | Contains all SalesRankings (comma separated). Important: For SalesRankings in subcategories, the first value is the category ID. |
| PRIME_STATE | If the article is shipped with the shipping method MFN-/FBA-Prime, the article is marked with a "YES", otherwise with a "NO". |
| MERCHANT_SHIPPING_GROUP | Name of the Amazon merchant shipping group. |
| FEATURED_MERCHANT | If your offer is a "Featured Merchant" offer at amazon, the article is marked with a "YES", otherwise with a "NO". If your item is not found on Amazon, it will be marked "UNKNOWN". |
| AI_PRICE | The "AI Price" shows you a price predicted by the eSagu AI to get into the BuyBox. Please note that this is a recommendation given by our AI. |
| CATEGORY_ID | The Amazon category ID, often also called Amazon (Browse) Node ID. |
| GTIN | The GTIN/EAN of the item on Amazon. |
| FEE_ESTIMATE_DIFFERENCE_PERCENT | The percentage difference between the referral fees estimated by eSagu and those calculated by Amazon. This field helps identify discrepancies in fee calculations to ensure that the estimates provided by eSagu are accurate and reliable. A significant difference may indicate that the item has been assigned to the wrong category. |
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 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 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. |
| Maximal row count exceeded | A single CSV file in eSagu may contain a maximum of 500,000 lines. |
| Price settings incomplete | This error occurs when there are no price modes set up. You need to add another column in the file named PRICE_MODE. |
| Price Settings Invalid | This 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.
Example CSV files
Here are a few sample files that might be helpful to you: