You may customize your site with your own retail prices to be displayed to your families or while browsing with your dedicated family account. To do so, add your prices to the spreadsheet template found in the customer center, and upload it to to this tab. If you have not uploaded a price, the current MSRP will be used.

Microsoft Excel or another spreadsheet program that can save a file in the .xlsx format.

Update prices in the column labeled “Price”. You may enter prices individually or calculate your prices from the cost you pay for your products. To calculate prices based on your cost, do the following:

1. Add the cost you pay for the item to the column “Your Cost $”.
2. Choose your calculation method
   1. Markup Multiplier: Multiplies Your Cost by the Markup Multiplier
   2. Margin %: Sets your prices based on a target margin you’d like to achieve.
3. Set your global adjustment for Markup or Margin. This will update all prices that have not been manually overwritten
4. Make individual adjustments to prices in the Price column
   1. Enter “X” to reset the price to the MSRP
   2. Leave a price cell blank if you do not want to update that price
   3. Overwritten cells are highlighted in yellow. Once a cell’s formula has been overwritten, any changes to the global adjustments will not affect that cell.
5. Save the document as a .xlsx file (regular Excel file)

File Requirements

Excel Verification: The excel file must be .xlsx. No macros are allowed. The worksheet name containing prices must be “PriceUpload”

SKU Verification: The column header “SKU” must be present. If a SKU within that column is not recognized, it will be skipped and added to the error log.

Price Verification: The column header “Price” must be present. Prices must be readable as decimal numbers. Rows with invalid price formats will be ignored and added to the error log. Note that 0 is allowed as a valid price.

On the Manage Prices page, click “Choose File,” choose your completed pricing template. Click Upload start the update process.

Once the process is complete, you will see a green confirmation that your upload was successful and will be presented with a summary of your uploaded prices, including which have been updated, reset to MSRP, or included errors.

Note: if there was an error processing your file. Try refreshing the page and re-uploading your template and check your file for errors.

To view your prices, log into your family portal and browse your site. Your prices will be displayed next to your products.

See Choosing an account to manage for help switching accounts.

IMPORTANT: Each price upload updates only the prices included in that upload. This means you can update all prices at once or just a single item. It’s up to you. Your most recent price upload sheets are saved on the manage prices page for you to download again.