Magento: Product Information Schema

@Version 1.0      Table Name: reporting_product_flat

This table contains information about each product with all their attributes as described below. If some thing does not fit into your ecommerce configuration, do give us a shout at hello@reckless.io. We do understand many of these attributes do not make sense to your business. This is complete customisable using our custom ui.

Column Name Description Notes
entity_id Product ID to be matched with other tables
sku SKU of the product
type_id Is it configurable or simpe
attribute_set_name Attribute Set
created_at The product created at date This does not change
updated_at The product updated at date Ths will change when anything related to the product is changed
status Enabled/ Disabled Status of the product
visibility_admin Visibility Configuration – Default Scope Please use admin visibility configuration since most of the visibilty for website is not enabled in the website today. We do not deal with website level visibility today/
visibility_int_en Visibility Configuration – International Website Scope English
visibility_us_en Visibility Configuration – USA website Scope English
visibility_eu_en Visibility Configuration – Europe website Scope English
visibility_uk_en Visibility Configuration – UK website Scope English
visibility_sa_sa Visibility Configuration – Saudi Arabia – Arabic Scope Arabic
visibility_sa_en Visibility Configuration – Saudi Arabia – English Scope English
baby_walking_stage Client custom attribute Usually the scope is global
gift_ideas Client custom attribute
manufacturer Product Designer
neck Client custom attribute
package_id Client custom attribute
product_type_clothing Client custom attribute
product_type_home_school Client custom attribute
product_type_shoe Client custom attribute
product_type_sport Client custom attribute
product_type_toy Client custom attribute
season Seasons for the product
shoe_fastening Client custom attribute
shoe_size Client custom attribute
shoe_size_manufacturer Client custom attribute
size_manufacturer Client custom attribute
sleeve_length Client custom attribute
age_group Client custom attribute Since this is a multi select, all the values are separated by comma
age_range Client custom attribute – Multi Select Since this is a multi select, all the values are separated by comma
color Client custom attribute – Multi Select Since this is a multi select, all the values are separated by comma
gender Client custom attribute – Multi Select Since this is a multi select, all the values are separated by comma
key_trends Client custom attribute – Multi Select Since this is a multi select, all the values are separated by comma
marketing_campaigns Client custom attribute – Multi Select Since this is a multi select, all the values are separated by comma
material Client custom attribute – Multi Select Since this is a multi select, all the values are separated by comma
new_in Client custom attribute – Multi Select Since this is a multi select, all the values are separated by comma
occasion Client custom attribute – Multi Select Since this is a multi select, all the values are separated by comma
sales Client custom attribute – Multi Select Since this is a multi select, all the values are separated by comma
special_features Client custom attribute – Multi Select Since this is a multi select, all the values are separated by comma
style Client custom attribute – Multi Select Since this is a multi select, all the values are separated by comma
image_label Label for the images
meta_title Meta titile of the product
name Product Name
product_video Video link if any
sku_new New SKU We have a new SKU to fix inconsitent SKU structures
small_image_label Labels of images
thumbnail_label Labels of images
url_key the url key of the product in default scope
url_path the url path of the product in default scope
warehouse_location Warehouse location code if any
country_of_manufacture Country of Manufacture
cost_admin Cost Configuration – Default Scope
cost_int_en Cost Configuration – International website Scope
cost_us_en Cost Configuration – USA website Scope
cost_eu_en Cost Configuration – Europe website Scope
cost_uk_en Cost Configuration – UK website Scope
cost_sa_sa Cost Configuration – Saudi Arabia – Arabic Scope
cost_sa_en Cost Configuration – Saudi Arabia – English Scope
weight Weight of the product
tax_class_id VAT Class that is configured
price_admin Price Configuration – Default Scope Always use this price if there are no prices configured for other stores.
price_int Price Configuration – International website Scope The prices are picked up from the product itself
price_usa Price Configuration – USA website Scope These columns might have values if the product was previously enabled in the website. Hence do not be surprised when you see values here even if the product is no longer enabled for the website scope.Do the required rule in BIME to ignore these values
price_eu Price Configuration – Europe website Scope If there is no value configured on a website level, the value will be NULL and in this case please use the prces form the Admin scope
price_uk Price Configuration – UK website Scope
price_sa Price Configuration – Saudi Arabia Scope
special_price_admin Special Price Configuration – Default Scope
special_price_int Special Price Configuration – International website Scope
special_price_usa Special Price Configuration – USA website Scope
special_price_eu Special Price Configuration – Europe website Scope
special_price_uk Special Price Configuration – UK website Scope
special_price_sa Special Price Configuration – Saudi Arabia Scope
final_price_int Final Price Configuration – International website Scope These are LIVE PRICES in the website. (Usually different than product prices depending on current special prices dates)
final_price_eu Final Price Configuration – Europe website Scope
final_price_usa Final Price Configuration – USA website Scope
final_price_uk Final Price Configuration – UK website Scope
final_price_sa Final Price Configuration – Arabia Saudi Scope
aa_is_hidden If the product is hidden
enable_googlecheckout Ignore this – we do not use Google checkout
gift_message_available if gift message is available
is_recurring Ignore this – Client has no recurring products
lucene_indexed Ignore this
aa_original_stock Original Stock Quantity
categories List of Categories the product belongs to, separated by comma “,” If this is a simple product this might be NULL. Please use parent_categories to understand which categories this product belongs to
custom_layout_update Ignore this
description Product Description
meta_keyword Meta information
recurring_profile Ignore this
short_description Short Description
qty Current Stock Quantity
is_in_stock Current Stock Availability Status
news_from_date_admin News From Date Configuration – Default Scope Use the Admin Values unless we have new in on a website level yet
news_from_date_int_en News From Date Configuration – International website Scope
news_from_date_us_en News From Date Configuration – USA website Scope
news_from_date_eu_en News From Date Configuration – Europe website Scope
news_from_date_uk_en News From Date Configuration – UK website Scope
news_from_date_sa_sa News From Date Configuration – Saudi Arabia – Arabic Scope
news_from_date_sa_en News From Date Configuration – Saudi Arabia – English Scope
news_to_date_admin News To Date Configuration – Default Scope
news_to_date_int_en News To Date Configuration – International website Scope
news_to_date_us_en News To Date Configuration – USA website Scope
news_to_date_eu_en News To Date Configuration – Europe website Scope
news_to_date_uk_en News To Date Configuration – UK website Scope
news_to_date_sa_sa News To Date Configuration – Saudi Arabia – Arabic Scope
news_to_date_sa_en News To Date Configuration – Saudi Arabia – English Scope
special_from_date_admin Special From Date Configuration – Default Scope Use the Admin Values unless we have special prices on a website level
special_from_date_int_en Special From Date Configuration – International website Scope
special_from_date_us_en Special From Date Configuration – USA website Scope
special_from_date_eu_en Special From Date Configuration – Europe website Scope
special_from_date_uk_en Special From Date Configuration – UK website Scope
special_from_date_sa_sa Special From Date Configuration – Saudi Arabia – Arabic Scope
special_from_date_sa_en Special From Date Configuration – Saudi Arabia – English Scope
special_to_date_admin Special To Date Configuration – Default Scope Use the Admin Values unless we have special prices on a website level
special_to_date_int_en Special To Date Configuration – International website Scope
special_to_date_us_en Special To Date Configuration – USA website Scope
special_to_date_eu_en Special To Date Configuration – Europe website Scope
special_to_date_uk_en Special To Date Configuration – UK website Scope
special_to_date_sa_sa Special To Date Configuration – Saudi Arabia – Arabic Scope
special_to_date_sa_en Special To Date Configuration – Saudi Arabia – English Scope
websites Websites where the product is currently being shown. Multiple websites are separated by comma (,) . Can be used later with BIME
images Images Urls of the product Multiple images are separated by comma (,) . Can be used later with BIME
up_sell Up Sell products related with the product Multiple entity_ids are separated by comma (,) . Can be used later with BIME
cross_sell Cross Sell products related with the product Multiple entity_ids are separated by comma (,) . Can be used later with BIME
relation Related products Multiple entity_ids are separated by comma (,) . Can be used later with BIME
parent_id Id of the parent product (only applies for the simple products) Will be null as well for the standalone simple products.
parent_sku SKU of the parent product (only applies for the simple products) Will be null as well for the standalone simple products.
parent_status Status of the parent product (only applies for the simple products) Will be null as well for the standalone simple products.
parent_categories Categories of the parent product (only applies for the simple products) Will be null as well for the standalone simple products.
Multiple categories are separated by comma (,) . Can be used later with BIME

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>