NameDescriptionTypeAdditional information
Id

The unique Stuller product ID.

integer

None.

SKU

The unique identifier for each item. This Sku must be included with any web service request related to product information or ordering.

string

None.

Description

The description of the product.

string

None.

ShortDescription

The short description for the product that is a combination of Series/ Quality / Size / Polish information.

string

None.

GroupDescription

The description for the series (group) for which the item belongs.

string

None.

LongGroupDescription

The html encoded long description for the series (group) for which the item belongs.

string

None.

MerchandisingArea

The specific area of the business that merchandising is focused.

string

None.

MerchandisingCategory1

First category in which the product is included.

string

None.

MerchandisingCategory2

Second category in which the product is included. This is a subcategory of MerchandisingCategory1.

string

None.

MerchandisingCategory3

Third category in which the product is included. This is a subcategory of MerchandisingCategory2.

string

None.

MerchandisingCategory4

Fourth category in which the product is included. This is a subcategory of MerchandisingCategory3.

string

None.

MerchandisingCategory5

Fifth category in which the product is included. This is a subcategory of MerchandisingCategory4.

string

None.

WebCategories

The list of all web categories of which the product belongs to which includes the Id of the category and its name.

Collection of WebCategory

None.

Collection

The branded Collection the item belongs to, if applicable.

string

None.

OnHand

This is the quantity of the item we have in-stock. If we have more than 10, we will return 10.

decimal number

None.

Status

Value indicating the current status of a product. Currently Not Available - Status used to identify manufactured product that is "Out of Production" for repair of the master or mold. Item can be backordered. 90 day lead time Made To Order – Item is not planned for replenishment purposes. It is normally only made when it is ordered. Usually holds a 3-5 day lead time. In Stock – Item is active, stocked, and available. Limited Availability – Status used to identify procured items that are sellable and available only when there is an on hand quantity. Same rules and functionality as an In Stock item. Out-Of-Stock – An orderable product that has 0 on hand but can be backordered. It will be shipped when we have more in stock. Special Order - Item is not stocked. Item is non-returnable. While supplies last - Used to identify product that is being liquidated through Stuller Overstock. Cannot be backordered. "<p>"Inactive -The product is inactive."</p>

string

None.

Orderable

Indicates if the product is orderable from Stuller.

boolean

None.

Price

A container for the currency code and price of the product.

Currency

None.

CustomerSpecificPrice

A container for the currency code and customer specific price of the product.

Currency

None.

ShowcasePrice

A container for the currency code and showcase price of the product. Only returned when markups are set for user.

Currency

None.

IsOnPriceList

Indicates if the product is on the price list.

boolean

None.

UnitOfSale

Indicates if the product is sold individually or in a pair. A P followed by a number indicates that it is sold in a pack.

string

None.

Weight

The weight of product."

decimal number

None.

WeightUnitOfMeasure

Unit of measure used to weigh the product.

string

None.

GramWeight

Weight of product in grams.

decimal number

None.

RingSizable

Indicates if the product is sizable in Stuller Studio. NOTE: Additional labor charges are applied for sizing a ring.

boolean

None.

RingSize

The default stock size of ring.

decimal number

None.

RingSizeType

Indicates if the ring is exact or approximate size.

RingSizeType

None.

LeadTime

Maximum time in days of which it could take to fulfill the product if no on-hand inventory is available.

integer

None.

DescriptiveElementGroup

The classification of product (ex. Jewelry) that drives the descriptive element attribute variations.

DescriptiveElementGroup

None.

SetWith

A container for a list of the products that the product is set with.

Collection of SetWith

None.

CanBeSetWith

A container for a list of the products that the product can be set with.

Collection of CanBeSetWith

None.

MadeWith

A container for a list of the products that the product is made with.

Collection of MadeWith

None.

StoneMapImage

Full URL to the Stone map image if applicable.

string

None.

Images

A container for a list of all the product’s images.

Collection of Image

None.

GroupImages

A container for a list of all the product’s group images.

Collection of Image

None.

Videos

A container for a list of all the item videos for the product.

Collection of Video

None.

GroupVideos

A container for a list of all the group videos that are associated with the product.

Collection of Video

None.

ConfigurationModel

A container for a list of all the product’s configurations, if applicable.

ConfigurationModel

None.

ConfigurationModelId

A container for a list of all the product’s configurations, if applicable.

integer

None.

CreationDate

Date the product was added/created in Stuller’s inventory.

date

None.

ReadyToWear

A flag that indicates if a Stuller employee has specifically flagged the item as ready to wear.

boolean

None.

DiscountPercent

A decimal value that indicates that the price of this product can be discounted by this percentage.

decimal number

None.

AGTA

The AGTA code for the product.

string

None.

EarringPostType

Indicates earring post type of the item.

string

None.

ProductType

Indicates the high level product type of the item.

string

None.

Specifications

A container for a list of product specifications.

Collection of Specification

None.

Publications

A container for a list of product publications.

Collection of Publication

None.

SearchFilters

The product filters for a product: Metal type, Karat, Metal color, Product Type, and Price Range

Collection of SearchFilter

None.

Hazardous

Flag that indicates if the product is hazardous.

boolean

None.

Heavy

Flag that indicates if the product is heavy.

boolean

None.

DefaultProductGroupId

ID for the default product group.

integer

None.

CountryOfOrigin

Country of orgin of the product

string

None.

CenterStoneShape

The center stone shape for the product.

string

None.

CenterStoneSize

The center stone size for the product.

string

None.

FullySetImages

A container for a list of all the product’s fully-set images.

Collection of Image

None.

MatchingBand

The matching band for the product.

Product

None.

QualityCatalogValue

The quality catalog value for the product.

string

None.

HarmonizedCode

The quality catalog value for the product.

string

None.