Bot for Automatic Product Publishing from Website to VK Group

Developing a Bot for Automatic Product Publishing from Website to VK Group

VKontakte remains a significant platform for sales in Russian-speaking segment. Bot automatically creates posts in VK group based on products from website catalog: uploads photo, generates text, adds link, and publishes — or schedules for delayed publication.

VK API for Publications

Uses wall.post method with pre-loaded photos:

import vk_api
from vk_api.upload import VkUpload
import httpx

class VKProductPublisher:
    def __init__(self, access_token: str, group_id: int):
        self.vk     = vk_api.VkApi(token=access_token)
        self.upload = VkUpload(self.vk)
        self.group_id = group_id

    async def publish(self, product: dict) -> int:
        # Upload first product image
        attachment = None
        if product.get('images'):
            image_url  = product['images'][0]['url']
            image_data = httpx.get(image_url).content

            # Upload photo to VK server
            photo = self.upload.photo_wall(
                photos=image_data,
                group_id=self.group_id
            )[0]
            attachment = f"photo{photo['owner_id']}_{photo['id']}"

        # Post text
        text = (
            f"{product['name']}\n\n"
            f"{product['short_description']}\n\n"
            f"💰 {product['price']:,.0f} ₽\n\n"
            f"🛒 Buy: {product['url']}\n\n"
            f"#{self.make_hashtags(product['categories'])}"
        )

        result = self.vk.method('wall.post', {
            'owner_id':     -self.group_id,
            'message':      text,
            'attachments':  attachment,
            'from_group':   1,
        })

        return result['post_id']

    def make_hashtags(self, categories: list) -> str:
        return ' '.join(f"#{c['slug'].replace('-', '_')}" for c in categories)

Scheduled Publishing

VK API supports delayed publication:

import time
from datetime import datetime, timedelta

publish_time = datetime.now() + timedelta(hours=2)

result = self.vk.method('wall.post', {
    'owner_id':     -self.group_id,
    'message':      text,
    'attachments':  attachment,
    'publish_date': int(publish_time.timestamp()),  # Unix timestamp
    'from_group':   1,
})

VK API Specifics

• Access Token must have wall, photos, groups rights
• Rate limits — no more than 50 posts per hour for one group
• Photos are uploaded via special upload server, not direct URL
• Group — negative group_id passed in owner_id

Timeline

Bot with schedule, photo upload, and queue: 3–5 business days.