When importing Master SKUs using Excel, you need to provide product weights and dimensions in a specific, easy-to-follow format. Here's exactly how to fill in these details:
Weights
Weights can be entered in ounces (oz) or pounds (lbs). Here are the column names and how to fill them out:
Columns:
Product Weight
Shipping Weight
Box Weight
Carton Weight
Pallet Weight
How to Enter Weights:
You have two simple ways to enter weights:
Default (Ounces): Just enter a number. The system will assume it's in ounces.
Example: Enter
16for 16 ounces.
Specify Unit: Enter the number followed directly by the unit (
ozorlbs) with no space.Examples:
16oz(16 ounces)1lbs(1 pound)1.5lbs(1.5 pounds)
Tip: Only enter one weight value per field to ensure accurate data.
Dimensions
Dimensions should always be entered in inches, using the format LengthxWidthxHeight.
Columns:
Product Dimension
Shipping Dimension
Box Dimension
Carton Dimension
Pallet Dimension
How to Enter Dimensions:
Enter dimensions separated by the lowercase letter
x.Dimensions can be whole numbers or decimals.
Examples:
10x12x8(10 inches long, 12 inches wide, 8 inches high)10.5x12.2x8.0(10.5 inches long, 12.2 inches wide, 8 inches high)
That's all you need to do! Follow these simple formats, and your Master SKU import will work smoothly.