Creation Date |
created |
|
DATETIME
|
Creation Date |
Updated Date |
updated |
|
DATETIME
|
Updated Date |
Product SKU |
identifier |
|
VARCHAR
|
Product SKU |
Enabled |
enabled |
|
BOOL
|
Enabled |
Family Code |
family_code |
|
VARCHAR
|
Family Code |
Family Name |
family_label |
|
VARCHAR
|
Family Name |
Family Variant Code |
family_variant_code |
|
VARCHAR
|
Family Variant Code |
Label |
label_de_DE |
|
VARCHAR
|
Label |
Product Name |
label_with_options_de_DE |
|
VARCHAR
|
Product Name |
DEFAULT Description |
default_desc_de_DE |
|
VARCHAR
|
DEFAULT Description |
Label |
label |
|
VARCHAR
|
Label |
Product Name |
label_with_options |
|
VARCHAR
|
Product Name |
DEFAULT Description |
default_desc |
|
VARCHAR
|
DEFAULT Description |
Label |
label_fr_FR |
|
VARCHAR
|
Label |
Product Name |
label_with_options_fr_FR |
|
VARCHAR
|
Product Name |
DEFAULT Description |
default_desc_fr_FR |
|
VARCHAR
|
DEFAULT Description |
Is Variant |
variant |
|
BOOL
|
Is Variant |
Parent Model ID |
parent |
|
VARCHAR
|
Parent Model ID |
Variants |
id@variants |
|
>
Product
|
Variants |
Variant SKU |
sku@variants |
|
>
VARCHAR
|
Variant SKU |
Variation Code |
code@attributes |
|
>
VARCHAR
|
Variation Code |
Attribute Name |
label_de_DE@attributes |
|
>
VARCHAR
|
Attribute Name |
Attribute Name |
label@attributes |
|
>
VARCHAR
|
Attribute Name |
Attribute Name |
label_fr_FR@attributes |
|
>
VARCHAR
|
Attribute Name |
Attribute Value |
value@attributes |
|
>
VARCHAR
|
Attribute Value |
Image |
image@images |
|
>
IMG
|
Image |
Position |
position@images |
|
>
INT
|
Position |
Cover |
cover@images |
|
>
BOOL
|
Cover |
Visible |
visible@images |
|
>
BOOL
|
Visible |
SKU |
sku |
|
VARCHAR
|
[ERP] SKU |
Name |
name |
|
VARCHAR
|
[Marketing] Name |
Beschreibung |
description_de_DE |
|
TEXT
|
[Marketing] Beschreibung |
Description |
description |
|
TEXT
|
[Marketing] Description |
Description |
description_fr_FR |
|
TEXT
|
[Marketing] Description |
Response time (ms) |
response_time |
|
INT
|
[Marketing] Response time (ms) |
Release date |
release_date |
|
DATE
|
[Marketing] Release date |
Price |
price |
|
PRICE
|
[ERP] Price |
Weight |
weight |
|
DOUBLE
|
[Technical] Weight |
Maximum scan size |
maximum_scan_size |
|
INT
|
[Technical] Maximum scan size |
Color scanning |
color_scanning |
|
BOOL
|
[Technical] Color scanning |
Power requirements |
power_requirements |
|
VARCHAR
|
[Technical] Power requirements |
Maximum print size |
maximum_print_size |
|
VARCHAR
|
[Technical] Maximum print size |
Sensor type |
sensor_type |
|
VARCHAR
|
[Technical] Sensor type |
Total megapixels |
total_megapixels |
|
VARCHAR
|
[Technical] Total megapixels |
Optical zoom |
optical_zoom |
|
INT
|
[Technical] Optical zoom |
Image stabilizer |
image_stabilizer |
|
BOOL
|
[Technical] Image stabilizer |
Camera type |
camera_type |
|
VARCHAR
|
[Technical] Camera type |
Total Harmonic Distortion (THD) |
thd |
|
INT
|
[Technical] Total Harmonic Distortion (THD) |
Signal-to-Noise Ratio (SNR) |
snr |
|
INT
|
[Technical] Signal-to-Noise Ratio (SNR) |
Headphone connectivity |
headphone_connectivity |
|
VARCHAR
|
[Technical] Headphone connectivity |
Maximum video resolution |
maximum_video_resolution |
|
VARCHAR
|
[Technical] Maximum video resolution |
Maximum frame rate |
maximum_frame_rate |
|
INT
|
[Technical] Maximum frame rate |
Display sRGB |
display_srgb |
|
BOOL
|
[Technical] Display sRGB |
Display Color |
display_color |
|
BOOL
|
[Technical] Display Color |
Display diagonal |
display_diagonal |
|
INT
|
[Technical] Display diagonal |
Effective viewing area |
viewing_area |
|
INT
|
[Technical] Effective viewing area |
Brand |
camera_brand |
|
VARCHAR
|
[Technical] Brand |
Model name |
camera_model_name |
|
VARCHAR
|
[Technical] Model name |
Kurze Beschreibung |
short_description_de_DE |
|
TEXT
|
[Technische] Kurze Beschreibung |
Short description |
short_description |
|
TEXT
|
[Technical] Short description |
Description courte |
short_description_fr_FR |
|
TEXT
|
[Technique] Description courte |
Maximum image resolution |
max_image_resolution |
|
VARCHAR
|
[Technical] Maximum image resolution |
Still image resolution(s) |
image_resolutions |
|
VARCHAR
|
[Technical] Still image resolution(s) |
Supported aspect ratios |
supported_aspect_ratios |
|
VARCHAR
|
[Technical] Supported aspect ratios |
Supported image format |
supported_image_format |
|
VARCHAR
|
[Technical] Supported image format |
Lens mount interface |
lens_mount_interface |
|
VARCHAR
|
[Technical] Lens mount interface |
Focus |
focus |
|
VARCHAR
|
[Technical] Focus |
Fokus-Apassung |
focus_adjustement_de_DE |
|
VARCHAR
|
[Technische] Fokus-Apassung |
Focus adjustment |
focus_adjustement |
|
VARCHAR
|
[Technical] Focus adjustment |
Ajustement mise au point |
focus_adjustement_fr_FR |
|
VARCHAR
|
[Technique] Ajustement mise au point |
Auto focus modes |
auto_focus_modes_de_DE |
|
VARCHAR
|
[Technische] Auto focus modes |
Auto focus modes |
auto_focus_modes |
|
VARCHAR
|
[Technical] Auto focus modes |
Auto focus modes |
auto_focus_modes_fr_FR |
|
VARCHAR
|
[Technique] Auto focus modes |
Auto focus points |
auto_focus_points |
|
INT
|
[Technical] Auto focus points |
Auto focus lock |
auto_focus_lock |
|
BOOL
|
[Technical] Auto focus lock |
Auto focus beam |
auto_focus_assist_beam |
|
BOOL
|
[Technical] Auto focus beam |
Iso sensitivity |
iso_sensitivity |
|
VARCHAR
|
[Technical] Iso sensitivity |
Light exposure modes |
light_exposure_modes_de_DE |
|
VARCHAR
|
[Technische] Light exposure modes |
Light exposure modes |
light_exposure_modes |
|
VARCHAR
|
[Technical] Light exposure modes |
Light exposure modes |
light_exposure_modes_fr_FR |
|
VARCHAR
|
[Technique] Light exposure modes |
Light exposure corrections |
light_exposure_corrections |
|
VARCHAR
|
[Technical] Light exposure corrections |
Light metering |
light_metering_de_DE |
|
VARCHAR
|
[Technische] Light metering |
Light metering |
light_metering |
|
VARCHAR
|
[Technical] Light metering |
Light metering |
light_metering_fr_FR |
|
VARCHAR
|
[Technique] Light metering |
Auto exposure |
auto_exposure |
|
BOOL
|
[Technical] Auto exposure |
ISO sensitivity (max) |
iso_sensitivity_max |
|
INT
|
[Technical] ISO sensitivity (max) |
ISO sensitivity (min) |
iso_sensitivity_min |
|
INT
|
[Technical] ISO sensitivity (min) |
Picture |
picture |
|
IMG
|
[Media] Picture |
Container material |
container_material |
|
VARCHAR
|
[Manufacturing] Container material |
T-Shirt material |
tshirt_materials |
|
VARCHAR
|
[Manufacturing] T-Shirt material |
Main color |
main_color |
|
VARCHAR
|
[Color] Main color |
Secondary color |
secondary_color |
|
VARCHAR
|
[Color] Secondary color |
Clothing size |
clothing_size |
|
VARCHAR
|
[Size] Clothing size |
ERP-Produktname |
erp_name_de_DE |
|
VARCHAR
|
[ERP] ERP-Produktname |
ERP name |
erp_name |
|
VARCHAR
|
[ERP] ERP name |
Nom ERP |
erp_name_fr_FR |
|
VARCHAR
|
[ERP] Nom ERP |
Meta title |
meta_title_de_DE |
|
VARCHAR
|
[Ecommerce] Meta title |
Meta title |
meta_title |
|
VARCHAR
|
[Ecommerce] Meta title |
Meta titre |
meta_title_fr_FR |
|
VARCHAR
|
[Ecommerce] Meta titre |
Meta description |
meta_description_de_DE |
|
TEXT
|
[Ecommerce] Meta description |
Meta description |
meta_description |
|
TEXT
|
[Ecommerce] Meta description |
Meta description |
meta_description_fr_FR |
|
TEXT
|
[Ecommerce] Meta description |
Keywords |
keywords_de_DE |
|
TEXT
|
[Ecommerce] Keywords |
Keywords |
keywords |
|
TEXT
|
[Ecommerce] Keywords |
Mots clés |
keywords_fr_FR |
|
TEXT
|
[Ecommerce] Mots clés |
Model picture |
image |
|
IMG
|
[Media] Model picture |
Variant Name |
variation_name_de_DE |
|
VARCHAR
|
[Marketing] Variant Name |
Variant Name |
variation_name |
|
VARCHAR
|
[Marketing] Variant Name |
Nom de la variante |
variation_name_fr_FR |
|
VARCHAR
|
[Marketing] Nom de la variante |
Variant beschreibung |
variation_description_de_DE |
|
TEXT
|
[Marketing] Variant beschreibung |
Variant description |
variation_description |
|
TEXT
|
[Marketing] Variant description |
Description de la variante |
variation_description_fr_FR |
|
TEXT
|
[Marketing] Description de la variante |
Variant picture |
variation_image |
|
IMG
|
[Media] Variant picture |
Composition |
composition |
|
TEXT
|
[Product] Composition |
Wash temperature |
wash_temperature |
|
VARCHAR
|
[Product] Wash temperature |
Care instructions |
care_instructions |
|
TEXT
|
[Product] Care instructions |
Color |
color |
|
VARCHAR
|
[Product] Color |
Size |
size |
|
VARCHAR
|
[Product] Size |
EU Shoes Size |
eu_shoes_size |
|
VARCHAR
|
[Product] EU Shoes Size |
Sole composition |
sole_composition |
|
VARCHAR
|
[Product] Sole composition |
Top composition |
top_composition |
|
VARCHAR
|
[Product] Top composition |
Brand |
brand |
|
VARCHAR
|
[Marketing] Brand |
EAN |
ean |
|
VARCHAR
|
[ERP] EAN |
Supplier |
supplier |
|
VARCHAR
|
[ERP] Supplier |
Material |
material |
|
VARCHAR
|
[Product] Material |