Integrating the Richard Cannon Jewelry product feed to your website

There are several ways you can access the product feed to integrate the product feeds onto your own website or market place. We have outlined the various methods below.

• Product Feed API
• Order Checkout API
• Amazon Feed
• .XLS/.XML Feed

You can use the web service to download and consume the product feed programmatically by following the steps below. The advantage of this is having a live feed in place with updated inventory data instead of manually maintaining any updates to a product feed. You also have the option to consume the feed with your own custom titles and descriptions that you can provide in bulk via an excel sheet.

1. Once you have created your product feed, copy the unique access key associated with the feed.
2. Write a program that downloads the feed to your server and database.
   
   Following versions are avaliable in API

Version 4.0

3. Add a web service reference to your program by adding the following URL: https://rcjewelry.com/WebAPI4/ProductFeedVersion4.asmx

4. Use following methods to consume the feed,know the status of stock,related products items and similar products:


• You need to get access token key to consume these methods. You can get access token key by login into Richard Cannon Jewelery then go to Account Setting Tab and get the token key in Web API AccessToken tab
• Use the GenarateXML method to consume the feed in your program which will return response as XML string of list of inventory items.
  • Request
  • Response

  GenarateXML(tokenKey,accessKey)

  Element	Description	Format
  tokenKey	Required. unique token key to consume product feed.	10-character maximum
  accessKey	Required. Merchant’s unique API Login ID. unique access key for your product feed	32-character maximum.

  GenarateXML(tokenKey,accessKey)

  Element	Description	Format
  RCJXMLResponseType
  resultCode	Overall Status Of response	Ok Or Error
  Message	Error Message or Success Message
  ResponseXmlString	XML string of list of inventory items

• Use the GenerateXMLForAllProducts method to get list Of inventory items with status of product like out of stock,In stock .
  • Request
  • Response

  GenerateXMLForAllProducts(tokenKey,accessKey,isAllProducts)

  Element	Description	Format
  tokenKey	Required. unique token key to consume product feed.	10-character maximum
  accessKey	Required. Merchant’s unique API Login ID. unique access key for your product feed	32-character maximum.
  isAllProducts	value should be true or false .

  GenerateXMLForAllProducts(tokenKey,accessKey,isAllProducts)

  Element	Description	Format
  RCJXMLResponseType
  resultCode	Overall Status Of response	Ok Or Error
  Message	Error Message or Success Message
  ResponseXmlString	XML string of list of inventory items with status of each product

• Use the GenerateOutOfStock method to get recently affected product items .
  • Request
  • Response

  GenerateOutOfStock(tokenKey)

  Element	Description	Format
  tokenKey	Required. unique token key to consume Method.	10-character maximum

  GenerateOutOfStock(tokenKey)

  Element	Description	Format
  RCJOutOfStockResponseType
  resultCode	Overall Status Of response	Ok Or Error
  Message	Error Message or Success Message
  RCJProductStockStatusEntityList	list of product items with information like stockno,price,itemtitle,imageurl and status of each product

• Use the GenerateOutOfStockWithFilter method to get recently affected product items based on given filter.
  • Request
  • Response

  GenerateOutOfStockWithFilter(tokenKey,FilterToken)

  Element	Description	Format
  tokenKey	Required. unique token key to consume Methodd.	10-character maximum
  FilterToken	Required. Filter Token like OUTOFSTOCK OR DISCONTINUED OR BACKINSTOCK.

  GenerateOutOfStockWithFilter(tokenKey,FilterToken)

  Element	Description	Format
  RCJOutOfStockResponseType
  resultCode	Overall Status Of response	Ok Or Error
  Message	Error Message or Success Message
  RCJProductStockStatusEntityList	list of product items with information like stockno,price,itemtitle,imageurl and status of each product based on filter token

• Use the GenerateOutOfStockWithDateFilter method to get recently affected product items based on given filter and date range.
  • Request
  • Response

  GenerateOutOfStockWithFilter(tokenKey,FilterToken,fromDate,toDate)

  Element	Description	Format
  tokenKey	Required. unique token key to consume Method.	10-character maximum
  FilterToken	Filter Token like OUTOFSTOCK OR DISCONTINUED OR BACKINSTOCK.
  fromDate	Required. start date .	Should be in Date Format
  toDate	Required. End date .	Should be in Date Format

  GenerateOutOfStockWithFilter(tokenKey,FilterToken,fromDate,toDate)

  Element	Description	Format
  RCJOutOfStockResponseType
  resultCode	Overall Status Of response	Ok Or Error
  Message	Error Message or Success Message
  RCJProductStockStatusEntityList	list of product items with information like stockno,price,itemtitle,imageurl and status of each product based on filter token and date range

• Use the GetStockStatus method to get status of perticular like out of stock,in stock and discontinued.
  • Request
  • Response

  GetStockStatus(tokenKey,StockNumber)

  Element	Description	Format
  tokenKey	Required. unique token key to consume method.	10-character maximum
  StockNumber	RCJ Stock number like XXXXX or XXXXX-X.	8-character maximum

  GetStockStatus(tokenKey,StockNumber)

  Element	Description	Format
  RCJStockStatusResponseType
  resultCode	Overall Status Of response	Ok Or Error
  Message	Error Message or Success Message
  RCJStockStatus	product item with information like stockno,itemtitle and status of product

