Articles on: Marketplace Basics & Setup

File as the Main Store: How to connect CSV

In addition to shopping cart integrations, LitCommerce also supports connecting Main Stores using files like CSV or Google Sheets.

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

Step 1: Select CSV File as the Main Store

Locate the Files section, and click on Add CSV File.

Step 2: Enter required information

Once select CSV, 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.

Select your preferred Import Method.

Please select one of the two below Import Methods depending on your usage purposes.

CSV - URL Download

Enter your file URL.

Select your authentication method based on the access validation setup of your file - there are 4 options:

No Authentication: LitCommerce’s default authentication method for all URLs.

Basic & Digest Authentication: You need to provide the username and password for the entered file URL.

Authentication header: A token generated by the server that contains your file will need to be provided.

Amazon S3: Use this method when your file URL’s source is Amazon S3 - a cloud storage service provided by Amazon Web Services (AWS). You need to enter your AWS Access Key ID and AWS Secret Access Key.

If an authentication method is selected when the entered file URL does not require verification, LitCommerce can still process the file.

CSV - SFTP/FTP

To proceed with the connection, please correctly enter the following information.

Host: Enter the server address where the file is stored (can be a domain name or an IP address). For example: ftp.example.com or 192.168.1.100. Please do not include prefixes, such as http://, https://, ftp://, sftp://.
Directory Path: The entered value should start with a /, which represents the root directory or a specific directory on the server. For example: /data/products.csv or /products.csv.
Username.
Password.

Step 3: Test Connection

Once the required details are entered, please click Test Connection for LitCommerce to check the readability of your file. From there, you will find the following information.

Encoding.
Quoting.
Delimiter.

This information determines how your data will be stored and displayed in our system. LitCommerce will automatically detect and assign the suitable Encoding, Quoting, and Delimiter based on the CSV file data. You can still update them per your preference.

To proceed with the next step, please click Next.

Step 4: 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!