eSagu ebay 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
ITEM_IDThe ITEM_ID is an assigned sequence of numbers to identify specific products.
The ITEM_ID is assigned by ebay for your current listing. After resetting your listing will receive a new ITEM_ID. Our system uses the ITEM_ID to identify your products and their variants.
Important: The ITEM_id is a mandatory specification. If your article has no SKU, the ITEM_ID is sufficient for identification.
SKUThe SKU is an associated string to identify a particular product.
The SKU may only be used once per ebay SITE for each listed product and may have a maximum of 50 alphanumeric characters.
Important: The SKU is a mandatory specification for all variant types and articles for which a SKU has been assigned.
MIN_PRICEThe minimum price determines the lowest price below which eSagu RePricing cannot/will not set your selling price, regardless of which price the competitor uses.
So it is your decision at what price you want to sell your products.
Important: For optimization, the fixed price must be within the minimum and maximum price. The minimum price must have two decimal places.
MAX_PRICEThe maximum price determines the upper price limit above which eSagu RePricing cannot/will not set your selling price regardless of which price the competitor uses.
So it is your decision at what price you want to sell your products.
Important: For optimization, the fixed price must be within the minimum and maximum price. The maximum price must have two decimal places.
FIXED_PRICEWith the fixed price the optimization is ignored, the products are offered at your fixed price.
Important: In order to be able to offer your products at a fixed price, they must be within the minimum and maximum price. The fixed price must have two decimal places.
PRICE_MODEThe price option determines how your products behave during optimization. You have several options to choose from:

OPTIMIZATION – Selected products are optimized on the basis of competitor information and the minimum and maximum prices you set. In our software this option is displayed as "Optimization: By Rank".

OPTIMIZATION_BEST_VISIBILITY – Selected products are optimized on the basis of competitor information and the minimum and maximum prices you set. In addition, competitors are reduced to 5 and sorted by price to give you the best visibility at the best price. In our software this option is displayed as "Optimization: By Price".

FIXED_PRICE – Selected products are offered at your fixed price.

CUSTOM_CODE – Selected products are optimized according to your CustomCodes.

DISABLED – Selected products are marked with the status "Disabled". There is no price adjustment in this case.

PRICE_GAPS_NAMEThe selected "price gap rule" determines which strategy the optimization should follow. Here you can choose between overbidding, equalising or underbidding.
Important: In order to optimize your selected products, you must choose a price gap rule with the corresponding rule name.
CUSTOM_CODE_SNIPPET_NAMEThe selected "CustomCode" determines which CustomCode is used for the chosen products.
Important: In order to optimize your selected products with the CustomCode, a "CustomCode" with the respective name must be selected.
CUSTOM_CODE_PAYLOADAdditional data can be used by the CustomCode for optimization.
Important: The length of the payload is limited to 140 characters.
FINDING_API_FILTER_NAMEThe selected "FindingApiFilterName" specifies which search filter is used for the selected "EbayFindingApiOperation".
Important: In order for your selected products to be filtered, an existing "search filter" with the respective name must be selected.
EBAY_FINDING_API_OPERATIONUsing the "EbayFindingApiOperation" you decide how we find your competition articles
You can choose:

FIND_ITEMS_ADVANCED – Specify an additional keyword in the field "EBAY_PRODUCT_SEARCH_TERM" to search for articles with the same keyword.

FIND_ITEMS_BY_KEYWORDS – Specify an additional keyword in the field "EBAY_PRODUCT_SEARCH_TERM" to search for articles with the same keyword.

FIND_ITEMS_BY_PRODUCT – Specify in addition EAN, UPC, ISBN or ReferenceId in the field "EBAY_PRODUCT_SEARCH_ID_TYPE" and a suitable "EBAY_PRODUCT_SEARCH_TERM" in order to RePrice selectively.

Important: Depending on the operation, the corresponding fields are mandatory.
EBAY_PRODUCT_SEARCH_ID_TYPEThe selected "EbayProductSearchIdType" specifies the type of product identification you want to use to find articles against which RePriced.
Important: Required for: FIND_ITEMS_BY_PRODUCT. You can choose between: EAN, UPC, ISBN or REFERENCE_ID.
EBAY_PRODUCT_SEARCH_TERMThe search term used to find items that are optimized against.
Important: The search term is always required if you want to change the "EbayFindingApiOperation".

