The table below describes each field of the CSV file in detail.
We've updated fields in the CSV files:
added some new fields for broad product descriptions (column “FIELDS NEW!”, highlighted in green);
rename some fields (column “FIELDS NEW!”, highlighted in yellow);
delete some field (column “FIELDS OLD!”, crossed off).
FIELDS OLD! | FIELDS NEW! | DESCRIPTION | REQUIRED (must be completed) | VALUE, LIMITS | |
brand_name | brand_name | Brand name. All collections of this brand will be displayed in the catalog inside the corresponding folder. | yes | no | text, 255 characters |
collection_name | collection_name | Name of the collection. All products from the same collection will be displayed in the catalog inside the corresponding folder. | yes | no | text, 255 characters |
product_name | product_name | Name/code of an SKU that will be displayed in the catalog under the corresponding article image | yes | no | text, 255 characters |
unique_sku_id | unique_sku_id | Unique SKU ID/code in your database. This value is required for successful integration with your e-catalogue. | yes | no | text |
product_image | product_image | SKU image name from the ZIP file. There is no need to add extension (.jpg, .png, or .jpeg) to the file name. | yes | no | text/multiselect |
product_width | product_width | Width of flooring. All measurements must be indicated in meters. | yes | no | float, numbers only, up to 15 meters |
product_length | product_length | Width of flooring. All measurements must be indicated in meters. | yes | no | float, numbers only, up to 15 meters |
product_shape | product_shape | Product shape: round, square. | yes | no | bool |
pile_height | pile_height | Pile height of flooring. All measurements must be indicated in meters. | no | no | float, numbers only, up to 0,5 meters |
pattern_width | pattern_width | Width of the pattern itself (usually the same as the product width). | no | no | float, numbers only, up to 15 meters |
pattern_length | pattern_length | Width of the pattern itself (usually the same as the product width). | no | no | float, numbers only, up to 15 meters |
product_link | product_link | Product link on the manufacturer's website. | no | yes | text |
product_description | product_description | Description of the product: up to 1000 symbols. | no | no | text |
country | country_of_origin | Description of the product: up to 1000 symbols. | no | no | text |
material | material | The material which the product is made from. | no | no | text |
backing_material | backing_material | Backing material of a rug. | no | no | text |
color | color | Product color. | no | no | text |
interior | interior_type | Describe what interior type where the product can be used in, for example: kitchen, bathroom, bedroom, basement. | no | no | text |
style | style | Can be in stock, Out of stock. Value by default is ‘in stock’. | no | no | text |
pattern | pattern | Pattern displayed on the product. | no | no | text |
application_surface | application_surface | The product can be applied on floor only. | no | no | multiselect |
product_availability | product_availability | Product availability: can be in stock or out of stock. Value by default is ‘in stock’. | no | no | bool |
product_regular_price | product_regular_price | Regular price per product | no | yes | float, only numbers |
product_promotional_price | product_promotional_price | Promotional price per product | no | yes | float, only numbers |
product_context | 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. | no | yes | text |
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." | |||||
context_currency | context_currency | Context currency (if you use different currencies for the domains, please state them in this field. Example “USD, EUR”. | no | yes | text |
| construction | Describe pile construction type, for example cut pile, loop pile, cut and loop pile, frieze, saxony, berber pile. | no | no | text |
additional_data | This column can be completed with any data if there are no columns which cover this information | no | no | text |