Product data

Product data

This is a batch upload for most information related to your products and/or variants. Categories must exist prior to creation.

Field option

Is required

Description

Id

Optional

Leave blank unless updating

ProductCodeID

Optional

Leave blank unless updating.

ProductCode

Required

This defines your product within Liftoff. This can be alphanumeric and contain hyphens if needed. Note: This value may not be updated for existing products via this batch job.

SKU

Required

This is your product's SKU. This can contain alphanumerics, hyphens, underscores, ampersands, number signs and spaces.

Option1-4

Optional

This is what identifies your SKU options. This field should be formatted as OptionName:OptionValue; for example, "Color:Blue". Please note that option types cannot be changed once they have been created through the bulk upload feature. You can manage any changes using the product management interface.

Classification

Optional

If you have any defined product classifications, the value of this field must exactly match the value of the classifications you defined. The value is not case-sensitive, but all letters, numbers, and symbols (hyphens, etc) must match. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

Image

Optional

This is the filename for this product and/or variant. The filename must be for a web-ready image such as a .jpg, .png, or .gif. Multiple images may be separated with a comma.

TaxCategoryCode

Required

The default code is '00000', but you may enter any of the appropriate 15-digit tax category codes from this list if your county or state supports product-specific tax codes. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

UOM

Required

This is the product's unit of measure. It identifies how the item is packaged. The value should match the UOM "Unit Code" as you have it defined in your units of measure.

UnitQuantity

Required

This is the quantity of individual units for the UOM selected. For example, "Ea" for "Each" would have a unit quantity of "1". Note that, generally speaking, only a UOM value of "M" would call for a UnitQuantity other than 1.

MetaDescription

Optional

This is for SEO purposes. The maximum length is 250 characters, although most search engines truncate this value to 150-160 characters. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

Title

Required

This is how your product landing page is displayed on browser tabs and on search engine results. This can be alphanumeric and contain special characters. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

UrlPath

Required

This is the URL path for this product's landing page. This can be alphanumeric and must contain dashes in place of spaces. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

ProductIsPublished

Required

This determines whether the product is published on the account's website. The value must be either 1 for yes or 0 for no. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

StartDate

Required

This date specifies when the product will be start being displayed to customers, assuming the product is published. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

ExpiresDate

Required

This date specifies when the product will be stop being displayed to customers, assuming the product is published. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

SKUIsPublished

Required

This determines whether the specific SKU is published on the account's website. The value must be either 1 for yes or 0 for no.

WeightPerUnit

Required

This is the weight of one unit of the SKU, in pounds. If this value is 0, then your site's first shipping option will be $0, and all other shipping options will be disabled. This supports numbers and a decimal.

HandlingFeePerCarton

Optional

This is the handling fee that is added to the shipping charges for the SKU. Enter the value as a decimal amount.

ShipUnitsSeparately

Required

If this SKU always ships in its own box, never grouped with other products (due to dimensions, weight, etc.), you can have the system automatically generate its own shipment ID. The value should be TRUE or FALSE.

Sequence

Optional

This allows you to sort SKUs. The value of the SKU you wish to display first should be set to 0.

TrackInventory

Required

This sets whether you are tracking inventory for this item. The value should be 1 for yes or 0 for no. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

DefaultOnHand

Required

This is the default inventory level that will be assigned to any new SKUs you create for this product. This does not affect inventory levels for existing SKUs. This value must be a number. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

DefaultParLevel

Required

This is the default par level that will be assigned to any new SKUs you create for this product. Low stock notices are sent when available inventory reaches or goes below the par level. This does not affect the par levels for any existing SKUs. This value must be a number. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

VariantName

Required

This is the display name of the specific SKU. This name is displayed on the product landing page and in customer's carts.

VariantDescription

Optional

This is a brief description of the SKU. It is displayed on the product landing page.

PageText

Optional

This is where you will enter in any information that you want to be displayed on the website for this product. There is no character limit. HTML is supported here. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

ProductName

Required

This is displayed on product listings and in search results. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

ProductDescription

Optional

This is displayed on product listings and search results. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

SearchTerms

Optional

These are any keywords that do not already exist on your product landing page that someone may use to search for the product and/or variant. They do not affect external search engines. Separate terms with a comma. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

QuantityIncrement

Optional

This value is only relevant if RestrictQuantities is set to 1. If you specify a quantity increment value, then available quantities will be incremented by that value between each price break. If you leave this field blank, then available quantities will include only the SKU's specific price breaks.

RestrictQuantities

Optional

This value determines whether a dropdown is presented for quantity selection. This value must be 1 for yes or 0 for no.

AllowOutOfStockOrders

Required

This determines whether backordering is supported for this product. This value must be 1 for yes or 0 for no. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

AllowCustomerUpload

Required

This determines whether you are allowing users to upload their own files for this product. This value must be 1 for yes or 0 for no.

RequireCustomerUpload

Required

This determines whether you are requiring users to upload their own files for this product. This value must be 1 for yes or 0 for no.

CustomerUploadFileFormats

Optional

The values enter here will restrict users to certain allowable file types. Enter the extensions of the allowed file formats. Do not include the decimal.

MaxQuantity

Optional

Enter a quantity value to restrict the maximum quantity of the SKU that may be ordered by a customer.

MetaKeywords

Optional

This is for SEO purposes. Separate keywords with a comma. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

DisplayStockLevel

Required

This determines whether you are displaying the level of stock to your customers. This value must be 1 for yes or 0 for no. Note: This value must be the same for all SKUs of a given product. If different values are specified for different SKUs of a given product in a single batch job, then the last SKU's value will be applied to all SKUs for that product.

Vendor

See description

Required only for new products and/or variants. The value must be entered exactly as specified in the vendor locations (Products --> Vendors --> Edit --> Locations).