Online price list in Google tables Author: PriceCop Saturday April 6th, 2019 • Category: Blog • Updated: Friday April 4th, 2025 The fastest and quite convenient way to create an accessible online price list is through Google Sheets. Content List Why is it fast? Why is it convenient? It’s FREE forever! [ IMPORTANT! ] Examples of Google Sheets–based online price lists Why is it fast? Because you can create your own online price list in just a couple of minutes. Unlike XML/YML exports from accounting systems or CMS, a Google Sheets–based price list requires no special setup—simply copy the data from your “offline price list” (for example, exported from 1C) into a sheet stored in your Google account. Why is it convenient? After exporting your price list from your accounting system (e.g., 1C), you can place it online so that it’s available not only to the PriceCop price monitoring system but also to your partners—online and offline stores, wholesale clients, regional representatives, etc. Having an up-to-date online price list allows partners to always have the latest information about suppliers’ 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. Google Sheets price lists are accessible from any device—desktops or mobile devices. It’s FREE forever! A price list in a Google document is just a regular spreadsheet, which you can host under your Google account—https://sheet.new—completely free of charge. Content Your price list can contain any fields you want, including (but not limited to): product code (unique ID in the client’s accounting system); product name; brand; price (RRP/MRP/RIC); availability; URL (link to the product page on your website). [ IMPORTANT! ] Key requirements for a Google Sheets online price list A fully populated price list must be on the sheet that was originally created when creating the Google Sheet (in Russian, “Лист1”; in English, “Sheet1”). If this sheet is deleted, the system won’t 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. The price list link in Google Sheets must be static and public. Access settings: “Anyone with the link can view.” Other settings won’t allow the system to access the file. A static data structure is mandatory—the layout of data columns, field headers, and the header row’s position must remain the same. In other words, the “header” must remain in the same row established initially and must not change position when the price list data is updated. No merged cells—each product must be in its own row, with a unique product name. No conditional formatting. Examples of Google Sheets–based online price lists Mир Автокресел (“Mir Avtokresel”): https://docs.google.com/spreadsheets/d/1hdiqUBcfZax5sXOLw4Kj5tdHQ5AqIeTxrfVfF4tVmJc/edit?usp=sharing Беккер-Украина (“Bekker-Ukraine”): https://docs.google.com/spreadsheets/d/1_Q7iCZQvRPl91iJdwD0_Kh2SfCjszMopc2pup8Wz9Ao/edit?usp=sharing Example structure: https://docs.google.com/spreadsheets/d/11gz-rIdsk-cRDlWnHQKV357EN1ZRpqfVjxIQSnSPDcs/edit#gid=0 Download the example structure: https://docs.google.com/spreadsheets/d/11gz-rIdsk-cRDlWnHQKV357EN1ZRpqfVjxIQSnSPDcs/copy