BUILD A BASIC STORE AND EXPAND TO INCLUDE ADVANCED FEATURES
1. LIST OF TASKS TO BE COMPLETED
2. BASIC SETUP - PHASE 1: BUILDING A GOOGLE SHEETS DATA "WAREHOUSE" - COPYING SAMPLE GOOGLE SHEETS FILES
2.1 Objectives and Preparation
2.2 Implementation Steps - Creating a Data "Warehouse"
2.2.1 Creating “1 order management”
a) The identifier string, also known as the Google Sheet ID:
b) Child sheet names:
2.2.2 Creating “2 product management”
a) The identifier string, also known as the Google Sheet ID:
b) Child sheet names:
2.3 Results and review of tasks to be completed in this step
3. BASIC SETUP – PHASE 2: A-CREATE PRODUCT CATALOG MANAGEMENT STAFF - CREATE APPS SCRIPT FILES AND DEPLOY FOR PRODUCT MANAGEMENT
3.1 Objectives and Preparation
3.2 Steps to follow - Create a product catalog manager
3.2.1 Phase 1 Offline – Create the '2 product management' Apps Script using the offline tool "Setup Store" - or what can be called creating a "Product Catalog Management Staff"
Step 1: Obtain the Google Sheet ID of the Google Sheet file ‘2 product management’ – this step can be considered obtaining the “warehouse address” of the “product catalog data warehouse”.
Step 2: Create the Apps script code for “2 product management” – this step can be followed by creating the first employee, “product catalog manager employee”.
Step 3: Create the Apps Script code for “2 product management” – or in other words, create a “product catalog management employee”.
3.2.2 Phase 2 Online – Deploying the newly created '2 product management' Apps Script – Or, in other words, assigning tasks to the "product catalog management staff".
Step 1: Create an Apps Script ‘2 product management’ linked to the Google Sheet ‘2 product management’ – or in other words, assign tasks to the product catalog management staff.
Step 2: Deploy the '2 product management' Apps Script code you just created using the "Setup Store" tool to the online environment – or, in other words, assign "employee codes" to the product catalog management staff.
❖ How to View “Deployment ID”: We will check the newly created “Employee ID” as follows:
3.3 Review and double-check the tasks to be completed in this step.
4. BASIC SETUP – PHASE 2: B - CREATING ORDER MANAGEMENT STAFF - CREATING APPS SCRIPT FILES AND IMPLEMENTING FOR ORDER MANAGEMENT
4.1 Objectives and Preparation
4.2 Steps to follow - Create order management staff
4.2.1 Phase 1 Offline – Create the '1 order management' Apps Script using the offline tool "Setup Store" - or what can be called creating an "Order Management Staff"
Step 1: Obtain the Google Sheet ID of the Google Sheet file ‘1 order management’ – this step can be considered obtaining the “warehouse address” of the “order information data warehouse”.
Step 2: Create the Apps script code for “1 order management” – this step can be considered creating a second employee, the “order management employee”.
4.2.2 Phase 2 Online – Deploying the newly created '1 order management' Apps Script – Or, in other words, assigning tasks to the "order management staff".
Step 1: Create an Apps Script ‘1 product management’ linked to the Google Sheet ‘1 product management’ – or in other words, assign tasks to the order management staff.
Step 2: Deploy this Apps Script – or in other words, assign "employee IDs" to order management staff.
Step 3: Enable Triggers for the Apps Script you just deployed – or you can think of it as scheduling extra work for order management staff.
❖ How to View “Deployment ID”: We will check the newly created “Employee ID” as follows:
4.3 Review and check the tasks to be completed in this step.
5. BASIC SETUP - PHASE 3: CREATING THE STORE FRONTAGE – GENERATING THE CODE FILE FOR THE STORE PAGE AND DEPLOYING IT TO GOOGLE SITES
5.1 Objectives and Preparation:
5.2 Steps to follow
5.2.1 Phase 1 Offline – Creating the “storefront”
5.2.1.1 Step 1: Obtain the Deployment ID: Product Management and fill in the information in the field.
5.2.1.2 Step 2: Obtain the Deployment ID: Order Management and fill in the information in the field.
5.2.1.3 Step 3: Create code to paste into Google Site – Create a “storefront”
5.2.2 Phase 2 Online – Deploying the “store google site” code to Google Sites – Also known as launching the store.
5.2.2.1 Step 1: Open your Google Sites page at https://sites.google.com
5.2.2.2 Step 2: Paste the code
5.3 Review and check the tasks to be completed in this step.
6. EXTENDED SETUP: CONNECTING APPS SHEET
6.1 Objectives and Preparation
6.2 Steps to follow
6.2.1 Step 1: Copy App
6.2.2 Step 2: Connect the newly created app to your data.
Establish a link to reconnect with your actual Google Sheet data.
6.2.3 Step 3: Set up to receive notifications on your phone when a new order is placed.
6.2.3.1 Step 3.1: Fill in email information
a) Fill in your email address in the "1 order management" table.
b) Enter your email address into the "Automation Bot"
6.2.3.2 Step 3.2: Enable Access Key
6.2.4 Step 4: Check if you are receiving notifications on the My Store Management app.
4.2.4.1 Step 4.1: Install the My Store Management app on your phone.
4.2.4.2 Step 4.2: Setting up notifications
6.3 Review and check the tasks to be completed in this step.
7. EXTENDED SETUP: CONNECT WITH GOOGLE ANALYTICS
7.1 Objectives
7.2 Steps to follow
7.2.1 Step 1: Create an account and log in to the Google Analytics homepage https://analytics.google.com/, log in using Gmail -> click on “Start measuring”
7.2.2 Step 2: Fill in the information to create an account. For example: Account name: “My store” -> Click “Next”
7.2.3 Step 3: Create Property: Fill in the Property name (e.g., mystore), select the time zone, and currency -> Click Next
7.2.4 Step 4: Create Business details: select Shopping category, scale 1-10 people -> Click Next
7.2.5 Step 5: Select Busness Objectives as figure : Generate leads, Drive sales, Understand web and/or app traffic, View user engagement and retention-> Click Create
7.2.6 Step 6: Select your region (e.g., Vietnam), tick “I also accept the…” -> Click “I Accept”
7.2.7 Step 7: A window opens -> you select the web platform
7.2.8 Step 8: Enter the direct access path to your store's website, name the stream (as shown below) -> Click "Create & continue"
7.2.9 Step 9: An information window will open where you will see “Measurement ID”: G-xxxxxxxxxxx -> Copy this information and paste it into the “Measurement ID” column in the Google Analytics configuration table in the Google Sheet file “2 product management” -> into sheetname “3 setting google analytics”.
7.2.10 Step 10: In the same “Web stream details” window, scroll down and click on “Measurement Protocol API secrets”
7.3 Review and check the tasks to be completed in this step.
7.3.1 Step 1: Go to Google Analytics for the account and property you just created > click on Report > click on Realtime overview
7.3.2 Step 2: Go to your store page, for example www.mystore.com/store, and click the "Buy Now" button. Immediately, an event called "view" will be sent to Google Analytics, and it will be displayed in the Realtime Overview window.
8. EXTENDED SETTINGS: CONNECT TO SECONDARY WEB APPS AND SCRIPT TO ENCOURAGE EMAIL SENDING INCREASE FEATURE
8.1 Objectives
8.2 Steps to follow
8.2.1 Step 1: Deploy the feature on secondary email accounts
8.2.1.1 Step 1.1: Log in to Google App Script
8.2.1.2 Step 1.2: Create SECRET_KEY
8.2.2 Step 2: Fill in the configuration table in the Google Sheets file 1 order management > sheet name “4 setting quotas email”
8.2.3 Step 3: Enable the extended features and perform a test.
8.2.3.1 Enable the extended features for use:
8.2.3.2 Perform functional testing (Optional)
8.3 Review and check the tasks to be completed in this step.
LIST OF TASKS TO BE COMPLETED
| --- | --- | --- | --- | --- | --- | --- |
Do you remember the steps that needed to be taken?