| Info |
|---|
We have updated the uploading process by adding some validation steps; several definitions in Data Mapping were also changed. If you have any questions or issues while uploading SKUs and CSV files, please contact support@wizart.ai |
Image upload requirements
File extension: jpg, jpeg, or png;
Resolution: the smaller dimension of the image should be 1024px (or more) per 1 meter of product physical size;
DPI: minimum 72 pixels. Good quality is 300 pixels.
Color mode: RGB;
The image must contain a fully repeated wallpaper pattern
| Expand | ||
|---|---|---|
| ||
  |
All images must be archived into a ZIP file (make sure that you have a .zip extension)
you can archive images directly to the root of the ZIP file
you can archive folders with several collections in one ZIP file
Maximum size of the ZIP archive - 2GB
| Expand | ||
|---|---|---|
| ||
  |
Requirements for file uploads with metadata.
You can download our default file samples below in CSV or Excel format, fill them in with the corresponding metadata, and upload them to your Wizart PIM account. Please do not forget to save the end file with a .csv extension prior to the upload.
Excel file sample
| View file | ||
|---|---|---|
|
СSV file sample (UTF-8 encoding)
| View file | ||
|---|---|---|
|
| Expand | ||
|---|---|---|
| ||
Excel files should be saved using a CSV extension and UTF-8 encoding (File→ Save As → Save as Type → СSV (comma delimited) → Tools → Web Options → Encoding → Save this document as → Unicode (UTF-8))  |
Step-by-step instruction for MAC users: | Completed CSV file to use as an example: | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
The same file but with an .xlsx extension (please remember to save it with a .csv extension):
Please note that the mandatory fields are highlighted in light yellow; the others may be left uncompleted. |
CSV file field requirements
| Tip |
|---|
You can use your own files with metadata (just don’t forget to save them with a .csv extension) not changing field names or field order as described below. While creating new Data Mapping choose the field name in your file that corresponds to the PIM field to connect them. Note: Field name should not include a space if it consists of two and more words. Please change the space between words to the underscore character “_” (for example: Wallpaper roll length should be written as Wallpaper_roll_length |
The first line must list the names of the fields which will subsequently be used for mapping.
The CSV file must include 7 mandatory fields and any of recommended/optional fields. If there is no information to be displayed in recommended/optional fields, such fields might be not included in the CSV file.
Old Fields | New Fields | Description | Examples/Notes | ||
|---|---|---|---|---|---|
Mandatory fields | |||||
Brand name (brand_name) | Brand name | Brand name. All collections of this brand will be displayed in the catalog inside the corresponding folder | Can be any numeric and/or text values.  | ||
Collection name (collection_name) | Collection name | Name of the collection. All wallpapers from the same collection will be displayed in the catalogue catalog inside the corresponding folder | Can be any numeric and/or text values.  | ||
Article name (article_name) | Article name | Name/code of an article will be displayed in the cataloguecatalog under the corresponding article image | Can be any numeric and/or text values.  | ||
Article image (article_image_path) | Article image | Article image name from the ZIP file There is no need to add extension (.jpg, .png, or .jpeg) to the file name anymore |  Example: 2021-1 | ||
Supplier code (article_vendor_name) | Unique SKU ID | Unique SKU ID/code in your database. This value is required for successful integration with your e-catalogue | Can be any numeric and/or text values. | ||
Width (article_width) | Product Width | Width of wallpaper roll. All measurements must be indicated in meters. The unit of measurement can be changed in your PIM account. Please contact support@wizart.ai for help. | Please mention NUMERIC VALUE only not adding units of measurement (m, cm, etc.): 0.64 | ||
Repeat Width | Width of the pattern itself. (Default value is in meters; if you use another metric system - please, specify it in the Unit field). Usually, the Repeat Width is the same as the Product Width. Please, All measurements must be indicated in meters. | Please mention NUMERIC VALUE only not adding measurements | like meters(m, cm, etc. | All measurements must be indicated in meters.): 0.64 | |
Recommended fields | |||||
Rapport (article_rapport) | Pattern Repeat | Height of repeated pattern (Default value is in meters; if you use another measurement system - please, specify it in Unit field) All measurements must be indicated in meters. | Please mention NUMERIC VALUE only not adding measurements like meters, cm etc. | Examples:  | |
Rapport shift / drop match (article_rapport_shift) | Pattern Offset | How much the next tile must be shifted so that the pattern matches – numeric value in meters. In case of straight/random match leave this cell empty or enter 0 All measurements must be indicated in meters. | |||
- | Article link | Link to SKU on main web-sitewebsite | Full link | ||
Optional fields | |||||
Unit of measurement (unit_name) | Unit | Specify unit of measurement you use for width/length/pattern repeat/pattern offset on your website, but please note that In the CSV file, all measurements must be indicated in meters. The unit of measurement can be cahnged changed in your PIM account. | ft | . Please check the screenshot on the right to see how or contact support@wizart.ai for help. |  |
Length (article_length): | Wallpaper roll length | Length of wallpaper roll (Default value is in meters; if you use another measurement system - please, specify it in Unit field)Please, All measurements must be indicated in meters. | Please mention NUMERIC VALUE only not adding measurements like meters, cm etc. | : 10.05 9 | |
Country (country_name) | Country | Country of origin (where wallpaper was produced) | Germany, Russia, US | ||
Article description (article_description) | Article description | Description of article: up to 1000 symbols | Can be any numeric and/or text values. | ||
Main color (article_main_color) | Main colour | Main color of wallpaper pattern | Green, blue | ||
Color (color_name) | Colour | Colors of wallpaper pattern (use comma to separate colors) | Green, blue, white | ||
Texture (texture_name) | Texture | Texture of wallpaper (use comma to separate textures) | Example: Texture 1, texture 2 | ||
Coating (coating_name) | Coating | Coating of wallpaper (use comma to separate coatings) | Example: Coating 1, coating 2 | ||
Basis (basis_name) | Basis | Basis of wallpaper | |||
Waterproofing (waterproofness_name) | Washability rating | Specify washability rating of wallpaper article | Spongeable | ||
Light resistance (lightproofness_name) | Light fastness | Light fastness is simply the degree to which wallpaper will keep its color in sunlight. | |||
Kind of removal (kindOfRemoval_name) | Removal Type | Specify removal type of wallpaper article | Strippable | ||
Interior (interior_name) | Room type | Type of room where this particular wallpaper design could be applied (use comma to separate room types) | Bedroom, living-room, kitchen | ||
Style (style_name) | Style | Describe style of wallpaper (use comma to separate styles) | Modern, classic, country | ||
Article layout | How wallpaper should be applied on the wall: horizontal/vertical. If not specified, wallpaper will be applied vertically | Horizontal | |||
Reverse | Reverse alternate length: yes/no If not specified, the value will be ‘no’. | Yes | |||
Mural | Mural: yes/no If not specified, the value will be ‘no’. | Yes | |||
Article Application type | Type of surface where article could be applied. If not specified, the value will be ‘wall’. Please use lowercase letters. | wall | |||
Article availability | Article availability | Only the following definitions can be applied: | |||
Article regular price | Regular price: numeric value | ||||
Article promotional price | Promotional price: numeric value | ||||
Article add to cart action | Link to shopping cart functionality on main web-sitewebsite | ||||
Article transparency | |||||
Article context | You can add the following types of context for the product items:
The context values are separated by commas in double quotes. | Article_regular_price ‘’5050, 220, 4199’’4199 Article_context ‘’GermanyGermany, Poland, Russia’’Russia | |||
Article currency by context | You can specify different types of currencies for the required regions. | ‘’EURUse comma to separate values: EUR, PLN, RUB’’RUB | |||
