Skip to content

Information

Product data file and photo use

One CSV file lists every orderable item in the AdornTrade catalogue: 7,964 item codes across 2,147 listings, each with its options, the 1, 3 and 8-piece prices, stock status, the date its stock was last checked, the product link and photo links. No account or sign-up is needed.

Download the product data file (CSV, 7,964 rows)

Stock and prices in the file come from the nightly check against source; the latest finished on 25 October 2026. The file is rebuilt from the live catalogue at least every six hours, so it matches the product pages.

What each row contains

One row is one orderable item: a single size, colour, length or stone option of a listing, with its own item code. The file opens in Excel or Google Sheets, and the columns can be mapped onto a store's product import.

ColumnWhat it holds
item_codeThe code for this exact option, for example AT-E83CC4D3-01. It stays with the option for as long as the listing is on sale, and the same code is printed on the commercial invoice and the packing list.
product_codeThe code of the listing the option belongs to.
titleThe listing title as shown on the product page.
material_familyThe material family: 925 sterling silver, moissanite, stainless steel, copper and brass, or natural stone and pearl.
categoryThe product type within that family, such as rings or earrings.
materialThe base metal stated for the listing.
option_1_nameThe first option dimension, such as Size or Color.
option_1_valueThe value of that option for this row. Ring sizes state their system: US sizes, or Hong Kong sizes with the inner diameter in millimetres.
option_2_nameThe second option dimension, if the listing has one.
option_2_valueIts value for this row.
option_3_nameThe third option dimension, if the listing has one.
option_3_valueIts value for this row.
us_ring_sizeFor rings sized in Hong Kong sizes, the US size calculated from the stated inner diameter, to the nearest quarter size.
price_1_usdThe price per piece in US dollars when you buy 1 or 2 pieces of the listing.
price_3plus_usdThe price per piece at 3 or more pieces of the same listing; options can be mixed to reach the quantity.
price_8plus_usdThe price per piece at 8 or more pieces of the same listing. All three prices are charged exactly as shown; shipping is quoted at checkout.
availabilityin_stock or out_of_stock at the time the file was built.
stock_checked_utcThe date this listing was last checked against source for price, stock and options.
product_urlThe product page, opened on this exact option.
image_urlThe photo for this option, or the main photo of the listing.
gallery_image_urlsAll photos of the listing, separated by |, on the first row of each listing.
specificationsStated facts such as base metal, finish, stone, setting and profile, as Label: value pairs separated by semicolons.
descriptionThe product description, on the first row of each listing.

Sample rows

These rows are taken from the current file: one item from each material family, and three sizes of a ring sold in Hong Kong sizes to show the US size column.

item_codetitleoptionus_ring_sizeprice_1_usdprice_3plus_usdprice_8plus_usdavailability
AT-E83CC4D3-01Scalloped Copper Open Cuff BangleRose Gold / Gold5.865.565.39in_stock
AT-A9FA43DA-01Refined 925 Sterling Silver Round Moissanite Tennis Bracelet3.0 mm Moissanite50.4947.9746.45in_stock
AT-B2FF51B3-02Six-Prong Round Stone 925 Sterling Silver Open Moissanite RingHK 9 · inner Ø 15.2 mm (47.7 mm circ.)4½29.2827.8226.94in_stock
AT-B2FF51B3-03Six-Prong Round Stone 925 Sterling Silver Open Moissanite RingHK 10 · inner Ø 15.5 mm (48.7 mm circ.)4¾29.2827.8226.94in_stock
AT-B2FF51B3-04Six-Prong Round Stone 925 Sterling Silver Open Moissanite RingHK 11 · inner Ø 15.9 mm (49.9 mm circ.)5¼29.2827.8226.94in_stock
AT-E66D81B4-01Delicate Gold-Plated Bead Freshwater Pearl BangleGold9.268.798.52in_stock
AT-5EB8E6BB-01Playful Stainless Steel Smile Charm Wavy Chain AnkletGold2.332.222.15in_stock
AT-7705388E-01Sleek Herringbone 925 Sterling Silver Tag AnkletSilver11.0810.5310.19in_stock

Using our product photos

For goods you have bought from AdornTrade, you may use our product photos on your own website, on marketplace listings such as Amazon, Etsy and eBay, and in social media posts and ads for those goods. You may crop and resize the photos and change the background. There is no fee. The photos may not be used to advertise goods sourced elsewhere. The same terms are in our terms of service.

The photo links in the file point to the image files on our site, so they can be downloaded in bulk or imported straight into a store.

Checking stock before you reorder

Each product page shows the date its stock was last checked, and the stock_checked_utc column carries the same date. A size that sells out shows as out_of_stock; on its product page you can register interest and we will let you know if it comes back. How repeat orders, specification changes and discontinued styles are handled is set out in reordering and restocking.