Ecommerce website sample data for MYSQL

categorys table

Fields name are

product_name, status
('Electronics', '1'),
('Clothes', '1'),
('Grocery', '1'),
('Vegetables', '0'),
('Fashion', '1'),
('Home', '0'),
('Appliances', '1'),
('Travel', '1'),
('Beauty ', '1'),
('Gifts', '0')

products table

Table fields are

product_name, price, sale_price, qty, status
('Mobile', '8999', '7000', '45', '1'),
('Jeans', '1250', '1100', '120', '1'),
('TV', '25000', '22000', '34', '1'),
('Shirt', '1900', '1700', '400', '0'),
('Watch', '3590', '3200', '23', '0'),
('DSLR Camera', '45000', '43000', '10', '1'),
('Mouse', '800', '700', '800', '0'),
('Router', '12000', '11500', '5', '1'),
('CCTV', '900', '780', '90', '0'),
('Chair', '1600', '1430', '20', '1'),
('Table', '4589', '4250', '120', '0'),
('Door bell', '1230', '1000', '300', '1')
© 2016 - 2022, All Rights are Reserved.