Articles on: Marketplace Basics & Setup

File as the Main Store: How to connect Google Sheets

Aside from the shopping cart integrations, LitCommerce supports two file types as the Main Store: CSV & Google Sheets.

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

Step 1: Select Google Sheets as the Main Store

Locate the Files section, and click Add Google Sheet.

Step 2: Enter required information

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

Enter your Store Name and File Name.

Select your Type of Import.

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.

Enter your file URL and click Next to proceed.

Step 3: Attribute mapping

After clicking Next, the interface for mapping your file fields to the LitCommerce fields will appear. 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.

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.

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.

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.

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

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

Updated on: 07/08/2025

Was this article helpful?

Thank you!