Check

Info
Please check our detailed

instructions on how to fill in a CSV file for different product types available in the PIM system as well as our general image upload requirements. If you have any issues with the file upload, please feel free to contact us at support@wizart.ai. We have updated the uploading process by adding some validation steps; several definitions in Data Mapping were also changed

requirements for the files imported to the PIM account. If you have any questions or issues while uploading SKUs and CSV

file

files, please contact us via support@wizart.ai

Expand

title	Wallpaper: File upload requirements

Info

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

Image Removed

Expand

title	Wallpaper pattern samples

Samples of wallpaper patterns

Image Added

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

title	Samples of ZIP archive samplesarchives

Requirements for file uploads with metadata.

You can download our default file samples below in csv CSV or excel 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

name	excel_default Default mapping template_Wallpaper.xlsx

СSV file sample (UTF-8 encoding)

View file

name	Default mapping template_Wallpaper.csv

Expand

title	How to save an Excel file with CSV extension

Excel file 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:

View file

name	CSV and ZIP files on MacOS.pdf

CSV file field requirements

TipYou can use your own files with metadata (just don’t forget

View file

name	Wallpaper_example - Example.csv

The same file but with an .xlsx extension (please remember to save it 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 space if it consists of two and more words. Please change space between words with 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

:

View file

name	Wallpaper_example.xlsx

Please note that the mandatory fields are highlighted in light yellow; the others may be left uncompleted.

catalogue catalogue catalogue at anymore (Default value is in meters; if you use another metric system - please, specify it in the Unit field)Please, . (Default value is in meters; if you use another metric system - please, specify it in the Unit field) (Default value is in meters; if you use another metric system - please, specify it in Unit field)Please, All measurements must be indicated in meters.6458
(Default value is in meters; if you use another metric system - please, specify it in Unit field) Please, mention NUMERIC VALUE only not adding measurements like meters, cm etc.0320.12 web-siteSpecify unit of measurement you use for width/length/pattern repeat/pattern offset on your website, but please note that ft
in
cm (Default value is in meters; if you use another metric system - please, specify it in Unit field)Please, wallpapers were colour Colours colours colour wallpapers The way how wallpapers wallpapers latters web-site in double quotes

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. Image Added
Collection name (collection_name)	Collection name	Name of the collection. All wallpapers from the same collection will be displayed in the	catalog inside the corresponding folder	Can be any numeric and/or text values. Image Added
Article name (article_name)	Article name	Name/code of an article will be displayed in the	catalog under the corresponding article image	Can be any numeric and/or text values. Image Added
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		Image Added 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 measurements like metersunits of measurement (m, cm, etc.All measurements must be indicated in meters.): 0.64 1 0.7
	Repeat Width	Width of the pattern itself	. Usually, the Repeat Width is the same as the Product Width. 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 1 0.7
Recommended fields
Rapport (article_rapport)	Pattern Repeat	Height of repeated pattern	All measurements must be indicated in meters.	Please mention NUMERIC VALUE only not adding measurements like meters, cm etc.	Examples: 0.	32 0.	12 Image Added
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		Examples: 0.	32 0.	12 Image Added	.
-	Article link	Link to SKU on main	website	Full link
Optional fields
Unit of measurement (unit_name)	Unit	In the CSV file, all measurements must be indicated in meters.	The unit of measurement can be changed in your PIM account. Please check the screenshot on the right to see how or contact support@wizart.ai for help.	Image Added
Length (article_length):	Wallpaper roll length	Length of wallpaper roll	All measurements must be indicated in meters.	Please mention NUMERIC VALUE only not adding measurements like meters, cm etc. All measurements must be indicated in meters. : 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 Washable Extra Washable Scrubbable
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 Peelable Wet Removable
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 Vertical
	Reverse	Reverse alternate length: yes/no If not specified, the value will be ‘no’.	Yes No
	Mural	Mural: yes/no If not specified, the value will be ‘no’.	Yes No
	Article Application type	Type of surface where article could be applied. If not specified, the value will be ‘wall’. Please use lowercase	letters.	wall floor
	Article availability	Article availability	Only the following definitions can be applied: In_Stock Out_of_stock Preorder
	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	website
	Article transparency
	Article context	You can add the following types of context for the product items: Price Discount price Country / Region Type of application Links to different sites The context values are separated by commas	.	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