For cron 

RUN on browser : WWW_ROOT./cron/getLocaterListData
RUN on browser : WWW_ROOT./cron/getState
RUN on browser : WWW_ROOT./cron/getCity 

/*12 August 2019*/

Run on CMD : composer require maatwebsite/excel

/*19 August 2019*/

ALTER TABLE `homepages` CHANGE `other_setting` `show_feed` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

CREATE TABLE `locater_feeds` (
  `id` bigint(20) NOT NULL,
  `show_feed` tinyint(4) NOT NULL DEFAULT '0',
  `feeds_id` varchar(100) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text,
  `gtin` varchar(100) DEFAULT NULL,
  `brand` varchar(100) DEFAULT NULL,
  `color` varchar(50) DEFAULT NULL,
  `size` text,
  `link` varchar(255) DEFAULT NULL,
  `image_link` varchar(255) DEFAULT NULL,
  `availability` varchar(50) DEFAULT NULL,
  `product_condition` varchar(50) DEFAULT NULL,
  `item_group_id` varchar(100) DEFAULT NULL,
  `google_product_category` varchar(150) DEFAULT NULL,
  `product_type` varchar(150) DEFAULT NULL,
  `sale_price` varchar(100) DEFAULT NULL,
  `price` varchar(100) DEFAULT NULL,
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '0=active,1=inactive',
  `is_deleted` tinyint(2) NOT NULL DEFAULT '0' COMMENT '1=deleted,0=notdeleted',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `locater_feeds`
 ADD PRIMARY KEY (`id`),
 ADD UNIQUE KEY `id` (`id`);
ALTER TABLE `locater_feeds`
 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5055;


/*20 August 2019*/

ALTER TABLE `homepages` ADD `feed_csv_url` TEXT NULL COMMENT 'Only feed csv url' AFTER `show_feed`;