How to Run Walmart Promotional Offer : Today’s Tip For Sales Boost!

Last Updated on June 1, 2019 by

Sometimes gaining the proper sales on Walmart as well as attracting the right customer can be a bit difficult. In order to make a powerful impact in such a short time, the best thing you can do is run a Walmart promotional offer. You can do this easily by reducing the price a bit for the season. So, are you interest for running Walmart promotional offer? If yes, then we have a video and also a step by step article for you on ” running Walmart promotional offer”.

Benefit of Walmart promotional offer

It can give you some great visibility and edge on Walmart. Also when you need to produce those big sales numbers.Running a Walmart promotional offer properly can give you a huge bang for your buck.

Here is a step by step guide on how you can set up your own Walmart promotional offer.

Step 1. Downloading the “Price and Promo Spec”

First, you will need to login to your seller central.

Then you will need to Download the “Price and promo Spec” template. This is the template where you will need to provide the data for your promotion.

To download the excel feed file you need to go to the panel on your left. There you will see “Bulk Price Updates” option under the “Items and inventory” Menu. Click on “Bulk Price Updates”. It will give you an option to download the “Price and Promo” excel feed file. Go ahead and download the file. It should not take more than a few seconds.

Walmart promotional offer
There will also be an option to upload the excel file directly below the download option. We will upload it a bit later after providing the necessary data.

Step 2. Read the Instructions and Definitions

Please open the Excel file that you just downloaded. Inside Excel, On the yellow Message Bar, click Enable Content. The file will open as a trusted document and will enable the “Macros” automatically which is needed to work in this file. You will see that the excel file contains two different sheets.

The first sheet will give you complete instructions on how to fill it with the necessary data. It will tell you what each data field requires, the purpose of each column, and how to fill them up so you can get going with your promotion. Give it a read before you start filling it up.
Walmart promotional offer

The other sheet is the “offer” sheet where we provide all our date for the promotion.

Step 3. Fill up the “Offer” Sheet with necessary data

Now it’s time to fill up the “Offer” sheet of the excel file. Necessary fields are SKU, Price, Promotion Status, Promo Price, Promo Type, Promo Placement, Promo start date, and Promo end date. Here are some explanations for each field so you can easily fill them up.

SKU:

Under the SKU field provide the SKU of the items that you want to run the promotion for. It is a mandatory field.

Price:

On the price field you must provide the current price of the item. It is a mandatory field.
Please note: if you only want to update your price (Nor run a promotion) then just update the price on this column and do not put anything on the “Promotional Price”

Promotional Price:

This is the price that you want to offer your customers for the duration of the promotion. You want to offer an attractive price that will grant you greater visibility on Walmart. Please put the offered price in this field.

Promo Start date and Promo End date:

Here you provide the date that you want your promotion to start on and the date that it will end. These two sections are very important and can generate errors if the conditions are not met.

Here are the conditions for setting the start and end dates.

  • The end date of a given promotion should be 365 days from the current date and time. Any promotions beyond 365 days will result in an error.
  • For any SKU, a promotion end date can’t be before or equal to the promotion start date. Uploading a Spec with overlapping dates will result in an error and cause the entire Spec to be rejected.
  • Promotions should be set up at least 4 hours before the start date. If a promotion start time is less than 30 minutes from the current time, it is not guaranteed that your promotion will go live at the start time.

Promotions Status:

Here we will set the status of our promotion. We can make it active by setting the status as “Active” Or we can choose to delete the promotion entirely by setting the status as “Delete all”. Here, for our purpose, we must set Promotions Status as “Active”.

There are also “Promo Type” and “Promo Placement” fields which are not mandatory for our purpose at this time. Please see the following picture for an example.

Walmart promotional offer
Please note that You can change Promo Price, Promo Type, and Promo at any time for any promotion, even live ones, as long as you follow the other rules. Start Date and End Date can only be changed for promotions that haven’t started yet.

Step 4. Upload the updated “Price and Promo spec”

Now we can go back to the “Bulk Price Update” sub-menu under “Items and Inventory menu”. Here we will find the option to upload the file directly below the download option. Choose the updated file from where you modified and saved it on your device.

You will find a “Submit” button once the file has been uploaded. If your uploaded file generates an error message then you will find a “bin” button on the right to instantly delete the file.
Walmart promotional offer

Then click ‘Submit’ button to full fill your feed setting.
Walmart promotional offer

If you receive any error message it means that your Spec violated one of the rules listed above. Open your Spec and use Validate Fields in the Walmart Toolbar. If the “validate fields” show green color it means that the data meets all requirements. Correct any errors and make sure that all your promotions follow the rules described above.

Thanks for visiting our website as well as our Blog. Now, let us know your thoughts, are you going to use Walmart promotional offer? Let us know in the comment if you have any more ideas. Please keep reading our blog, we will come again with another important topic of eCommerce world.

Leave a Comment

BLOG CATEGORIES

BOOK FOR FREE CONSULTATION

Sign Up For Our Newsletter

Keep yourself updated with latest trends to maximize revenues across all of your sales channels.

POPULAR TAGS

What Clients Say About Us?

Wow, their team has been great! I have been working with freelancers and remote marketing agencies for about a decade and they are among the best.

Isaac Curtiss

Office Furniture Outlet INC.

Helped overcome difficult tasks that would have taken us a lot of time. We do recommend their services!

Blake Tanner

Tanner International INC.

I’ve been working with Fred and his team for the past few months and have been very happy with their work.

Dan Hawkins

Mixles Limited

Great help/addition to our business. All tasks are fully completed in a timely manner.

Maurice Embry

Sam Tucker LLC

Used for years now and wil continue to use for many more years. I also have no doubt recommending friends and colleagues to use too.

Nathan Reeves

Xenons Online Limited

Our company has worked with Ecomclips for over a year now. I’ve found the team to be very flexible, easy to coach, and adaptable. You won’t regret working with them.

Abraham Kwan

PG Incorporation

The team at Ecomclips has served all my needs with excellence. They are very attentive to my requirements. Communication is fast and crystal clear. I definitely recommend them.

PR

Right Parts Group INC.

So far I have hired Freddy and his team has been excellent, they are guiding me as grow my business. I will continue to work with them.

Bev Matushewski

FiTTeck INC.

Excellent friendly prompt service

Ahmedani

Ahmedani Canada INC.

We’ve been working with Ecomclips for a couple of years now and we are more than happy and appreciative of the their service. Definitely recommend.

Michael Burnley

Zooshoo INC.

A+++ Perfect!!

Imran Hassam

Amedeo Apparels Limited

RECENT BLOG POSTS

Get rid of eBay Seller Account Suspension

In this article, we will discuss the reasons for the eBay seller account suspension and th

Read More

eBay new eBay’s OAuth access token issue on Linnworks

In this documentation, we will discuss recent eBay token issues and solutions on Linnworks

Read More

The Complete Guide to Sell on Walmart – Get Started selling product ..

In this article, we will discuss the complete guide to get started on selling on Walmart a

Read More