Skip to content
English
  • There are no suggestions because the search field is empty.

Manually edit a product sheet - data lock

Introduction 

SellRapido allows the manual editing of a product sheet.

After making the change, to ensure that the edited data is not overwritten during the overnight catalogue update, it is necessary to carry out an operation called  Lock fields.

There are two ways to lock data:

  • the first is mainly used to control the price of a product on a certain marketplace/e-commerce site
  • the second is mainly used to edit, within the product sheet, the master data from the source file

N.B.: in EAN-based sales channels (such as Amazon) only the sale price and shipping costs can be changed.


Data locking - Method 1

This method is mostly used to openly control the price of a product on a given marketplace/e-commerce site.

To lock the price using this method:

1. Access the product sheet and go to the Marketplace tab.

2. Select the channel row on which you want to set a different fixed price and enter the desired price.

3. Click on  Lock fields at the top.

4. A window will open with a list of the fields on which you can activate the lock. 

In this window, select Price and then click on OK.

5. The locked price will have a grey background. 

N.B.: if product stock finishes and there is no active relevance on the Marketplace where the data was locked, the publication will be removed and locked data will be lost.

To avoid this, we suggest locking at least one of the fields in the product sheet using Method 2.


Data locking - Method 2

This method is used to edit the product sheet master data upstream of the source file.

N.B.: unlike in method 1, here a product with at least one locked field remains in SellRapido even if the product is no longer in the listing (possibly marked as “out of stock”) .

To lock the data, follow these steps:

1. Enter a product sheet.

2. Choose the data to edit and make the change.

3. In the bottom right corner, click on Lock fields.

4. A window will open with a list of the fields on which you can activate the lock.

Flag the fields that should be excluded from any automatic update procedure. 

These fields can be edited only manually, and the data entered will not be overwritten by the bulk import of the upstream catalogue.

When at least one field is flagged, the lock button turns red (indicating that there are locked fields).


How to remove the field block from out-of-stock products (Field Lock button) 

With this button you can remove the field block from out of stock products, so that they disappear from the catalog.

1. When no catalog is selected, the Field Lock button is disabled and cannot be clicked.

rimozione_blocco_campi_01_eng

2. Once a catalog is selected, the Field Lock button becomes active. 

rimozione_blocco_campi_02_eng

3. Clicking Field Lock opens a dropdown with the option Remove from Depleted Products

rimozione_blocco_campi_03_eng

4. Clicking Remove from Depleted Products checks the catalog for eligible products:

4a. If no depleted products with an active field lock are found, an informational alert is shown and no changes are made.

rimozione_blocco_campi_04_eng

4b. If eligible products are found, a confirmation dialog is shown displaying the number of affected products, the catalog name, and an irreversibility warning. The user must click Confirm to proceed or Cancel to abort.

rimozione_blocco_campi_05_eng

5. After confirming, a success dialog shows the total number of products whose field locks were removed. The product grid reloads automatically. 

rimozione_blocco_campi_06_eng