Catalog - Import

Catalog Import is a job that gives a supplier the ability to import sample data into Loupe

The following article is for the new Loupe 2.0 application.

File Structure

The file structure for Catalog Import is simple. Each row in the file corresponds to a single sample. If a sample contains multiple repeated fields or objects (described below) then those are repeated as columns in the file, like in the example below.

Header Row

variant_code

type

collection_code_1

collection_code_2

look

Sample Row

abc-123

ring

RGF

FVG

family

File Template

Here is the Catalog Import file template with example data.

File Protocols

Here is a list of protocols in the file that affect the data in Loupe.

    • Edit - To edit a field’s value in Loupe simply enter valid data in that field. Any valid data will overwrite the existing data in Loupe, with the exception of ‘null’ as noted below.
    • Delete - To delete a field’s value in Loupe, then you must enter null in that field in the file.
    • Ignore - To ignore a field simply leave the field blank / empty in the file. Doing so will not affect the field’s value in Loupe.

Required Fields

Catalog Import has a small set of required fields that must be used for every sample loaded to Loupe. Here is the list of all required fields.

  • variant_code
  • sell_method
  • list_price
  • list_price_currency_code
  • global_type
  • type
  • size
  • size_measurement
  • size_unit_of_measure

Non-Repeatable Fields

Most fields for a sample are not repeatable. Meaning they can only have one value. Here is a list of all non-repeatable fields.

  • master_style_code
  • master_style_name
  • model_code
  • model_name
  • style_code
  • style_name
  • variant_name
  • privacy
  • barcode
  • gold_lock
  • gold_lock_currency_code
  • silver_lock
  • silver_lock_currency_code
  • platinum_lock
  • platinum_lock_currency_code
  • palladium_lock
  • palladium_lock_currency_code
  • design_element
  • design_theme
  • look

Repeatable Fields

There are a few fields that are repeatable by adding a number to the end of the field. For example, you can import multiple images by simply adding a number to the end of the image field name, like ‘variant_image_file_name_1’, ‘variant_image_file_name_2’, etc. Here is a list of all repeatable fields. Just replace the ‘N’ with the number you want to use.

  • variant_image_file_name_N
  • alternative_barcode_N
  • collection_code_N

Repeatable Objects

A repeatable object is like a repeatable field, but it is a full set of data that can be repeated. Repeatable objects also have their own required fields. Each repeatable object has a prefix with a number that can be incremented just like a repeatable field. For example, you can import multiple stones into Loupe by using ‘stone_1’, ‘stone_2’, etc. as the prefix. Then after the prefix you give the field name suffix, like ‘type’, ‘sub_type’, etc. In between the prefix and suffix you simply enter a period. So full repeatable object examples can include ‘stone_1.type’, ‘stone_1.placement’, and ‘stone_2.colour’. Here is a list of all repeatable objects. Just replace the ‘N’ with the number you want to use.

Stones

  • stone_N.id
  • stone_N.type - Required
  • stone_N.sub_type - Required
  • stone_N.total_carat_weight - Required
  • stone_N.placement
  • stone_N.colour
  • stone_N.grade
  • stone_N.cut
  • stone_N.shape
  • stone_N.size
  • stone_N.quantity
  • stone_N.treatment
  • stone_N.certificate_type
  • stone_N.country_of_origin
  • stone_N.carat_weight
  • stone_N.external_reference
  • stone_N.internal_reference
  • stone_N.calculation
  • stone_N.price
  • stone_N.price_currency
  • stone_N.setting_type
  • stone_N.setting_method
  • stone_N.size_minimum
  • stone_N.size_maximum
  • stone_N.quantity_minimum
  • stone_N.quantity_maximum
  • stone_N.carat_weight_minimum
  • stone_N.carat_weight_maximum

Core Materials

  • cm_N.id
  • cm_N.type
  • cm_N.sub_type
  • cm_N.metal_title
  • cm_N.colour
  • cm_N.nickel_content
  • cm_N.metal_loss
  • cm_N.invoiced_metal_title_including_loss
  • cm_N.net_metal_weight