Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

We have updated the uploading process by adding some validation steps; several definitions in Data Mapping have also been changed. If you have any questions or issues while uploading SKUs and/or 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 1m of the actual product side size.

  • Every image must contain a single piece of the product

 Laminate board samples
  • 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

 ZIP archive samples
 How to save an Excel file with a CSV extension

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

Please note that some fields are not available for certain product types. Check the table below for more info.

Colors and symbols used:

  1. Green - available, i.e. you can specify this info for this product type;

  2. Red - not available, i.e. this field is not available in the CSV for this very product type;

  3. Yellow - recommended field, i.e. it is not required, but we do recommend filling this one in for a more accurate visualization result or simply for giving more details on the product);

  4. An asterisk (*) means that this field is required, i.e. must be completed.

Fields

Laminate

Tile

Carpet tiles

Carpet in rolls

Parquet

Engineering board

Vinyl Flooring

Rugs

brand_name

*

*

*

*

*

*

*

*

collection_name

*

*

*

*

*

*

*

*

product_name

*

*

*

*

*

*

*

*

unique_sku_id

*

*

*

*

*

*

*

*

product_image

*

*

*

*

*

*

*

*

product_width

*

*

*

*

*

*

*

*

product_length

*

*

*

*

*

*

*

*

product_thickness

product_shape

*

pile_height

pattern_width

pattern_length

product_link

product_description

package_quantity

package_coverage

wear_resistant_class

ac_rating

country

material

backing_material

color

product_edge

surface_finish

texture

interior

style

application_surface

floor

By default

wall, floor

By default

floor

By default

floor

By default

floor

By default

floor

By default

floor

By default

floor

By default

product_availability

In stock

By default

In stock

By default

In stock

By default

In stock

By default

In stock

By default

In stock

By default

In stock

By default

In stock

By default

price_per_m2

promotional_price_per_m2

price_per_package

promotional_price_per_package

product_regular_price

product_promotional_price

product_context

context_currency

layouts

1/2, 1/3, Random offset

By default

1/2, 1/3, Random offset

By default

pattern

All up-to-date CSV templates for various floor product types, as well as sample completed CSV files for these product types, can be downloaded from the table below:

Fields

Laminate

Tile

Carpet tiles

Carpet in rolls

Parquet

(Hardwood Flooring)

Engineering board

Vinyl Flooring

Rugs

CSV template (empty)

CSV file sample

The table below describes each field of the CSV file in detail (for floor product types only):

Fields

Description

Can be edited in the CSV

Can be edited in the
product card

Value

brand_name

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

No

Yes

Can be any numeric and/or text values.

collection_name

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

No

Yes

Can be any numeric and/or text values.

product_name

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

Yes

Yes

Can be any numeric and/or text values.

unique_sku_id

Unique SKU ID/code in your database. This value is required for successful integration with your e-catalogue

No

Yes

Can be any numeric and/or text values. SKU ID cannot be repeated within the same collection, but can belong to several different collections.

product_image

Product image name from the ZIP file. There is no need to add an extension (.jpg, .png, or .jpeg) to the file name

No

No

text/multiselect.

product_width

Width of flooring. 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.

No

No

Please mention NUMERIC VALUE only, not adding units of measurement (m, cm, etc.):

product_length

Length of flooring. All measurements must be indicated in meters.

No

No

Please mention NUMERIC VALUE only, not adding units of measurement (m, cm, etc.):

product_thickness

Thickness of flooring. All measurements must be indicated in meters.

Yes

Yes

float

pile_height

Pile height of flooring. All measurements must be indicated in meters.

Yes

Yes

float

pattern_width

Pattern width of flooring. All measurements must be indicated in meters. If completed, various layouts will be available for the product.

No

No

Please mention NUMERIC VALUE only, not adding units of measurement (m, cm, etc.):

pattern_length

Pattern length of flooring. All measurements must be indicated in meters. If completed, various layouts will be available for the product.

No

No

Please mention NUMERIC VALUE only, not adding units of measurement (m, cm, etc.):

product_link

A link to the product on the main website.

Yes

Yes

Full link

product_description

Description of the product: up to 1000 symbols.

Yes

Yes

Can be any numeric and/or text values.

package_quantity

Package quantity of flooring.

Yes

Yes

Can be only numeric (int).

package_coverage

Package quantity of coverage. All measurements must be indicated in square meters.

Yes

Yes

Can be only numeric (float).

wear_resistant_class

Wear resistant class.

Yes

Yes

text

ac_rating

Yes

Yes

text

country

Country of origin (where the flooring was produced).

Yes

Yes

text

material

The material from which the flooring is made.

Yes

Yes

text

backing_material

Backing material.

Yes

Yes

text

color

Colors of flooring (use comma to separate colors).

Yes

Yes

text

product_edge

Product edge.

Yes

Yes

text

surface_finish

Surface finish (for example: glossy, matte, oil, varnish).

Yes

Yes

text

texture

Texture of flooring (use comma to separate textures).

Yes

Yes

text

interior

Type of room where this particular flooring design could be applied (use comma to separate room types, for example: bedroom, living-room, kitchen).

Yes

Yes

text

style

Describe style of flooring (use comma to separate styles, for example: modern, classic, country).

Yes

Yes

text

application_surface

Possible values: wall, floor.

Unless otherwise noted, value by default is ‘floor’.

Yes

Yes

multi-
select

product_availability

Can be in stock, Out of stock. Value by default is ‘in stock’.

Yes

Yes

bool

price_per_m2

Price per m2.

Yes

Yes

float

promotional_price_per_m2

Promotional
price per m2.

Yes

Yes

float

price_per_package

Price per package

Yes

Yes

float

promotional_price_per_package

Promotional price per package

Yes

Yes

float

product_context**

Context for products (if you have several domains for different cities/states/countries, and each of your domains has a different stock, the context gives you an opportunity to ‘hide’ some products that are not available for this particular area; put different links to the corresponding domain for each product; set different prices and currencies for each domain.

That’s how to use the context in the CSV: “site_A, site_B“. Use comma to separate values. If you have any questions, please contact support@wizart.ai.

Yes

Yes

text

context_currency**

Context currency (if you use different currencies for your domains, please state them in this field. Example “USD, EUR”.

Yes

Yes

text

layouts

The way in which flooring pieces (boards, tiles) are arranged.

Possible values: 1/2, 1/3, no_offset, random, herringbone, double_herringbone, chervron, basket wave

Yes

Yes

multi -
select

pattern

Type of the pattern

Yes

Yes

text

** - Please, check Context (public).

  • No labels