Walmart Product Update

This page is to define general requirements for Walmart listing maintenance.

This is an extention of our current call logic and feed management logic so this does not change. The changes are in the schemas and payloads being used. So we should keep our general logic for product create on Walmart.

API Docs: https://developer.walmart.com/api/us/mp/feeds & https://developer.walmart.com/global-marketplace/reference/itembulkuploads

API Call: POST /v3/feeds

Feed type : MP_MAINTENANCE

All triggers, validations etc. are as per our abstraction for Product Update. Product Listing general requirements

Below is an example payload for the feed followed by mapping

{
    "MPItemFeedHeader": {
      "locale": "en",
      "version": "5.0.20240517-04_08_27-api",
      "businessUnit": "WALMART_US"
    },
    "MPItem": [
      {
        "Orderable": {
          "sku": "09876543210987",
          "productIdentifiers": {
            "productIdType": "UPC",
            "productId": "12345678901234"
          },
          "startDate": "2024-01-01T00:00:00+00:00",
          "endDate": "2032-12-31T00:00:00+00:00",
          "price": 19.83         
        },
        "Visible": {
          "Storage Chests & Boxes": {
            "brand": "Walmart",
            "color": "Blue",
            "count": 1,
            "shape": "Rectangle",
            "finish": "Flat",
            "isBulk": "Yes",
            "pattern": [
              "Sun"
            ],
            "ageGroup": [
              "Adult"
            ],
            "features": [
              "gift cards birthday gifts for women gifts for him gift card birthday gift card birthday gifts for men mothers day gifts gifts for female gifts for mom easter gifts gift bags wedding gifts gifts for women bridesmaid gifts anniversary gifts for him gifts for men gifts house warming gifts new home baby shower gifts gift box best friend gifts for women 1 year old girl gifts sister gifts graduation gifts gift basket gifts for bridal shower gift baby girl gifts 1 year old boy gifts gifts for women who have everything dog memorial gifts for loss of dog anniversary gift for her birthday gifts mom gifts baby boy gifts gift card personalized gifts 50th birthday gifts for women gifts for her retirement gifts for women easter gifts for girls gifts for mom from daughter 3 year old girl gifts get well soon gifts for women easter gifts for toddlers groomsmen gifts mens gifts 40th birthday gifts women gifts for boyfriend gift cards email delivery gifts for girlfriend birthday gifts for mom gift bag 4 year old girl birthday gifts 5 year old girl birthday gifts gift bags medium size couples gifts boyfriend gifts cards gift cards thank you gifts baby gifts 60th birthday gifts for women teen girl gifts birthday gift sisters gifts from sister easter gifts for teens gifts 6 year old girl gifts engagement gifts for couples gift boxes gifts for teenage girls self care gifts for women funny gifts bridesmaid proposal gifts bride to be gifts gift anniversary gift for couple one year old girl birthday gifts baby books for baby shower gift mom birthday gifts small gift bags before christmas gifts"
            ],
            "material": [
              "Polyester"
            ],
            "occasion": [
              "Vacation"
            ],
            "condition": "New",
            "pieceCount": 1,
            "keyFeatures": [
              "Size: S Size.: Small US: 4 EU: 8 UK: 34 Bust: 88cm/34.65'' Waist: 66cm/25.98'' Length: 120cm/47.24''",
              "Size: M Size.: Medium US: 6 EU: 10 UK: 36 Bust: 93cm/36.61'' Waist: 70cm/27.56'' Length: 121cm/47.64''",
              "Size: L Size.: Large US: 8 EU: 12 UK: 38 Bust: 98cm/38.58'' Waist: 74cm/29.13'' Length: 122cm/48.03''",
              "Size: XL Size.: X-Large US: 10 EU: 14 UK: 40 Bust: 103cm/40.55'' Waist: 78cm/30.71'' Length: 123cm/48.43''",
              "Size: XXL Size.: XX-Large US: 12 EU: 16 UK: 42 Bust: 108cm/42.52'' Waist: 82cm/32.28'' Length: 124cm/48.82''",
              "pink cocktail dress puffy sleeve prom dress women formal dresses black dress sandals for women kids dress shoes dress blue satin dress plus size satin dress dresses white spring dresses for women flowy summer dress for women formal black dress black off the shoulder dress green dress for women sun dress plus size rustic dresser plus size prom dresses for teens light wood dresser long sleeve dress shirts for men 50s dress yellow dress for women active dress aqua dress for women green maxi dress for women purple formal dress for women sexy birthday dress women belts for dresses jumpsuit for women dressy long spring dress all dressed ruffles chips neon green dress one shoulder maxi dress for women red plus size dress for women flowy maxi dress dresses under 5492 for women lilac dresses pink ruffle dress pink dress pants for women red dress shoes for women baby dresser organizer garment bag for dresses long pink sundresses for women blue and white floral dress high low dress mommy and me dress mens dress vest sexy maxi dress colorful dress"
            ],
            "modelNumber": "women summer clothes 18-60 clearance 20230514",
            "productName": "Walmart Fashion Women Summer Printing One Shoulder Sleeveless Ruffle Long Dress Floral Summer Dress XXL Blue On Clearance",
            "countPerPack": 1,
            "mainImageUrl": "https://i5.walmartimages.com/seo/Time-and-Tru-Women-s-Cotton-Knit-Tiered-Dress-Sizes-XS-XXXL_62abc090-6021-45ac-8945-728376466af5.5a681d257989e0df67c315b2c3aeee90.jpeg",
            "manufacturer": "Walmart",
            "clothing_type": [
              "Tie~Underwear~Shirt~Pant~Sweater~Socks~Accessory~Under Garment"
            ],
            "colorCategory": [
              "Blue"
            ],
            "homeDecorStyle": [
              "Modern"
            ],
            "volumeCapacity": {
              "unit": "qt",
              "measure": 16
            },
            "recommendedUses": [
              "Dog Toys~Office~Keepsake~Cat Toys"
            ],
            "recommendedRooms": [
              "Home Office~Living Room~Under the Bed"
            ],
            "shortDescription": "<p> Fashion Women Summer Printing One Shoulder Sleeveless Ruffle Long Dress <br /></p> <p><b>Features:</b></p> <ul><li>Function:Casual wear, Print Dress, Sleeveless, Fashion Design <br /></li><li>Material: Polyester. Made of high-quality fabrics, Lightweight, Soft And Comfortable.</li><li> The Floral Print Dress Design Makes It More Casual And Attractive To Wear</li><li>Occasions: Leisure, Holidays, Birthdays, Appointments, Dance Performances, Parties, Weddings, Work, Vacations At Home, Etc. Suitable For Autumn, Winter And Spring.</li><li> Please note: Hand Wash With Cold Water Or Gently Machine Wash/Do not bleach/dry. Our Clothes Are Designed According To The Asian Figure, Which Will Be Smaller Than The Normal Size In Europe. <br /></li><li>Please Refer To Our Own Size Chart, You Can Find It In Our Pictures Or Descriptions.</li></ul> <p> <b>Product information: </b><br /></p> <ul><li>Season: Summer/Spring</li><li> Gender: Female</li><li> Occasion: parties, weddings Material:Polyester</li><li> Pattern type:Print</li><li> Style:Casual</li><li> Sleeve: Sleeveless</li><li> Length:Ankle-Length</li><li> Washing method: hand wash cold, hang or dry</li><li> You will get: 1PC dress</li></ul> <br />Women's 2023 Floral Summer Dress Wrap V Neck Short Sleeve Belted Ruffle Hem A-Line Dresses Summer Casual Short Sleeve Crew Neck Smocked Elastic Waist Tiered Midi Dress Women's Summer Short Sleeve V-Neck Floral Short Party Dress with Pockets Women's Swing Loose T-Shirt Fit Comfy Casual Flowy Cute Swing Dress Women's Elegant Bridesmaid Dresses Square Neck Ruffle Split Midi Formal Dress for Wedding Guest Cocktail Party Summer Puff Sleeve Smocked Floral Dress Crewneck Lace Flowy Tiered Midi Dresses<br />",
            "multipackQuantity": 1,
            "isAssemblyRequired": "No",
            "smallPartsWarnings": [
              "0 - No warning applicable"
            ],
            "accessoriesIncluded": [
              "lids"
            ],
            "ib_retail_packaging": "Set",
            "has_written_warranty": "No",
            "numberOfCompartments": 1,
            "recommendedLocations": [
              "Indoor~Outdoor"
            ],
            "assembledProductWidth": {
              "unit": "in",
              "measure": 12.6
            },
            "assembledProductHeight": {
              "unit": "in",
              "measure": 7.2
            },
            "assembledProductLength": {
              "unit": "in",
              "measure": 18
            },
            "assembledProductWeight": {
              "unit": "in",
              "measure": 2.2
            },
            "manufacturerPartNumber": "WM20230514",
            "isProp65WarningRequired": "No",
            "productSecondaryImageURL": [
              "https://i5.walmartimages.com/seo/Time-and-Tru-Women-s-Tie-Back-Midi-Dress-with-Ruffled-Straps-Sizes-XS-XXXL_a110c971-bdd3-48e4-b50a-b578321ec73f.234e18821eec49faf08eff4278adeb3e.jpeg"
            ],
            "cleaningCareAndMaintenance": "Wipe Clean",
            "storage_chest_and_box_type": "Storage Bins"
          }
        }
      }
    ]
  }

