{"draftJsState":{"blocks":[{"data":{"image":{"id":"68ef5709450673417c9cec89"}},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"atomic:image","key":"gur5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"aim0i"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":16,"offset":58,"style":"BOLD"},{"length":13,"offset":92,"style":"BOLD"},{"length":20,"offset":197,"style":"BOLD"}],"text":"Если вы уже сделали свой первый YML-файл и добавили его в Яндекс.Вебмастер, следующий шаг — автоматизация.\n\nЧтобы больше не редактировать XML вручную и не обновлять цены каждый день, можно сделать динамический YML-фид, который создаётся “на лету” из Google Sheets или базы данных \uD83D\uDCA1","type":"unstyled","key":"f7416"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Разберём пошагово, как это сделать.","type":"unstyled","key":"7v68e"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"\uD83D\uDD39 Что такое динамический YML","type":"header-two","key":"ccc1b"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Обычный YML — это статичный XML-файл.\n\nВы сделали его один раз, загрузили на сервер, и всё. Но при изменении цен или остатков нужно снова вручную обновлять.","type":"unstyled","key":"dvm9k"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":16,"offset":0,"style":"BOLD"}],"text":"Динамический YML работает иначе:","type":"unstyled","key":"31jmq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":21,"offset":18,"style":"BOLD"}],"text":"данные берутся из таблицы Google Sheets (или базы);","type":"unordered-list-item","key":"9foo0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":3,"offset":10,"style":"BOLD"}],"text":"скрипт на PHP формирует XML в реальном времени;","type":"unordered-list-item","key":"2pgtt"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"файл всегда актуален — без ручного обновления.","type":"unordered-list-item","key":"rab5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"\uD83E\uDDF1 Что понадобится","type":"header-two","key":"4o76"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"✅ Аккаунт Google и таблица с товарами\n\n✅ Доступ к серверу с PHP\n\n✅ Любой текстовый редактор","type":"unstyled","key":"2lvk0"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"\uD83D\uDCCA Шаг 1. Подготовьте таблицу в Google Sheets","type":"header-two","key":"31buq"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Создайте таблицу со столбцами:","type":"unstyled","key":"bjpsn"},{"data":{"image":{"id":"68ef55fb6fa513574f14a9b6"}},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"atomic:image","key":"beg66"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":30,"offset":24,"style":"BOLD"},{"length":37,"offset":57,"style":"BOLD"}],"text":"Теперь сделайте таблицу доступной для чтения по ссылке:\n\nФайл → Опубликовать в интернете → CSV.","type":"unstyled","key":"cj1lr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"После публикации вы получите ссылку примерно такого вида:","type":"unstyled","key":"97asl"},{"data":{"image":{"id":"68ef561d0133b70f8607b0f2"}},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"atomic:image","key":"b5km5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Эта ссылка будет источником данных для вашего фида.","type":"unstyled","key":"23t4n"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"\uD83D\uDCBB Шаг 2. Создайте PHP-скрипт","type":"header-two","key":"l54m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"На сервере создайте файл, например:\n\n/public_html/yml.php","type":"unstyled","key":"c8svb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"И вставьте код:","type":"unstyled","key":"78k73"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"';","type":"unstyled","key":"1fq9f"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"?>","type":"unstyled","key":"dlv23"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"\">","type":"unstyled","key":"e5bko"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"50vrm"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Мой магазин","type":"unstyled","key":"en0m6"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ООО «Мой магазин»","type":"unstyled","key":"dhc2s"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"https://test.ru","type":"unstyled","key":"6goru"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"2u7kp"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"63g46"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"3vku8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"6ms60"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"aa5le"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"\" available=\"\">","type":"unstyled","key":"1hp4m"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"18pm3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"10ffn"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"RUR","type":"unstyled","key":"8e1bg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"1","type":"unstyled","key":"7lvpr"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"nq49"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"bq9nv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"dqmtk"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"3prhg"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"c856e"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"1ig5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"2cfv1"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"epmcl"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"unstyled","key":"4kogf"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Теперь по ссылке:","type":"unstyled","key":"9mfg2"},{"data":{},"depth":0,"entityRanges":[{"key":0,"length":27,"offset":0}],"inlineStyleRanges":[],"text":"https://ваш_сайт.ru/yml.php","type":"unstyled","key":"3h8hv"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"вы получите живой XML-фид, который автоматически подгружает актуальные данные из Google Sheets \uD83D\uDCAB","type":"unstyled","key":"8n3ot"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"\uD83D\uDD04 Шаг 3. Настройте автоматическое обновление","type":"header-two","key":"funu3"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":11,"offset":58,"style":"BOLD"}],"text":"Фид обновляется каждый раз при запросе, но можно добавить кеширование для оптимизации:","type":"unstyled","key":"49fva"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"if (file_exists('cache.xml') && time() - filemtime('cache.xml') < 3600) {","type":"unstyled","key":"64um9"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"readfile('cache.xml');","type":"unstyled","key":"7tdec"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"exit;","type":"unstyled","key":"595c8"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"}","type":"unstyled","key":"av74r"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ob_start();","type":"unstyled","key":"8n362"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"// … тут формируется XML …","type":"unstyled","key":"e82q5"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"file_put_contents('cache.xml', ob_get_contents());","type":"unstyled","key":"54tas"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"ob_end_flush();","type":"unstyled","key":"48i5v"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Так вы избежите лишней загрузки таблицы — обновление будет раз в час.","type":"unstyled","key":"4f14a"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"\uD83E\uDDE0 Преимущества такого подхода","type":"header-two","key":"1hkng"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"✅ Данные обновляются автоматически\n\n✅ Не нужно заливать файлы вручную\n\n✅ Можно управлять товарами прямо в Google Sheets\n\n✅ Работает на любом хостинге с PHP","type":"unstyled","key":"ccedb"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"⚙️ Итог","type":"header-two","key":"cc2ok"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"Динамический YML через PHP и Google Sheets — идеальное решение, если у вас:","type":"unstyled","key":"1vc5e"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"нет CMS, но есть товары;","type":"unordered-list-item","key":"1hii7"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"нужно быстро обновлять цены и остатки;","type":"unordered-list-item","key":"ffi13"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"хочется упростить жизнь себе и маркетологу \uD83D\uDE0A","type":"unordered-list-item","key":"8jslo"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[{"length":29,"offset":30,"style":"BOLD"}],"text":"\uD83D\uDCAC Если статья была полезной — ставьте лайк и подписывайтесь!\n\nВ следующем материале разберём:","type":"unstyled","key":"f9kal"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"\uD83D\uDC49 как добавить автоматическую выгрузку по cron и связать динамический YML с Яндекс.Маркетом.","type":"blockquote","key":"245u"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"\uD83C\uDFF7️ Хэштеги:","type":"header-three","key":"7s4op"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"#yml #яндексвебмастер #яндексмаркет #googleSheets #php #xml #фид #интернетмагазин #автоматизация #seo #директ #вебразработка #созданиесайта #продвижениесайта #онлайнторговля #маркетплейсы","type":"unstyled","key":"2pk22"},{"data":{},"depth":0,"entityRanges":[],"inlineStyleRanges":[],"text":"","type":"marker","key":"kKeJLQLHxSq1niO84iTj"}],"entityMap":{"0":{"data":{"url":"https://ваш_сайт.ru/yml.php"},"mutability":"MUTABLE","type":"LINK"}}},"mentions":[]}