There are 2 methods for sellers to list jewelry inventory to RapNet:
Single upload: click here to read more
Upload using a CSV jewelry inventory file with images
This page explains the following topics; click on a topic to read more.
List jewelry on RapNet using CSV inventory file
Step 1: Prepare jewelry inventory on a CSV file
Step 2: Photograph and save images
Step 3: Upload CSV file with jewlery inventory and images to RapNet
Important: Jewelry without images only show in your own jewelry listings. They do not appear on buyer's search results.
Step 1: Prepare jewelry inventory file in CSV file
Download RapNet's CSV jewelry template, or use your own jewelry CSV file.
Fill out jewelry details
Refer to RapNet Jewelry Fields Dictionary for guidance.
You can add multiple values for some fields, for example, various metal types:
Separate each value with a comma.
Click here for a list of fields which accept multiple values.
Scroll down to read more about to listing jewelry with multiple images/metals/stone types.
Top Upload Tips: Read Jewelry upload rules for successful uploading first time round!
Step 2: Photograph & save jewelry images
Photograph images:
Dimensions: minimum 1280x1280 pixels, anything lower will not upload.
Photograph images on a clean white background.
Refer to this article to correctly format your jewelry images.
Save jewelry images
Top tip: Image filenames matching the jewelry stock number auto-connect to the correct jewelry item. If the image file names don't match, either
Go to field name Image File Name in the CSV inventory file & type in the media file names.
Or manually connect images to jewelry after uploading. Read more here.
Click here to learn how to auto or manually connect one or multiple images to jewelry.
Step 3: Upload inventory file and images
Jewelry > Upload Jewelry > Multiple
Drag & Drop or browse to select your CSV stock file
Create Listings
To upload jewelry inventory to your Instant Inventory feed only, tick 'Upload items as "Own Stock" items for your Instant Inventory'. Read more here.
Match Your Columns: Match the field names in your uploaded CSV file to RapNet's Jewelry fields.
This step is only required if your column headers do not match RapNet's column names.
Use drop-downs to find unmatched columns in your jewelry file.
Columns
RapNet column name: as per the Fields Dictionary.
Your column name: use drop-down to select the correct column name and match those listed in the RapNet Column Name.
Sample from your file: confirm using an example using a value from your jewelry file.
Important:
Once you select a matching column, it is removed from the drop-down list so you can’t select it again.
You only need to match the jewelry fields the first time you upload. RapNet 'remembers' your mapping for next time. If you later change the field names in your CSV file, you will need to re-match again.
Next: only possible when all mandatory fields are correctly matched.
Review Values: Either skip this step, continue importing file and fix the value later, or fix all invalid values now before moving on.
Number of incorrect values
A corrected value
Fix invalid values
Click the blue edit button
Choose correct values from the drop-down menu
Save the corrected value
Either
Skip this step, continue importing and fix the file later, or
Click Next once you've corrected your values
Import Summary: this page displays the number of succesfully uploaded items and invalid values. On this page, you can:
Download Error File: review & fix error items
Note: This file is only available once for download. Once you've downloaded it, please save as it will not be available for re-download.
Click to scroll down the page & read more about the jewelry error file.
Finish your jewelry import & upload images.
Upload Images: Drag & drop or browse images > Go to Manage My Jewelry
Images below 1280x1280 pixels will not upload.
Jewelry filenames matching the jewelry stock number are automatically matched to the jewelry item.
List jewelry with multiple categories/qualities/metals/gemstones
A jewelry item can be listed with more than one metal type, gemstone or image, and can also fall into multiple jewelry categories.
Example:
Jewelry Style: Bridal, Eternity and Women.
Metal: Rose gold, white gold and yellow gold, 14k, 18k and 24k
Images: 3 plus a video
Jewelry Category: Woman's, Designer Jewelry and new
List a single jewelery item with multiple categories/qualities/metals/gemstones/ images
List jewelery item/s with multiple categories/qualities/metals/gemstones/ images via CSV jewelry upload:
Example: a jewelry item has multiple gemstones and each gemstone has specific details relating to it, as follows:
The item has a 1ct Pear shaped red ruby and 25 round shaped small diamonds
The item's main gemstone is a diamonds with a grading report & report number.
In this case, each gemstone needs its own individual row with its corresponding details. To do this:
Type a gemstone on the same row as the item information and add the corresponding details such as shape/color/lab/carat in the correct cells.
Insert a new row > type in the 2nd gemstone in a new cell directly below the 1st gemstone and type in the additional details for that specific gemstone.
For metals and properties which do not have any corresponding details, type all the properties into one cell, separating each property with a comma.
To add multiple images to a single jewelry item:
If your image file name/s match your jewelry stock number/s, there is no need to type in the image file name/s into field "Image File Name". They will automatically connect to your jewelry item. Read more here.
If your image file name/s do not match your jewelry stock number/sfind column name Image File Name and type in the image file name.
Offer multiple delivery locations, payment terms and conditions
Sellers can offer delivery from the jewelry's location to multiple delivery locations, with individual prices, terms and delivery times based on the delivery location.
Example:
Upload item with multiple delivery locations:
Type in your price/currency (USD only), terms and delivery time
If you deliver to another location, add the delivery location information on the same row using columns: Delivery Location, Delivery Location Price, Delivery Location Currency, Delivery Location Terms, Delivery Location Time
To offer delivery to more locations:
Insert a new row > type in the 3rd delivery location information into new cells directly below the 2nd delivery location.
To offer more delivery locations, keep inserting new rows thereafter.
Fixing invalid jewelry lots & the jewelry error file
If your inventory file contains missing or invalid jewelry values, the valid jewelry items will upload successfully and only the jewelry with missing or invalid values will be supressed.
You can fix the errors either during the upload process itself or after uploading the rest of your valid lots.
We provide you with a jewelry error file to download so you can easily see your errors and where to fix for re-uploading.
Notes:
The error file is only available once for download so we advise you to save it as soon as you've downloaded it.
The error file is cumulative. This means that errors from different uploads are added to one single error file until that error file is downloaded.
Understanding the error file
The error file is identical to your CSV jewelry file, except for the addition of the first 6 columns with the following data: Date & time that the file was uploaded, the RapNet account where the file was uploaded to, the file name and the reason for the error.
An asterix appears in cells with missing mandatory values.
An asterix followed by the incorrect value appears in cells with invalid values.
When can I find & download the error file?
You can download the error file during the upload process or later on the Upload Multiple Jewelry page.
During upload process:
Upload file > Review Values > skip online fix and continue to import file
Import Summary > Download Error File
Upload Multiple Jewelry page > Download Latest Error file
Related Articles: