Enhanced Product & Stock Data

Who are these for?

Rich product and stock data in a variety of formats so you can display our products on your website. Please note, some manual work will be required to ensure our Enhanced Product & Stock Data suits your shop’s needs.

Our product data can be used on e-commerce platforms such as Magento, WooCommerce, BigCommerce, Squarespace and Wix, but please visit your e-commerce platform’s support centre for further technical guidance. 

What's included?

We’ve listened to your feedback and added the most requested features you've been looking for, including: 

• More product imagery – our data now features model shots and images for each colourway
• Greater colour information – colours are now referenced by CMYK and pantone values
• Richer product data – including material compositions and weights, commodity codes and country of origin
• New category and product use information – making it easier to organise products to meet your website’s navigation needs
• Product availability and promotions - know when a product is new, on clearance or discontinued
• Access product data via our API - keep your website's product and stock data in sync with PenCarrie 

What's new?

Last updated Wednesday 20th April 2022

Three new fields have been added to the Enhanced Product Data:

• Grouped Products - a list of product codes to indicate other versions of the product is available in either mens, ladies, unisex, kids or infants
• Similar Products - a list of similar products curated by PenCarrie
• Related Products - a list of related products curated by PenCarrie

For more information please see ‘file specification’ in the support section below. 

Data available

• Product data
• Stock Data

Product data via our API

We offer an Enhanced Product Data feed via our API (subject to reasonable use), so you can stay in sync with PenCarrie product updates. 

API Authorisation

You’ll need an API Access Token to access the API, which can be generated as follows:

1. Go to My Account > Account Settings > API Access Tokens.

   Click “Create New Token” and give the Token a descriptive name of your choice.

   Click “Create” and then copy the access token generated - it's a very long irregular-looking string of characters with some dashes in it that appears in a text area at the top of the page – for security reasons, you'll only be able to copy this text once. If you don’t do this, you'll need to revoke the token and create a new one.

Download File API Call

• The API calls to retrieve product data files are GET requests to one of the following URLs with an Authorization header of Bearer $TOKEN, where $TOKEN is the access token created above.

  • https://www.pencarrie.com/api/public/v1/export/products.zip (CSV format)

    https://www.pencarrie.com/api/public/v1/export/product-xml.zip (XML format)

    https://www.pencarrie.com/api/public/v1/export/product-sql.zip (SQL format)

• The response is a ZIP file containing the data file(s) in the specified format.

• The equivalent calls using the cURL command-line utility are as follows.

  • curl -o products.zip -X GET https://www.pencarrie.com/api/public/v1/export/products.zip -H "Authorization: Bearer $TOKEN"

    curl -o product-xml.zip -X GET https://www.pencarrie.com/api/public/v1/export/product-xml.zip -H "Authorization: Bearer $TOKEN"

    curl -o product-sql.zip -X GET https://www.pencarrie.com/api/public/v1/export/product-sql.zip -H "Authorization: Bearer $TOKEN"

Live Stock Data

We offer a live stock feed via our API which can be requested at a frequency to suit your needs, subject to reasonable use.

API Authorisation

You’ll need an API Access Token in order to access the API, which can be generated as follows:

1. Go to My Account > Account Settings > API Access Tokens
2. Click “Create New Token” and give the Token a descriptive name of your choice
3. Click “Create” and then copy the access token generated - it's a very long random-looking string of characters with some dashes in it that appears in a text area at the top of the page – for security reasons, you'll only be able to copy this text once. If you don’t do this, you'll need to revoke the token and create a new one.

Live Stock API Call

• The API Call to retrieve live stock is a GET request to https://www.pencarrie.com/api/public/v1/stock.csv with an Authorization header of Bearer $TOKEN, where $TOKEN is the access token created above.
• The response is a CSV of free-to-sell stock levels for all SKUs, where values over 500 are replaced with “500+”.
• The equivalent call using cURL is: curl -X GET https://www.pencarrie.com/api/public/v1/stock.csv -H "Authorization: Bearer $TOKEN"

Support

Overview

Files are updated every 24 hours and will include any new and changed products as well as omitting any products that are no longer available from PenCarrie, where applicable.

Regardless of the format chosen, the overall structure and data fields in the files are the same and outlined in the table below. Product data is made up of the following hierarchical levels, although in CSV format this is in a flat file format, meaning data is repeated.

The levels are:

• Style Level - contains data that applies to every product using that code
• Colourway Level - contains data that applies to a specific colour for a style
• SKU Level - contains data that applies to a specific colourway and size for a style

File specification

Categorisation

Every business and website platform is different. That is why we have provided a number of fields that you can use to develop a product categorisation and navigation that meets the needs of your business and customers. Fields such as:

• Suggested Categories
• Suggested Collections
• Care Instructions
• Certifications
• Feature
• Brand
• Gender
• Colour Group

By tailoring these within Excel or Google Sheets, you can develop a rich categorisation for your products that will be unique, make sense to your customers and help differentiate you online.

Images

Images are provided via URL reference in JPG format at a resolution of 886x1024.

Depending on the e-commerce platform used, these can either be referenced directly or migrated to your local website hosting - please consult with your website provider or developer on the best approach.

Model images are licensed for B2C use and will be updated periodically as rights expire. Where you are hosting images for your website locally, we recommend refreshing these every month to ensure you are using the latest licensed version.

Pricing

All prices are shown as net list prices for single, pack and carton rates. 

Margin or markup should be applied to prices before being displayed on your website, along with the appropriate tax rate for that SKU.