Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
| Campo | Tipo | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id_product | int(10) unsigned | NO | PRI | auto_increment | |
| id_supplier | int(10) unsigned | YES | MUL | ||
| id_manufacturer | int(10) unsigned | YES | MUL | ||
| id_category_default | int(10) unsigned | YES | MUL | ||
| id_shop_default | int(10) unsigned | NO | 1 | ||
| id_tax_rules_group | int(11) unsigned | NO | |||
| on_sale | tinyint(1) unsigned | NO | 0 | ||
| online_only | tinyint(1) unsigned | NO | 0 | ||
| ean13 | varchar(13) | YES | |||
| isbn | varchar(32) | YES | |||
| upc | varchar(12) | YES | |||
| mpn | varchar(40) | YES | |||
| ecotax | decimal(17,6) | NO | 0.000000 | ||
| quantity | int(10) | NO | 0 | ||
| minimal_quantity | int(10) unsigned | NO | 1 | ||
| low_stock_threshold | int(10) | YES | |||
| low_stock_alert | tinyint(1) | NO | 0 | ||
| price | decimal(20,6) | NO | 0.000000 | ||
| wholesale_price | decimal(20,6) | NO | 0.000000 | ||
| unity | varchar(255) | YES | |||
| unit_price | decimal(20,6) | NO | 0.000000 | ||
| unit_price_ratio | decimal(20,6) | NO | 0.000000 | ||
| additional_shipping_cost | decimal(20,6) | NO | 0.000000 | ||
| reference | varchar(64) | YES | MUL | ||
| supplier_reference | varchar(64) | YES | MUL | ||
| location | varchar(255) | NO | |||
| width | decimal(20,6) | NO | 0.000000 | ||
| height | decimal(20,6) | NO | 0.000000 | ||
| depth | decimal(20,6) | NO | 0.000000 | ||
| weight | decimal(20,6) | NO | 0.000000 | ||
| out_of_stock | int(10) unsigned | NO | 2 | ||
| additional_delivery_times | tinyint(1) unsigned | NO | 1 | ||
| quantity_discount | tinyint(1) | YES | 0 | ||
| customizable | tinyint(2) | NO | 0 | ||
| uploadable_files | tinyint(4) | NO | 0 | ||
| text_fields | tinyint(4) | NO | 0 | ||
| active | tinyint(1) unsigned | NO | 0 | ||
| redirect_type | enum('','404','410','301-product','302-product','301-category','302-category','200-displayed','404-displayed','410-displayed','default') | NO | default | ||
| id_type_redirected | int(10) unsigned | NO | 0 | ||
| available_for_order | tinyint(1) | NO | 1 | ||
| available_date | date | YES | |||
| show_condition | tinyint(1) | NO | 0 | ||
| condition | enum('new','used','refurbished') | NO | new | ||
| show_price | tinyint(1) | NO | 1 | ||
| indexed | tinyint(1) | NO | MUL | 0 | |
| visibility | enum('both','catalog','search','none') | NO | both | ||
| cache_is_pack | tinyint(1) | NO | 0 | ||
| cache_has_attachments | tinyint(1) | NO | 0 | ||
| is_virtual | tinyint(1) | NO | 0 | ||
| cache_default_attribute | int(10) unsigned | YES | |||
| date_add | datetime | NO | MUL | ||
| date_upd | datetime | NO | |||
| advanced_stock_management | tinyint(1) | NO | 0 | ||
| pack_stock_type | int(11) unsigned | NO | 3 | ||
| state | int(11) unsigned | NO | MUL | 1 | |
| product_type | enum('standard','pack','virtual','combinations','') | NO |
| id_product | id_supplier | id_manufacturer | id_category_default | id_shop_default | id_tax_rules_group | on_sale | online_only | ean13 | isbn | upc | mpn | ecotax | quantity | minimal_quantity | low_stock_threshold | low_stock_alert | price | wholesale_price | unity | unit_price | unit_price_ratio | additional_shipping_cost | reference | supplier_reference | location | width | height | depth | weight | out_of_stock | additional_delivery_times | quantity_discount | customizable | uploadable_files | text_fields | active | redirect_type | id_type_redirected | available_for_order | available_date | show_condition | condition | show_price | indexed | visibility | cache_is_pack | cache_has_attachments | is_virtual | cache_default_attribute | date_add | date_upd | advanced_stock_management | pack_stock_type | state | product_type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | 4 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 23.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_1 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 1 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | combinations | |||||||
| 2 | 1 | 1 | 5 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 35.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_3 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 404 | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 9 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | combinations | |||||||
| 3 | 1 | 2 | 9 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 29.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_6 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 13 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | combinations | |||||||
| 4 | 1 | 2 | 9 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 29.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_5 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 404 | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 16 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | combinations | |||||||
| 5 | 1 | 2 | 9 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 29.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_7 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 19 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | combinations | |||||||
| 6 | 2 | 1 | 8 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 11.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_11 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | standard | |||||||
| 7 | 2 | 1 | 8 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 11.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_12 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | standard | |||||||
| 8 | 2 | 1 | 8 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 11.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_13 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 404 | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | standard | |||||||
| 9 | 2 | 1 | 8 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 18.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_15 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 22 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | combinations | |||||||
| 10 | 2 | 1 | 8 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 18.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_16 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 24 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | combinations | |||||||
| 11 | 2 | 1 | 8 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 18.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_17 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 26 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | combinations | |||||||
| 12 | 2 | 2 | 9 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 9.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_18 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 1 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | virtual | |||||||
| 13 | 2 | 2 | 9 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 9.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_19 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 1 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | virtual | |||||||
| 14 | 2 | 2 | 9 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 9.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_20 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 1 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | virtual | |||||||
| 15 | 2 | 0 | 8 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 35.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_21 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 1 | 0 | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | pack | |||||||
| 16 | 2 | 2 | 7 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 12.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_8 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 28 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | combinations | |||||||
| 17 | 2 | 2 | 7 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 12.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_9 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 32 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | combinations | |||||||
| 18 | 2 | 2 | 7 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 12.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_10 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 36 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | combinations | |||||||
| 19 | 2 | 1 | 8 | 1 | 1 | 0 | 0 | 0.000000 | 0 | 1 | 0 | 0 | 13.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | demo_14 | 0.000000 | 0.000000 | 0.000000 | 0.300000 | 2 | 1 | 0 | 1 | 0 | 1 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 3 | 1 | standard |