Manual

Send-A-Quote

Note: Set Custom Pricing is available via "Quotes" and "Wishlists" in the salesperson's account area. Once you choose a quote or wishlist, you'll see a "Set Custom Price" link under the product.

Back To Top

Importer

These are the exact instructions on how to work the importer we've built custom to the Joseph's website.
There is an FTP server set up at 64.227.2.129 that Happy Medium hosts with Digital Ocean. This server is strictly for Joseph's Jewlers to upload product files that will be imported by the website nightly.

The file structure should be EXACTLY as follows:

Details.xlsx This file contains basic product data. It's first row should act as headers for these EXACT columns: ItemNum - ProductClass - ProductSubClass - MaterialType1 - Kt1 - LengthUnits - Length - StoneType1 - StoneShape1 - StoneWeight1 - StoneColor1 - StoneClairty1 - StoneMake1 - StoneType2 - StoneShape2 - StoneWeight2 - StoneColor2 - StoneClairty2 - StoneMake2 - StoneType3 - StoneShape3 - StoneWeight3 - StoneColor3 - StoneClairty3 - StoneMake3 - StoneType4 - StoneShape4- StoneWeight4 - StoneColor4 - StoneClairty4 - StoneMake4 - StoneType5 - StoneShape5 - StoneWeight5 - StoneColor5 - StoneClairty5 - StoneMake5 - ItemColor - MaterialType5 - Kt5 - MaterialWt5 - WebItemFlag - ListPrice - MerchandiseCode

Inv.xlsx This file contains inventory data. The ItemNum column is cross-referenced with the column by the same name in Details.xlsx. There can be multiple rows with the same ItemNum if the item is located at multiple locations (defined by the LocationNum column). It's first row should act as headers for these EXACT columns: ItemNum - LocationNum - PiecesOnHand

Mch.xlsx This file contains the item names. The ItemNum column is cross-referenced with the column by the same name in Details.xlsx. It's first row should act as headers for these EXACT columns: ItemNum - LineNum - Text

Mkt.xlsx This file contains the item descriptions. The ItemNum column is cross-referenced with the column by the same name in Details.xlsx. It's first row should act as headers for these EXACT columns: ItemNum - LineNum - Text

The Images Directory Product images should be placed in this folder. Their file names should begin with an ItemNum from Details.xlsx. After the ItemNum in the file name, any sort of characters can be used to associate multiple images with the same product. For example: CSBCT00028.JPG CSBCT00028specialDiamond.JPG CSBCT00028emeraldRing.JPG

Back To Top