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

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