Cost Overrides: Import/Export

Cost Overrides allow you to import your actual distributor costs into Ecommerce. The system doesn't have default cost data, so this feature is essential if you want to use "Cost Plus X" calculations in your Pricing Rules.

Import Cost Overrides

Location: File Center > Cost Overrides > "Client: Import Cost Overrides"

On the left-hand menu, click "Client: Import Cost Overrides"

Step 1 - Download Template

Download the Compatible File Template which is in the blue hyperlink.  Open the File Template from your computer.

For this template and any others in Ecommerce, make sure that you review the developer notes so that you can ensure that your file meets Ecommerce specifications.

Step 2 - Populate Template With Data

This template has three (3) columns, some of which are optional.  Below we offer an explanation of what each column header represents.

Template Columns:

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 in Ecommerce.

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 Job that you just ran in File Center.  The job will be in a Pending or Processing status until Ecommerce 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.

Export Cost Overrides

Location: File Center > Cost Overrides > "Client: Export Cost Overrides"

Exports all current cost override data. Useful for reviewing your cost basis or preparing updates.