Cheat Sheet

The Bulk Inventory Update Sheet
• The Bulk Inventory Update Sheet is used to update your available stock or quantity of items on hand.
• This would normally done every day or several times a day, depending on how quickly your stock moves in or out of your warehouse to other retailers and customers or from your suppliers.
• To locate and download your Bulk Inventory Update Sheet, go to your “Bulk Updates” page located under the “Items & Inventory” Heading.
• Under “STEP 1: SELECT SPEC TEMPLATE”, select the “Bulk Inventory Update” Option from the Drop-Down Menu provided and click the “Download” button alongside it.
• When you open up your Bulk Inventory Update Sheet, you will see the following fields:
     * SKU; and
     * New Quantity.
• The “SKU” field obviously pertains to your specific product SKU that you wish to update your inventory for and the “New Quantity” field refers to the current stock available on hand.
• Once you have completed all of the fields, return to your “Bulk Updates” page.
• Under “STEP 2: UPLOAD SPEC TEMPLATE”, either Drag and Drop your completed spreadsheet into the box provided or click the “Click” link to locate and select your spreadsheet for upload.
• Select the “Bulk Inventory Update” Option from the Drop-Down Menu provided and click the “Submit” button below.
• Your uploaded spreadsheet will appear in the “Feed Status” below.

Bulk Pricing and Promotion Update Sheet
• The Bulk Pricing and Promotion Update Sheet is used to update your prices for your products, as well as to create and manage any promotional pricing for your products on Walmart.
• To locate and download your Bulk Pricing and Promotion Update Sheet, go to your “Bulk Updates” page located under the “Items & Inventory” Heading.
• Under “STEP 1: SELECT SPEC TEMPLATE”, select the “Bulk Pricing and Promotion Update” Option from the Drop-Down Menu provided and click the “Download” button alongside it.
• When you open up your Bulk Pricing and Promotion Update Sheet, you will see the following tabs:
     * Welcome, which is essentially a reminder to click the “enable editing” bar at the top of the sheet so that you can enter your details and enable the macros for the spreadsheet;
     * Instructions & Definitions, which explains what you will find on the “Offer” tab and how to complete the document successfully; and
     * Offer, which is where you fill out your pricing and promotion update information.
• When you click through to the “Offer” tab, you will see the following fields:
     * SKU, a required field which is your product SKU;
     * Price, a required field which is your price for the product and not the MSRP or Manufacturer Suggested Retail Price;
     * Promotions Status, which shows how you would like to change the status of your promotions and you select this from the Drop-Down Menu provided, namely, “Active” promotion or “Delete All” promotions in this line for this SKU;
     * Then you will see the following fields for up to five promotions, named “Promotion 1” through to “Promotion 5”:
     * Promo Price, which is the price you would like to sell this SKU for on your promotion;
     * Promo Type, which is a tag that can be displayed on Walmart.com with your product for the promotion and you have the three available options from the Drop-Down Menu provided: a) Reduced, 2) Clearance, or 3) Base.
     * Promo Placement, which is where you would like the promotional price displayed if you are charging less than the MAP or Minimum Advertised Price and you have the option of showing this price in the “Cart” or at “Checkout”;
     * Promo Start Date, which is the date you would like your promotion to start; and
     * Promo End Date, which is the date you would like your promotion to end.
• Once you have completed all of the fields, return to your “Bulk Updates” page.
• Under “STEP 2: UPLOAD SPEC TEMPLATE”, either Drag and Drop your completed spreadsheet into the box provided or click the “Click” link to locate and select your spreadsheet for upload.
• Select the “Bulk Pricing and Promotion Update” Option from the Drop-Down Menu provided and click the “Submit” button below.
• Your uploaded spreadsheet will appear in the “Feed Status” below.

Bulk Lag Time Update Sheet
• The Bulk Lag Time Update Sheet is used to amend your lag time or fulfillment time for your products in one big go.
• To locate and download your Bulk Lag Time Update Sheet, go to your “Bulk Updates” page located under the “Items & Inventory” Heading.
• Under “STEP 1: SELECT SPEC TEMPLATE”, select the “Bulk Lag Time Update” Option from the Drop-Down Menu provided and click the “Download” button alongside it.
• When you open up your Bulk Lag Time Update Sheet, you will see the following fields:
     * SKU; and
     * Fulfillment Lag Time.
