ASOS - Create Offer
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)
Date | Version | Name | Applied changes |
---|---|---|---|
28/09/2022 | 1.1 | Bogomil Pavlov | Statuses updated based on a comments |
30/09/2022 | 1.2 | Bogomil Pavlov | Complete flow added |
01/02/2023 | 1.3 | Bogomil Pavlov | Additional Details updated |
The purpose of this page is to describe in details the process of creating offer to already existing product on MIRAKL.
To create offer we should use following API calls - POST OF01 (Import a file to add offers), GET OF02 (Get information and statistics about an offer import), GET OF03 (Get the error report file for an offer import)
Complete flow:
Аfter successful product creation should have Channel Item ID, which for MIRAKL integration is the SKU!
Create offer cron should pick products only with statuses:
Product status = Product created and Listing Status = Inactive and List/Update the whole item =Pending
When the offer is successfully picked for creation we will set:
Product status = Product created and Listing Status = Inactive and List/Update the whole item =Sent
When the offer is created, we set statuses:
Product status - Product Published and Listing Status - Active and List/Update the whole item =Not Needed
If there is an error during offer creation, we will set following statuses:
Product status = Product created and Listing Status = Inactive and List/Update the whole item =Error
and we need to store the relevant error in Update Item Error field
- POST OF01 - Import a file to add offers
API Call: /api/offers/imports
API Docs: https://asosuk-dev.mirakl.net/help/api-doc/seller/mmp.html#OF01
clothing-example (1) - offers.xml
Example file:
<?xml version='1.0' encoding='UTF-8'?><import><offers>
<offer>
<sku>4064536387215</sku>
<product-id>4064536387215</product-id>
<product-id-type>SHOP_SKU</product-id-type>
<description>PUMA Unisex Future Rider Displaced Trainers Sports Shoes - Ice Flow/Mineral Blue</description>
<internal-description>This is the internal description of my offer.</internal-description>
<price>1000</price>
<price-additional-info>Price including taxes</price-additional-info>
<quantity>10</quantity>
<state>11</state>
<available-start-date>2022-09-01</available-start-date>
<available-end-date>2022-09-30</available-end-date>
<logistic-class/>
<update-delete>UPDATE</update-delete>
<all-prices>
<pricing>
<channel-code>GB</channel-code>
<price>1000</price>
<discount-price>1000</discount-price>
<discount-start-date>2022-09-01</discount-start-date>
<discount-end-date>2022-09-30</discount-end-date>
</pricing>
</all-prices>
</offer>
</offers></import>
Mapping:
Mirakl Field | Mirakl Notes | Integration Required | Hemi Field | Comment | ||
---|---|---|---|---|---|---|
sku |
The offer’s unique identifier in the shop - Required - Maximum 40 characters, no "/" character | Yes | Product >SKU | |||
product-id |
Unique product identifier for a given product-id-type - Required at offer creation - Maximum 40 characters | Yes | Product Account >Marketplace EAN |
OR
Product >EAN | |
| product-id-type
| | | | Yes | hardcoded as “ean“ | If we have ean populated we hardcoded the type as “ean“
Note: We always need to have EAN when we check call for listing create |
| description
| | | Offer description - Recommended - Maximum 2000 characters | No | Product Account > Description | |
| internal-description
| | | The description of the offer as shown in the back office view - Optional - Maximum 2000 characters | Optional | N/A | |
| price
| | | The selling price in the currency.
It is up to the operator to define with the seller whether the selling price includes or excludes taxes.
Decimal number; a period is used to separate cents | Yes | Product Account > Start Price
OR
Product Account> RRP | we send Product Account > RRP If RRP is populated and is bigger than Price |
| price-additional-info
| | | Information regarding the price of the offer.
Check with your operator if this information appears on the front.
Character string limited to 100 characters | No | Product Account ASOS > Price Additional Info | |
| quantity
| | | The quantity available in stock (maximum: one billion).
Integer greater than or equal to 0 | Yes | Product Account > Quantity | |
| state
| | | The state code of the offer
The accepted values are defined from the Mirakl back office | Required | see notes | Mapping to our conditions:
11- New > 1000;
1-Excellent > 1500;
2-Very Good >4000;
3-Good >5000;
4-Sufficient >6000;
5-Refurbished_like_new > 2750
6-Refurnished_very_good >2500
7-Refurbished_good > 2000
8-Refurbished_acceptable > New state(condition) to be created in Hemi (8000) |
| available-start-date
| | | The first day the offer becomes available. The offer has no start date if blank.
yyyy-MM-dd
or
yyyy-MM-ddThh:mm:ss+00
| No | N/A | |
| available-end-date
| | | The last day the offer is available. The offer has no end date if blank.
yyyy-MM-dd
or
yyyy-MM-ddThh:mm:ss+00
| No | N/A | |
| logistic-class
| | | The code for the logistic class. This logistic class overwrites the default logistic class defined for the product or Marketplace category assigned to the offer. | No | Account ASOS > Logistic class
Product Account ASOS > Logistic class | Our default Logistic Class is selected on account level and if we have selected on Product Account we pick it with priority |
| update-delete
| | | Used only in "Normal" import mode. Update mode is used if blank.
"", "update", "delete" | No | N/A | |
| all-prices
| | | | | | |
| | pricing
| | | No | | |
| | | channel-code
| | No | Account ASOS > Channel Code | We will use on GB channel for ASOS By default to be only the option GB |
| | | price
| | No | Product Account > Price
OR
Product Account > RRP | we send Product Account > RRP If RRP is populated and is bigger than Price |
| | | discount-price
| | No | Product Account > Price | If RRP > Price
- If there are discount dates imported in Hemi we use them
- If there are no dates imported in Hemi we use the default dates (Now) and (Now + 2y)
If RRP <= Price
3.We include the discount fields with empty values |
| | |
discount-start-date
| The first day the discount becomes available (if blank, the discount has no start date and is immediately active) - Optional - Valid date Date format:2022-09-01
| No | Product Account ASOS> Discount Start Date | If RRP > Price and If we do not specify any dates in the relevant fields we hardcoded current date (“NOW“) Date format -2017-02-20T10:45:53+01
If RRP <= Price We include the discount fields with empty values | | | |discount-end-date
| The last day the discount is available (if blank, the discount has no end date) - Optional - Valid date | No | Product Account ASOS > Discount End Date | If RRP > Price and If we do not specify any dates in the relevant fields we hardcode current date + 2 year (“NOW“ +2y) Date format -2017-02-20T10:45:53+01
If RRP <= Price We include the discount fields with empty values |
Example Response:
{
"import_id": 2035
}
After each successfully send feed for creation we will receive the feed id from the response and need to store it in Marketplace Feeds table.
Mirakl Field | Hemi Field | Comment |
---|---|---|
import_id | Marketplace Feed > External ID | |
Marketplace Feed > Account | For which account is the feed generated. | |
Marketplace Feed > Type | Hardcoded as “Offer Create“ | |
Marketplace Feed > Submitted Date | When the feed is submitted | |
Marketplace Feed > Sent Objects Count | How many products we have pushed in the feed |
Please note we will also add the feed objects which after processing need to be removed.
- GET OF02 - Get information and statistics about an offer import
API Call: /api/offers/imports/{import}
API Docs: https://asosuk-dev.mirakl.net/help/api-doc/seller/mmp.html#OF02
Parameter | Integration Notes / Value | Required |
---|---|---|
import |
Import identifier | Yes |
Using this call, we are able to check the status of the imported file.
Example Response:
{
"date_created": "2019-04-01T15:16:31Z",
"has_error_report": false,
"import_id": 2035,
"lines_in_error": 0,
"lines_in_pending": 0,
"lines_in_success": 1,
"lines_read": 1,
"mode": "NORMAL",
"offer_deleted": 0,
"offer_inserted": 1,
"offer_updated": 0,
"status": "COMPLETE"
}
OF02 call is returning the response for the actual offer import (all offers).
For example, { "message": "Not Found", "status": 404 }, this means there is no feed, no matter of the status of the feed - complete or error.
Based on the response, we will need to check if we have to continue with the error report (if "has_error_report": true or "has_transformation_error_report": true
) we continue with OF03 & OF04, otherwise we treat it as success.
Success case (once the offer is created successfully)
Product status = Product Published and Listing Status = Active and List/Update the whole item =Not Needed
Error case:
Product status = Product created and Listing Status = Inactive and List/Update the whole item =Error
and we need to store the relevant error in Update Item Error field
- GET OF03 - Get the error report file for an offer import
In order to check if there are any errors related to the products, into imported file we should use the GET OF03 API Call.
API Call: /api/offers/imports/{import}/error_report
API Docs: https://asosuk-dev.mirakl.net/help/api-doc/seller/mmp.html#OF03
"sku";"product-id";"product-id-type";"description";"internal-description";"price-additional-info";"quantity";"min-quantity-alert";"state";"available-start-date";"available-end-date";"logistic-class";"update-delete";"discount-start-date";"discount-end-date";"price";"discount-price";"discount-ranges";"price-ranges";"discount-start-date[channel=FR]";"discount-end-date[channel=FR]";"price[channel=FR]";"discount-price[channel=FR]";"discount-ranges[channel=FR]";"prices-ranges[channel=FR]";"discount-start-date[channel=CA]";"discount-end-date[channel=CA]";"price[channel=CA]";"discount-price[channel=CA]";"discount-ranges[channel=CA]";"prices-ranges[channel=CA]";"leadtime-to-ship";"error-line";"error-message"
"OFFER_SKU_004";"MKP100000000195360";"SKU";"My Offer Description n°1";"My Internal description 1";"My price Additional innformations";"1000000";"20";"11";"2017-02-20T10:45:53+01";"2017-04-30T10:45:53+01";"S";"update";"2017-02-22T10:45:53+01";"2017-04-30T10:45:53+01";"110.52";"108,56";"";"5|109.20,10|108.736";"2017-02-22T10:45:53+01";"2017-03-31T10:45:53+01";"105.56";"102,36";"";"5|104.56,10|103.27";"2017-02-22T10:45:53+01";"2017-03-31T10:45:53+01";"190.23";"175,36";"";"5|182.58,10|181.27";"15";"2";"The product does not exist"
As described above, this response give us detailed report of the SKUs and the actual SKUs errors are in the “error-message“
OF02 come directly when we import the file. if OF02 is 404 we set everything on Error and then we use the the actual response reader, which is OF03 API Call.
Get all logistic classes SH31 - List all logistic classes
API Call: /api/shipping/logistic_classes
API Docs: https://asosuk-dev.mirakl.net/help/api-doc/seller/mmp.html#SH31
Sample Respons
{
"logistic_classes": [
{
"code": "S",
"description": "Small items less than 1 kg and dimension less than 1 meter (L x W x H)",
"label": "Small"
},
{
"code": "M",
"description": "Medium items between 1 and 3 kg and dimension less than 1 meter (L x W x H)",
"label": "Medium"
},
{
"code": "L",
"description": "Large between 3 and 5 kg and dimension less than 1 meter (L x W x H)",
"label": "Large"
}
]
}
Once we get the logistic classes we need to store them in Hemi and display them as enumerations in Account ASOS > Logistic class and Product Account ASOS > Logistic class. Please note we need to push the code to MIRAKL and display the label in Hemi.
Additional Information:
For this integration we will need to make sure the protect flags are working as expected:
Protect Quantity (Stop all quantity updates) - Applicable for already created offers. If the offer is not created this flag is ignored. If Protect Quantity = Yes and Update Quantity = Pending - We skip the product If Protect Quantity = Yes and Update Price= Pending - We pick the product only for price update and do NOT include the quantity in the payload If Protect Quantity = Yes and List/Update the Whole Item = Pending - We pick the product for full update but do NOT include the quantity in the payload
Protect Price (Stop all price updates) -Applicable for already created offers. If the offer is not created this flag is ignored. If Protect Price = Yes and Update Quantity = Pending -We pick the product only for stock update and do NOT include the prices in the payload If Protect Price = Yes and Update Price= Pending - We skip the product If Protect Price = Yes and List/Update the Whole Item = Pending - We pick the product for full update but do NOT include the prices in the payload
Protect the whole item - (Stop all product updates apart from Quantity) -Applicable for already created offers. If the offer is not created this flag is ignored. If Protect the whole item = Yes and Update Quantity = Pending -We send the quantity only If Protect the whole item = Yes and Update Price= Pending - We skip the product If Protect the whole item = Yes and List/Update the Whole Item = Pending - We skip the product
Closed -will stop all the updates to the MPs apart from the end item (send 0 stock update). This flag applies for all products the ones which are created and all new products.