Update Offerr

Summary of Changes: (The purpose of this table is to keep traceability and Product team to highlight the things that were changed into the scope, based on comments or discussions)

• Submits an offer package
• Read Offer Package
• Limits:

Submits an offer package

The Full Offer Update structure is the same as Create Offerr

After each successfully send feed for creation we will receive the packageId from the response and need to store it in Marketplace Feeds table.

Please note we will also add the feed objects which after processing need to be removed.

Read Offer Package

API Call: GET https://api.octopia-io.net/seller/v2/offer-integration-packages[?packageId][&gtin][&pageIndex][&pageSize][&fields][&sort][&desc] API Doc: https://developer.octopia-io.net/api-details#api=api-rest-seller-v2&operation=get-product-integration-reports

Request parameters

Sample Request: GET https://api.octopia-io.net/seller/v2/products-integration-reports?packageId=309592003&page=1&limit=50

Sample Response:

{
    "package_id": 309592003,
    "integration_state": "Integrated",
    "number_of_errors": 1,
    "offer_log_paged_list": [
        {
            "log_date": "2022-11-22T00:31:04.75+00:00",
            "offer_integration_status": "Integrated",
            "product_ean": "5056553233698",
            "seller_product_id": "96581",
            "property_list": [
                {
                    "log_message": "96581|5056553233698|MP60297644-0004|OK|9000|Offer updated|Cdiscount",
                    "property_code": "0",
                    "property_error": "90"
                }
            ]
        }
        ,
        {
            "log_date": "2022-11-22T08:57:08.12+00:00",
            "offer_integration_status": "Rejected",
            "product_ean": "5054697499253",
            "seller_product_id": "11806603270",
            "property_list": [
                {
                    "log_message": "11806603270|5054697499253||KO|3893|Données manquantes|Cdiscount",
                    "property_code": "93",
                    "property_error": "38"
                }
            ]
        }
    ],
    "seller_id": 51102,
    "page": 0,
    "count_by_page": 50,
    "total_logs_count": 2
}

Request Mapping:

OR Product Account >Update Quantity Error OR Product Account >Update Price Error OR Product Account >End Item Error | Depends on the feed type we have pushed we will have to store the relevant message in the relevant field. | | | | property_code | N/A | | | | | property_error | N/A | | | seller_id | | | N/A | | | page | | | N/A | | | count_by_page | | | N/A | | | total_logs_count | | | N/A | |

In order to pick a product for offer creation we must HAVE Product Account > Channel Item ID populated, the relevant flags set and Product Account > Listing Status = Active/Inactive Product Account > Product Status =Product published Product Account > List / Update the Whole Item = Pending

Once the product is picked for offer creation we will have: Product Account > Listing Status = Active/Inactive Product Account > Product Status =Product published Product Account > List / Update the Whole Item = Sent

When we read the response if successful we will update the product: Product Account > Listing Status = Active/Inactive Product Account > Product Status =Product published Product Account > List / Update the Whole Item = Not Needed

When we read the response if error we will update the product: Product Account > Listing Status = Active/Inactive Product Account > Product Status =Product published Product Account > List / Update the Whole Item = Error With the relevant error message in Product Account > Update Item Error

Limits:

There is a a limit of 200 000 offers in a package but I think in order to have better performance we can set a limit of 50 000 or 100 000 offers per package.

Additional Information:

For this integration we will need to make sure the protect flags are working as expected:

Protect Quantity - We can exclude the quantity from the payload when we are doing updates so we do not add the quantity in the payload when have Protect Quantity raised

Protect Price - We can exclude the price from the payload when we are doing updates so we do not add the price in the payload when have Protect Price raised.

Protect the whole item - We update the quantity only.

Closed -will stop all the updates to the MPs apart from the end item (send 0 stock update);