ScxOffer

Unique id of the offer.

Id of the sales channel (the seller account) the offer belongs to. Opaque, tenant-local composite identifier (not a UUID). Pass this value as "SalesChannelId" to restrict the list to this sales channel.

Name of the sales channel (the seller account) the offer belongs to, or null if no name is set.

Id of the catalog channel (for example the Amazon site) the sales channel of the offer is operated on, or null if it is not available. The catalog channel is shared by all sellers; use "SalesChannelId" to address a single sales channel.

Unique name (code) of the catalog channel, or null if it is not available.

Display name of the catalog channel as shown to users, or null if it is not available.

Id of the offer on the sales channel, or null if the channel has not assigned an id yet.

Origin of the offer: "Wawi" if it was created in JTL-Wawi, "External" if it was imported from the sales channel. An imported offer stays "External" after it has been assigned to an item.

Whether the offer is assigned to an item (true) or not (false). If true, "ItemId" is set.

Id of the item the offer is assigned to, or null if the offer is not assigned to an item.

SKU (stock keeping unit) of the item the offer is assigned to, or null if the offer is not assigned to an item.

SKU (stock keeping unit) of the offer. For an offer imported from the sales channel this is the SKU reported by the channel, if there is one; otherwise it is the SKU of the assigned item. Null if neither is available.

Title of the offer. For an offer that is not assigned to an item this is the title imported from the sales channel; otherwise it is the name of the assigned item in the language of the sales channel. Null if none is available.

Combined lifecycle and action status of the offer.

Whether the offer is currently listed on the sales channel.

URL of the offer listing on the sales channel, or null if it is not available.

Point in time since which the offer is active, in UTC, or null if it is not known.

Point in time at which the offer expires, in UTC, or null if no expiry date is known.

Point in time of the last upload of the offer to the sales channel, in UTC, or null if the offer has not been uploaded yet.

Point in time at which the status of the offer was last received from the sales channel, in UTC, or null if no status has been received yet.

Current quantity of the offer: the more recently updated of the quantity stored with the offer and the stock maintained for the sales channel in JTL-Wawi.

Point in time at which the quantity stored with the offer was last updated, in UTC.

Point in time at which the price of the offer was last updated, in UTC, or null if it is not known.

Stock of the assigned item that is available for sale, or null if the offer is not assigned to an item or no stock data exists for it.

Quantity of the assigned item that is reserved in sales orders, or null if the offer is not assigned to an item or no stock data exists for it.

Quantity of the assigned item that is expected from suppliers and awaiting delivery, or null if the offer is not assigned to an item or no stock data exists for it.

Date on which the stock of the assigned item that is awaiting delivery ("QuantityAwaitingDelivery") becomes available, or null if the offer is not assigned to an item or no date is maintained. Only the date part is meaningful; the time part carries no meaning and must be ignored.

Minimum stock level configured for the assigned item on this sales channel, or null if none is configured. Always null for an offer that is not assigned to an item.

Maximum stock level configured for the assigned item on this sales channel, or null if none is configured. Always null for an offer that is not assigned to an item.

Net price of the offer in the default customer group: the price maintained for the sales channel if there is one, otherwise the standard net sales price ("SalesPriceNet") of the assigned item. Null if the offer is not assigned to an item.

Discount in percent on the standard net sales price ("SalesPriceNet") of the assigned item that applies to this sales channel in the default customer group, or null if no price specific to the sales channel is maintained.

Customer group that "NetPrice" and "DiscountPercent" refer to (the default customer group).

Standard net sales price of the assigned item, or null if the offer is not assigned to an item.

Last price uploaded to the channel. Null if no price has been uploaded yet.

Id of the tax class of the assigned item, or null if the offer is not assigned to an item.

Id of the company the sales channel is assigned to, or null if none is assigned.

ISO 4217 currency code of the catalog channel in upper case letters, or null if it is not available.

Id of the channel category the offer is assigned to, or null if the offer has no category.

Identifier of the channel category as used by the sales channel itself, or null if the offer has no category.

Display name of the channel category on the sales channel, or null if the offer has no category.

Global Trade Item Number (GTIN) of the offer. For an offer imported from the sales channel this is the GTIN reported by the channel, if there is one; otherwise it is the barcode of the assigned item. Null if neither is available.

Manufacturer Part Number (MPN) of the assigned item, or null if the offer is not assigned to an item or the item has none.

International Standard Book Number (ISBN) of the assigned item, or null if the offer is not assigned to an item or the item has none.

Amazon Standard Identification Number (ASIN) of the assigned item, or null if the offer is not assigned to an item or the item has none. The value is taken from the item only, so it is always null for an offer that is not assigned to an item.

Name of the manufacturer of the assigned item, or null if the offer is not assigned to an item or the item has no manufacturer.

Weight of the assigned item as maintained in JTL-Wawi, or null if the offer is not assigned to an item.

Processing time of the assigned item in days, or null if the offer is not assigned to an item or the item has none set.