The Mini-Ecommerce solution is a set of tools and processes that allows you to build and own a completely streamlined e-commerce platform yourself, operating entirely within the Google ecosystem. The solution combines familiar tools in a new way to create a smart, simple, and powerful online store.

The solution's three core components include:

• Google Sites: It serves as the storefront (Frontend). This is where customers visit, view products, and place orders.

• Google Sheets: Serving as a data and record-keeping repository (Database), this is where all important information is stored, such as product lists, order details, and store settings.

• Google Apps Script: Acts as the control brain (Backend) or an “automated management staff member.” It connects the frontend and the database, automating tasks such as recording new orders and sending notification emails.

This solution is specifically designed for the following target groups:

• Individual sellers, small businesses, or companies looking to create satellite websites to increase engagement and expand their sales channels.

• Users are already familiar with products within the Google ecosystem such as Google Sheets, Google Drive, Google Docs, Google Apps Script, Google Sites, AppSheet. . .

• Those who truly want to build and own their own platform, with complete control over data and source code.

To make the right decision, you need to clearly understand the limitations of this solution:

• Dependence on Google: The entire store operation is built on Google’s ecosystem. If Google changes policies related to Google Sites, Sheets, or Apps Script, the store’s operation may be affected.

• Limitations of free accounts: Free Google accounts have certain quotas, such as daily email sending limits (100 emails/day) and Google Sheets read/write speed limits (60 requests/minute). Therefore, the system is best suited for small to medium-scale businesses and can efficiently handle around a hundred orders per day.

• Initial setup time required: This is not a “plug-and-play” solution. You need to spend some initial time (around 40–60 minutes) reading the documentation, learning the system, and completing the setup steps.

• Not suitable for heavy traffic: The solution is not designed to handle massive traffic volumes (thousands of simultaneous visitors) like professional e-commerce platforms.

You can easily purchase the solution package by following these steps:

1. Access the homepage at this address www.phongtasia.com.

2. Go to the "Pricing" section.

3. Click the "Buy Solution Package" button and follow the instructions to complete the payment.

After successful payment, you will receive an email containing the following resources:

• Activation code information: This is a unique code used to activate the “Setup Store” tool. You only need to activate it once and can use it for a lifetime.

• A Google Drive link: This link leads to the folder containing the complete solution package, including:

  • Setup Store Tool: An offline tool that helps you design the interface and generate the necessary code snippets for your store.

  • Sample Google Sheet Templates: Includes 2 files:

    1. Order Management (for managing orders)

    2. Product Management (for managing products and promotions)

  • Sample AppSheet Template: Includes the My Store Management app, allowing you to manage your store directly from your mobile device.

• • It’s very simple. You just need to use the “activation code” (including the Order ID and Public Key) provided in the purchase confirmation email to activate the “Setup Store” tool. Simply enter the information into the corresponding fields in the verification interface, then click verify and wait for the system to complete the authentication process, which usually takes about 1 minute. This process only needs to be done once.

  • Once you have all the necessary tools, you are ready to move on to the technical setup phase. The next section will answer common questions that may arise during this process.

The overall process of building a basic store consists of 3 main steps, illustrated as follows:

1. Step 1: Build the “warehouse”: Create Google Sheets data files by copying from the provided sample templates  (1 order management và 2 product management). This is where all of the store’s data will be stored.

2. Step 2: Create the “staff”: Use the “Setup Store” tool to generate Google Apps Script code for product management and order management. After that, you will “deploy” these code scripts.

3. Step 3: Set up the “storefront” : Continue using the “Setup Store” tool to generate HTML code for the store interface, then embed this code into your Google Sites page.

These are two core concepts you will encounter during the setup process. Simply put:

• Google Sheet ID: It is the unique identifier of a Google Sheet file, which you can find in the file’s URL link. Think of it as the “warehouse address”. The “staff” (Apps Script) needs to know this exact address in order to retrieve product data or record new order information.

• Deployment ID: It is an identifier assigned by Google after an Apps Script has been successfully deployed. Think of it as an “employee ID”. This code helps the system recognize and assign the correct tasks to the right “staff member” (for example, assigning product management tasks to the product management staff).

