Get unpublished item insights

Marketplace sellers can use the Unpublished Item Count and Unpublished Items APIs to figure out why items get unpublished and how many items are unpublished for each reason. 

There are many reasons why items get unpublished, either by Walmart actions, or by a seller’s action. Some reasons include: Item’s end date has passed, so it goes unpublished. Or, If the item image is missing, it can trigger the item to get unpublished. These simple fixes can get your items republished so you can win more sales and grow your business.

The top five reasons items go unpublished are:

• End Date Issue
• Reasonable Price Not Satisfied
• No Primary Image
• Start Date Issue
• No Price

To find out why an item was unpublished, use the Unpublished Items API to locate the reason code. To get a complete list of reason codes, see Unpublished Item Reason Codes.

Unpublished items workflow

1. Use the Unpublished Item Count API to get a list of all unpublished item reason codes after a specific date. The response includes a list of all groups of unpublished item information, grouped by:
   • Count of unique item SKUs unpublished by specific reason code
   • Unpublished item reason code
   • Total cost for all items unpublished for that reason
2. Use the Unpublished Items API to return all item details with the reason code you pass in.
3. Re-ingest and publish your item again. See the Item Management API Overview.

Note: All API call examples shown in this tutorial assume the API endpoint is prepended to the call.

Walmart API endpoint: [https://marketplace.walmartapis.com]

Step 1: Get a list of all unpublished items with reason codes

To get a list of all reasons why items were unpublished since a certain date, call the GET Unpublished Item Counts API, and specify the fromDate parameter. 

Consider this example: to return a list of how many items were unpublished for each possible reason after April 1, 2020, call:

/v3/insights/items/unpublished/counts?fromDate=2020-04-01

Upon success, the API returns the total number of distinct items SKUs that were unpublished by a specific reason code and the total cost of the unpublished items.

Here is example response that includes reason code: END_DATE, number of items unpublished for that reason and total cost of the unpublished items:

"unpublishedCount": "185",
"unpublishedValue": "2154.0",
"unpublishedReasonCode": "END_DATE"

In the list of reason codes provided, there are 185 unique item SKUs with expired end dates that were unpublished.

Now that you have the reason code END_DATE, you can make a call to GET Unpublished Items API to return all item-level details for item SKUs unpublished for that reason.

Step 2: Get item details for unpublished items

Now you can pass in the reason code to the GET Unpublished Items API. It will return all item-level information for each item that was unpublished with that reason code.

For example, to get all items unpublished for END_DATE reason code after Sept. 14, 2020, call:

/v3/insights/items/unpublished/items?fromDate=2020-09-14&unpublishedReasonCode=END_DATE

All item-level information is returned for any unpublished items with the reason code you specify, such as:

• Item SKU, ID, condition, and product name
• Item is trending or not
• Item lifecycle status
• Item publish status

For the complete list of response parameters, and sample response JSON payloads, see the Unpublished Items API Reference.

(Optional): Get list of all unpublished items for all reasons

You can also get a full list of all unpublished items for all reason codes.

Call the GET Unpublished Items API and specify fromDate parameter only. By default, if you do not provide a reason code, it returns all reason codes.

For example to get a list of all unpublished items since Jan. 15th, 2020 call:

/v3/insights/items/unpublished/items?fromDate=2020-01-15

Step 3: Re-publish items with Item APIs

Now you can republish the items using item information provided by Insights APIs: Unpublished Item Counts and Unpublished Items APIs. See the Item Management API Overview.

Unpublished item reason codes

These are all unpublished item reason codes available.