Post by hkeung » Sat Feb 16, 2019 4:10 pm

Hi,
I would like to develop a system to add a large number of products into opencart 3.0. Just wonder what is the minimum database table needed to be change for adding a new product.

From my understanding, these tables needed to be updated once you add a new product:
product
product_description
product_to_category
product_to_layout
product_to_store

Please let me know if there is something I missed

Vincent

Newbie

Posts

Joined
Sat Mar 10, 2018 8:06 pm

Post by straightlight » Sun Feb 17, 2019 4:45 am

You could visit the admin/model/catalog/product.php file in the addProduct or editProduct method that describes pretty much everywhere the products are assigned into. However, according to your above list, product_to_layout table is not a mandatory one nor the product_to_category table. The product_to_category table is useful when associating a product to a category but a product can also be shown as stand-alone unfortunately.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: Amazon [Bot] and 89 guests