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
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
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:
Green - available, i.e. you can specify this info for this product type;
Red - not available, i.e. this field is not available in the CSV for this very product type;
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);
An asterisk (*) means that this field is required, i.e. must be completed.
Digits separated by commas for min and max allowed values
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 | *, square, round | |||||||
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 | 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- |
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 | 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 - |
pattern | Type of the pattern | Yes | Yes | text |
** - Please, check Context (public).