Please wait...

loading...

loading results

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.

Using the Richard Cannon Jewelry Web Service


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
  3. Version 4.0

    Version 3.0

    Version 2.0

Placing Order using API


You can use the API to Place your order .

  • Request
  • Response

Create order checkout


POST /OrderAPI/Order.aspx HTTP/1.1
Host: https://www.rcjewelry.com/
Content-Type: application/json
Cache-Control: no-cache

{
"requestType":"CREATE",
"tokenKey":"XXXXXXX",
"PO_Number":"PO23655",
"OrderDate":"2017-05-01",
"OrderDetails":
[
{
"StockNo":"XXXXX-XX",
"Quantity":1,
"JBoxQty":0
},
{
"StockNo":"XXXXX-XX",
"Quantity":1,
"JBoxQty":1
}
],
"BillingAddress":
[
{
"FirstName":"Richard",
"LastName":"Canon",
"AddressLine1":"130 West Pleasant",
"AddressLine2":"Avenue",
"City":"Banglore",
"CompanyName":"RCJ",
"State":"NJ",
"ZipCode":"XXXXX",
"Country":"US",
"PhoneNo":"XXX-XXX-XXXX"
}
],
"ShippingAddress":
[
{
"FirstName":"Richard",
"LastName":"Canon",
"AddressLine1":"130 West Pleasant",
"AddressLine2":"Avenue",
"City":"Banglore",
"CompanyName":"RCJ",
"State":"NJ",
"ZipCode":"XXXXX",
"Country":"US",
"PhoneNo":"XXX-XXX-XXXX"
}
],
"PaymentMethodList":
[
{
"ProfileName":"XXXXXX",
"PaymentType":"CREDITCARD"
}
],
"OrderNotes":"any custom notes about order",
"ShippingMethod":"1",
"OrderUploadFiles":
[
{
"DocumentType":"Invoice",
"FileContent":"file",
"FileExtenesion":".pdf"
},
{
"DocumentType":"Shipping Carrier Label",
"FileContent":"file",
"FileExtenesion":".txt"
},
{
"DocumentType":"General Note",
"FileContent":"file",
"FileExtenesion":".jpg"
}
]
}


Element Description Format Valid Values
requestType Required.
type of request for order API.
8-character maximum
Valid values for type request are
1.CREATE: to create a new order
2.BYORDERNO:get order status by Order number
3.BYPONUMBER:get order status by PO Number
tokenKey Required.
unique token key to reuest order API.
8-character maximum
PO_Number Required.
unique Purchase order number .
20-character maximum.
OrderDate Optional.
mention order date in folloing date format "YYYY-MM-DD".
8-character maximum
OrderNotes Optional.
A note about the order. .
200-character length
ShippingMethod Required.
method of shippment to place an order .
1-character length
Valid Shipping Methods accepted by RCJ
Id Name Type
1 I will use my own carrier and upload a label Domestic and International
14 USPS 1st Class Mail (Only available for orders under $200. Tracking Number Provided-No Signature Required-3 to 5 Day Delivery) Domestic
25 USPS 1st Class Mail With Signature Domestic
19 USPS Priority Mail(Only available for orders under $400. Tracking Number Provided-No Signature Required-1 to 3 Day Delivery) Domestic
26 USPS Priority Mail With Signature Domestic
3 UPS 2nd Day Domestic
7 UPS Overnight Domestic
20 USPS International First Class Mail (7 to 21 day delivery depending on country-Tracking number provided-Only available for orders under $300) International
23 USPS Priority International (Only available for orders under $400-Tracking number provided) International
24 USPS Priority Mail Express International (Tracking number provided) International
2 UPS International (1-5 day delivery) International
OrderDetails
StockNo Required.
RCJ Stock number like XXXXX or XXXXX-X.
8-character maximum
Quantity Required.
Specify no of items you need to place an order.
Integer number
Valid values like 1,2 etc
JBoxQty Optional.
Specify no of gift box items you need to place with an order.
Integer number
Valid values like 1,2 etc
PaymentMethodList
ProfileName Required.
Saved card profile name for credit card payment
150-character maximum
PaymentType Required.
specify the type of payment.
Valid Values are CREDITCARD,BANKWIRE
BillingAddress
FirstName Required.
The customer's first name .
50-character length
LastName Required.
The customer's last name .
50-character length
AddressLine1 Required.
The customer's mailing address.
100-character length
AddressLine2 Optional.
An additional field for the customer's mailing address.
100-character length
City Required.
The customer's city.
100-character length
CompanyName Required.
The customer's company.
100-character length
State Required.
The two-letter pcode for the customer's province or state.
2-character length
ZipCode Required.
The customer's zip or postal code.
10-character length
Country Required.
The customer's normalized country name.
50-character length
ZipCode Required.
The customer's zip or postal code.
10-character length
Valid formats can be of different types, for example:XXXX-XXXX,XXXXXXX
PhoneNo Required.
The customer's phone number for this mailing address..
20-character length
Valid formats can be of different types, for example:XXX-XXX-XXXX
ShippingAddress
FirstName Required.
The customer's first name .
50-character length
LastName Required.
The customer's last name .
50-character length
AddressLine1 Required.
The customer's mailing address.
100-character length
AddressLine2 Optional.
An additional field for the customer's mailing address.
100-character length
City Required.
The customer's city.
100-character length
CompanyName Required.
The customer's company.
100-character length
State Required.
The two-letter pcode for the customer's province or state.
2-character length
ZipCode Required.
The customer's zip or postal code.
10-character length
Country Required.
The customer's normalized country name.
50-character length
ZipCode Required.
The customer's zip or postal code.
10-character length
Valid formats can be of different types, for example:XXXX-XXXX,XXXXXXX
PhoneNo Required.
The customer's phone number for this mailing address..
20-character length
Valid formats can be of different types, for example:XXX-XXX-XXXX
OrderUploadFiles
DocumentType Required.
Specify type of document.
30-character maximum
valid values for Document type are
Invoice
Shipping Carrier Label
General Note
FileContent Required.
base64 byte String data.
File Size could not exceed 2MB
Valid values like 1,2 etc
FileExtenesion Required.
Extension of file .
5-character maximum
Valid values like
.pdf
.jpg
.doc
.docx
.txt

