Author Archives: rickmarlette

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:

https://forms.office.com/Pages/ResponsePage.aspx?id=6YEXioazKUaJjncu9-u-pNwbMj-xJhhOpTaiJMox9zNUMjlPWFY0VjNTUlgwWU9QQjVXUE1aQ0xQUC4u

Additional Resources

If you need more data, or have additional needs, please contact sales@opsoftware.com. 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