EQ2 SC Marketplace Data

A new collection has been added to EQ2 data: marketplace_data.

The query result is a list of itemIDs with marketplace data. There is no separate category tree. You must read the entire marketplace_item collection and work out all the categories and their parent-child relationships programmatically.

You may get a count of Marketplace items:

Code:

<marketplace_item_list count="1809"/>

Here's an example marketplace_item:

Code:

<marketplace_item alt_currency_cost="4" alt_currency_id="379866960" category="Housing.Furnishings.Matching Furniture.Refined Dark Wood|Housing.Furnishings.Chairs.Stools" cost="35" cost_override_text="" flags="0" house_guid="0" id="2469009756" last_update="1370502334.810351" max_quantity="0" merchant_category="" normal_cost="50" rebate="0" ts="1370502334.810351">
<is_featured value="0"/>
<is_new value="0"/>
<is_cannot_gift value="0"/>
<is_login value="0"/>
<is_consumable value="0"/>
<is_otw value="0"/>
<is_playerstudio value="0"/>
<is_recurring value="0"/>
<is_pon value="0"/>
<is_hot value="0"/>
</marketplace_item>

The id of 2469009756 is an itemid representing the item Red Velvet Stool. At this time, no c:resolve=items is available, so you'll need to do separate pulls against the item collection.

The example item costs 35SC with a normal price of 50SC. From the value difference between cost and normal_cost, you should infer that the item is a Sale item and thus you may choose to display the item in a "Sale" pseudocategory on your site.

In addition to StationCash, the example item may also be purchased with an alternate currency, in this case 4 Goblin Gold pieces. If an alt_currency_id is provided, it is an internal ID which represents:

• 379866960 - Goblin Gold
• 3793001961 - Dungeon Maker
• 4294967295 - None (2 ^ 32)

If cost_override_txt is set, then the item is not a StationCash item but instead displays in-game text, such as "$14.99 per month" for a monthly EQ2 subscription.

If rebate is set, then the item is available for sale at a Rebate. I don't know if this value will be 1, or a decimal representing the percent of SC returned to the customer.

Categories

The category field contains this value:

Housing.Furnishings.Matching Furniture.Refined Dark Wood|Housing.Furnishings.Chairs.Stools


The bar (|) indicates that the item appears in more than one category. The dot (.) indicate the depth of that category. The placement of this item could be represented visually this way:

Housing

Furnishings

Matching Furniture

Refined Dark Wood

Red Velvet Stool​

Housing

Furnishings

Chairs

Stools

Red Velvet Stool​

Marketplace Item Flags

Marketplace items have a number of possible flags. This information is available both in a flags bitfield (which you are welcome to decode at your leisure), as well as a breakdown of values.

is_featured - Item is featured in the Welcome Box when first logging into EQ2.

is_new - Item is New and should indicate this with a banner or other verbiage. You may also categorize this item into a "New" pseudocategory on your site.

is_cannot_gift - This item may not be gifted. This is not shown in-game, but is only discoverable when the Gift button greys out when certain items are collected.

is_login - Unknown

is_consumable - Unknown

is_otw - Unknown

is_playerstudio - Item is a PlayerStudio item. PlayerStudio items generally also appear in the [PS] category.

is_recurring - Item will automatically be rebilled every month/quarter/year. Thus far, this is only used for Expansions and Subscriptions, both of which are hidden in-game.

is_pon - Point of Need item

is_hot - Item is "Hot" and should indicate this with a banner or other verbiage​

Finally, there are 0 items currently set with house_guid = 1, and I don't know what the value would indicate.

 

Very useful! Glad to see this finally added.

However... I notice this doesn't show items that have been removed from the Marketplace, including holiday items and items placed into the <span style="text-decoration: line-through">Disney SOE "vault". Could they add these, maybe with some sort of removed flag?

 

Would it be possible to add null values to alt_currency_cost, cost, and normal_cost, to distinguish between items that cost 0 Station Cash (like the free Antonia/Lucan statues they had) and items without a SC cost (like the spawner booster packs)?

 

It's something I can ask about, but right now, you can tell something is FREE if:

1. cost = 0
2. alt_currency_id = 4294967295

 

Again, Marketplace data is updated regularly, so we use TS (timestamp) to see if we are up-to-date.

The last 10 items which were updated in Marketplace:
census.daybreakgames.com/xml/get/eq2/marketplace_item/?c:sort=ts:-1&c:limit=10&c:show=ts

I have a timestamp "1370761533" (2013.06.09 @ 2:05:33 EST).

The number of items updated after that timestamp:
census.daybreakgames.com/xml/count/eq2/marketplace_item/?ts=]1370761533

The number of items updated before that timestamp:
census.daybreakgames.com/xml/count/eq2/marketplace_item/?ts=[1370761533

 

That should work.