Catalogue import (CSV)

You can bring your catalogue in as a CSV file, from the Catalogue tab (Import CSV). Every import is checked first: Check file shows the errors, warnings and examples of what would be created and updated, and nothing is written until you press Apply. Apply is disabled while the file has errors.

To keep the catalogue in step automatically instead, connect a source. See Catalogue sources.

The product file

Export CSV gives you the full set of columns, in this order:

sku, name, brand, category, type, colour,
metal, audience, sizes, occasions, tags,
images, list_price, currency, status,
metal_type, fineness, net_weight_g,
gross_weight_g, making_type, making_value,
stones_value, stones, hallmark, pricing,
width_mm, length_mm, attributes, barcodes,
size chart

Headers are matched without regard to case, spaces, underscores or hyphens. A column Ateliq doesn't use gives a warning ("Column 'X' isn't used"), not an error.

Updates. For an existing product, only the columns in the file are updated, and a blank cell leaves the stored value as it is. The same SKU twice in one file is an error.

Jewellery columns

For jewellery only. Once any jewellery detail is given, metal_type, fineness and net_weight_g are required.

A stone of kind other needs a label, which a file can't carry: add or change those stones in the product editor.

Attributes

Attributes come from a fixed vocabulary, so the stylist, the agents and your reports all use the same words.

• Fashion: garment, silhouette, neckline, sleeve, length, fabric, craft, pattern, colour.
• Jewellery: piece, metal colour, stone, craft, motif, style.
• Both: occasion.

Write each as facet:value, such as neckline:v-neck|fabric:silk. Facets that take one value accept only one. The Cataloguer agent can suggest attributes from your photos for a person to accept.

Barcodes

Each barcode is code or code:size. A GTIN (EAN-8, UPC-A, EAN-13, GTIN-14, or an expanded UPC-E) must have a valid check digit. Anything else is treated as your own store code: 1 to 32 characters from A to Z, 0 to 9 and . _ / -. A barcode's size must be one of the product's sizes, and the same code can't be on two products. Shoppers and staff scan these at the screens.

The store range file

From the Assortment tab, import each store's range with these columns:

You can also give stock one row per size, with the columns sku, size, qty. Store managers can change only stock, visibility and location.

Limits

• Files up to 5 MB and 50,000 rows.
• The check lists up to 500 errors, each with its row number.
• Exports start with a UTF-8 byte-order mark, so spreadsheets read accents and symbols correctly, and are protected against spreadsheet formula injection.