Import and Synchronization
What It Is
If you already run an online store, warehouse system, or product list in a spreadsheet, there is no need to enter catalog items manually. Botconsole supports bulk spreadsheet imports as well as real-time two-way synchronization of stock and prices with your business tools.
Data Loading Methods
- Spreadsheet Import (CSV, Excel): quickly seed a new catalog or perform batch price adjustments.
- Automated Synchronization: update product details or stock automatically whenever an event occurs on your website or warehouse software.
- Direct Integration: connect your warehouse or CRM software (1C, MoySklad, HubSpot, etc.) for automated data exchange.
- Scheduled Scenario Updates: the bot can periodically check an external price list and refresh catalog info for customers.
CSV & Excel Import Format
The spreadsheet file should contain clear columns matching key product fields:
| Column Name | Botconsole Mapping | Required |
|---|---|---|
name / Title |
Product name | Yes |
sku / SKU |
Stock keeping unit identifier | Recommended |
price / Price |
Current base price | Yes |
old_price / Old Price |
Strikethrough price | No |
amount / Stock |
Available quantity | No |
description / Summary |
Short summary | No |
description_full |
Comprehensive description | No |
category / Category |
Category name | No |
image / Photo |
Direct image URL | No |
When re-uploading a file with identical SKUs, existing products are updated with the latest price and inventory numbers without creating duplicate records.
Inventory Synchronization
1. Warehouse-to-Bot Updates
When inventory levels change in your warehouse system:
- The warehouse notifies your bot scenario about the updated stock.
- The bot locates the item by SKU and instantly updates its stock quantity in the catalog.
- Customers in chat always see actual real-time availability.
2. Bot-to-CRM Order Sync
When a customer completes a checkout in Telegram:
- The order is immediately registered in Botconsole's order list.
- The bot scenario sends the order details (order number, customer contacts, purchased items, and total amount) directly to your CRM (HubSpot, Salesforce, AmoCRM, Bitrix24).
- Sales reps in your CRM instantly see the new deal and can take it into fulfillment.
Best Practices
- Always maintain unique SKUs: a distinct SKU guarantees accurate mapping between your website, warehouse, and bot catalog.
- Ensure direct image links: product photo links should open directly without passwords so the bot can display them in messenger chats.