Using Excel to build a Product Import

Setting up your document

1. Select all data on sheet and create a table
2. Insert columns into the table you made such as ProductGroupID, ListPrice, SupplierID, ItemID

Filling the ProductGroupID Column

Read the descriptions of each item and determine what product group the item belongs to

Filling the ListPrice Column

This column should be an equation based on what we would like to markup the item by

The equation should consist of =(CostPrice * MarkupMultiplier)

For a 30% markup the multiplier would be 1.3

Filling the SupplierID Column

This should be consistent for the whole column and is the supplier ID of the supplier you are importing

Filling the ItemID Column

You will apply a prefix to the SupplierPartNo based on what the existing pattern was for that supplier.

For Liberty products the items were prefixed with LIB in our system

The equation should be similar to a =concat("LIB", SupplierPartNo)

Written by Collin Smallegan
1-12-2023