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: 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",
"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
2 FedEx International (1-5 day delivery) International
3 UPS 2nd Day Domestic
7 UPS Overnight Domestic
14 USPS 1st Class Mail (Only available for orders under $200. Tracking Number Provided-No Signature Required-3 to 5 Day Delivery) Domestic
16 USPS Domestic
17 I will be using my UPS shipping account number Domestic and International
18 I will be using my FedEx shipping account number Domestic and International
19 USPS Priority Mail(Only available for orders under $400. Tracking Number Provided-No Signature Required-1 to 3 Day Delivery) 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
22 I will pick up from RCJ office Domestic
23 USPS Priority International (Only available for orders under $400-Tracking number provided) International
24 USPS Priority Mail Express International (Tracking number provided) 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: 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: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.

Uploading your ebay Turbolister Feed File


If you have an eBay account/store, you can download the Turbolister feed format to upload your feed in bulk to your account/store via the Turbolister listing tool provided for FREE by eBay.

If you do not currently have Turbolister, you can download it locally to your machine here. At this point, the Turbolister application is only supported on Windows platform and cannot be used on Mac operating systems.

It is recommended that you upgrade to the latest Turbolister version, as eBay periodically updates their listing tools for better performance.

For upgrade refer Steps to Upgrade Turbolister section

  1. Download Turbolister and install it locally on your machine. (Double-click the setupUS.exe to start installation.)
  2. Once installed, open up the application and enter your account details as prompted.
    • If this is your first time using Turbolister, select the option to Create a new Turbo Lister file.
    • If you have used it previously, you may be prompted to Open an existing Turbo Lister file.
  3. To import your product feed file, highlight the Inventory window on the top left panel.
    • Go to File > Import Items > From File...
    • Browse to and select your downloaded Turbolister product feed file.
  4. In the Import From File window box, under Import Selected Fields, Select All fields except for ProductID.
  5. Click the Import button which will import your items into Turbolister.
  6. Please note that the feed file should be closed and not in use while doing the import or this step will fail.

  7. Once imported, you will see your product feed items appear at the right hand window panel. Highlight selected or all of the items that you wish to upload to your live eBay account and click on Add to Upload.
  8. The items will then appear under the Waiting to Upload section on the left hand side panel.
  9. From Waiting to Upload, you can either:
    • Click on Calculate Fees if you wish to see the charges for your upload.
    • Or click on Upload All to upload the items to your live eBay account. You will be prompted about the fees that you will be charged. Click Ok to continue.
  10. Once the upload is complete, the items will appear under the Listing Activity window panel under Active Listings. You should now also be able to access your items via your storefront.

Customizing your Turbolister Feed File

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

Columm Name Explanation of usage
Site This indicates the country site where you will be uploading your products to. 0 is for eBay US. See below for additional values for various countries:
eBay Canada = 2
eBay UK = 3
eBay Australia = 15
Format Indicates the format of your eBay listing. 9 indicates a Fixed Price format. You can set this to 1 for Auction format.
Currency Indicates the currency of the listing. 1 indicates USD. Additional values:
CAD = 2
GBP = 3
AUD = 5
EUR = 7
Title The item title
Description The item description
SubtitleText A secondary field to the title, which appears in search results for an item. Max character length is 55. Additional fees apply for this field.
Category 1 This is the category in which your listing appears in. If you wish to edit this, you can look up the category ID options here.
Category 2 Additional category which you want your items to appear in. For a list of Category ID options, click here.
Store Category If you have a custom store category, you can specify the custom ID here. By default this is set to 1 to indicate 'Other'.
Starting Price Item price
Duration The listing duration. By default this is set to GTC (Good Til Cancelled). Other possible values are: 1, 3, 5, 7, 10, 30 (days).
Payment Instructions Any special payment instruction that you would like to add to your listings. Max character length is 500.
PayPal Email Address Your paypal email address. By default this is set to your account email.
Location - Country The location of the item. By default this is set to the Country specified in your account.
ThemeId A list of themes available from eBay can be found here. By default, this is populated with 27 which is the 'Jewelry-Blue' theme
ShippingServiceOptions This is an encrypted field and by default sets the Shipping & Handling to Free Shipping. If you want to modify this, edit one of your listings manually via Turbolister, then export the file into a Turbolister file (Under File>Export) and copy the encrypted value in your exported Turbolister file as the value in this field.
Zip The location of the item. By default this is set to the zip code specified in your account.
DispatchTimeMax Specifies the handling time in business days.
BuyerRequirementDetails/MaximumUnpaidItemStrikesInfo/Count This specifies the maximum number of unpaid strikes a user can have during a specified period (see field below). By default this is set to 2. Other possible values are 3, 4 or 5.
BuyerRequirementDetails/ MaximumUnpaidItemStrikesInfo/Period This specifies the period during which a user can incur a specific number of unpaid strikes (see field above). By default this is set to 30 days (Days_30).
SellerTags This field contains details of Item Specifics that appear in your listing in XML format. These can be edited as you wish but need to be given in correct XML syntax. You can use an XML editor to validate the syntax.
ReturnsAccepted Indicates whether returns are accepted or not. By default this is set to 1 to specify that returns are not accepted. Set to 0 if you accept returns.
ReturnsWithin The length of time in which returns are accepted. Possible values are Days_14, Days_30, Days_60.
Refund Indicates how a refund is given to a user. Possible options are MoneyBack or MoneyBackorExchange.
Variations Specifies the size variations and any dependencies on size variations (such as gram weight). Can be edited, however syntax needs to be valid XML syntax.

You can also manually edit individual listings in Turbolister directly by right-clicking the listing under Waiting to Upload, and choosing Edit...

Product Feeds in .XLS/.XML format


We also provide product feeds in .xls and .xml format which you can download and edit/consume as you wish.

TOP

Steps to Upgrade Turbolister


Run Turbolister as an Administrator

  1. Right-click the Turbolister icon and select Properties.
  2. Click on the Compatibility tab.
  3. Choose the Run this program as an Administrator option.

Update Turbolister

  1. Open Turbolister program.
  2. Click on the Tools > Install Complete Version Update
  3. Follow on screen Instructions. The program after update, will restart.

Note: Please make sure you take the backup of the existing database. To backup use File > Backup Database from the Turbolister menu