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