REST API catalogProductRepositoryV1 overwriting default values

[giano574]

Preconditions

1. Magento 2

Steps to reproduce

This demonstration is only with a single storeview, but can be reproduced with multiple storeviews or multiple websites like already mentioned by a bunch of other reporters above

1. Setup a clean Magento installation using the 2.2-develop branch (I used commit eb84c53)

2. Go into the backend

3. Make a note of the default storeview code, it's default (we'll need this later when we create an API request)

4. Create a new product:

   • name: "Base"
   • SKU: "base"
   • price: 100
   • description: "Base"
   • short description: "Base"

5. Look at the various catalog_product_entity_int, catalog_product_entity_text, catalog_product_entity_varchar tables in the database, they contain only values for store_id = 0, this is good so far!

6. Still in the backend, go to System > Integrations and add a new integration with full access

7. Activate the new integration and take a note of the 'access token' (example: abc)

8. Execute the following curl command, which only updates the "name" attribute, using the storeview code from 3, and the access token from 7:

curl -k -X PUT -H "Accept: application/json" -H "Content-Type: application/json" -H "Authorization: Bearer abc" -d "{ \"product\": { \"name\": \"New name on storeview level\" }}" https://domain/rest/default/V1/products/base

9. Go back in the backend and take a look at the product, but switch to the 'Default Store View' scope.

10. It is expected that the

11. Also take a look at the database again, to the catalog_product_entity_int, catalog_product_entity_text, catalog_product_entity_varchar tables, it is expected you'll only see one entry for store_id = 1, but there are like 10 entries, not good!

Expected result

Only attribute where the checkmark "Use Default Value" is unchecked is for the attribute "name"

Actual result

All the following attributes now also have a value on storeview level, which is not what is expected:
- status
- tax class
- visibility
- description
- short description
- url key
- meta title
- meta keywords
- meta description
- display product options in

[bartlubbersen]

@magento-team,

Is there any update on this issue, it still occurs in Magento 2.1.7 and makes it impossible to update product storeview values through API. Because if after an storeview API call the default value is changed, it won't work because the value is already unintentionally overwritten on storeview level.

[TomashKhamlai]

Hello! Thank you for submission!
I tried to reproduce this issue. Here is the full list of actions that I performed:

1. Install Magento using composer from repo.magento.com
2. Go to Admin and create Integration: System -> Extension -> Integrations
3. Press 'Add New Integration' button
4. Fill required fields
5. Switch to 'API' tab
6. Select 'All' in the dropdown with label 'Resource Access'
7. Press 'Save and Activate' and then 'Allow' button
8. Copy the value from Access Token Input and press Done button
9. Go to Stores -> Settings -> All Stores
10. Click on 'Create Website' button
11. Fill 'Danish' in the 'Name' input field and 'danish' in the 'Code' input field
12. Click on 'Save Website' button
13. Click on 'Create Store' button
14. Make sure that 'Web Site' drop-down has 'Danish' value selected.
15. Type 'Danish Store' in 'Name' input field
16. Select 'Default Category' as a 'Root Category'
17. Click on 'Save Website' button
18. Click on 'Create Store View' button
19. Make sure that 'Store' drop-down has 'Danish Store' value selected.
20. Type 'Store view (Danish)' in the 'Name' input field
21. Type 'danish' in the 'Code' input field
22. Select 'Enabled' from 'Status' drop-down
23. Click on 'Save Store View' button

As a result, I have got this:

Web Site	Store	Store View
Danish	Danish Store	Store view (Danish)
Main Website	Main Website Store	Default Store View

24. POST the following JSON to {domain.com}/rest/V1/products (catalogProductRepositoryV1) - product status set to 2 (disabled):

{
	"saveOptions": true,
	"product": {
		"attribute_set_id": 10,
		"visibility": 4,
		"price": 120,
		"type_id": "virtual",
		"name": "Rest product",
		"extension_attributes": {
			"stock_item": {
				"manage_stock": false,
				"is_in_stock": true,
				"use_config_manage_stock": false
			}
		},
		"sku": "TK207582890",
		"status": 2
	}
}

Result:

{
    "id": 1,
    "sku": "TK207582890",
    "name": "Rest product",
    "attribute_set_id": 4,
    "price": 120,
    "status": 2,
    "visibility": 4,
    "type_id": "virtual",
    "created_at": "2017-08-04 13:34:53",
    "updated_at": "2017-08-04 13:34:53",
    "extension_attributes": {
        "stock_item": {
            "item_id": 1,
            "product_id": 1,
            "stock_id": 1,
            "qty": null,
            "is_in_stock": true,
            "is_qty_decimal": false,
            "show_default_notification_message": false,
            "use_config_min_qty": true,
            "min_qty": 0,
            "use_config_min_sale_qty": 1,
            "min_sale_qty": 1,
            "use_config_max_sale_qty": true,
            "max_sale_qty": 10000,
            "use_config_backorders": true,
            "backorders": 0,
            "use_config_notify_stock_qty": true,
            "notify_stock_qty": 1,
            "use_config_qty_increments": true,
            "qty_increments": 0,
            "use_config_enable_qty_inc": true,
            "enable_qty_increments": false,
            "use_config_manage_stock": false,
            "manage_stock": false,
            "low_stock_date": null,
            "is_decimal_divided": false,
            "stock_status_changed_auto": 0
        }
    },
    "product_links": [],
    "options": [],
    "media_gallery_entries": [],
    "tier_prices": [],
    "custom_attributes": [
        {
            "attribute_code": "category_ids",
            "value": []
        },
        {
            "attribute_code": "options_container",
            "value": "container2"
        },
        {
            "attribute_code": "required_options",
            "value": "0"
        },
        {
            "attribute_code": "has_options",
            "value": "0"
        },
        {
            "attribute_code": "url_key",
            "value": "rest-product"
        },
        {
            "attribute_code": "tax_class_id",
            "value": "2"
        }
    ]
}

25. Inspect the database with the following two queries:

SELECT 
    attribute_id
FROM 
    eav_attribute
WHERE
    attribute_code = 'status' AND 
    entity_type_id = (SELECT 
                entity_type_id 
              FROM 
                eav_entity_type
              WHERE
                entity_type_code = 'catalog_product'
            )

Result:

+--------------+
| attribute_id |
+--------------+
|           97 |
+--------------+
1 row in set (0.00 sec)

26. Use value from step 2 (I got 97) in the next query:

SELECT * FROM 
    catalog_product_entity_int
WHERE 
    attribute_id = 97

Result:

+----------+--------------+----------+-----------+-------+
| value_id | attribute_id | store_id | entity_id | value |
+----------+--------------+----------+-----------+-------+
|        1 |           97 |        0 |         1 |     2 |
+----------+--------------+----------+-----------+-------+
1 row in set (0.00 sec)

Unfortunately, I am not able to reproduce this issue.

[magento-engcom-team]

@giano574 we are closing this issue due to inactivity. If you'd like to update it, please reopen the issue.