I’m looking for a PHP/Modx developer that can create a snippet to use in the Modx CMS that will allow authorized users to upload a CSV file to replace data in the associated products Mysql table. You should provide a check-box to select what "Item Group" to replace with the CSV file. I’ve attach a sample CSV file and a layout of the mysql table
Deadline : 5 days
Payment : Flexible
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
CREATE TABLE IF NOT EXISTS `products` (
`Item Group` int(11) DEFAULT NULL,
`Item Group Name` varchar(255) DEFAULT NULL,
`Business Dept` varchar(255) DEFAULT NULL,
`Business Dept Sub` varchar(255) DEFAULT NULL,
`Business Sector` varchar(255) DEFAULT NULL,
`Gender` varchar(255) DEFAULT NULL,
`Gender Sub` varchar(255) DEFAULT NULL,
`Classification 1` varchar(255) DEFAULT NULL,
`Default Season` varchar(255) DEFAULT NULL,
`Item Number` varchar(255) DEFAULT NULL,
`Item Name` varchar(255) DEFAULT NULL,
`Color` varchar(255) DEFAULT NULL,
`Color Name` varchar(255) DEFAULT NULL,
`Sales Price` varchar(255) DEFAULT NULL,
`Size` varchar(255) DEFAULT NULL,
`Available Physical Qty` int(255) DEFAULT NULL,
`Total Available Qty` int(255) DEFAULT NULL,
`Available Physical value` varchar(255) DEFAULT NULL,
`Total Available Value` varchar(255) DEFAULT NULL,
`pkey` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`pkey`),
FULLTEXT KEY `Business Dept Sub` (`Business Dept Sub`),
FULLTEXT KEY `Item Name` (`Item Name`),
FULLTEXT KEY `Item Number` (`Item Number`),
FULLTEXT KEY `Gender Sub` (`Gender Sub`),
FULLTEXT KEY `Item Number_2` (`Item Number`),
FULLTEXT KEY `Item Name_2` (`Item Name`),
FULLTEXT KEY `Item Name_3` (`Item Name`,`Item Number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4786 ;
Thanks position has been filled
