1. Home
  2. DotActiv - Data
  3. How To Find, Edit And Update Products In The SQL Database

How To Find, Edit And Update Products In The SQL Database

This article will show you how simple it is to find, edit and update products in the SQL database in DotActiv.

Applicable Products: DotActiv Pro, DotActiv Enterprise

Finding Products in SQL

First, open the SQL by navigating to the ‘Data’ tab. Then, click on ‘SQL’ in the ‘Show’ section.

This opens the SQL in your selected Product Drill on the left-hand side of the screen.

Right-click anywhere next to the fields and click on ‘Find’ in the drop-down menu. In this example, we have copied a Barcode we’d like to find in the database, so we clicked on ‘Paste’.

It is possible to manually ‘Add’ the value you would like to look up and also ‘Remove’ values. 

Once you have pasted/added the value(s) that you want to find, select which section and field these values can be found in.

In this example, ‘Barcode’ is the field in the ‘Item Detail’ section of our database. We want to tell the system that it should look for the value we have pasted in that specific section and field.

Finding Products In The SQL Database

Click on ‘OK’ to find the value you’ve added. DotActiv will now open the ‘Data View’ displaying the line you have looked up.

Using The Find And Edit Icon

First, navigate to the ‘Data’ tab and click on the ‘Find And Edit’ icon in the ‘Show’ section.

Doing so opens a new window with all your selected columns. You can search for products in a column, by using a keyword. For example, Brand = Nivea. Then click ‘Enter’.

As seen in the GIF above, you can find all your results in the grid that displays.

Please note that before you can begin with the ‘Find And Edit’ icon, you need to set up your Admin View.

Read this article on how to set up an Admin View.

Editing And Updated Products

Open the ‘Data View’ of the line(s) you want to edit by selecting the Department, Category etc. where the product(s) is that you want to edit. Then right-click and select ‘View Data/Images’.

Now, double-click on the specific field you would like to edit for that product to select the text you want to edit in that field.

Enter the new information in that field, paying special attention to spelling, letter case and punctuation marks.

Please note that just the use of a space will result in the SQL database reading two values with the same text as unique values. ‘DRBROWN and ‘DR BROWN’ will not be recognised as the same brand.

After putting in the new information, you will see the information displays in red text. This indicates that this is new/changed information that has not yet been saved in the database.

To save it, click on ‘Update Database’ in the ‘Tools’ tab at the top of the screen.

A window will open asking you to confirm which values to update. To confirm this, click ‘Update Database’ again. You will get a pop-up window confirming that the database was updated with the changes made.

Editing Products In The SQL Database

Finding and editing data in the SQL database is very easy one you have found your way around navigating the database. Once you have a clear understanding, it is very easy to locate products and classify lines.

Updated on November 14, 2019

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support