Response

HTTP/1.1 200 Accepted
Content-Type: application/json; charset=utf-8
{
"resultCode": "Success",
"Message": "Order << Order No>> Created Successfully "
}

Element Description Format
resultCode Overall Status Of response
Success Or Error
Message Error Message or Success Message

Get order status by Order number .

  • Request
  • Response

get order status by Order number


POST /OrderAPI/Order.aspx HTTP/1.1
Host: https://www.rcjewelry.com/
Content-Type: application/json
Cache-Control: no-cache

{
"requestType":"BYORDERNO",
"tokenKey":"XXXXXXXX",
"OrderNo":"XXXXX",
}


Element Description Format Valid Values
requestType Required.
type of request for order API.
8-character maximum
Valid values for type request are
1.CREATE: to create a new order
2.BYORDERNO:get order status by Order number
3.BYPONUMBER:get order status by PO Number
tokenKey Required.
unique token key to reuest order API.
8-character maximum
OrderNo Required.
RCJ Order Number.

Response

HTTP/1.1 200 Accepted
Content-Type: application/json; charset=utf-8
{
"orderNo": "XXXXX",
"trackingNo": "XXXXX"
"PONumber": "PO1234",
"orderStatus": "Complete"
"OrderDate": "7/13/2017"
}

Element Description Format
orderNo RCJ Order number
trackingNo tracking number provided by RCJ
orderStatus status of order like Pending,Complete,Confirmed,Shipped
OrderDate order placed date.

Get order status by PO Number .

  • Request
  • Response

get order status by PO number


POST /OrderAPI/Order.aspx HTTP/1.1
Host:https://www.rcjewelry.com/
Content-Type: application/json
Cache-Control: no-cache

{
"requestType":"BYPONUMBER",
"tokenKey":"XXXXXXX",
"PO_Number":"PO1234",
}


Element Description Format Valid Values
requestType Required.
type of request for order API.
8-character maximum
Valid values for type request are
1.CREATE: to create a new order
2.BYORDERNO:get order status by Order number
3.BYPONUMBER:get order status by PO Number
tokenKey Required.
unique token key to reuest order API.
8-character maximum
PO_Number Required.
unique purchase order number.

Response

HTTP/1.1 200 Accepted
Content-Type: application/json; charset=utf-8
{
"orderNo": "XXXXX",
"trackingNo": "XXXX"
"PONumber": "PO1234",
"orderStatus": "Complete"
"OrderDate": "7/13/2017"
}

Element Description Format
orderNo RCJ Order number
trackingNo tracking number provided by RCJ
orderStatus status of order like Pending,Complete,Confirmed,Shipped
OrderDate order placed date.

Uploading your Amazon Feed File


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
  3. On this page, you can select the file to upload under the 'Upload inventory files' section.

  4. In the drop-down,select 'Inventory Files for non-Media Categories'
  5. Browse to the location of your amazon feed file that you saved in tab delimited format.
  6. 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.