Welcome to our Help Center

Updating OEM Pricing in Bulk

This article will walk you through the steps to upload custom pricing for the OEM catalog. These rules will override your standard pricing rule and will stay in place until you delete the rule or until the "valid until" date expires.

  • Download our Bulk Price Upload file template, Bulk Price Upload.csv, and open it in Excel (or a similar spreadsheet program).
  • Each column is explained below
    • Manufacturer (Required) – List the part manufacturer (Mopar, GM, Ford, Nissan, etc).
    • Part Number Prefix/Part Number (Required) – You can list a part prefix to cover multiple parts, or a full part number to make a change to a specific part.
    • Pricing Strategy (Required)
      • Fixed – Fixed price
      • CostPlus – Enter a percentage to set the pricing rule to add that percentage to the cost
      • MSRPMinus – Enter a percentage to subtract the percentage from the MSRP (List)
    • Value (Required) – For Fixed Price, you must enter a dollar amount. For (Cost +) and (MSRP -), you must enter the percentage you want the product price to be changed by.
    • MSRP (Optional) – Enter the MSRP (List) price.
    • Comment (Optional) – Add a comment explaining why the price change was needed.
    • Valid Until (Optional) – By setting a valid-until date, the price rule will automatically stop after that date. If no valid-until date is set, the price rule will stay in place until it is deleted manually.
  • Save your spreadsheet (be sure to keep it in CSV format).
  • On your Control Panel, either search for "Bulk Part Pricing Loader" or navigate through Products & Categories > Bulk Loaders & Automation > Bulk Part Pricing Loader.
  • Delimiter used to separate the data will be a “Comma (,)”
  • Data update rule will be “Update pricing for exiting rules & add new rules. ”
  • Choose your CSV file.
  • Click the Upload file button.
  • Map the correct fields to the headers of your spreadsheet, as shown below.
  • Click the Import Pricing Info button.
  • The next page will load, and will tell you how many products were changed
  • Check the product on your site
    • Part number 1UB77HDAAG fixed price of $100.00
    • Part number 68216992AA Cost + 10%
    • Part number YD99HDAAA MSRP – 25%

 

Still have questions? You can contact our support team by email at support@revolutionparts.com or call 480-779-7278.


EVERYTHING BELOW THIS BLOCK IS MANAGE-ONLY CONTENT.

This text will not appear on the finished article.

 

This article will walk you through the steps to upload custom pricing for the OEM catalog.

  • Download our Products file template, products-template.csv, and open it in Excel (or a similar spreadsheet program).
    1.png
  • You only need 3 columns filled out to update the pricing, PARTNUMBERBRAND, and SALESPRICE.2.png
  • Add the part numbers, brands, and sales prices to your spreadsheet for all parts you want to update.
  • Save your spreadsheet (be sure to keep it in CSV format).
  • On your Manage Dashboard, click on the Gear icon in the upper-right corner.
    3.png
  • Select Bulk then Imports from the left-side menu.
    4.png
  • Click on the green New Import button.
    5.png
  • From the drop-down menu, select Products.
    6.png
  • Click the Select File button, choose the CSV that you updated earlier and hit OK.
  • Click the Upload File button (the rest of the options can remain as their defaults).
    7.png
  • You will receive a message on the bottom-right corner of the screen, indicating that the upload was successful, and that the system is processing the upload.
    8.png
  • You will see in the activity log that the file is in process, indicated by the yellow arrows to the far right of the line.
    9.png
  • Clicking on the refresh button (next to New Import) will update this page. Once the file has been processed, the icon to the far right will either be a green check, indicating a successful update, or a red warning, indicating an error. 
    10.png
  • If there was an error, you will have the ability to download a CSV file that indicates what the error was.

Still have questions? You can contact our support team by email at support@revolutionparts.com or call 480-779-7278.


If you have any questions, feel free to reach out to us by emailing
support@revolutionparts.com or calling 480-779-7278!

RevolutionParts Logo
Powered by Zendesk