{"id":2459,"date":"2026-01-29T11:41:10","date_gmt":"2026-01-29T08:41:10","guid":{"rendered":"https:\/\/pricecop.net\/?p=2459"},"modified":"2026-02-20T13:01:59","modified_gmt":"2026-02-20T10:01:59","slug":"xml-conv","status":"publish","type":"post","link":"https:\/\/pricecop.net\/en\/blog\/xml-conv\/","title":{"rendered":"PriceCop XML converter: automation of feeds from Excel and Google Sheets"},"content":{"rendered":"

<\/p>\n

\n <\/p>\n
\n [PriceCop] XML Converter: How to Create a Universal Language for Your E-commerce\n <\/div>\n
\n
<\/div>\n
\n
<\/div>\n<\/p><\/div>\n
\n \n \n <\/svg>\n <\/div>\n<\/p><\/div>\n

<\/a>\n<\/div>\n

In many companies, the price list is a “living” organism existing in Excel<\/strong> or Google Sheets<\/strong>. This is convenient for operational edits: a manager can change a price, update stock, or add a new product in a second. However, partners, marketplaces (Rozetka, Prom), and price aggregators (Hotline) require an XML feed<\/strong> \u2014 a structured file that the system reads automatically via a link.<\/p>\n

The XML Converter in PriceCop<\/strong> bridges this gap: it takes data from your spreadsheet, converts it into valid XML code, and updates it regularly (almost every hour) so your partners always see up-to-date information without any manual intervention.<\/p>\n

Why a Standard Spreadsheet Can’t Replace a Feed<\/h2>\n

Spreadsheets are built for humans, while XML is built for machines. Integration systems require parameters that are often ignored in Excel:<\/p>\n

    \n
  • Strict Structure:<\/strong> Tags, attributes, and encoding (UTF-8) that leave no room for error.<\/li>\n
  • Stable URL:<\/strong> You provide the link once, and the system fetches updates automatically.<\/li>\n
  • Identification:<\/strong> A clear “key” for the product (ID or SKU) that prevents duplicate entries.<\/li>\n<\/ul>\n

    In spreadsheets, data is often “blurry”: one row might say “yes,” another “in stock,” and another might just have a dash. For an import algorithm, this is a critical error leading to product rejection.<\/p><\/blockquote>\n

    Where is an XML Feed Critically Necessary?<\/h2>\n

    For Ukrainian e-commerce, the XML\/YML format is the industry standard. Without it, it is impossible to work with top platforms:<\/p>\n\n\n\n\n\n\n\n
    Platform<\/th>\nFeed Requirements<\/th>\n<\/tr>\n<\/thead>\n
    ROZETKA<\/strong><\/td>\nRequires XML (YML) with clear category mapping and mandatory characteristics (param).<\/td>\n<\/tr>\n
    Prom.ua<\/strong><\/td>\nSupports import via XML, where it is vital to correctly transmit availability statuses and wholesale prices.<\/td>\n<\/tr>\n
    Hotline<\/strong><\/td>\nUses extended XML for detailed descriptions of delivery terms, warranties, and promotions.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Field Mapping: Turning Columns into Data<\/h2>\n

    The conversion process in PriceCop is based on mapping<\/em> \u2014 establishing a correspondence between your Excel column and an XML tag. A typical set of fields includes:<\/p>\n

      \n
    • ID \/ SKU<\/strong> \u2014 a unique identifier (the foundation of everything).<\/li>\n
    • Name and Description<\/strong> \u2014 the marketing component.<\/li>\n
    • Price<\/strong> \u2014 retail price, as well as separate levels for B2B partners.<\/li>\n
    • Stock (Availability)<\/strong> \u2014 a numerical value or logical status.<\/li>\n
    • Parameters<\/strong> \u2014 characteristics (color, material, power) which turn into filters on Rozetka.<\/li>\n<\/ul>\n

      The Advantage of Regular Updates<\/h2>\n

      A one-time conversion becomes obsolete within an hour if you have dynamic sales. The PriceCop XML Converter automatically rebuilds the feed every hour<\/strong>. This guarantees:<\/p>\n

        \n
      1. No “ghost” items (selling products that are no longer in stock).<\/li>\n
      2. Instant transmission of promotional prices to all platforms simultaneously.<\/li>\n
      3. Partner trust, as they see the real picture of your inventory.<\/li>\n<\/ol>\n

        Checklist: Preparing Your Spreadsheet for Conversion<\/h2>\n

        To ensure your feed works perfectly, check your Excel\/Google Sheet against these points:<\/p>\n

          \n
        • Uniqueness:<\/strong> Each SKU should appear only once.<\/li>\n
        • Price Integrity:<\/strong> Numbers only. No “from $100” or comments inside the price cell.<\/li>\n
        • Media Accessibility:<\/strong> Links to photos must be direct and accessible without passwords.<\/li>\n
        • Category Structure:<\/strong> It is recommended to have a separate column for the category tree (e.g., Electronics > Smartphones<\/em>).<\/li>\n<\/ul>\n

          [PriceCop] XML Converter: How to Create a Universal Language for Your E-commerce<\/h3>\n