Admin Panel
Creating New Admin Panel User Accounts
Managing Admin User Permissions
Resetting Your Admin Panel Password
Signing Into the Admin Panel
Analytics
Using The Website Analytics Report
Setting Up Google Conversion Tracking for Dealer Spike Forms
Using the New Reputation Management Console
Website Analytics Report FAQ
Tips to Improve Your Site's Search Engine Optimization
Basic DNS Information for Your Website & Email Domain
Changing Metadata through the inline editor
Important Analytics and SEO Terms and What They Mean for Your Site
Content Editing
Image Guidelines and Tips
Adding OEM Promotions to Your Website
Updating Slideshows (Rotating Banners)
New Certified Partner Program Announcement
Creating Modal Pop-Ups with the Announcement Builder
Create Content Pages
Using Basic HTML to Format Text in Inventory Fields and Content Snippets
Managing Staff with the Staff Builder Tool
Changing the About Us Statement on the Home Page
Creating Calendar Events
Using Built-in Web Forms and Leads
Customizing Page URLs
Creating Blog Posts
Tips and Tricks for Laying Out Pages
Changing Hours with the Hours Editor
Managing Announcement Pop-Up Templates
DMS Integrations
How to Turn off Inventory Fields from Updating Nightly
Inventory Trim Matching Guide
DMS Integration Frequently Asked Questions
DMS Integrations Overview (Incoming Feeds)
Getting Started with DMS Integrations
Integration Details for Dealers with CDK Lightspeed DMS
How to Prepare for your DMS Integration
Integration Details for Dealers with an AutoMate DMS
How to Manage your Talon DMS Integration
Dealer Spike Information
Contacting Technical Support
Getting Started
Third Party Partner Program Script Guidelines
Changing Your Billing Information
Getting News and Updates about Dealer Spike
Getting in Touch with Your Account Manager
Ecommerce
Catalog and Product Management
Aftermarket Catalog and Product Management
OEM Catalog and Product Management
Update Ecommerce OEM Prices by Price File Import
OEM Information
StreamsAdmin / OEM Replacement Catalog
Catalog Availablility- Partstream OEM
Private Catalog and Product Management
Examples of Product Data and Attributes
Update Private Catalog Products and Product Groups by User Interface
Update Private Catalog Products and Product Groups by CSV Import
What Should I Know Before Starting a Private Catalog?
Update Fitment by User Interface
Export Ecommerce Products and Product Groups to CSV
Update Fitment by CSV Import
How do I Create and Publish Private/Custom Catalogs?
Delete Products
Hide or Show Ecommerce Product Groups and Categories
Update Image Overrides by CSV Import
Update Cost Overrides by CSV Import
Update Price Overrides by CSV Import
Update Shelf Inventory and Price by User Interface
Update Categories and Category Structure by User Interface
Update Categories and Category Structure by CSV Import
How to Format an Ecommerce SKU for Imports
Hosting Visuals in Media Center
Set Sales on Ecommerce Products
Update Shelf Inventory and Sale Price by CSV Import
Creating Ecommerce Feature Groups
Update Price Rules & Price Overrides by User Interface
Ecommerce Products, Product Groups, Categories and Catalogs
Delete or Exclude a Product Group
Update Product Group Category Mapping by User Interface
Update Product Group Category Mapping by CSV Import
Ecommerce Checkout Process and Orders
How to Charge Shipping
Configure In-Store Pickup
Orders Overview
Configure Shipping
EasyPost - Feature Summary and Set-up
How to Configure Paypal for Checkout
How to configure Authorize.net for checkout
How to configure Stripe for checkout
Lightspeed Web Orders Module
Order Automation
How to Buy Postage
Create Coupon Codes
Getting Started with Ecommerce
FAQs
Ecommerce Terms and Functions
What is the New Webstore Landing Page for Ecommerce?
Ecommerce Setup Checklist and Troubleshooting
Webstore Settings
Configure Inventory Rules
General Account Settings
Accessing Ecommerce
File Center Import and Export Hub
Other Integrations
Inventory
Enhance Digital Retailing with Payment Genie
How to Add a Sale Price to Inventory Listings
Dealerpic360 User Guide
Add and Remove Inventory Units
How to Troubleshoot Duplicate Inventory Units on your Dealer Spike Website
Managing Stock Photos on Inventory Units
About The Vehicle Detail Page
Protecting Manual Changes to your Major Inventory Units
Clearance, Consignment, and Custom Inventory
Adding Youtube Videos to Inventory Units
What to Do If Your Inventory Isn't Updating
Tips on Troubleshooting VIN Issues
Changing Inventory Prices
Sold Inventory Units Still Showing on Website
Managing Rental Inventory
Exporting / Printing Out Your Inventory
Adding Overlay Text to Inventory Units
Managing Featured Inventory
Managing Multi-Location and Multi-Site Inventory
Managing Inventory Display Order
Recently Viewed Inventory
Adding Units that Aren't in the Vehicle Database
How to Edit/Update Inventory Units in the Inventory Manager
Leads
Tips for Managing Leads to Increase Sales
Leads Manager
Change Lead Email Settings
Approving and Rejecting User Surveys and Testimonials
Printing Finance App Leads
Exporting Leads
Marketing
Newsletter
Log into the Dealerspike Newsletter tool
Resetting Your Newsletter Password
Creating a Newsletter
Importing an Audience List into the Newsletter Tool
Exporting Newsletter Contacts to a CSV File
Outbound Feeds and Syndications
- All Categories
- Ecommerce
- Catalog and Product Management
- Update Price Overrides by CSV Import
Update Price Overrides by CSV Import
Price Override imports grant you the ability to Import exact pricing for each Distributor SKU in Aftermarket and Private Catalogs. They also enable you to Export every single Price Override that you have in place already.
If you are looking to update OEM pricing see Ecommerce OEM Price update by Price File Import.
Browse to File Center from the main navigation bar.
Step 1 - Download Template
On the left-hand menu under Price Overrides, click "Client: Import Price Overrides".
Download the Compatible File Template which is in the blue hyperlink. Open the File Template from your computer.
Step 2 - Populate Template with Data
Open the csv file that you just downloaded. This template has four (4) columns, some of which are optional. Below we offer an explanation of what each column header represents.
Catalog.name
The catalog where the sku that you are overriding exists.
- If you are trying to override an aftermarket sku and you would enter AFTERMARKET (all caps)
- If you are trying to override a Private Catalog sku you would enter PRIVATE.
Source.name
This is where you want the override applied. Enter Webstore (proper capitalization)
DistributorPart.distributor_sku
The sku from the distributor but in the software's format with the proper prefix. If you are unsure what the correct format or prefix is please visit this article pertaining to the Aftermarket Catalog and distributor prefixes.
How do I get the distributor SKU into the correct format with prefix? Click Here
PriceOverride.price
The exact price that you want this SKU to display on the provided marketplace. Must be a valid decimal number. No $ symbol
Correct way = 43.99 Incorrect way = $43.99
Correct way = 87.00 Incorrect way = 87
Step 3 - Upload Your Data
When you click "Client: Import Price Overrides" you will see "Choose File" next to File Upload. Click this button to locate the file on your computer. Double click your file and it will be ready to go.
Enter your email address if you want to be notified when the job is complete. (optional)
Click Submit
Step 4 - Monitor Job Processing
You will want to monitor the Price Override Job that you just ran in File Center. The job will be in a Pending or Processing status until the system has completed it. These jobs typically take 30-60 minutes depending on the size of the csv file.
Once finished you will see the job Completed or Complete w/ Warnings. Click on the job and you will have access to a Processing Report. Open the report and the success or failure of each line item will be reported.
Key Notes
How to Clear a Price Override
You can clear an override by supplying an empty cell on the Price Override input. Priceoverride.price
Careful with your Copy/Paste
When you are working with multiple files and templates there is no doubt that you will do some copy and paste. Make sure that when you copy data that you do one of the following:
- Paste Special - Text Only
- Paste Values
- Paste Unformatted Text
Main Reasons for File Upload Failure
- Trailing space on the end of a cell value. Make sure there are no spaces after the last character on your Distributor sku, no spaces after the last decimal of price, no spaces after the marketplace.
- Misspelled Marketplace. Webstore spelled incorrectly, etc
- Misspelled Catalog. Aftermarket spelled incorrectly, etc
Export Applied Overrides
Next to the Import Price Overrides job you will also see an export option. This allows you to export all Price Overrides that exist in your application for future changes.