Lidia Commerce Documentation

In the previous steps, you prepared your product data model and pool. In this guide, you will learn how to add products to Lidia PIM, either individually or in bulk using Excel, and how to publish them.

🚀 Add and Publish Products in PIM

The product creation process works according to the data model you prepared. Product information is created based on the fields defined in the data schema connected to the relevant pool.

Lidia icon Before Adding Products

Important

Before adding products to the system, make sure the following structures have been configured.

✓

1. A product data schema must be created.

To learn how to create a data schema → How to Create a Data Schema?

✓

2. Product properties and options must be defined.

To learn how to define properties and options → How to Define Properties and Options?

✓

3. The defined properties and options must be added to the data schema.

To learn how to configure data schema fields → How to Add Properties and Options to a Data Schema?

✓

4. A product category must be created and connected to the data schema.

To learn more → How to Create a Category?

✓

5. A pool linked to the relevant category must be created.

To learn how to create and manage pools → Understand and Manage Pools

Lidia icon How Do Asynchronous Operations Work?

Some operations in Lidia PIM continue asynchronously in the background. You can continue working in other areas of PIM while the operation is processed.

Track these processes from the Operations section in the upper-right corner.

Import Operations

Product imports are processed asynchronously. Their status can be tracked as In Progress or Completed.

When processing is completed, open the related operation and continue manually to validation.

Export Operations

Product exports are also prepared asynchronously. When the export is completed, you receive a notification.

Open the completed operation and click Download.

Operations panel

Lidia icon How to Download the Excel Template?

To add multiple products, first download the Excel template generated for the pool.

Complete the following 5 steps
1
Open Pools
Catalog > Pools
2
Open the Pool

Find the pool and click Manage Products.

Manage Products
3
Click Add Products

Click Add Products.

Add Products
4
Select Add Multiple Products

Select Add Multiple Products.

Add Multiple Products
5
Download the Draft Template

Click Download Draft Template.

Pool-Specific Excel Template

Each pool has its own Excel template. The template is generated according to the data schema and fields connected to that pool.

Lidia icon How to Fill in the Excel File?

The Excel file contains the fields required to add product information.

Template Information

Provides information about the fields included in the template.

Products

The main sheet where product information is entered.

Template Information Sheet

This sheet shows field names, descriptions, and whether each field is required or optional.

Required Fields

Required fields are highlighted in red. If these fields are left empty, an error occurs during product import.

Product Import Template Guide

System-Generated Fields

Some fields are standard across pools and are included by the system.

Required

The following fields are required and must be completed:

  • Product Name
  • Item Code
  • Merchant Item Code
  • Group Code
  • Image Code
  • Product Status
  • Pool Status
Optional

The following fields are optional:

  • General Tags
  • Badge Tags
  • Administrative Tags
  • Other Tags
Read Only

The following fields are read-only:

  • Updated Date
  • Created Date

Lidia icon How to Add a Single Product?

Start the process 3 steps
1
Open Pools
Catalog > Pools
2
Open the Pool

Find the pool where you want to add the product and click Manage Products.

Manage Products
3
Select Add Single Product

Click Add Products at the top of the pool detail page.

Add Products

Select Add Single Product.

Enter the following required information:

  • Product Name
  • Product Code

Click Continue.

Draft Behavior

If you leave the creation process at this stage, the product is saved as a draft and can be accessed from the Drafts tab.

Add Single Product

Single product creation consists of four main stages:

Single Product Stages
1
Basic Information

Complete the main information required to create the product.

Product Title Item Code Category Brand Data Schema Merchant Item Code Group Code Image Code

All Basic Information fields are required. Data Schema is automatically populated and read-only.

Image Code

If Image Code matches an existing media code, the related image automatically appears in Media.

Basic Information
2
Properties

Properties added to the pool's data schema are listed here. Complete all fields defined as required.

3
Order Information

Reference fields and product management tags are displayed in this step.

General Tags Attribute Tags Badge Tags Administrative Tags
Publishing Requirement

Both Pool Item Status and Product Status must be Active before publishing.

