# File as the Main Store: How to connect Google Sheets

Aside from the shopping carts and LitCommerce itself, LitCommerce supports two file types as the Main Store: [CSV](https://litcommerce.gitbook.io/litcommerce-helpdesk/marketplace-integration/supported-platforms/files/file-as-the-main-store-how-to-connect-csv) & Google Sheets.

This article outlines the instructions for connecting a Google Sheet as the Main Store to your LitCommerce account.

## <mark style="color:$primary;">**Step 1: Select Google Sheets as the Main Store**</mark>

{% stepper %}
{% step %}
Log in to your LitCommerce account. If you don’t have one, sign up [HERE](https://app.litcommerce.com/login).

If this is your first setup, choose your desired LitCommerce app: **Marketplace Integration** or **Feed Management**.

<figure><img src="/files/yVR7hjrHUvuixxqHITt7" alt=""><figcaption></figcaption></figure>

{% hint style="success" %}
**If you select the Marketplace Integration app, choose "Your online store becomes the source of truth" and click `Next` to proceed.**
{% endhint %}

<figure><img src="/files/cSANxzyw0ywHkIMH0IAr" alt=""><figcaption></figcaption></figure>

{% endstep %}

{% step %}
Locate the Files section, and click `Add Google Sheet`.

<figure><img src="/files/b7iH4W4lt4GcgWcX3KP1" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

## <mark style="color:$primary;">**Step 2: Enter required information**</mark>

Once select Google Sheets, you will need to complete the following stages to connect your Main Store.

{% stepper %}
{% step %}
Enter your Store Name and File Name.

<figure><img src="/files/NciPUYTqwuJlEZY9aIRs" alt=""><figcaption></figcaption></figure>

{% endstep %}

{% step %}
Select your Type of Import.

<figure><img src="/files/iGUnL0uuqn1Lj2SvHGLA" alt=""><figcaption></figcaption></figure>

* **Add New & Update:** This option allows new product/data to be retrieved into our system, and updates existing data.

* **Update Only:** Only existing data in our system will be updated when selecting this option. New/non-existing data will be skipped.

{% endstep %}

{% step %}
Enter your file URL and click `Next` to proceed.

<figure><img src="/files/VskiXAFHAriMCw6AxAkc" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

## <mark style="color:$primary;">**Step 3: Fields mapping**</mark>

After clicking `Next`, the interface for mapping your file fields to the LitCommerce fields will appear.&#x20;

Mapping refers to the essential process of connecting data fields between your Main Store and LitCommerce so that product information flows correctly to our system and the sales channels.

<figure><img src="/files/KqE9QBTg2OrPsUjDGfXM" alt=""><figcaption></figcaption></figure>

{% hint style="success" %}
**The AI-Field Mapping feature automatically maps your Main Store fields to the LitCommerce fields, even when they only have similar meanings or are in a different language. This helps you speed up the setup process.**
{% endhint %}

<figure><img src="/files/zyRZujOv8po4Nsih5629" alt=""><figcaption></figcaption></figure>

Here, you will see two field types:

* **Standard fields:** They are predefined by LitCommerce based on standard fields across platforms, ensuring key data is included when transferring data from the Main Store to the sales channels. LitCommerce will automatically map these fields to the matching fields in your file.

<figure><img src="/files/GXFFFPLb01miKulhQhEu" alt=""><figcaption></figcaption></figure>

* **Custom fields:** These are a group of flexible data fields that you can add aside from the standardized fields. These fields are not required and can be used to store additional information depending on how you manage your data. The number of custom fields is unlimited, but will not be automatically transferred to the sales channels.

<figure><img src="/files/pDa2jpxs1wob2uiNVH6j" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}

* **The Product ID field is the primary key for identifying matching products between your file and LitCommerce. If multiple products share the same Product IDs, they will be considered as one item.**

* **The Parent SKU field is for grouping the variations under the correct parents. Skip this field if your products are simple format.**

* **The Images field helps retrieve your product images into our system. Each image URL must be placed in a separate column of your CSV file. This allows LitCommerce to import multiple images for your products.**
  {% endhint %}

Once all fields are mapped correctly, click `Save` to complete the connection process.

<figure><img src="/files/v8OIfXx4lvAANkKbCIvG" alt=""><figcaption></figcaption></figure>

If you have any questions, let us know via the Chat Box in the bottom-right corner of our Help Center.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.litcommerce.com/marketplace-integration/supported-platforms/files/file-as-the-main-store-how-to-connect-google-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.