Skip to main content

How to find errors before customers do

To improve the data quality of your shop, automatic checks for the release of a product in cobby provide even more overview. How far advanced the work in catalog management is, you can easily find out with cobby using formulas.

We describe in our example two checks that check which data of a product is missing or complete:

1. Is the manufacturer on file?

2. Have the dimensions been entered?

First, we create new columns in cobby for both checks. Then we fill these columns with formulas.

  1. For the question whether the manufacturer is listed with a product, we use the following formula: =NOT(ISEMPTY([@Manufacturer]))

  2. We use this formula to check if the dimensions of the product have been entered: =IF([@Type]="simple";NOT(ISEMPTY([@Dimensions]));"")

We then apply the formulas to the complete column and can see at a glance where data is still missing. Of course you can create individual checks for your products.

More examples of checks you can use:

  • Images: Have the given three images been stored?

Corresponding formula:

=(LEN([@Images]) -LEN( SUBSTITUTE([@Images];”file”;””)))/LEN(“file”)>=3

  • Image attributes: Have the image attributes been entered?

Corresponding formula:

=AND(IFERROR(FIND(“image”;[@Images]);0)>=1;IFERROR(FIND(“small_image”;[@Images]);0)>=1;IFERROR(FIND(“thumbnail”;[@Images]);0)>=1)

  • Categories: Is the article assigned to the given three categories?

Corresponding formula:

=AND(IFERROR(FIND(“image”;[@Images]);0)>=1;IFERROR(FIND(“small_image”;[@Images]);0)>=1;IFERROR(FIND(“thumbnail”;[@Bilder]);0)>=1)