• The “SKU” field obviously pertains to your specific product SKU that you wish to update your inventory for and the “Fulfillment Lag Time” field refers to the number of days between when the item is ordered and when it is shipped.
• So, if your lag time increases or decreases for any item, this would be the update sheet you would use.
• Once you have completed all of the fields, return to your “Bulk Updates” page.
• Under “STEP 2: UPLOAD SPEC TEMPLATE”, either Drag and Drop your completed spreadsheet into the box provided or click the “Click” link to locate and select your spreadsheet for upload.
• Select the “Bulk Lag Time Update” Option from the Drop-Down Menu provided and click the “Submit” button below.
• Your uploaded spreadsheet will appear in the “Feed Status” below.

Bulk Return Rules Update
• Your Bulk Return Rules Update Sheet is used to update any return rules you have in place for your catalog when it comes to customers returning items for a refund or not.
• To locate and download your Bulk Return Rules Update Sheet, go to your “Bulk Updates” page located under the “Items & Inventory” Heading.
• Under “STEP 1: SELECT SPEC TEMPLATE”, select the “Bulk Return Rules Update” Option from the Drop-Down Menu provided and click the “Download” button alongside it.
• When you open up your Bulk Return Rules Update Sheet, you will see the following tabs:
     * Definitions, which explains the definitions of the fields in this sheet;
     * Example, which gives an example of how to fill this sheet out; and
     * Returns_ItemOverrides, which is where you fill out your returns overrides rules for your catalog items.
• When you click on the “Returns_ItemOverrides” tab, you will see the following fields:
     * SKU, which pertains to your product SKU;
     * Keep it, which allows customers to keep this item and still get a refund and you have the option of “Yes” or “No” from the available Drop-Down Menu;
     * Return Restricted, which allows you to delete any existing return restricted overrides and you have the option of “No” or a blank in the Drop-Down Menu provided;
     * Restricted Reason, which is the Delete restriction reason for any existing return restricted overrides and should remain blank; and
     * Return Center (Alias), which is the alias or shortened name of your existing Return Center as setup for your Seller Center account.
• Once you have completed all of the fields, return to your “Bulk Updates” page.
• Under “STEP 2: UPLOAD SPEC TEMPLATE”, either Drag and Drop your completed spreadsheet into the box provided or click the “Click” link to locate and select your spreadsheet for upload.
• Select the “Bulk Return Rules Update” Option from the Drop-Down Menu provided and click the “Submit” button below.
• Your uploaded spreadsheet will appear in the “Feed Status” below.

Bulk Two Day Shipping Overrides
• The Bulk Two Day Shipping Overrides Sheet is used to override or update your two-day shipping to the various regions and states in the US for your catalog.
• To locate and download your Bulk Two Day Shipping Overrides Sheet, go to your “Bulk Updates” page located under the “Items & Inventory” Heading.
• Under “STEP 1: SELECT SPEC TEMPLATE”, select the “Bulk Two Day Shipping Overrides” Option from the Drop-Down Menu provided and click the “Download” button alongside it.
• When you open up your Bulk Two Day Shipping Overrides Sheet, you will see the following fields with examples in the cells for you to work off of:
     * SKULD, which is your product SKU;
     * GTIN, which is your product UPC, ISBN, etc.;
     * Override, which is a “yes” or “no” response;
     * Region, which is the region for the shipping override;
     * Southregionstates, which is a State in the South Region;
     * Northeastregionstates, which is a State in the North and East Regions;
     * Westregionstates, which is a State in the West Region.
• Once you have completed all of the fields, return to your “Bulk Updates” page.
• Under “STEP 2: UPLOAD SPEC TEMPLATE”, either Drag and Drop your completed spreadsheet into the box provided or click the “Click” link to locate and select your spreadsheet for upload.
• Select the “Bulk Two Day Shipping Overrides” Option from the Drop-Down Menu provided and click the “Submit” button below.
• Your uploaded spreadsheet will appear in the “Feed Status” below.