Order Information
4
Media

If Image Code matches an existing media code, the image is displayed automatically.

Otherwise, click Add New Image to upload product images.

Media

Lidia icon How to Add Multiple Products?

To add multiple products to a pool at once, use an Excel file.

Upload Excel → Asynchronous Processing → Operations → Validation → Products Added to Pool
Complete the following 9 steps
1
Open Pools
Catalog > Pools
2
Open the Pool

Find the pool where you want to upload products and click Manage Products.

3
Select Add Multiple Products

Click Add Products and select Add Multiple Products.

4
Upload the Excel File

Click Click to upload file and select the completed Excel file.

Only .xlsx files can be uploaded.

5
Start the Import

Click Continue.

The import now continues asynchronously in the background.

6
Track the Import from Operations

You can continue working in other areas of PIM while the file is processed.

Track the operation from Operations.

  • In Progress — processing continues.
  • Completed — background processing is complete.

You receive a notification when processing is completed.

7
Open the Import Operation

Open the completed operation from Operations.

The system directs you to the validation page.

Open Import Operation
8
Review Validation Results

Review the validation results before completing the import.

If errors are found, correct them. If validation is successful, click Continue.

Validation Results
9
Import Completed
🎉 Product import is complete.

The products have been added to the pool and are ready for publishing.

Lidia icon How to Publish Products in a Pool?

Complete the following 8 steps
1
Select Products

Go to the All tab and select the products you want to publish.

2
Publish Products

Click Publish Products.

Publish Products
  • Publish only the selected products
  • Publish the entire product pool
3
Continue

Select the publishing scope and click Continue.

4
Validate Products

The system checks whether All Products Can Be Published.

All Products Can Be Published

Click Continue.

5
Review Products

Products are grouped under:

  • New Products
  • Updated Products
  • New Variants
  • Updated Variants

First-time uploads appear under New Products and New Variants. Updates to existing records appear under Updated Products and Updated Variants.

Modified fields are highlighted in yellow.

6
Approve and Publish

Click Approve and Publish.

7
Confirm Publishing

In the opened window, click Publish.

Confirm Publishing
8
Product Published
🎉 You have added and published your first product in PIM.

Lidia icon Possible Errors During Excel Upload

During validation, the system checks whether the Excel file contains missing or invalid product information.

Excel Import Validation Errors
⚠️ Lidia Code Is Filled In

Lidia Code is generated automatically by the system.

Solution: Leave the Lidia Code field empty.

⚠️ Required Fields Are Empty

Required fields cannot be left empty.

Solution: Complete all required fields.

⚠️ Product Image Is Missing

Products cannot be published without the required image information.

Solution: Upload the required images.

⚠️ Invalid File Format

Only .xlsx files are supported.

Solution: Upload the file in .xlsx format.

⚠️ Empty Excel File

An empty product file cannot be imported.

Solution: Complete the product rows.

⚠️ Product Status Is Not Active

The product cannot be published while inactive.

Solution: Set Product Status to Active.

Lidia icon Possible Scenarios During Product Publishing

During publishing, additional validations are performed. Publishing may be fully successful, partially successful, or blocked.

⚠️ Partial Publishing

If some products meet the publishing requirements while others do not, the system displays a Partial Publishing warning.

Publishable and non-publishable product counts are displayed separately.

Possible reasons include:

  • Product status is not active
  • Required content fields are missing
  • Required properties have not been completed
Partial Publishing
⚠️ No Products Can Be Published

If none of the selected products meet the publishing requirements, publishing is blocked.

Recommended actions:

  • Complete missing product information
  • Set Product Status to Active
  • Complete all required fields
  • Review the affected products
No Products Can Be Published

Lidia icon Post-Import Checks

After import, verify that the products have been added to the pool correctly and published successfully.

Published products appear under both the All and Published tabs.

Published Products

Published products are also listed under Catalog > Products and Catalog > Variants.

‍

‍

‍

‍

‍

‍

‍

‍

‍

‍

‍

<FOOTER>