What are the basic tables which need to use, so Product will be shown in Admin & Frontend as well?
No need for extra attribute/image as well. Required fields & Enabled Product.
As I seen below 2 tables required. Not sure about other tables
catalog_product_entity
catalog_category_product
catalog_category_product_index
catalog_eav_attribute
catalog_product_website
catalog_product_entity_text
catalog_product_entity_varchar
catalog_product_entity_datetime
catalog_product_entity_decimal
catalog_product_entity_int
catalog_product_flat_1
catalog_product_index_price
cataloginventory_stock_item
cataloginventory_stock_status
cataloginventory_stock_status_idx
eav_entity_attribute
eav_attribute_option_value
url_rewrite
As I'm unable to import products from Backend. I'm thinking of alternatives.
Please re-confirm the above tables. This gonna be also tough. It's better someone can help with the Admin Side Product Import Issue
Best Answer
As Admin side Import is not working. Have to follow this way to achieve functionality ASAP.
Managed to do below things, But 1 issue not able to Save on Admin side. I have compared table entry with other tables as well. Please point out what I'm missing
catalog_product_entity
// Main Product Table EntryWill Return 2049 as Product Id & will be used for Future Tables
catalog_product_entity_varchar
// Title & Description & URLcatalog_product_website
// Assign Product to Websitecatalog_product_entity_decimal
// Product Pricecatalog_product_index_price
// Assign All Group Wise Pricecatalog_category_product
// Assign Product to Categorycatalog_product_entity_int
// Enable Product & Visibilitycataloginventory_stock_item
// For Inventory Quantityurl_rewrite
// For URL RewriteCheck the
eav_attribute
table which stores ALL Attributes10]
catalog_url_rewrite_product_category
// For URL RewriteAfter this, you are able to see your Product on the Frontend
Execute Below Command:
You can see your newly created product entry in Below tables now
Issue: When i go to
Admin -> Catalog -> Edit
Product & Save. It's not doing anything. Just Hold Over there. No Errors displayed on Admin or in Console no issue logged in Log file as well.[UPDATE - Solution]
I'm using my new "Attribute Set" in that some of the Attributes are Mandatory fields.
I have added that attribute entry in
catalog_product_entity_varchar
& it's work fine now :)