Versions Compared

Key

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

We have updated 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 file, please contact support@wizart.tech

Image upload requirements

  • File extension: jpg, jpeg or png;

  • Resolution: the smaller dimension of the image must should be 1024px (or more).

  • The image must contain a fully repeated wallpaper pattern

Expand
titleSamples of wallpaper patterns
Image AddedImage Added

  • All images must be directly archived into ZIP file (make sure that you have .zip extension)

    • you can archive images directly to the root of ZIP file

    • you can archive folders with several collections in one ZIP file

    • Maximum size of ZIP archive - 512MB

Image Removed
Expand

Sample images

Image Removed
Image Removed
titleSamples of ZIP archives
Image AddedImage Added

Requirements for file uploads with metadata

Info

We have updated 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 file, please contact support@wizart.tech

Excel file sample

View file
namePIM Excel.xlsx

СSV file sample (UTF-8 encoding)

СSV file sample


View file
name

example

PIM CSV.csv

File
Expand
titleHow to save Excel file with CSV extension

Excel file should be saved using 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))

Image RemovedImage Removed
Image AddedImage Added

CSV file field requirements

Tip

You can use your own files with metadata (just don’t forget to save it with .csv extension) not changing field names or field order as described below. While creating new Data Mapping choose field name in your file that corresponds to PIM field to connect them.

The first line must list the names of the fields which will subsequently be used for mapping.

CSV file must include 6 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.

Old Fields

New Fields

Description

Examples/Notes

Mandatory fields

:Width (article_width): numeric value in meters

Brand name (brand_name)

Brand name

Brand name. All collections of this brand will be displayed in the catalogue inside corresponding folder

Collection name (collection_name)

Collection name

Name of the collection. All wallpapers from the same collection will be displayed in the catalogue inside corresponding folder

Article name (article_name)

  • Supplier code (article_vendor_name): unique SKU id / code in your database

  • Article name

    Name/code of article will be displayed in the catalogue under corresponding article image

    Article image (article_image_path)

    : file_name.jpg , where file_name  is the name of the image

    Article image

    Article image name from the ZIP file

    Optional fields:

  • Short local name (locale)

  • Country (country_name)

  • Article description (article_description)

  • There is no need at add extension (.jpg, .png or .jpeg) to file name anymore

    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

    Width (article_width)

    Width

    Width of wallpaper roll. (Default value is in meters; if you use another metric system - please, specify it in Unit field)

    Numeric value only:
    0.64
    1
    0.7

    Recommended fields

    Rapport (article_rapport)

    : height

    Pattern Repeat

    Height of repeated pattern

    – numeric

    (Default value is in meters; if you use another metric system - please, specify it in Unit field)

    see example below the table

    Numeric value only:
    0.64
    0.58

    Rapport shift / drop match (article_rapport_shift)

    : how

    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)

    see example below the table

    Numeric value only:
    0.32
    0.12

    -

    Article link

    Link to SKU on main web-site

    Full link

    Optional fields

    Unit of measurement (unit_name)

    Unit

    Specify unit of measurement you use for width/length/pattern repeat/pattern offset. If not specified, all measurements are calculated in meters

    ft
    in

    Length (article_length):

    numeric value in meters

    Wallpaper roll length

    Length of wallpaper roll (Default value is in meters; if you use another metric system - please, specify it in Unit field)

    Country (country_name)

    Country

    Country of origin (where wallpapers were produced)

    Article description (article_description)

    Article description

    Description of article: up to 1000 symbols

    Main color (article_main_color)

    Main colour

    Main colour of wallpaper pattern

    Color (color_name)

    Colour

    Colours of wallpaper pattern (use comma to separate colours)

    Green, blue, white

    Texture (texture_name)

    Texture

    Texture of wallpaper (use comma to separate textures)

    Coating (coating_name)

    Coating

    Coating of wallpaper (use comma to separate coatings)

    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)

    Removal type

    Light fastness

    Light fastness is simply the degree to which wallpaper will keep its colour 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 design could be applied (use comma to separate room types)

    Bedroom, living-room, kitchen

    Style (style_name)

    Style

    Unit

    Describe style of

    measurement (unit_name)Image Removed

    wallpaper (use comma to separate styles)

    Modern, classic, country

    Article layout

    The way how wallpapers should be applied on the wall: horizontal/vertical. If not specified, wallpapers will be applied vertically

    Horizontal
    Vertical

    Reverse 180

    Reverse alternate length: yes/no

    Yes
    No

    Mural

    Mural: yes/no

    Yes
    No

    Article type

    Type of surface where article could be applied

    Wallpaper
    Floor

    Article availability

    Article availability

    Only 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 find store action

    Link to main web-site functionality to find a store where user can buy chosen wallpapers

    Article add to cart action

    Link to shopping cart functionality on main web-site

    Image AddedImage Added