Bulk Mapping SKUs to Shipping Template
• The Bulk Mapping SKUs to Shipping Template is used to assign your SKUs to a different shipping template in one go as normally, once you have added your SKUs to your Walmart Catalog, they will automatically be assigned to the default Shipping Template which you would have setup in your Shipping Templates Page under the “Settings” tab in your Seller Center Account.
• We will be going through this in more detail in another course.
• To locate and download your Bulk Mapping SKUs to Shipping Template, go to your “Bulk Updates” page located under the “Items & Inventory” Heading.
• Under “STEP 1: SELECT SPEC TEMPLATE”, select the “Bulk Mapping SKUs to Shipping Template” Option from the Drop-Down Menu provided and click the “Download” button alongside it.
• When you open up your Bulk Mapping SKUs to Shipping Template Sheet, you will see the following fields:
     * SKU, which is your product SKU;
     * Shipping Template ID, which is the specific ID given to your shipping template when setup in your Seller Center account. You can find the details and the ID of your Shipping Template on the “Shipping Template” page available on your Seller Center account;
     * Fulfillment Center ID, which is the ID of your Fulfillment Center where this SKU is physically located. If you have not defined any Fulfillment Center and operate under the default node, then you can use the Virtual Node ID, which is the same as your Partner ID, which can be located in your Settings Drop-Down Menu on your Seller Center account; and
     * Action Type, which can be “Add” or “Remove” from the available Drop-Down Menu. “Add” will cause your SKU to be added to this shipping template, while “Remove” will result in your SKU being removed from this shipping template.
• Once you have completed all of the fields, return to your “Bulk Updates” page.
• Under “STEP 2: UPLOAD SPEC TEMPLATE”, either Drag and Drop your completed spreadsheet into the box provided or click the “Click” link to locate and select your spreadsheet for upload.
• Select the “Bulk Mapping SKUs to Shipping Template” Option from the Drop-Down Menu provided and click the “Submit” button below.
• Your uploaded spreadsheet will appear in the “Feed Status” below.

The Feed Status Overview
• Your Feed Status simply shows you the current status of the items you have updated, amended or submitted for your catalog and can be located on the “Feed Status” Page found beneath the “Items & Inventory” Heading on your Seller Center account.
• On this page, you have the same available actions to do bulk updates as on the “Bulk Updates” Page, namely:
     * Selecting a Bulk Update Sheet from the available Drop-Down Menu in Step 1;
     * Downloading and completing the Update Sheet; and
     * Re-uploading it in Step 2.
• Beneath these two blocks is the “Feed Status” table.
• You have the option to filter your uploaded sheets by the type, which can be selected from the available Drop-Down Menu and are:
     * Item Setup, which refers to the Item Setup Sheets Spec Version 4.0 or 3.1;
     * Item Maintenance, which refers to your Item Maintenance Sheet;
     * Inventory Feed, which refers to your Bulk Inventory Update Sheet;
     * Price Feed, which refers to your Bulk Pricing Update Sheet;
     * Promo Feed, which refers to your Bulk Pricing and Promotions Update Sheet;
     * Lag Time Feed, which refers to your Bulk Lag Time Update Sheet;
     * Return Rules Feed, which refers to your Bulk Return Rules Update Sheet;
     * Two Day Shipping Overrides, which refers to your Bulk Two Day Shipping Overrides Sheet; and
     * Shipping Template, which refers to your Bulk Mapping SKUs to Shipping Template.
• You also have the option to enter text you are searching for in the search bar alongside.
• You can “Refresh” the table listing or apply more filters by clicking the “Filters” icon to the right side of the table.
• This will give you the following filter options:
     * Feed Type as per the templates mentioned previously;
     * Status, which can be “Submitted”, “Pending”, “Processed” or “Error”; and
     * Date.
• The table itself has the following fields:
     * Feed ID, which is the automatically generated ID that the system gives to your spreadsheet once it has been uploaded;
     * Feed Type, which is one of the aforementioned template options;
     * Date & Time, which refers to the date and time of the upload;
     * Status, which refers to whether the entire submission has been submitted, is pending, processed or in error. Note that, if some of the items are still pending or in error, this status will show as “Pending” as all line items in the submitted spreadsheet have not been processed;
     * Processed, which refers to how many items have been processed already from that one submission;
     * Pending refers to how many items are still pending from that one submission;
     * Errors refers to how many items are in error from that one submission, and
     * Error Report, which is downloadable so that you can see what needs to be amended.
• At the bottom of the table, you can see all pages you can click through to and have the option to show up to 200 items on one page.