Import Product into my ecommerce system via API from my vendors

I need a programmer to import products into our e-commerce platform. There are tens of thousands of products. From a few different vendors. We will provide API documentation for the vendors and you will be assisted by our programmers on how to bring these items into our system. Our system allows out users to pick and choose what products they want to offer, but we need to have all of the products available in our central systems for them to pull from. The project is to import those items into our central system. We are looking for a programmer to work with on an ongoing basis to manage our imports and bring in new products on a regular basis. Some notes from our programmer: Our system using one database table for main product record and sub-tables related to product part indexed by product ID from main table. Database structure, related to product looks like: Product table - product color: product can have multiple colors, one color is required. It is product color variation included info about the color only, sample: Red, Grey Heather, Red on Black - product size: product can have multiple sizes, one size at least is required. there are info about the size only, ordering/arrange usually matters for display (XS, S, M, ...) - product side: it means view/side/location of product to be designed, sample "front", "back", "left sleeve", "inner side". Every product requires one side at least, the preferred side is "front", arranged usually matters for display (front, back, left, right, ...) - product image: here are stored product "side" images shown on designer tool as images to be designed. Image is indexed to product side, so logic for choose product image is product => product side => product images, but at image options is also information related to product color, because we need to show selected color images, so there also info about product color ID may occur, on Promostandards always. - product area: it is print area over the product image - product price: there is simple price list based on qty/price - product description: short, usually plain text, description about the product - product file: using promostadards (or any vendor's datafile) we may extract info about size chart - usually as remote file - product category: allowed for categorize product, at this case is individual table with product categories so product category keeps indexing only, we will explain later, not crucial right now PRICES: Data file returns prices based on product parts (color-size) and on related volume (dozens, case, ... ) so we know exact price for the size of product color ... but it is not good for our system, because of we simplify some things and there are just following pricing options: 1., product (base) price - stored on product price table 2., color up-charge: increase product base price, stored on product color table 3., size up-charge: increase product base price, stored on product size table So, for populate product base price is necessary find lowest price from all parts and after generate charges/difference for colors and sizes I will share more info via chat.