Master SKU Definitions
These fields define individual products in your inventory, including pricing, dimensions, and supplier details.
MASTER_SKU – The unique identifier for a product used for inventory tracking and sales. Required for import.
PRODUCT_NAME – The official name of the product as listed in your catalog. (Required for import).
PRODUCT_DESCRIPTION – A detailed description of the product, including key features and specifications.
PRODUCT_CATEGORY – The broad classification of the product (e.g., "Electronics," "Apparel"). Required for import.
PRODUCT_SUB_CATEGORY – A more specific classification within the category (e.g., "Headphones" under "Electronics").
TYPE – Specifies whether the SKU is a standalone product or a kit. This column can only contain one of these two options: Product (a single item) or Kit (a bundled set of items). Items included within a kit (kit items) are classified as products, not as kits.
UOM_CLASS – The unit of measure classification (e.g., "Weight" or "Length").
DEFAULT_SELLING_UOM – The unit of measure used when selling the product (e.g., "Each," "Pallet," "12 pack").
DEFAULT_PURCHASE_UOM – The unit of measure used when purchasing from suppliers (e.g., "Carton," "Pallet").
MATERIALS – The raw materials or components used in the product (for BOM tracking). This is a legacy field, consider creating a Bill of Materials instead.
INTERNAL_USE – Indicates if the product is for internal use only (e.g., warehouse supplies, items not sold directly, etc.).
STATUS – The availability status of the product (e.g., "Active," "Discontinued").
TAGS – Keywords or labels to categorize the product for filtering and searches.
PRODUCT_IMAGE_URL – A direct link to the product’s image for online catalogs.
UPC – The Universal Product Code, a barcode identifier for the product.
REORDER_LEVEL – The inventory level at which a reorder is triggered.
LOW_STOCK_ALERT_QUANTITY – The threshold quantity that triggers a low-stock alert.
MINIMUM_STOCK – The absolute minimum inventory level that should be maintained.
WHOLESALE_PRICE – The price charged for bulk or wholesale purchases.
RETAIL_PRICE – The standard selling price for customers.
LINKS – Any associated product links, such as manufacturer pages or eCommerce listings.
SHIPMENT_VALUE – The total cost value of a single unit when shipped.
EFFICIENCY_SCORE – A metric indicating production or fulfillment efficiency.
PACKAGE_COST – The cost of packaging materials per unit.
LABOR_COST – The labor cost associated with manufacturing or preparing the product.
UNIT_COST – The total cost of the product, including materials, labor, and packaging.
DEFAULT_SHIPPING – The default shipping method or carrier for the product.
PRODUCT_WEIGHT – The weight of the product itself (without packaging).
PRODUCT_DIMENSION – The dimensions of the product itself (without packaging). LxWxH and in inches, volume, pounds.
SHIPPING_WEIGHT – The weight of the product including all packaging materials.
SHIPPING_DIMENSION – The dimensions of the product when fully packaged for shipping. LxWxH and in inches, volume, pounds.
BOX_WEIGHT – The weight of a single box containing multiple units.
BOX_DIMENSION – The dimensions of the box containing multiple units. LxWxH and in inches, volume, pounds.
CARTON_WEIGHT – The weight of a full carton of products.
CARTON_DIMENSION – The dimensions of a full carton. LxWxH and in inches, volume, pounds.
UNITS_PER_CARTON – The number of individual units contained in a single carton.
PALLET_WEIGHT – The total weight of a fully palletized shipment.
PALLET_DIMENSION – The dimensions of a fully palletized shipment.
CARTONS_PER_PALLET – The number of cartons that fit on a single pallet.
UNITS_PER_PALLET – The total number of units on a single pallet.
PALLETIZED – A boolean field indicating whether the product is shipped on pallets (Yes/No).
SUPPLIER_NAME – The name of the default supplier for this SKU. This must match the Supplier Name in the supplier import template or under Manage > Suppliers.
LEAD_TIME – The number of days required for the supplier to fulfill an order.
Kit SKU Definitions
Kits consist of multiple component SKUs bundled together as a single product.
Kit SKU – A virtual SKU that represents a kit, meaning it does not exist as a pre-assembled product in inventory. Instead, it defines how the components are grouped together at the time of fulfillment (made to order). This differs from a assembled product created with a BOM (Bill of Materials), which is assembled and stored in inventory before being sold.
Component SKU 1-5 (more fields may be added) – The individual products that make up the kit upon fulfillment.
Quantity – The number of each component included in the kit.
Price – The assigned price for each component within the kit.
(Additional component fields follow the same structure for up to five components.)
Bill of Materials (BOM) Definitions
A BOM defines the components and materials required to manufacture a product.
BOM Name/Product Name – The name of the BOM or the product it corresponds to.
Component SKU – The SKU of a component or raw material.
Quantity – The amount of each component needed for one unit of the final product.
Unit of Measure – The measurement unit for each component (e.g., "Each," "Pound").
Notes – Any additional information about the BOM or components.
Supplier Definitions
Supplier details for managing vendor relationships and payments.
SUPPLIER_NAME – The name of the supplier.
SUPPLIER_DESCRIPTION – A short description of the supplier and its offerings.
SUPPLIER_ADMIN_EMAIL – The primary contact email for supplier management.
STREET_ADDRESS – The supplier’s physical address.
CITY – The city where the supplier is located.
STATE – The state where the supplier is located.
ZIP_CODE – The postal code of the supplier’s location.
COUNTRY_CODE – The country code (e.g., "US" for United States).
DEFAULT_PAYMENT_TERM – The agreed-upon payment terms (e.g., "Net 30").
BANK_NAME – The name of the supplier’s bank for payments.
BANK_ACCOUNT_NUMBER – The supplier’s bank account number for transactions.
BANK_ROUTING_NUMBER – The routing number for the supplier’s bank.
BANK_SWIFT_CODE – The international SWIFT code for supplier payments.
CONTACT_EMAIL – The supplier’s general contact email for inquiries.