To import your products file into the GemHub dashboard, follow the steps below

Get a Sample File

You can download and view a sample product file to use as a template by clicking here.

Product File Format

The first line of your product file must not contain any column headers or titles, the file should start directly with the product details.

The lines or records in the file must contain data for your product using the same columns in that same exact order starting with: SKU, Title, Description, Price, Product Type, Quantity.  If you have additional columns with product details, make sure they come after the initial 6 mandatory columns and you can create custom attributes for the additional columns during the import process.

SKU is the only mandatory field; not providing other columns with attribute titles during the import process will result in those fields being empty.

The existing product types are: Bracelet, Brooch, Diamonds, Earrings, Gemstone, Necklace, Rings, Watch.  Product types are case sensitive and must be written the same exact way to be imported.  If your file contains product types which are not one of the eight pre-existing product types, the products will not be imported.

Please note that a product's title in the import file cannot exceed 100 characters; space between words counts as a character.

Instructions

  1. Prepare your file according to the product file format requirements above. Click on the drop down then Import Products.

Products 9.PNG

  1. Drag and drop your prepared file or upload from your PC by pressing “Browse”.

Products 10.PNG

  1. First, drag and drop the mandatory SKU attribute into the first column.