• Use the GenerateRelatedProducts method to get list of related products for given stock number.
  • Request
  • Response

  GenerateRelatedProducts(tokenKey,StockNumber)

  Element	Description	Format
  tokenKey	Required. unique token key to consume method.	10-character maximum
  StockNumber	RCJ Stock number like XXXXX or XXXXX-X.	8-character maximum

  GenerateRelatedProducts(tokenKey,StockNumber)

  Element	Description	Format
  RCJRelatedProdcutsResponseType
  resultCode	Overall Status Of response	Ok Or Error
  Message	Error Message or Success Message
  RCJRelatedProductsList	list of related product items with information like stockno,itemtitle,category,price and status of each product for given stock number

• Use the GenerateSimilarProducts method to get list of similar products for given stock number.
  • Request
  • Response

  GenerateSimilarProducts(tokenKey,StockNumber)

  Element	Description	Format
  tokenKey	Required. unique token key to consume method.	10-character maximum
  StockNumber	RCJ Stock number like XXXXX or XXXXX-X.	8-character maximum

  GenerateSimilarProducts(tokenKey,StockNumber)

  Element	Description	Format
  RCJSimilarProductsResponseType
  resultCode	Overall Status Of response	Ok Or Error
  Message	Error Message or Success Message
  RCJSimilarProductsList	list of similar product items with information like stockno,itemtitle,category,price and status of each product for given stock number

Version 3.0

3. Add a web service reference to your program by adding the following URL: https://rcjewelry.com/webapi3/productfeedversion3.asmx

4. Use following method to consume the feed:

• Use the GenarateXML method and access key parameter to consume the feed in your program which will return resonse as XML string of list of inventory items.

  GenarateXML(accessKey)

Version 2.0

3. Add a web service reference to your program by adding the following URL: https://rcjewelry.com/webapi/productfeed.asmx
4. Use one of the below methods to consume the feed:
• Use the GetFeedData method and access key parameter to consume the feed in your program which will return an object with list of inventory items. The method should be initialized prior to calling of GetFeedData using the method InitializeFeed

  GetFeedData(accessKey)

• Use the GetFeed method and access key parameter to consume the feed in your program which will return an object with list of inventory items.

  GetFeed(accessKey)

• Use the GetFeedXML method and access key parameter to consume the feed in your program which will return resonse as XML string of list of inventory items.

  GetFeedXML(accessKey)

• b) Use the GetFeedWithCustomTitle method to consume the feed with your own custom product Title and Description. To use this option, use an Excel file to populate the custom title and descriptions for the stock numbers in your feed, and then pass this excel file to this method. You can download and save the excel template to use here.

  GetFeedWithCustomTitle(accessKey, fileName, fileData)

  where
  accessKey is the unique access key for your product feed.
  fileName is a the file name of the excel file that you are using with the full path.
  fileData is the system object value for an excel application object, in byte data format.
  
  e.g., in C#.net, one way to write this would be:
  

  byte[] fileData = File.ReadAllBytes(string filepath);

  We recommend that you update the feed stream once every day to ensure you have the latest product data on your web site/application.

You can use the API to Place your order .

• Request
• Response

Get order status by Order number .

• Request
• Response

Get order status by PO Number .

• Request
• Response

The Amazon feed file that you will be downloading is in .csv (excel) format. Before uploading this onto using your Amazon Seller Central account, you will need to convert it to a text delimited file. To do so, open your feed file in Microsoft Excel.

1. Go to File and Save As...
2. Under 'Save as type' , select the following file type: Text (Tab delimited) (*.txt)

Once the file is prepared, login to your Amazon Seller Central account.

To upload the inventory file in bulk, go to:

1. Click on the Inventory tab
2. Select Add Products via Upload
On this page, you can select the file to upload under the 'Upload inventory files' section.
3. In the drop-down,select 'Inventory Files for non-Media Categories'
4. Browse to the location of your amazon feed file that you saved in tab delimited format.
5. Click Upload Now

Customizing your Amazon Feed File

You can make configurations to your amazon feed file if you wish. Below are explanations of some of the fields to help you.

Columm Name	Explanation of usage
ProductName	The item title
Description	The item description
BulletPoint1-5	If you wish to list information in bullet points about the item, you can enter them here
SalesPrice	If you would like to offer your item on sale, you can specify the sale price here. This will strikethrough the original price of the item.
SaleStartDate	The start date when you want to offer the sale price. Must be filled in if you are specifying a SalesPrice above in format yyyy-mm-dd.
SalesEndDate	The end date of when you want to end offering the sale price. Must be filled in if you are specifying a SalesPrice above in format yyyy-mm-dd.
UpdateDelete	If you wish to delete items in bulk, you can specify Delete in this column. If left blank, the default operation is Update.

You can also manually edit individual listings in Amazon seller central directly to customize your items.