Template - Product list update via Google spreadsheet

To make the product list update the most smooth transaction ever, Competera adopted automatic products list update by using Google spreadsheets. 

Google spreadsheet (GS) is like excel but in the cloud :)

Basics: 

1. Competera will create the GS file and host it on our domain. Support Team Lead will manage the file. 
2. Competera will set up a daily automatic update (several updated) of the data from the GS table. 
3. GS will have designated columns outline. Information must be stored within the columns only. 
4. The user will be granted admin access the table in order to makes corrections in the data.
5. There is a possibility to add and delete products, alter prices and change categories. 
6. All changes should be performed within outlined columns and cells, keep the range in line
7. All the data from the GS table will be automatically added to the system for monitoring after each update.
8. All the data that is no longer available in the GS will be removed from the Dashboard.
9. While updating prices, only dots acceptable (ex. 556.50)
10. No empty cells allowed 
11. To remove the product just remove whole line

sample GS is available via the standard - Link example 

Limitations: 

• In some cases Gmail account required. 
• Prod list access could be granted only to a specific list of users