{"id":660,"date":"2019-04-06T18:13:56","date_gmt":"2019-04-06T15:13:56","guid":{"rendered":"https:\/\/pricecop.net\/?p=660"},"modified":"2025-04-04T09:58:42","modified_gmt":"2025-04-04T06:58:42","slug":"online-google-price","status":"publish","type":"post","link":"https:\/\/pricecop.net\/en\/blog\/online-google-price\/","title":{"rendered":"Online price list in Google tables"},"content":{"rendered":"<p><\/p>\n<p>The fastest and quite convenient way to create an accessible online price list is through Google Sheets.<\/p>\n<p> <!--more--> <img decoding=\"async\" class=\"size-full wp-image-1319 aligncenter lazyload\" data-src=\"https:\/\/pricecop.net\/wp-content\/uploads\/2020\/03\/online-price.png\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 770px; --smush-placeholder-aspect-ratio: 770\/433;\" \/> <\/p>\n<hr \/>\n<p class=\"content-list\">Content List<\/p>\n<ul>\n<li><a href=\"#content-list-title-1\" title=\"Why is it fast?\">Why is it fast?<\/a><\/li>\n<li><a href=\"#content-list-title-2\" title=\"Why is it convenient?\">Why is it convenient?<\/a><\/li>\n<li><a href=\"#content-list-title-3\" title=\"It\u2019s FREE forever!\">It\u2019s FREE forever!<\/a><\/li>\n<li><a href=\"#content-list-title-4\" title=\"[ IMPORTANT! ]\">[ IMPORTANT! ]<\/a><\/li>\n<li><a href=\"#content-list-title-5\" title=\"Examples of Google Sheets\u2013based online price lists\">Examples of Google Sheets\u2013based online price lists<\/a><\/li>\n<\/ul>\n<h2 id=\"content-list-title-1\">Why is it fast?<\/h2>\n<p>Because you can <a href=\"https:\/\/sheet.new\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">create your own online price list<\/a> in just a couple of minutes. Unlike XML\/YML exports from accounting systems or CMS, a Google Sheets\u2013based price list requires no special setup\u2014simply copy the data from your \u201coffline price list\u201d (for example, exported from 1C) into a sheet stored in your Google account.<\/p>\n<p> &nbsp; <\/p>\n<h2 id=\"content-list-title-2\">Why is it convenient?<\/h2>\n<p>After exporting your price list from your accounting system (e.g., 1C), you can place it online so that it\u2019s available not only to the <a href=\"https:\/\/pricecop.net\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">PriceCop price monitoring system<\/a> but also to your partners\u2014online and offline stores, wholesale clients, regional representatives, etc.<\/p>\n<p>Having an up-to-date online price list allows partners to always have the latest information about suppliers\u2019 products. In addition to simply viewing the information, updates from online price lists can be automated, ensuring rapid updates of prices and stock availability. Hosting your price list online saves a lot of time and eliminates the outdated method of sending files by email.<\/p>\n<p>Google Sheets price lists are accessible from any device\u2014desktops or mobile devices.<\/p>\n<h2 id=\"content-list-title-3\">It\u2019s FREE forever!<\/h2>\n<p>A price list in a Google document is just a regular spreadsheet, which you can host under your Google account\u2014<a href=\"https:\/\/sheet.new\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">https:\/\/sheet.new<\/a>\u2014completely free of charge.<\/p>\n<h3>Content<\/h3>\n<p>Your price list can contain any fields you want, including (but not limited to):<\/p>\n<ul>\n<li>product code (unique ID in the client\u2019s accounting system);<\/li>\n<li>product name;<\/li>\n<li>brand;<\/li>\n<li>price (RRP\/MRP\/RIC);<\/li>\n<li>availability;<\/li>\n<li>URL (link to the product page on your website).<\/li>\n<\/ul>\n<h2 id=\"content-list-title-4\">[ IMPORTANT! ]<\/h2>\n<h3>Key requirements for a Google Sheets online price list<\/h3>\n<ol>\n<li>A <b>fully populated price list must be on the sheet<\/b> that was originally created when <a href=\"https:\/\/sheet.new\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">creating the Google Sheet<\/a> (in Russian, \u201c\u041b\u0438\u0441\u04421\u201d; in English, \u201cSheet1\u201d). If this sheet is deleted, the system won\u2019t be able to import data from that document. The entire price list should be on this single sheet. Data on other sheets will not be imported.<\/li>\n<li>The <b>price list link<\/b> in Google Sheets must be static and public. Access settings: \u201cAnyone with the link can view.\u201d Other settings won\u2019t allow the system to access the file.<\/li>\n<li>A <b>static data structure<\/b> is mandatory\u2014the layout of data columns, field headers, and the header row\u2019s position must remain the same. In other words, the \u201cheader\u201d must remain in the same row established initially and must not change position when the price list data is updated.<\/li>\n<li><b>No merged cells<\/b>\u2014each product must be in its own row, with a unique product name.<\/li>\n<li><strong>No conditional formatting<\/strong>.<\/li>\n<\/ol>\n<h2 id=\"content-list-title-5\">Examples of Google Sheets\u2013based online price lists<\/h2>\n<p>M\u0438\u0440 \u0410\u0432\u0442\u043e\u043a\u0440\u0435\u0441\u0435\u043b (\u201cMir Avtokresel\u201d):<\/p>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1hdiqUBcfZax5sXOLw4Kj5tdHQ5AqIeTxrfVfF4tVmJc\/edit?usp=sharing\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">https:\/\/docs.google.com\/spreadsheets\/d\/1hdiqUBcfZax5sXOLw4Kj5tdHQ5AqIeTxrfVfF4tVmJc\/edit?usp=sharing<\/a><\/p>\n<p>\u0411\u0435\u043a\u043a\u0435\u0440-\u0423\u043a\u0440\u0430\u0438\u043d\u0430 (\u201cBekker-Ukraine\u201d):<\/p>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1_Q7iCZQvRPl91iJdwD0_Kh2SfCjszMopc2pup8Wz9Ao\/edit?usp=sharing\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/docs.google.com\/spreadsheets\/d\/1_Q7iCZQvRPl91iJdwD0_Kh2SfCjszMopc2pup8Wz9Ao\/edit?usp=sharing<\/a><\/p>\n<p>Example structure:<\/p>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/11gz-rIdsk-cRDlWnHQKV357EN1ZRpqfVjxIQSnSPDcs\/edit#gid=0\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">https:\/\/docs.google.com\/spreadsheets\/d\/11gz-rIdsk-cRDlWnHQKV357EN1ZRpqfVjxIQSnSPDcs\/edit#gid=0<\/a><\/p>\n<p>Download the example structure:<\/p>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/11gz-rIdsk-cRDlWnHQKV357EN1ZRpqfVjxIQSnSPDcs\/copy\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">https:\/\/docs.google.com\/spreadsheets\/d\/11gz-rIdsk-cRDlWnHQKV357EN1ZRpqfVjxIQSnSPDcs\/copy<\/a><\/p>\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Sorry, this entry is only available in UA.<\/p>\n","protected":false},"author":1,"featured_media":1614,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-660","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pricecop.net\/en\/wp-json\/wp\/v2\/posts\/660","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pricecop.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pricecop.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pricecop.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pricecop.net\/en\/wp-json\/wp\/v2\/comments?post=660"}],"version-history":[{"count":3,"href":"https:\/\/pricecop.net\/en\/wp-json\/wp\/v2\/posts\/660\/revisions"}],"predecessor-version":[{"id":2161,"href":"https:\/\/pricecop.net\/en\/wp-json\/wp\/v2\/posts\/660\/revisions\/2161"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pricecop.net\/en\/wp-json\/wp\/v2\/media\/1614"}],"wp:attachment":[{"href":"https:\/\/pricecop.net\/en\/wp-json\/wp\/v2\/media?parent=660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pricecop.net\/en\/wp-json\/wp\/v2\/categories?post=660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pricecop.net\/en\/wp-json\/wp\/v2\/tags?post=660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}