Kaspi is a popular online platform in Kazakhstan where entrepreneurs can sell their goods and buyers can find the best offers. This marketplace covers all of Kazakhstan, allowing customers to compare prices from different sellers and choose the best deals. To sell successfully on Kaspi, sellers need to know how to correctly create and upload a price list. Beginners can quickly learn the filling process, and the right approach ensures a smooth start in the business.
Web tool for finding profitable products
There are many analytics tools for successful selling on Kaspi. The best option for fast analysis and boosting sales is the AWW service. It helps sellers track price dynamics and choose the most profitable items. With AWW you can quickly adapt your assortment and minimize risks.
See also: direct link to login and a step-by-step guide — Kaspi.kz seller cabinet.
Kaspi price list: basic rules
Creating a price list is an important step that requires attention to detail. Mistakes in filling out the file can lead to profit loss. For example, if you accidentally enter 50,000 tenge instead of 500,000 tenge, the seller will incur significant losses. That's why it's worth reviewing the main stages of creating a price list for the Kaspi cabinet in advance.
How to create a price list for Kaspi
Kaspi provides a template in Excel format that simplifies data entry. You can add extra columns to the template for convenience. Here are the key columns and their meanings:
- SKU: copy the item article, make sure the data is accurate.
- Model: enter the full product name, e.g., 'knife jumbo polywood 127mm/237mm for steak'.
- Brand: specify the brand if it exists. If there is no brand, leave the field empty.
- Comment: you can indicate margin, stock availability and other information that will be displayed after calculation.
- Price: be sure to check all digits carefully when entering the product cost.
- Minimum price: this field is not in the standard template, but it is recommended to add it. Minimum price is the price below which selling the product is unprofitable. Usually it is about 15% above cost price to cover Kaspi commission, delivery and other expenses.
- RR1, RR2, RR3: these rows are for warehouses. If you have only one warehouse, fill only the RR1 column.
- Preorder: number of days for delivery. If the product is in stock, you can put a dash.
To calculate all values, you can choose View > Macros > Calculate in Excel. Recommendations for each product will appear in the 'Comment' column.
Possible statuses in the "Comment" field
- All good: the product is in stock and priced competitively.
- Minimum price reached: the price is at the minimum allowed level.
- Out of stock: no units available at the moment.
- Price too low: selling at this price is not profitable — check minimum price and margins.
- Check data: some fields are missing or formatted incorrectly; review SKU, Model and Price.
These statuses help quickly understand what action is needed: restock, raise price, or correct data before upload.
How to upload a price list to Kaspi: step-by-step
Follow these steps to upload your price list to the Kaspi seller cabinet:
- Download the current Kaspi template from the seller cabinet and open it in Excel.
- Fill in required fields (SKU, Model, Price) and any optional columns you need. Keep numeric fields as plain numbers without spaces, commas or currency symbols.
- Add a 'Minimum price' column if you use it and fill values as integers in tenge.
- Remove any formatting, hidden characters and validation rules that may interfere with import. Check for duplicate SKUs.
- Save the file in a supported format (usually XLSX or CSV). If using CSV, make sure encoding is UTF-8 and the delimiter matches the import settings.
- Go to the import section in the Kaspi seller cabinet, select the file and match columns if prompted.
- Start the upload and monitor processing. The system will show progress and provide an import report with details on errors and accepted rows.
- Fix errors listed in the report (indicated by row numbers) and re-upload the corrected file.
After a successful upload, check products in the seller cabinet and on the marketplace. It may take some time for changes to appear publicly depending on Kaspi's processing queue.
Common mistakes and how to avoid them
- Entering prices with spaces or symbols — always use plain integers (e.g., 500000).
- Using the wrong file format — save in the format recommended by Kaspi.
- Duplicate SKUs — ensure each SKU is unique.
- Text in numeric fields — remove any non-numeric characters from price and quantity fields.
- Incorrect column names — use the template headers or map columns correctly during import.
If the import is rejected, download the error report, correct the problematic lines in Excel and upload again. The import report usually points to exact rows and the nature of the problem, which accelerates fixes.
Following these rules will help sellers avoid typical pitfalls and speed up the process of listing products on Kaspi.
Часто задаваемые вопросы
- Which fields in the Kaspi price list Excel template are mandatory and what should I pay special attention to when filling them?
- Mandatory fields typically are: SKU (unique article), Model (full product name) and Price. It is important not to use spaces, currency symbols or thousand separators in numeric fields — enter a plain number in tenge, and SKU must be unique and accurate. Optional fields (Brand, Quantity, Comment) affect display but if absent the upload can still succeed.
- How to correctly specify the price in the price list to avoid entering the wrong order of magnitude (for example, 50 000 instead of 500 000)?
- Enter the price as an integer in tenge without spaces, commas or symbols (for example, 500000). Before saving, check by sorting and reviewing minimum/maximum values and compare them with the calculated markup in Excel. It helps to add a control column with a margin formula to quickly spot anomalies.
- What common errors most often lead to a file being rejected during upload to the Kaspi cabinet and how to fix them quickly?
- Common errors: wrong file format, missing mandatory columns, duplicate SKUs, text in numeric fields and special characters in headers. To fix: open the template in Excel, remove formatting, align columns to required names, remove duplicates and save in a supported format (usually XLSX/CSV), then re-upload. After upload, check the import report with row numbers and error descriptions.
- How do I upload a price list step-by-step in the Kaspi seller cabinet and where to check file processing status?
- Download the current Kaspi template, fill it in and save in a supported format, then go to the import section in the seller cabinet. Select your file, map columns if needed and start the upload; the system will show processing progress. Results and errors are shown in the import history/notifications with details per row for correction.
- If the template lacks a 'Minimum price' column, how can I correctly pass this parameter without errors during upload?
- Add a new column with the exact field name required by Kaspi (check instructions or template settings) and fill values in the same numeric format as other price fields. During upload, map this column in the import interface; if the platform does not support the field, provide the value in the comment and coordinate the format with Kaspi support. Always review the import report for missing or unrecognized columns.