This is a completely normal and mandatory security process from Google. Granting permissions is necessary for the following reasons: 

1. The Apps Script code is created and owned by you. Google needs you to confirm that you trust and allow this script to run on your account.

2. Granting permissions is essentially allowing the “Apps Script staff” to access and interact with the data in your Google Sheets “warehouse” (for example: reading product lists to display on a website, or recording new order information into the system). 

Bạn có thể thêm sản phẩm mới một cách nhanh chóng trực tiếp từ Google Sheets:

1. Open the Google Sheet file 2 product management and go to the sheet named 1 product management.

2. Enter the basic product information into the corresponding columns, such as:Product ID, Product Name, Price, Category Name...

3. For product images: 

   • Upload all images to a folder in Google Drive. Make sure the folder is set to public access ("Anyone with the link").

   • In Google Sheets, select the image cell corresponding to the product, then use the Your Image menu on the toolbar to automatically select and insert the image link.

4. For detailed product descriptions:

   • Create a Google Docs file containing the full product description. 

   • In that Google Docs file, go to File > Share > Publish to web.

   • Copy the link from the Embed section and paste it into the Product document column in Google Sheets.

The system allows you to create multiple flexible promotion scenarios. To set this up, open the file 2 product management and go to the sheet named 2 setting coupon management. Here, you can create promotional campaigns with various options:

• Discount by percentage (%) or a fixed amount (fixed).

• Apply to the entire order (Total).

• Apply to one or more specific products (Product).

• Apply to one or more specific product categories (Category). 

Order management is very intuitive and simple:

1. Open the Google Sheet file 1 order management. All new orders from the website will be automatically recorded here in real time.

2. To update the status of an order (for example: “Confirmed,” “Shipped to carrier”), you only need to edit the content in the “Order Status” column of that order.

3. To automatically send an email notification about this status change to the customer, simply tick the checkbox in the “Send notification to customers” column. An automated trigger will immediately send the updated email to the customer. 

The solution supports deep integration with Google Analytics, Google’s leading website analytics tool.

1. You need to create a Google Analytics account and obtain the required information: "Measurement ID" and "Data stream API (Secret value)".

2. Paste this information into the sheet 3 setting google analytics in the Google Sheet file  2 product management.

3. Once successfully connected, you can track important customer behaviors such as product views (view_item), adding items to cart (add_to_cart), and completing purchases (purchase). This data is extremely valuable for analyzing and optimizing your business strategy.

This is a common issue caused by the limitations of free Gmail accounts, and the solution includes an extension feature to address it. 

1. Issue: A free Gmail account only allows sending up to 100 emails per day. If your store receives more than 100 orders, customers after that limit will not receive confirmation emails. 

2. Solution: The extension feature allows you to connect and use additional secondary email accounts (for example: mystore2@gmail.com, mystore3@gmail.com).

3. How it works: When the primary email reaches its daily sending limit, the system will automatically switch to using secondary email accounts to continue sending order confirmation emails to customers. This significantly increases the store’s sending capacity.

This is one of the most common errors and usually has a very simple cause:

• Cause: It is likely that the images or the folder containing the images in your Google Drive have not been set to public sharing mode. The system does not have permission to access them for display.

• Solution: Go to Google Drive, right-click the folder or image file, select “Share,” and make sure the access permission is set to “Anyone with the link.”

• The definitive answer is NO.

• Explanation: The entire automation system operates based on the default structure and naming of columns and sheets in the template Google Sheets file. Any changes to the names or order of columns/sheets will disrupt the data flow and cause system errors.

• Note: However, you CAN add completely new sheet names to the Google Sheets file for your own management purposes (for example: inventory management, expense tracking) without affecting the system’s operation.

For the most visual and detailed guidance, you can access our video system by following these steps:

• Go to the website www.phongtasia.com.

• Navigate to Guides > Tutorial video. Here, you will find a full series of instructional videos covering all steps from purchasing, activation, setup, to operating your store.

>>>View the configuration table here

>>>Link to copy template Appsheet My Store Management

>>>>>>Link Guide For Begin