Import to Magento 2 and create colour search

Job ID: 31301951

Budget: $250 – $750 USD

We have two tasks
1. import data to our Magento 2 catalog tables
2. Create a colour search

1*Import data to our Magento 2 catalog tables.
There has been scraped data off some websites.
This data must now be imported into 5 different vendor accounts in the Magento 2 database and all tables

The job is
1. to create a magento-php script that can import this data into 5 vendors in the platform
2. Create a special table to put every product that is added by the vendors that converts from HEX to cielab and index on CIELAB as a primary key as soon as it is uploaded.
- id
- magentoID
- HEXcolour
- CIELAB Primary
- Category

2*Create colour search
1. Receive from API what part of the face colours should be searched for
2. For different parts you need different input to find the right information in a table with colours for every part of the face and with alternative colours
3. Find closest matching center colours for every area
4. Find closest matching Alternative colours to the center colour
5. Send center colours and alternative colours to API for each area that is searched for (can be up to 13 areas).

Matching colour class: https://github.com/hasbridge/php-color
Get closest matching color using the Lab(CIE) colorspace:
$color = new Color(0xFFFFFF);

$palette = array(
0x000000,
0x888888,
0xAAAAAA
);
#Pallette is all existing colours in the table for a particular category

$matchIndex = $color->getClosestMatch($palette);
$matchColor = $palette[$matchIndex];



Your experience:
1. Import of data from SQL to Magento 2 catalog tables
2. PHP experience
3. 5+ years of multivendor Magento 2
Related categories: PHP Software Architecture eCommerce MySQL Magento 2