Create a MySQL database according to specs from a csv file database. Then upload to Bigcommerce via API.

We are looking for a freelancer or freelancer team to create a BigCommerce store. Freelancer must have expert level experience with creating a MySQL database from a csv file, and working with the BigCommerce API to upload/update store data. We have a database currently in CSV format that we need to upload to create the store. Image Files have already been uploaded to server. The Specifications: Part 1 Create a MySQL database that contains all the data for each product. The raw data is contained on a csv file. The data instructions for each field to be imported to the MySQL database will be provided in a separate spreadsheet. Ex. Some data will be combined to form the required field information to be uploaded into BigCommerce. Note: There are some special characters in the data that must able to be uploaded. The data to be imported is: Name Description Product code/SKU Weight Width Height Depth Manufacturer Part Number Product type Description Brand Name Product UPC/EAN Product Condition Search Keywords Cost Price Price Page Title Meta Description We then will import Custom Fields There are 27 Custom Fields that will need minor manipulation. We have created the Custom Field Names to be used. The Custom Field Values are defined in the csv file as the Column Header with Y/N for the values. We need to only load the Custom Fields that have a value = Y for each product. See Attachment "Database to BigCommerce" Part 2 Create a script to upload Products to our Bigcommerce store via API. All products will go into an "Default" category. (website owner will manually move all products into the correct categories). Create a script to upload all the Images for each product. Each product has a Large Image File. Manually upload the Category Structure from our Shopify Development store to Bigcommerce. Shopify does not have a category export so this will need to be done manually. Approximately 200 categories. In order for the site owner to categorize products we need to include the category abbreviations in a searchable field. We may need to put category abbreviation in the Product Name field. Then after owner categorized all the products. Re-upload the Product Name without the Category abbreviations. Ex. fields in csv file [Grouping Class], [Group Name], [Inventory Class]