Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

We have updated the uploading process by adding some validation steps; several definitions in Data Mapping were also changedPlease check our detailed requirements for the files imported to the PIM account. If you have any questions or issues while uploading SKUs and CSV filefiles, please contact us via support@wizart.tech 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
titleSamples of wallpaper patterns

  • 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 - 512MB2GB

Expand
titleSamples of ZIP archives


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
nameexcel_default Default mapping template_Wallpaper.xlsx

СSV file sample (UTF-8 encoding)

View file
namecsv_default Default mapping template_Wallpaper.csv

Expand
titleHow 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
nameCSV and ZIP files on MacOS.pdf

CSV file field requirements TipYou can use your own files with metadata (just don’t forget

View file
nameWallpaper_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 CSV file

:

View file
nameWallpaper_example.xlsx

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

measurements like meters

All measurements must be indicated in meters.

, like meters

All measurements must be indicated in meters.

All measurements must be indicated in meters.6458All measurements must be indicated in meters.‘’EUR

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 cataloguecatalog 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 catalogue 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 cataloguecatalog 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 at to add extension (.jpg, .png, or .jpeg) to the file name anymore

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. (Default value is in meters; if you use another metric system - please, specify it in the Unit field)Please,

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
1
0.7

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.

All measurements must be indicated in meters.

Please

mention NUMERIC VALUE only not adding measurements

(m, cm, etc.

):

0.64
1
0.7

Recommended fields

Rapport (article_rapport)

Pattern Repeat

Height of repeated pattern (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.

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
(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.

All measurements must be indicated in meters.

0.32
0.12

-

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.

ft
in
cmThe 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 (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.

Please mention NUMERIC VALUE only not adding measurements like meters, cm etc.

:

10.05

9

Country (country_name)

Country

Country of origin (where wallpapers were 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 colour color of wallpaper pattern

Green, blue

Color (color_name)

Colour

Colours Colors of wallpaper pattern (use comma to separate colourscolors)

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 colour 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 wallpapers 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

The way how wallpapers How wallpaper should be applied on the wall: horizontal/vertical. If not specified, wallpapers 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 lattersletters.

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 web-sitewebsite

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 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.

Use comma to separate values:

EUR, PLN, RUB’’

Image Removed

RUB

Image Modified