Add product name, product category, product sku, product price segments (#15144)

* Add product category segment.

* Fix productCategory action, add productName, productSku, productPrice segments.

* Hide productCategory1...5 segments in UI/API.

* fix tests

* Do not select conversion items that are deleted in segments + fix bug in ecommerce item insert (do not fail whole insert if one duplicate primary key is found).

* update expected files

* Fix unit test.

1 files changed, 39 insertions, 4 deletions

diff --git a/tests/PHPUnit/Integration/Tracker/ModelTest.php b/tests/PHPUnit/Integration/Tracker/ModelTest.php
index 7023cd502f..b14c066afc 100644
--- a/tests/PHPUnit/Integration/Tracker/ModelTest.php
+++ b/tests/PHPUnit/Integration/Tracker/ModelTest.php
@@ -124,7 +124,7 @@ class ModelTest extends IntegrationTestCase
 
     public function test_createEcommerceItems_shouldNotFail_IfWritingSameItemTwice()
     {
-        $item = array(array(
+        $item = array(
             'idsite' => '1',
             'idvisitor' => 'test',
             'server_time' => '2014-01-01 00:00:00',
@@ -140,9 +140,44 @@ class ModelTest extends IntegrationTestCase
             'price' => '10.00',
             'quantity' => '1',
             'deleted' => '0'
-        ));
-        $this->model->createEcommerceItems($item);
-        $this->model->createEcommerceItems($item);
+        );
+        $item2 = [
+            'idsite' => '1',
+            'idvisitor' => 'test',
+            'server_time' => '2014-01-01 00:00:00',
+            'idvisit' => '1',
+            'idorder' => '12',
+            'idaction_sku' => '2',
+            'idaction_name' => '2',
+            'idaction_category' => '3',
+            'idaction_category2' => '4',
+            'idaction_category3' => '5',
+            'idaction_category4' => '6',
+            'idaction_category5' => '7',
+            'price' => '20.00',
+            'quantity' => '1',
+            'deleted' => '0'
+        ];
+        $this->model->createEcommerceItems([$item]);
+        $this->model->createEcommerceItems([$item, $item2]);
+
+        $itemsInDb = Db::fetchAll("SELECT idsite, HEX(idvisitor) as idvisitor, idorder, idaction_sku FROM " . Common::prefixTable('log_conversion_item'));
+        $expectedItemsInDb = [
+            [
+                'idsite' => '1',
+                'idvisitor' => '7465737400000000',
+                'idorder' => '12',
+                'idaction_sku' => '1',
+            ],
+            [
+                'idsite' => '1',
+                'idvisitor' => '7465737400000000',
+                'idorder' => '12',
+                'idaction_sku' => '2',
+            ],
+        ];
+
+        $this->assertEquals($expectedItemsInDb, $itemsInDb);
     }
 
     private function assertLogActionTableContainsTestAction($idaction)