Info columns

ColumnDescription
TITLEYour product name for a specific product. The title is not used by eSagu or ebay for identification purposes.
Important: ebay only passes the first 100 characters of the title to us.
OPTIMIZED_PRICEThe "Optimized Price" informs you which price we send to ebay last or up to date.
CURRENT_PRICEThe current ebay online price including shipping costs, as it is currently available on ebay for this product.
INITIAL_PRICEThe initial price was read by eSagu RePricing at the first start of the software. It can be used to set your minimum and maximum prices automatically.
QUANTITYThe "Quantity" displays the current information about the initial quantity for each product.
QUANTITY_SOLDThe "Sold Quantity" shows you how many of the total stock you have already sold for this item.
SHIPPING_COSTSThe "Shipping costs" will show you your shipping costs defined as the primary shipping costs.
OFFER_COUNTIn the column "Offer Count" you can see how many competitors are facing you in this offer.
VARIATION_TYPEThe variation type of the article.
An article must always be of type NONE, PARENT or CHILD.
Important: You can change a PARENT in our system, but changes will not be sent to ebay because parent articles cannot be sold.
START_TIMEThe start time of the offer of your article.
Important: This information is only available if the article is of the type "Scheduled Listing".
END_TIMEThe end time of the offer of your article.
Important: This information is only available if the article is of the type "Scheduled Listing".
ITEM_URLThe link to the offer of your article on ebay.
SITEThe Ebay country to the article.
EBAY_PRODUCT_IDThe ebay product ID of your article.
EBAY_PRODUCT_ID_TYPEThe type of product ID of your article.
Important:EAN, ISBN or REFERENCE_ID.
RELIST_PARENT_IDThe RelistParentId of your article.
LISTING_TYPEThe type of offer of the item (auction or fixed price).
PRIMARY_CATEGORY_IDThe ID of the primary ebay category.
PRIMARY_CATEGORY_NAMEThe name of the primary ebay category.
Important: This information is only available if the category ID exists in the current ebay category tree.
PRIMARY_CATEGORY_PARENT_IDParents category ID of the primary ebay category.
Important: Root categories have no parent category. This information is only available if the category ID exists in the current ebay category tree.
PRIMARY_CATEGORY_LEVELThe depth of the primary ebay category, the maximum depth is 6.
Important: Root categories have a depth of 1 and this information is only available if the category ID exists in the current ebay category tree.
SECONDARY_CATEGORY_IDThe ID of the secondary ebay category.
SECONDARY_CATEGORY_NAMEThe name of the secondary ebay category.
Important: This information is only available if the category ID exists in the current ebay category tree.
SECONDARY_CATEGORY_PARENT_IDThe Parents Category ID of the secondary ebay category.
Important: Root categories have no parent category. This information is only available if the category ID exists in the current ebay category tree.
SECONDARY_CATEGORY_LEVELThe depth of the secondary ebay category, the maximum depth is 6.
Important: Root categories have a depth of 1 and this information is only available if the category ID exists in the current ebay category tree.
ITEM_SPECIFICSThis column contains the ebay article features.
VARIATION_SPECIFICSThis column contains the ebay variant characteristics.
SEARCH_RANKShows the position of your article within the search results of ebay.
TOTAL_ENTRIESDisplays the total number of search results based on your search criteria.
SEARCH_TERM_SOURCESpecifies how the search term stored under EBAY_PRODUCT_SEARCH_TERM was created.

MANUAL – This search term was edited manually in our software.

CSV – This search term was adjusted via a CSV import.

AUTO_GENERATED_ITEM_SPECS – This search term was created from the item specs.

AUTO_GENERATED_TITLE – This search term was created from the titles.

AUTO_GENERATED_PRODUCT_ID – The product ID is used as a search term.

UNKNOWN – This search term was created before the introduction of the SEARCH_TERM_SOURCE column.

HIT_COUNTContains the page views of the article on ebay, therefore the "hit counter" must be active for this offer.
ESAGU_ITEM_IDContains our item ID 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).

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