Cheat Sheet

The Manage Items Dashboard Overview
• Before we jump right into editing your existing listings, let’s take a look at your Manage Items Dashboard so you can better understand what actions are available to you here.
• After logging into your Walmart Seller Center portal, you should automatically land on your “Manage Items” page located under the “Items & Inventory” Heading.
• On this page, you will see a table of all of your listings.
• Right at the top of the page, you can see immediate categories of status for your listings, which are all clickable and allow you to sort your inventory by the status quickly, namely:
     * Draft – which refers to your product listings in draft format;
     * Published Items – which refers to your listings that are published and live on the Walmart site;
     * Unpublished Items – which refers to your listings that are complete but not yet live on the Walmart site;
     * Items Processing – which refers to your items still being processed after you added or edited them; and
     * Items with Errors – which indicates items that need to be fixed.
• You can remove the filter of one of these statuses by simply clicking the “X” sign alongside this filter lower down and you will then be able to see your entire catalog again.
• Speaking of filters, you have a few more options to sort your inventory with.
• Click the “Filter” link to the left top of the table and select which filter option you would like from the “Filter” Drop-Down Menu provided, i.e. SKU, Item Name, UPC, Item ID, Item Status, Lifecyle, GTIN, Inventory Status, Price, Status Change Reason (which is the reason that a particular item changes status.
• For example, items are unpublished when they are missing an image or violating our pricing rules.), Average Customer Rating (This is on a scale of 0-5 stars); or Number of Reviews.
• You can then proceed to select from additional Drop-Down Menus to the right of this filter option or enter relevant text, depending on which of the above you choose.
• You can even add additional filters beneath this initial filter by clicking the “+ Add Filter” link beneath it.
• You can then “Clear Sorting”, “Clear all filters” or “Apply Filters” all in the top left side of the table.
• Using the “Preferences” link to the top right of the page, you can also “Hide Images” or “Customize the Grid” of the table, where you can reorder Columns or hide Columns by unchecking the box to the left of the ones you don’t wish to see.
• You can also then choose to “Cancel” or “Apply”.
• In the top right side of the table, you can also choose to download your list by clicking the “Download” link and selecting whether you would like to:
     * Export the Page – which would be to download the entire table on the page;
     * Download BuyBox Report;
     * Download Item Report; or
     * Download Return Rules Override Reports.
• You also have a text box where you can search for a SKU or Item Name as well as the status Drop-Down Menu alongside it.
• And of course, there is a little button that you can click to add a single new listing!
• If you click on the “+ New Item” you will be taken to the page we mentioned previously in the video on how to add a single new listing.
• Now you have found two places to do this!
• Right, so the top of the Manage Items Page has been discussed, let’s delve a little deeper into the actual listings table. If you check the boxes alongside some or all of your items, you will see further actions appear at the top of the table, namely:
     * Update Price- which, when clicked, opens a pop-up window where you can enter the new price in the text box provided, or alternately, download the price spec sheet, edit the prices on the sheet and then re-upload it here;
     * Update Inventory – which, when clicked, opens a pop-up window where you can enter the new count of inventory on hand or choose to download the inventory update spec sheet and enter the inventory count there before re-uploading it. Should you also ship to Walmart Warehouses, you will be able to choose this option from the Drop-Down menu provided below the “Entering New Count” option; and
     * Retire Items – which, when clicked, opens a pop-up window where you can choose to retire the item/s.
• You can also choose to export your chosen items by clicking the “Export Selected Items” button, which will download a csv file for you.
• Alongside the check box will be the main image for your item.
• The next field – Item Details – shows your product title and SKU.
• Should you hover this field, you will see two more icons appear in the bottom right side, namely:
     * View Item – which takes you to the product detail page on the Walmart site; and
     * More – which allows you to click the “Edit Item” link to edit the listing.
• The next field shows the status of your item, i.e. published, unpublished, draft, etc. The following field shows the lifecycle of your item, which is clearly “active” in this example, but it can be “retired” or even “archived”.
• The next field is the Price Field and shows the current price you are selling the product for plus the cost of shipping.
• If you hover over the Price field, you will see these options:
     * Edit – which, when clicked, opens a small pop-up window where you can enter the new price and click the “Submit” button alongside; and
     * A little truck icon -which, when clicked, opens a small pop-up window showing the shipping options for this particular item.
• After this comes the BuyBox field which shows you the status of your item with regards to the BuyBox and we’re winning in this example!
• The following field is the Inventory field, which shows you the current available stock on hand.
• If you hover over this field, you will see a small “edit” icon to the bottom left of the cell, which, when clicked, opens a small pop-up window where you can enter the new count and select which Fulfilment Center if you ship from your own AND Walmart’s warehouse.
• The next field is the Fulfillment Type and our examples are all “Seller Fulfilled”.
• Then you get these fields:
     * The Category;
     * The Average Rating of the item;
     * The Number of Reviews for the item;
     * The Item ID;
     * The Product ID;
     * The Number of Listings – which includes listings of this product by other sellers;
     * The GTIN;
     * The UPC;
     * The commission to Walmart;
     * Comparable SKUs;
     * Timestamp; and
     * The Item Page Link – which takes you to the Product Detail Page on the Walmart Site.