Mapping (please note the mapping is based on the example. As a follow information please see a general breakdown of the schema)

In a 8601 ISO format.

Product SKU and Product ID update

(the logic we are already using is almost identical, there is only one field which was made obsolete and we need to exclude it from the payload and this is the sellingChannel , nothing else has changed)

Walmart are allowing us to update SKU and Product ID and for this we need to send specific attribute in the payload based on a trigger in Hemi. We need to send the feed with feedType = MP_ITEM (basically the SKU and Product Updates are considered as “item creation” and we need to use the feed type and payload for product create)

We will need a new internal feed type which should be named “Listing SKU/ID update”. We will need this new type in order to distinguish the different feeds that are being sent to walmart.

The field attributes are as follows and they need to be in the “Orderable” section :

"SkuUpdate": "Yes",
"ProductIdUpdate": "Yes"

Mapping :

We want to still stick to abstraction rules and if we have a product for sku update from a variation, we push the whole variation but only add the UpdateSku attribute in the payload for the relevant product. We want to treat the UpdateSku flow with priority meaning that if we have a variation where a product is due to be updated and then another product from the same variation that is due to have SKU update, we should pick the SKU update first, send the update and then raise the List/Update field to Pending again so we can send the standard update.

After successful update, we want to update the Product Account Walmart >Update SKU or Product Account Walmart > Update GTIN (depending which was sent for update) and uncheck the field. If there was an error we want to store it as per the Listing Update abstraction

Product Listing general requirements