You can import batches of mats and mouldings to your account under Menu -> Mats & Mouldings. Select "Mouldings" or "Mats" at the top of the page and locate the "Import data" or "Import images" buttons.
Import Data
The "Import data" function allows you to import all the product information without the images, this is normally the first step when adding new items. For an import to be successful, you must select a properly formatted .csv file on your computer and click "Upload".
Here are the columns to include in a moulding csv file:
- Code - Uppercase alpha-numeric code for the moulding (e.g. MOUL001)
- Vendor - Optional vendor name
- Category - Optional category name
- Description - The description of the moulding (e.g. 1.5" Matte Black)
- Price Code - The price code of the moulding for retail price calculation if you are using this method
- Price - The cost per foot (when imperial) or per meter (when metric) for retail price calculation if you are using this method
- Width - The visual width in inches (when imperial) or centimeter (when metric) of the moulding
- Height - The optional height in inches (when imperial) or centimeter (when metric) of the moulding
- Rabbet - The optional rabbet in inches (when imperial) or centimeter (when metric) of the moulding
- Length - The optional maximum length allowed in inches (when imperial) or centimeter (when metric) of the moulding
- Style - One of the available styles (Regular, Floater, Liner, Fillet)
- Available to - The single digit value of one of the available groups (1 - Users/Customers/Guests, 2 - Users/Customers, 3 - Users, 0 - Disabled)
- System - Should always be set to 0 for custom items
Here are the columns to include in a mat csv file:
- Code - Uppercase alpha-numeric code for the mat (e.g. MAT001)
- Vendor - Optional vendor name
- Category - Optional category name
- Description - The description of the mat (e.g. Conservation Raspberry)
- Price Code - The price code of the mat for retail price calculation if you are using this method
- Price - The mat cost per sheet for retail price calculation if you are using this method
- Core - The color of the mat core (white, cream, black, solid)
- Width - The width of the mat sheet in inches (when imperial) or centimeter (when metric)
- Height - The height of the mat sheet in inches (when imperial) or centimeter (when metric)
- Thickness - The thickness of the mat (normal, double, triple)
- Available to - The single digit value of one of the available groups (1 - Users/Customers/Guests, 2 - Users/Customers, 3 - Users, 0 - Disabled)
- System - Should always be set to 0 for custom items
Please see the sample files included below.
Import Images
Once the data is imported, you can import a zip file holding all the images. Your images should be already cropped jpeg files with the file name matching your item codes. For example, if a moulding has the code MOUL001, the image should be named MOUL001.jpg. Select a properly formatted .zip file on your computer and click "Upload".
Moulding Images
If your moulding images are already tileable or have directional patterns, select "Yes, do not modify them" before uploading. If your images are not already flipped/mirrored and do not have directional patterns, select "No, flip and tile my images".
Mat Images
Imported mat images are always flipped and tiled.
Extra Images
For each mat or moulding, you can add an optional extra image displayed on the design page. This extra image can be enlarged by users and can be anything you want. It can for example be a profile image with measurements, an image showing the side, or a photo of an assembled frame.
To include extra images in your import, add images with the "_extra" suffix in your zip file. For example, a moulding code MOUL001 would have an image "MOUL001.jpg" and an extra image "MOUL001_extra.jpg".
See the example files attached below.