• So now that you have explored this page, you can already see where we are heading when it comes to editing your products as we already know how to do quick edits on Price and Inventory Count right off of this Manage Items Dashboard.
• So, let’s move on to editing a listing.

Editing a Single Listing
• In order to edit a single listing, you will need to go to your “Manage Items” page located under the “Items & Inventory” Heading.
• On this page, you will see a table of all of your listings. Locate your listing that you wish to edit and hover over its title in the “Item Details” field.
• Click on the “More” link which appears and select “Edit Item”.
• You will now be taken to the Single Listing edit page, where you will already be familiar with all of the fields as we went through them when adding a single listing in our very first video of this course.
• Fill in whichever sections need to be updated in the “Item Content”, “Imagery and Media” and “Offer” tabs along the top.
• Once you have made all of your edits, click the “Submit” button at the bottom of the page and your changes will be saved.

Editing Multiple Listings in Bulk Using the Spec Version 3.1 Spreadsheet
• Now, in order to edit multiple products in one go, you would need to make use of spreadsheet.
• While you may find this strange, we recommend you use the Spec Version 3.1 Spreadsheet to make your edits.
• Since you will already have this spreadsheet saved somewhere on your computer when you initially setup the new products, it won’t take much to edit them.
• Let’s walk through the process.
• Open up your previous Spec Version 3.1 Spreadsheet from your computer – this may be the one you used to create the listings in the first place or perhaps you have already made several edits and so you have a later version of this spreadsheet.
• Save this Spreadsheet as the next latest version, normally with today’s date and then proceed to update the copy and information as needed.
• Remember, you can add columns for certain fields should you wish to add more images, more Key Features, override shipping models, etc.
• On your Walmart Seller Center portal, select “Item Setup & Maintenance” from the Options available under the “Items & Inventory” Menu Header.
• On the following page, click the “Add Items in Bulk” link.
• Upload your newly edited spreadsheet either dragging and dropping the file into the box provided or clicking the “click here” link in the box provided.
• Click the “Submit” button to submit your bulk upload.
• Your new products will appear on the “Bulk Updates” page under the “Feed Status” or simply on the “Feed Status” page, which is essentially the same page.

Understanding the Category Spec Sheet
• There are two options available to you should you wish to go the standard route of updating multiple products.
• On your Walmart Seller Center portal, select “Item Setup & Maintenance” from the Options available under the “Items & Inventory” Menu Header.
• On the following page, click the “Maintain Items” link.
• On the next page, you will be presented with the following two options:
     * Option 1: Match Items using GTIN Match option. Enter the GTINs in the space provided and select “Match”. Your spreadsheet will appear in the table below and be ready to download in a few minutes by clicking the “Download” icon to the right of it. The spreadsheet will be the Spec Version 4.0 spreadsheet where you can make the necessary updates in the relevant fields, save the sheet and then upload and submit at the bottom of the page. Since we already know all about this Version Spreadsheet, we don’t need to go through all the fields again. Remember, that you can add additional fields alongside those marked with a (+) symbol, so long as you copy and paste the header and its explanation into the new column alongside it.
     * Option 2: Download Category Spec Sheet option. Select your category from the Drop-Down Menu provided and click the “Download” button. Save the spreadsheet to your computer. This will now be a blank Spec Version 4.0 spreadsheet where you would need to fill in all the details again. This is okay if you already used the Spec Version 4.0 spreadsheet to create your listings as it is a simple “copy/paste” from the original spreadsheet you setup and then an edit of the fields you wish to edit or update. Save this new version and then upload and submit at the bottom of the page. Remember, that you can add additional fields alongside those marked with a (+) symbol, so long as you copy and paste the header and its explanation into the new column alongside it.

Using the Spec Version 3.1 Spreadsheet instead of the Category Spec Sheet
• So, why do we use the Spec Version 3.1 Spreadsheet to update our listings instead of the Category Spec Sheet 4.0 that Walmart provides? Simple.
• The 3.1 version spreadsheet allows us to add far more information faster than the 4.0 version does because of the “add more” links in the 3.1 version instead of us having to manually insert additional columns in the 4.0 version.
• When updating the listings you created, would you not want to be able to fill as many fields as you can as quickly as you can and provide the most information and images for your products? Of course you would!
• Just like we recommended the 3.1 Version Spec Sheet to create your listings, we recommend it again to update and edit them.

Troubleshooting Items with Errors
• Sometimes, in the table provided on your “Feed Status” page, you may find errors.
• Alongside these errors will be a little eye icon, which, when clicked, will open a small pop-up window showing you what the error is and which SKU it affected.
• You can also choose to download this information by clicking the download icon to the far right.
• Sometimes it’s a timeout on the system; other times you entered the incorrect information or the incorrect value of the information, etc.
• To fix these errors, download the spreadsheet, the file that you will receive when you click the download icon in the Error Report column is the full item spec with highlighted errors if there were issues with your information and it was not a system or timeout error – which will be downloaded as a csv file.
• You will see the number of errors and descriptions in columns A and B.
• The cells that contain the errors will be highlighted in yellow.
• Have a look what the errors are and fix them in your spreadsheet before uploading the sheet again as indicated in the previous video.