Category Archives: Amazon

The Perfect Storm

You may have seen a recent story (here) of an Amazon delivery person spitting on a package and then using his hand to smear his saliva on the package. While this may be an exceptional occurrence, it starkly illustrates the clear and present danger facing America from our selfish, uncaring and lazy choices.

No one should be surprised to see this kind of behavior from an Amazon employee. The evidence documenting the horrible way in which Amazon treats their employees is abundant. Most just choose to ignore it for the alleged “convenience” Amazon provides. It’s payback time.

We’re number one! Again, no one should be surprised. America has the highest number of confirmed COVID-19 cases in the world. Why is this?

America has the perfect distribution system for COVID-19, Amazon. A concentrated, centralized infection point with a far reaching and “to your door” delivery structure. If you’re a virus, Amazon is your dream. In case you missed it (here), Amazon workers have tested positive for COVID-19 at 10 U.S. warehouses. Considering the working conditions at Amazon, expect practically every Amazon warehouse and delivery person in America to be infected.

Now we have to have an uncomfortable conversation. Amazon is not the only reason America has the highest COVID-19 cases, but Amazon has contributed to the lazy and horribly out-of-shape American lifestyle.

According to the CDC, the prevalence of adult obesity increased from 30.5% in 2000 to 42.4% in 2018. It’s not all Amazon of course, but they have made a significant contribution. Clicking a button doesn’t burn near as many calories as walking to the grocery store, like my 91 year old mother did during the great depression.

Now here’s the really scary part. Again, according to the CDC, the prevalence of obesity was 40.0% among America’s young adults aged 20 to 39 years.

When COVID-19 first came to America, they were saying it wasn’t affecting young people, and only those with underlying conditions. This turned out not to be true in America. That’s because there is a huge difference between a typical Chinese or Korean youth and the now nearly typical (40% obese) American youth. Turns out, obesity is a COVID-19 underlying condition.

Please, if you’re overweight, consider yourself as having an COVID-19 underlying condition and take extreme caution. The death toll in America from COVID-19 could very well be staggering.

In the future, if America has one, we may want to reconsider some of the choices we’ve made. Like buying locally from trusted businesses that respect their employees, instead of continuing to rely on the massive corporations that created and fueled this perfect storm.

NOPA Amazon Data Feed

File Specifications

The file format is CSV (comma separated values). These files can easily be imported into Excel or other applications.

Two files are provided, one for Essendant first-call dealers and one for SP Richards first-call dealers.

It is important to choose the appropriate file for your dealership.

All prices are converted to the selected wholesaler unit of measure. There is no need to perform any additional price conversions or calculations.

Data Columns

The following data columns are provided in the file:

Prefix: Your selected wholesaler’s prefix
Number: Your selected wholesaler’s item number with no special characters
UM: Your selected wholesaler’s unit of measure
List Price: Your selected wholesaler’s list price
Amazon ASIN: Amazon Standard Identification Number
Amazon Price: Lowest seller price for the item
UM Diff: Is there a unit of measure difference between Amazon and your wholesaler
Prime: Is the item available for Amazon Prime
Prime Price: Lowest prime sell price for the item
Verified Date: The date the price was verified
Amazon URL: URL directly to the item on the Amazon site

Item Selection

The wholesaler items selected for inclusion in the file are our “A” list of items. This “A” list is the top items as determined by activity on the OPSoftware websites. There are over 400 current and active independent dealers utilizing these sites.

The list is subject to change monthly as activity changes. The “A” list typically ranges between 1500 and 2000 items depending on activity and the wholesaler selected.

How We Match Items

The exact same item can be found on the Amazon site several times, if not dozens of times, under different and unique Amazon Standard Identification Numbers, or ASINs. Just go to the Amazon site and enter AVE5160 and you’ll get two Prime versions of this item plus many more unique ASIN listings for this item.

We choose from this clutter what we think an informed consumer would choose. The following considerations go into our matching process:

  • Prime Items
  • Lowest Price
  • Free Shipping
  • Number of Reviews
  • Number of Sellers

In addition, we also make sure the manufacturer is the same, the unit of measure is the same (or as close as possible), and the item is available and in stock for delivery.

As with any such endeavor, this is a subjective process and relies on the industry knowledge of the person making the matches. All of these matches were verified by someone with over 40 years of experience in the office products industry.

Update Schedule

The data is currently refreshed three times a week. You can expect new versions of the files to be posted on the following days and times:

Monday, 12:00 Noon, Eastern Time
Wednesday, 12:00 Noon, Eastern Time
Friday, 12:00 Noon, Eastern Time

Sometimes there are delays due to changes on the Amazon site and these times cannot be guaranteed. Delays are typically minimal, but can occur unexpectedly. Look in the file at the “Verified Date” column to confirm the latest data feed.

Reporting Issues

You can report general issues and individual item issues by filling out the NOPA Amazon Data Feed Issue Report located at the following URL:

Additional Resources

If you need more data, or have additional needs, please contact We can provide independent dealers with complete lists of all your wholesaler items matched to and pricing for:

  • Amazon
  • Staples
  • Office Depot
  • Quill
  • Costco
  • Sam’s Club
  • Walmart
  • Grainger
  • And more

We also have interfaces to all popular back-end computer systems allowing you to create match-or-beat contract pricing for your entire website or individual customers.


NOPA Teams with Rick Marlette

Is Amazon after your business?

Now you can fight back educating your customers with hard facts about Amazon pricing.

US Communities has signed a contract with Amazon Business to allow local government agencies, schools and others to buy on the Amazon Business Marketplace. Incredibly, there is no special pricing for this contract. The agency is simply allowed to buy on Amazon Business at the same price anyone else pays.

Amazon recently announced they would be raising the prices on low-dollar items to cover the costs of “free” shipping. Amazon is already very high on many common office supply items and this move will make many more office supply items even higher.

The opportunity to inform and educate your customers and potential customers with the facts has never been greater. It’s time for independents to be proactive, even if you don’t perceive Amazon as a current threat to your business.

This is why NOPA has teamed with Rick Marlette of OPSoftware to provide NOPA members with an Amazon Pricing Data Feed, updated three times a week. This data is downloadable from the NOPA website and is not temporary or a promotion. Our intent is to maintain this data feed for as long as possible.

You are encouraged to use this data to show customers how independents are cheaper on many, if not most, of these roughly 2000 top selling items.

  • Post it on your own website – Our Price – Amazon Price (w/date verified)
  • Cherry-pick items you look good on and promote, promote, promote! It’s what Staples does!
  • Use the data in your marketing materials
  • Construct your own timeline of wild price fluctuations
  • Use it to create a match-or-beat contract in your back-end system.

Be creative, and be sure to let us know if you come up with great ideas on how to use the data so we can share with others. There are no limits or restrictions imposed on what you can do with this data.

All the pricing is factored to your primary wholesaler unit of measure with full URL’s to the Amazon item.

Essendant Amazon Data

S.P. Richards Amazon Data